beautypg.com

Restarting the database, Restoring a cold backup, Setting the archive mode – HP Storage Essentials NAS Manager Software User Manual

Page 280: Bed in, Setting, The archive mode, Setting the, Archive mode

background image

Database Maintenance and Management

248

Restarting the Database

You may sometimes need to restart the AppIQ instance of the database. Use this feature in the

Database Admin Utility when the database is down or you need to shutdown and then start the

database.
To restart the database:

1.

Access the Database Admin Utility as described in ”

Accessing the Database Admin Utility

” on

page 243.

2.

Click Restart Database Server in the left pane.

3.

Type the SYS password in the SYS Password field.

4.

Click the Restart Database Server button.

Restoring a Cold Backup

If you performed an RMAN cold backup, follow the steps in this section to restore the RMAN cold

backup. You can only perform a cold backup if you selected Disable Database Archive Mode
and RMAN Backup

. See ”

Setting the Archive Mode

” on page 248 for information about changing

the archive mode. The backup is referred to as being “cold” because the management server is not

running while the backup is occurring.
To restore a cold backup:

1.

Access the Database Admin Utility as described in ”

Accessing the Database Admin Utility

” on

page 243.

2.

Click Restore Cold Backup in the left pane.

3.

Click the Browse button.

4.

In the File Name field, provide a directory path containing the cold backup (may automatically

be populated in some Web browsers), but do not provide a file name. In this release the cold

backup is saved in the COLDBACKUP directory in the path specified by the person who did the

cold backup. The RMAN backup consists of several files. The Database Admin Utility

automatically notices the backup files in the directory provided.

5.

Type the password of the SYS account.

6.

Click Run Cold Backup.

Setting the Archive Mode

By default the management server database runs in no-archive mode, which requires you to backup

the database manually by using a cold RMAN backup. A cold RMAN backup is an RMAN backup

without the management server running. If you want to take an RMAN hot backup of the database,

switch the database to archive mode. An RMAN hot backup is with the database running while the

backup is occurring.
Keep in mind the following implications if you decide to leave the database in no archive mode.

If you leave the database in no archive mode (Disable Database Archive Mode and RMAN
Backup

), it is up to you to back up the management server manually. If you forget to back up

your management server and your management server fails, you will not have a database to

import. To learn more about manual backups, see ”

Running a Cold Backup

” on page 250.