RMAN recover

[Roshan]

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

[ErmanArslansOracleBlog]

That feature is for 12.2.

find highest log sequence of each thread.
You decice the log sequence that you will use for the until clause.
Recover until (that sequence+1)
You use the following syntax for this type of a recover in RAC ->

SET UNTIL SEQUENCE m THREAD n;
For instance; SET UNTIL SEQUENCE 232 THREAD 1;

Please see "RMAN: RAC Backup, Restore and Recovery using RMAN (Doc ID 243760.1)" for more details. Read Section 7 and later sections.

Bytheway, I didn't understand you actual purpose.. What is the actual recovery need here?

[Roshan]

The actual recovery need is to recover till the latest archivelog which has been backed up since some days we do not have incremental backups.

[ErmanArslansOracleBlog]

Okay.. Section named "Incomplete Recovery" of the MOS note "RMAN: RAC Backup, Restore and Recovery using RMAN (Doc ID 243760.1)" will help you on this.