Oracle 11g RAC Open Archive log and flashback

1. Check if the database is turned on for flashback (view two nodes Rac1 and RAC2 Open Archive log)

Sql> archiveloglist

Sp2-0734:unknown command Beginning "Archivelog ..."-rest of line ignored.

Sql> Archive Log List

Database log mode No Archive mode

Automatic Archival Disabled

Archive Destination Use_db_recovery_file_dest

Oldest online log sequence 7

Current Log Sequence 8

Sql>

2. Set the parameters in Node 1 (RAC1) to modify only node 1, without affecting node 2.

Sql> alter system set Cluster_database=false scope=spfile sid= ' racdb1 ';

System altered.

Sql>

3. Close the database with the SRVCTL command

[Email protected] ~]$ srvctl stop database-d racdb

This article is from the "Days Together" blog, please be sure to keep this source http://tongcheng.blog.51cto.com/6214144/1857477

Oracle 11g RAC Open Archive log and flashback