DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Wednesday, April 11, 2018

Steps to Flashback to Particular Restore Point

set pagesize 1000

col name format a70

col scn format 9999999999999999999

col time format a50

select SCN,NAME,TIME,STORAGE_SIZE from v$restore_point;

shutdown immediate

startup mount

exit



flashback the database to before deployment

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

rman target /



flashback database to restore point xxxxxxxxxxx;

 ( if you want to execute from sqlplus remove quotes and if you want to execute from rman you need quotes)

alter database open resetlogs;



exit



drop all restore points including the one which used as restore point

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

dba



set pagesize 1000

select 'drop restore point '||NAME||';' from v$restore_point;

No comments: