Shulou(Shulou.com)06/01 Report--

Switching between 11g RAC archiving and non-archiving

Non-archiving-> archiving 1. Set the archive path SYS@rac1 > alter system set log_archive_dest_1='LOCATION=+fra' scope=both sid='rac1'; SYS@rac2 > alter system set log_archive_dest_1='LOCATION=+fra' scope=both sid='rac2'

two。 Close all instances of shutdown immediate

3. Set Archive SYS@rac1 > startup mount SYS@rac1 > alter database archivelog

4. Open the database SYS@rac1 > alter database open

five. Two nodes verify Node 1 SYS@rac1 > archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination + FRA Oldest online log sequence 25 Next log sequence to archive 26 Current log sequence 26

Node 2 SYS@rac2 > archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination + FRA Oldest online log sequence 29 Next log sequence to archive 30 Current log sequence 30

6. View the archive file ASMCMD [+ FRA/rac/archivelog/2018_03_23] > ls thread_1_seq_26.263.971545091 thread_2_seq_29.261.971544421 thread_2_seq_30.262.971545055

Archive-> non-archive 1 close the database [oracle@rac1 ~] $srvctl stop database-d rac

two。 One of the nodes operates SYS@rac1 > startup mount; SYS@rac1 > alter database noarchivelog; SYS@rac1 > alter database open

3. Verify SYS@rac1 > archive log list Database log mode No Archive Mode Automatic archival Disabled Archive destination + FRA Oldest online log sequence 26 Current log sequence 27

SYS@rac2 > archive log list Database log mode No Archive Mode Automatic archival Disabled Archive destination + FRA Oldest online log sequence 31 Current log sequence 32

Delete the archive [oracle@rac1 ~] $rman target / RMAN > delete archivelog all using rman

ASMCMD [+ fra/rac] > ls CONTROLFILE/ ONLINELOG/ has been deleted

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.