Flashback db using restore point
--- Below are the steps for flashback database to a guaranteed restore point;
oracle configurationintermediate
by OracleDba
13 views
📋Steps in this guide1/1
1
Flashback db using restore point
1. Get the restore point name:
2. Shutdown database and start db in Mount stage:
3. flashback db to restore point:
4. Open with resetlog:
Code/Command (click line numbers to comment):
123456789
--- Below are the steps for flashback database to a guaranteed restore point;
SQL> select NAME,time from v$restore_point;
NAME Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â TIME
-------------------------------- Â Â Â Â Â -----------------------------------------------
GRP_1490100093811 Â Â Â Â Â Â Â Â Â Â Â Â 21-MAR-17 03.41.33.000000000 PM
shutdown immediate;
startup mount;
flashback database to restore point GRP_1490100093811;
alter database open resetlogs:Comments (0)
Please to add comments
No comments yet. Be the first to comment!