cancel
Showing results forΒ 
Search instead forΒ 
Did you mean:Β 

Oracle control file DO NOT restore in RAC mode !

f_dashti
Level 2

Dear masters ,

I have a scenario to try backup/restore of tablespaces on my production Oracle servers.

my environment :  Oracle 11g-R2 (OEL 5.5)  -  Netbackup 7.1.0.3

I'm able to backup successfully without any error but when try to restore the instance completely or restore a deleted

tablespace i face errors..

This is important to mention that my procedure is SUCCESSFUL for FS (file system mode) Oracle databases BUT not for

RAC modes.

my procedure :

1- enabling controlfile autoback "on" and configuring channels (RMAN)

2- backing up of control file and tablespaces

3- creating of touch file (NO.RESTRICTION) on Netbackup server

4- startup nomount of instance (SQLPLUS)

5- set DBID (RMAN)

6- typing of RMAN commands on RUN (please refer to attached screenshot)

 

this procedure is OK for FS Oracle DB but I face the error ORA-06172 for RAC databases..

I tried to specify the correct piece handle name by the command :

5> restore controlfile from '/ctrl_xxxxxxxxx';

but the result was unsuccessful...

I will appreciate your comments...

 

4 REPLIES 4

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

Touch file on master is called No.Restrictions  - case sensitive with just N and R in uppercase and 's' at the end.

To troubleshoot, you need the following logs:

On master: bprd (NBU needs to be restarted afted log folder is created).

On RAC node where restore is intiated from: dbclient log (ensure folder has 777 permissions).

Please also share details of backup job - which Client name (NB_ORA_CLIENT) is used for backup?
Which Client name is used for restore request (CLIENT_NAME in bp.conf)?

Please rename logs to reflect process name (e.g. bprd.txt) and post as attachments.

Will_Restore
Level 6

Action: Modify autobackup search criteria or verify the handle

http://www.dba-oracle.com/t_rman_06172_no_autobackup_found.htm

 

 

Stephane_COLIN
Level 4
Partner Accredited Certified

Find below, an example to restore your control file from a backup NetBackup :

1) On your nbu client (connected with your oracle account), display list all files backup available with bplist command:

      [oracle@NBUCLNTORACLE bin]$ /usr/openv/netbackup/bin/bplist -C NBUCLNTORACLE -t 4 -l -R /
      -rw-rw---- oracle asmadmin 20971520 May 06 03:40 /cntrl_1806_1_782538018
      -rw-rw---- oracle asmadmin 2571008K May 06 03:24 /al_1794_1_782537063
      -rw-rw---- oracle asmadmin 2561536K May 06 03:22 /al_1793_1_782536965
      -rw-rw---- oracle asmadmin 2558208K May 06 03:21 /al_1792_1_782536888
      -rw-rw---- oracle asmadmin 2458880K May 06 03:20 /al_1791_1_782536810
      -rw-rw---- oracle asmadmin 2545920K May 06 03:19 /al_1790_1_782536743
      -rw-rw---- oracle asmadmin 20971520 May 06 03:18 /bk_1789_1_782536700
      -rw-rw---- oracle asmadmin 24988416K May 06 03:05 /bk_1788_1_782535934
      -rw-rw---- oracle asmadmin 28007424K May 06 02:53 /bk_1787_1_782535208
      -rw-rw---- oracle asmadmin 29487104K May 06 02:43 /bk_1786_1_782534612
      -rw-rw---- oracle asmadmin 45272576K May 06 02:25 /bk_1785_1_782533516

 

2) Shutdown your database and startup nomount:

      [oracle@NBUCLNTORACLE bin]$ sqlplus / as sysdba
      shutdown immediate;
      startup nomount;
      exit

 

3) Restore and copy your control files:

      [oracle@NBUCLNTORACLE bin]$ rman target / nocatalog

      run {
      ALLOCATE CHANNEL CH01 TYPE 'SBT_TAPE';
      SEND 'NB_ORA_SERV=NBU_SRV, NB_ORA_CLIENT=NBUCLNTORACLE';
      restore controlfile to '/tmp/controlfile.ctl' from '/cntrl_1806_1_782538018';
      release channel CH01;
      }

      run {
      ALLOCATE CHANNEL CH01 TYPE 'SBT_TAPE';
      replicate controlfile from '/tmp/controlfile.ctl' ;
      release channel CH01;
      }
      exit

 

4) Mount your database:

      [oracle@NBUCLNTORACLE bin]$ sqlplus / as sysdba
      alter database mount;
      exit

 

 

5) now you can restore your database
 

 

 

 

f_dashti
Level 2

thank you masters... I will double check all of your recommendations and notice the results..