Enabling flashback,restore point and restore point in database

 

Commands as below

Sql > select flashback_on from v$database

 

If no then  follow below step

 

sql > shutdown immediate

sql> startup mount

sql > alter database flashback on

sql> shutdown immediate

sql> startup

sql> select flashback_on from v$database

sql> create restore point before_upgrade

sql > create restore point befor_upg guarantee flashback database

sql> select * from v$restore_point

sql > exit

rman target /

rman > list restore point all

sql > shutdown immediate

sql > startup mount

sql> flashback database to restore point before_upgrade

sql> shutdown immediate

sql > startup mount

sql>alter database open resetlogs;

sql > select * from v$restore_point

sql> drop restore point before_upgrade

sql>drop restore point befor_upg