RMAN recover

Posted by Roshan on Apr 01, 2021; 4:51am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/RMAN-recover-tp9555.html

Oracle DB 12.1.0.2

Hello Erman,

suppose my backup policy is as shown below;

L0 - Sunday
L1 - Tuesday, Thursday, Saturday

Archivelog backups - every 4 hours every day (completes before L1 and L0 start)

Could you please advise how to recover DB till latest archivelog?

Oracle 12.2.0 has the feature UNTIL AVAILABLE REDO. How about 12.1.0.2?

I have checked link https://docs.oracle.com/database/121/RCMRF/rcmsubcl022.htm#GUID-6A6C502A-6E21-4673-9FC9-C075D1E2F97A__BABEDABD

For option 2, until sequence. If source is a RAC of 2 nodes, should I select the maximum sequence number among thread 1 and 2 and use them before the restore command? Is below correct?

SQL> select max(sequence#) from v$archived_log where thread#=1;

MAX(SEQUENCE#)
--------------
     15454
SQL>

SQL> select max(sequence#) from v$archived_log where thread#=2;
MAX(SEQUENCE#)
--------------
     14849

SQL> select FIRST_CHANGE# from v$archived_log where SEQUENCE#=15454;

                  FIRST_CHANGE#
-------------------------------------------------
                   318933439334
                   318933439334

RUN
{
  SET UNTIL SCN 318933439334; (max scn for thread 1)
  RESTORE DATABASE;
  RECOVER DATABASE;
}


for the time clause if I recover until 'sysdate', will it recover till the last archivelog backed up?

RECOVER DATABASE UNTIL TIME 'SYSDATE'.
Thanks,

Roshan