I have to check to failover from primary to standby database , for that i need to open the standby database in read/write mode , i configured the flasahback at standby database and open the standby database after saving restore point , but when i try to revert the standby database at that restore point it is giving me error
SQL> flashback database to restore point before_open_standby
2 /
flashback database to restore point before_open_standby
*
ERROR at line 1:
ORA-38769: FLASHBACK DATABASE failed after modifying data.
ORA-27103: internal error
Additional information: 27129
Additional information: -2
Additional information: 3
Following are the stpes which i followed to failover at standby database.
SQL> alter database recover managed standby database cancel
2 /
Database altered.
SQL> select open_mode from v$database
2 /
OPEN_MODE
------------------------------
MOUNTED
SQL> alter database flashback on
2 /
Database altered.
SQL> alter database recover managed standby database using current logfile disconnect from session
2 /
Database altered.
SQL> alter database recover managed standby database cancel
2 /
Database altered.
SQL> create restore point before_open_standby guarantee flashback database
2 /
Restore point created.
SQL> column SCN format 999999999999999999999
SQL> select scn,storage_size,time,name from v$restore_point
2 /
SCN STORAGE_SIZE TIME NAME
------------- ------------ ---------------------------------- ----
5970295936140 16613376 13-NOV-11 01.01.39.000000000 PM BEFORE_OPEN_STANDBY
SQL> alter database activate standby database
2 /
Database altered.
SQL> startup mount force
ORACLE instance started.
Total System Global Area 1.1476E+10 bytes
Fixed Size 1263428 bytes
Variable Size 2868906172 bytes
Database Buffers 8589934592 bytes
Redo Buffers 15511552 bytes
Database mounted.
SQL> alter database set standby database to maximize performance
2 /
Database altered.
SQL> alter database open
2 /
Database altered.
SQL> flashback database to restore point before_open_standby
2 /
flashback database to restore point before_open_standby
*
ERROR at line 1:
ORA-38769: FLASHBACK DATABASE failed after modifying data.
ORA-27103: internal error
Additional information: 27129
Additional information: -2
Additional information: 3