Mục đích: Bật Archive Log Mode trong Oracle RAC
1. Đặt đường dẫn chứa archive
SQL> alter system set log_archive_dest_1='LOCATION=+ARCH/' scope=both sid='*'; System altered.
2. Stop database
srvctl stop database -d RAC
3. Start database ở chế độ mount
srvctl start database -d RAC -o mount
4. Enable archive log mode.
SQL> alter database archivelog; Database altered.
5. Open database
alter database open
6. Check
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.
