Database Reference
In-Depth Information
2.
Specify a shared recovery destination path (in this example, an ASM diskgroup) in which
archivelogs from all instances of a RAC database will be stored:
SQL> alter system set db_recovery_file_dest = '+DG_RONDB_ARCH' SCOPE=BOTH SID='*';
■
Note
in a raC database, the settings must remain consistent across all instances.
To enable archivelog mode:
1.
Shut down the database first:
# srvctl stop database -d RONDB -o immediate
2.
Mount the first instance either from the SQL*Plus prompt or by using the srvctl command,
as follows:
SQL> startup mount;
# srvctl start database -d RONDB -o mount
Unlike pre-11gR2, you don't need to off/on the
cluster_database
parameter to switch between the archive/
noarchive modes.
1.
Switch the database mode to archivelog and start the database using the following examples:
SQL> alter database archivelog;
SQL> alter database open;
2.
To start the rest of the instance, use one of the following examples:
# srvctl start database -d RONDB
# srvctl start instance -d RONDB -I RONDB2
Once the preceding settings are made, connect to
SQL*Plus
and verify the database log mode and recovery
parameters using the following commands:
SQL> SELECT log_mode FROM v$database;
SQL> archive log list
The outcome should be similar to the following:
SYS @RONDB1 >archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 10
Next log sequence to archive 12
Current log sequence 12
From the preceding output, you can see that the database log mode is in Archive Mode now, and the archivelog
location is set to Flash Recovery Area.
