11gR2 RAC
1. Verify Archive log and Flashback is enable.
archive log list
select FLASHBACK_ON from v$database;
2. cluster_database parameter false
alter system set cluster_database=false scope=false sid='racdb1';
3. Setting up FLASHBACK Area.
alter system set DB_RECOVERY_FILE_DEST_SIZE=200M scope=spfile;
alter system set DB_RECOVERY_FILE_DEST='+FRA/flashback/' scope=spfile;
4. shutdown all instance.
srvctl stop database -d RACDB
5. Mount database.
startup mlount
6. Enable Flashback.
alter database flashback on;
7. set parameter cluster_database true.
alter system set cluster_database=true scope=spfile side='racdb1';
8. shutdown instance.
shutdown ;
9. start all instances.
srvctl start database -d racdb
1. Verify Archive log and Flashback is enable.
archive log list
select FLASHBACK_ON from v$database;
2. cluster_database parameter false
alter system set cluster_database=false scope=false sid='racdb1';
3. Setting up FLASHBACK Area.
alter system set DB_RECOVERY_FILE_DEST_SIZE=200M scope=spfile;
alter system set DB_RECOVERY_FILE_DEST='+FRA/flashback/' scope=spfile;
4. shutdown all instance.
srvctl stop database -d RACDB
5. Mount database.
startup mlount
6. Enable Flashback.
alter database flashback on;
7. set parameter cluster_database true.
alter system set cluster_database=true scope=spfile side='racdb1';
8. shutdown instance.
shutdown ;
9. start all instances.
srvctl start database -d racdb
No comments:
Post a Comment