====== RMAN ======

=== restore database from tape ===
0- Goal : Restore enyo:C1EPROJ4  to iris:C1IUATJ4

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

1- 
<code BASH>
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;
}
</code>

2- mount database
<code BASH>
RMAN> alter database mount;

Statement processed
</code>
3- restore and recover
<code BASH>
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;
}
</code>

4- open resetlogs

<code BASH>
SQL> alter database open resetlogs;

Database altered.

SQL>
</code>

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


5- Rename PDB if needed

//

=== restore archivelog from tape ===
== Standalone ==
<code BASH>
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 ;
}
</code>


== RAC ==
Dane le cadre d'un dataguard, on liste les thread:
<code PLSQL>
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

</code>
On restore l'archive manquante
<code BASH>
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 ;
}
</code>