beautypg.com

Setting the archive mode, No archive mode. see, D in – HP Storage Essentials NAS Manager Software User Manual

Page 270: Setting the archive, Mode, Described in, Setting the, Archive mode

background image

Database Maintenance and Management

238

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 239.

Export the database after you change the database mode to no archive. See ”

Exporting the

Database

” on page 234.

Scheduled RMAN backup jobs do not run. If you change the database mode to no archive

during an RMAN backup, the RMAN backup will error out.

If the database fails as a result of a corrupt data file, the database can only be restored to the

last export backup available. This requires recreating the database along with the import.

To change the archive mode:

1.

Access the Database Admin Utility as described in ”

Accessing the Database Admin Utility

” on

page 232.

2.

Click Archive Mode Switch in the left pane.

3.

Select one of the following:
Enable Database Archive Mode and RMAN Backup - Select this option if you plan to run

database in archive mode and automated backup while the management server is running.

If database is already in archive mode, you can use this option to clean up archive files.

See ”

About the Database Admin Utility

” on page 232 for more information about the

automatic backups. When you change the database to archive mode, you reset the logs

SCN, set the archive parameter in the database parameter file and enable the RMAN

backup scheduler. Take a current RMAN backup after switching to archive mode (Options

> Storage Essentials > Manage Product Health > Disk Space > RMAN Backup >
Backup Now

in HP Systems Insight Manager) as described in ”

Performing an RMAN Hot

Backup

” on page 230.

Disable Database Archive Mode and RMAN Backup - Select this option if and only if

you always shut down the management server prior to a backup. With database running in

no-archive mode, you can only cold back up your database. When you change the

database to no archive mode, you reset the logs SCN, set the archive parameter in the

database parameter file and disable the RMAN backup scheduler. See ”

Running a Cold

Backup

” on page 239 for more information. Export the database after switching to no

archive mode. See ”

Exporting the Database

” on page 234.

4.

Type the SYS password in the SYS Password field.

5.

Click the Change Settings button.