RMAN

0- Goal : Restore enyo:C1EPROJ4 to iris:C1IUATJ4

Important on the target and the source databases should have the same db_name : C1EPROJ

1-

connect target /
set DBID=1515590738
run {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';
SEND 'NB_ORA_SERV=gvaveritasbck1.corp.sch.ch,NB_ORA_CLIENT=enyoa.corp.sch.ch,NB_ORA_POLICY=OraclePrdDbBackupPolicy_Srcpit,NB_ORA_SCHED=Oracle_RMAN0_Monthly_Application';
set until time  "TO_DATE('18-06-2024 18:00:00','DD-MM-YYYY HH24:MI:SS')";
restore controlfile from autobackup;
release channel ch00;
}

2- mount database

RMAN> alter database mount;
 
Statement processed

3- restore and recover

run {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';
ALLOCATE CHANNEL ch02 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';
ALLOCATE CHANNEL ch03 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';
ALLOCATE CHANNEL ch04 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';
ALLOCATE CHANNEL ch05 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';
ALLOCATE CHANNEL ch06 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';
ALLOCATE CHANNEL ch07 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';
SEND 'NB_ORA_SERV=gvaveritasbck1.corp.sch.ch,NB_ORA_CLIENT=enyoa.corp.sch.ch,NB_ORA_POLICY=OraclePrdDbBackupPolicy_Srcpit,NB_ORA_SCHED=Oracle_RMAN0_Monthly_Application';
set until time  "TO_DATE('18-06-2024 18:00:00','DD-MM-YYYY2>  HH24:MI:SS')";
restore database;
recover database;
release channel ch00;
release channel ch01;
release channel ch02;
release channel ch03;
release channel ch04;
release channel ch05;
release channel ch06;
release channel ch07;
}

4- open resetlogs

SQL> alter database open resetlogs;
 
Database altered.
 
SQL>

4- recreate redo if needed (– not needed but verify that redo are on the right place)

5- Rename PDB if needed

run {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';
SEND 'NB_ORA_SERV=NBU.labo.local,NB_ORA_CLIENT=oracle1.labo.local,NB_ORA_POLICY=OracleDbArchiveBackupPolicy_Script';
restore archivelog sequence 33261 ;
}

Dane le cadre d'un dataguard, on liste les thread:

SELECT * FROM gv$archive_gap;
  INST_ID    THREAD# LOW_SEQUENCE# HIGH_SEQUENCE#     CON_ID
---------- ---------- ------------- -------------- ----------
         2          1         31765          31767          1
         2          2         33262          33264          1
         1          1         31765          31767          1
         1          2         33262          33264          1

On restore l'archive manquante

run {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';
SEND 'NB_ORA_SERV=NBU.labo.local,NB_ORA_CLIENT=oracle1.labo.local,NB_ORA_POLICY=OracleDbArchiveBackupPolicy_Script';
restore archivelog sequence 33261 thread 2 ;
}