- 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.
1 | srvctl stop database -d DBACLASS |
2. start the database in mount state.
1 | srvctl start database -d DBACLASS -o mount |
3. enable archive log mode.
1 2 3 | SQL> alter database archivelog;Database altered. |
4. Restart the database service (using srvctl)
1 2 3 | srvctl stop database -d DBACLASsrvctl start database -d DBACLAS |
5. set the archive destination to a ASM DISK.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 | SQL> alter system set log_archive_dest_1='LOCATION=+ARCH/' scope=both sid='*';System altered.SQL> archive log listDatabase log mode Archive ModeAutomatic archival EnabledArchive destination +ARCHOldest online log sequence 724Next log sequence to archive 726Current log sequence 726SQL> alter system switch logfile;System altered. |
For disabling archive mode also . steps are same
1 2 3 4 5 | srvctl stop database -d DBACLASSsrvctl start database -d DBACLASS -o mountalter database noarchivelog;srvctl stop database -d DBACLASSsrvctl start database -d DBACLASS |