Home > RAC11G. > How to enable the flashback database in RAC environment.

How to enable the flashback database in RAC environment.

January 16, 2014

 

flashback (RAC) ## Make sure that the database is running in archive log mode
SQL> archive log list

## Setup the flashback
SQL> alter system set cluster_database=false scope=spfile sid=’orcl1′;
SQL> alter system set DB_RECOVERY_FILE_DEST_SIZE=200M scope=spfile;
SQL> alter system set DB_RECOVERY_FILE_DEST=’/ocfs2/flashback’ scope=spfile;
srvctl stop database -p orcl
SQL> startup mount
SQL> alter database flashback on;
SQL>alter system set cluster_database=true scope=spfile sid=’orcl1′;

SQL>

SQL>shutdown;
srvctl start database -p orcl

Advertisements
Categories: RAC11G.
%d bloggers like this: