1> Take the backup of Application
fs1 fs2 fs_ne
rsync -arvh –delete –log-file=test.log /d02/oracle/PROD/fs2 /d02/oracle/PROD/backup
rsync -arvh –delete –log-file=test.log /d02/oracle/PROD/fs1 /d02/oracle/PROD/backup
rsync -arvh –delete –log-file=test.log /d02/oracle/PROD/fs_ne /d02/oracle/PROD/backup
2> Create Restore Point (optional) – Before cutover or at the begining of the patch
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
alter system set db_recovery_file_dest_size=100G scope=both sid=’‘; alter system set db_recovery_file_dest=’/d02/oracle/PROD/recovery’ scope=both sid=’‘;
alter database flashback on;
create restore point Before_cutover guarantee flashback database;
Enable flashbackup on and restore point
https://www.dell.com/support/kbdoc/en-in/000146492/how-to-quickly-restore-to-a-clean-database-using-oracle-s-restore-point
SQL> alter system set db_recovery_file_dest_size=200G scope=both sid=’‘; System altered. SQL> alter system set db_recovery_file_dest=’/archivelog/oracle/CEBSPRD’ scope=both sid=’‘;
alter database flashback on;
create restore point AFTER_DB guarantee flashback database;
select * from v$restore_point;
select scn from v$restore_point;
select current_scn from v$database;
Flashback to the guaranteed restore point
Now, in order to restore your database to the guaranteed restore point, follow the steps below:
$> su – oracle
$> sqlplus / as sysdba;
SQL> select current_scn from v$database;
SQL> shutdown immediate;
SQL> startup mount;
SQL> select * from v$restore_point;
SQL> flashback database to restore point Before_cutover;
SQL> alter database open resetlogs;
SQL> select current_scn from v$database;
