- Enable archiving:
SQL> alter database archivelog;
- Re-enable support for clustering by modifying the instance parameter cluster_database to TRUE from the current instance:
SQL> alter system set cluster_database=true scope=spfile sid='racdb1';
- Shutdown the local instance:
SQL> shutdown immediate
- Bring all instance back up using srvctl:
$ srvctl start database -d racdb
- (Optional) Bring any services (i.e. TAF) back up using srvctl:
$ srvctl start service -d racdb
- Login to the local instance and verify Archive Log Mode is enabled:
$ sqlplus "/ as sysdba" SQL> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 83 Next log sequence to archive 84 Current log sequence 84
Search This Blog
Monday, March 5, 2012
Enabling Archive Logs in a RAC Environment
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment