ANKUSH THAVALI
- 21 Jun, 2022
- 0 Comments
- 52 Secs Read
Enable Archive Log Mode In Oracle RAC
Enable Archive Log Mode In Oracle RAC
Follow below steps for enabling archive log mode in oracle RAC.
1. stop the database service.
srvctl stop database -d DBACLASS
2. start the database in mount state.
srvctl start database -d DBACLASS -o mount
3. enable archive log mode.
SQL> alter database archivelog; Database altered.
4. Restart the database service (using srvctl)
srvctl stop database -d DBACLAS srvctl start database -d DBACLAS
5. set the archive destination to a ASM DISK.
SQL> alter system set log_archive_dest_1='LOCATION=+ARCH/' scope=both sid='*'; System altered. SQL> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination +ARCH Oldest online log sequence 724 Next log sequence to archive 726 Current log sequence 726 SQL> alter system switch logfile; System altered.
For disabling archive mode also . steps are same
srvctl stop database -d DBACLASS srvctl start database -d DBACLASS -o mount alter database noarchivelog; srvctl stop database -d DBACLASS srvctl start database -d DBACLASS