Restore RAC database to different client

Envirenment

requirements

  1. Successful Netbackup backup of set.
  2. Same version of database.
  3. Record Source DBID/DATAFILE/TABLESPACE.
  4. Install database software only on Destination client.
  5. Install Netbackup client software on Destination client.

  6. Touch the file on the master server: => /usr/openv/netbackup/db/altnames/No.Restrictions 

SQL> select name from v$datafile;
Press Return to Continue

SQL> select name from v$tempfile;

SQL> select name from v$controlfile;

Master Server hosts file

Netbackup-master:/home/maintenance # tail -5 /etc/hosts 

192.168.74.151 MC-PMS-DB
192.168.80.155  Netbackup-master
192.168.80.152  oem

192.168.80.162 MC-POSHIS-DB

Client/Media Server

Netbackup-master: ~# cat /usr/openv/netbackup/bp.conf 

[oracle@MC-PMS-DB ~]$ cat /usr/openv/netbackup/bp.conf
SERVER = Netbackup-master
CLIENT_NAME = MC-PMS-DB
CONNECT_OPTIONS = localhost 1 0 2

[root@MC-POSHIS-DB ~]# cat /usr/openv/netbackup/bp.conf 
SERVER = Netbackup-master
CLIENT_NAME = MC-POSHIS-DB
CONNECT_OPTIONS = localhost 1 0 2

Excute restore

Create initPMSDB.ora & orapwd file

copy pfile from Source client MC-PMS-DB OR create new one. 

PMSDB.__db_cache_size=5737807872
PMSDB.__java_pool_size=117440512
PMSDB.__large_pool_size=134217728
PMSDB.__pga_aggregate_target=3221225472
PMSDB.__sga_target=7516192768
PMSDB.__shared_io_pool_size=0
PMSDB.__shared_pool_size=1308622848
PMSDB.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/PMSDB/adump'
*.audit_trail='db'
*.compatible='11.2.0.4.0'
*.control_files='/MC-POSHIS-DB/PMSDB/controlfile/ctrl_dPMSDB.ctl'
*.db_block_size=8192
*.db_create_file_dest='/MC-POSHIS-DB'
*.db_domain=''
*.db_name='PMSDB'
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=PMSDBXDB)'
*.log_archive_dest_1='LOCATION=/MC-POSHIS-DB/PMSDB/arch'
*.log_archive_format='arch_%t_%s_%r.arc'
*.open_cursors=300
*.pga_aggregate_target=3221225472
*.processes=300
*.remote_login_passwordfile='exclusive'
*.sessions=335
*.sga_target=7516192768
*.undo_tablespace='UNDOTBS1'

[oracle@MC-POSHIS-DB dbs]$ orapwd password=Systec36 file=orapwPMSDB

[oracle@MC-POSHIS-DB dbs]$ ls
hc_PMSDB.dat  initPMSDB.ora  initPMSDB.ora.old  init.ora  orapwPMSDB

create directories

[root@MC-POSHIS-DB ]# mkdir -pv /MC-POSHIS-DB/PMSDB/{controlfile,arch}
[root@MC-POSHIS-DB ]# chown -Rv oracle:oinstall /MC-POSHIS-DB/PMSDB/

restore controlfile

/usr/openv/netbackup/bin/bplist -S Netbackup-master -C MC-PMS-DB -t 4 -l -R / | tee nbu_backups20170704_MC-PMS-DB.txt 

  export ORACLE_SID=PMSDB
  rman target / nocatalog

RMAN> startup nomount pfile='/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initPMSDB.ora';

RMAN> set DBID=2147825860
run {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';
SEND 'NB_ORA_SERV=Netbackup-master, NB_ORA_CLIENT=MC-PMS-DB';
restore controlfile from '/cntrl_HDPMS_set11_piece1_20180913_0btd0ica_1_1';
RELEASE CHANNEL ch00;
}

RMAN> startup mount

RMAN> startup mount;

}}}

restore database by UNTIL TIME

spool log to rman_restore-PMSDB-preview.log
set echo on
show all;
report schema;
list backup summary;
list backup;
list copy;
run {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';
SEND 'NB_ORA_SERV=Netbackup-master, NB_ORA_CLIENT=MC-PMS-DB';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';
SEND 'NB_ORA_SERV=Netbackup-master, NB_ORA_CLIENT=MC-PMS-DB';

crosscheck backupset of database;
restore database preview;
restore database validate;
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
}
spool log off

RMAN> 
spool log to rman_restore-PMSDB-v1.log
set echo on
run {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';
SEND 'NB_ORA_SERV=Netbackup-master, NB_ORA_CLIENT=MC-PMS-DB';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';
SEND 'NB_ORA_SERV=Netbackup-master, NB_ORA_CLIENT=MC-PMS-DB';
restore database;
restore archivelog all;
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
}
spool log off

export ORACLE_SID=HDPMS; sqlplus / as sysdba

SQL> recover database until cancel using backup controlfile;
ORA-00279: change 1817651 generated at 09/13/2018 11:20:33 needed for thread 1
ORA-00289: suggestion : /oradata/HDPMS/archlog/1_5_984912390.dbf
ORA-00280: change 1817651 for thread 1 is in sequence #5
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
==> CANCEL
Media recovery cancelled.

SQL> alter database open resetlogs;
Database altered.

Open database

Troubleshooting