Role Back to a Restore point

Following restore point is available on the RAC database. We wanted to role back to the below restore point.

 

SQL> SELECT DATABASE_INCARNATION#,SCN,NAME,TIME,STORAGE_SIZE/1024/1024 "SIZE(MB)",GUARANTEE_FLASHBACK_DATABASE FROM V$RESTORE_POINT;

 

DATABASE_INCARNATION#        SCN NAME                                     TIME                                                                          SIZE(MB) GUA

--------------------- ---------- ---------------------------------------- --------------------------------------------------------------------------- ---------- ---

                    2 5.5896E+12 DATAGUARDTEST                            22-AUG-17 06.45.23.000000000                                                128677.508 YES

When roll backing  to the restore point following error raised

SQL> select instance_name,status from gv$instance;

INSTANCE_NAME    STATUS

---------------- ------------

RRRM02A2         MOUNTED

SQL>

SQL> FLASHBACK DATABASE TO RESTORE POINT DATAGUARDTEST;

FLASHBACK DATABASE TO RESTORE POINT DATAGUARDTEST

*

ERROR at line 1:

ORA-38754: FLASHBACK DATABASE not started; required redo log is not available

ORA-38762: redo logs needed for SCN 5589595118347 to SCN 5589595118351

ORA-38761: redo log sequence 33 in thread 2, incarnation 2 could not be

accessed

 

We have carried Below Steps to resolve this.

srvctl status database -d RRRM02A

srvctl stop database -d RRRM02A

srvctl status database -d RRRM02A

srvctl start instance -d RRRM02A -i RRRM02A1 -o mount

SQL> select name, host_name, status from gv$instance;

SQL> select log_mode,flashback_on from v$database;

SQL> select name,time from v$restore_point;

 

SQL>alter system set cluster_database=false scope=spfile sid='*';

Connect RMAN Catalogue

rman target / catalog RMAN_RRRM02/******@PRMAN02.CORP.LCH.COM

 

RMAN>FLASHBACK DATABASE TO RESTORE POINT DATAGUARDTEST;

RMAN> sql 'alter database open resetlogs';

SQL> alter system set cluster_database=true scope=spfile sid='*';

srvctl status database -d RRRM02A

SQL> select open_mode,database_role from gv$database;