meta données pour cette page
  •  

Différences

Ci-dessous, les différences entre deux révisions de la page.

Lien vers cette vue comparative

Prochaine révision		Révision précédente
oracle:rman [26/03/2024 10:20] – créée mdloracle:rman [24/06/2024 12:23] (Version actuelle) – mdl
Ligne 1: Ligne 1:
 ====== RMAN ====== ====== RMAN ======
-== restore archivelog from tape == 
  
 +=== 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 { run {
 ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64'; 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=enyodevprea.corp.sch.ch,NB_ORA_POLICY=OracleDevPreDbArchiveBackupPolicy_Srcpit';+SEND 'NB_ORA_SERV=NBU.labo.local,NB_ORA_CLIENT=oracle1.labo.local,NB_ORA_POLICY=OracleDbArchiveBackupPolicy_Script';
 restore archivelog sequence 33261 thread 2 ; restore archivelog sequence 33261 thread 2 ;
 } }
 +</code>