Oracle RMAN DB disaster recovery procedure and prerequisites

Question

Hello EMC, I created one vm named as oratest to test and perform the oracle db backup & restore using Networker NMDA. To test the backup and recovery I created the database and performed the backups successfully. After completing the backup successfully I delete the oracle DB. Now I want to rebuilt the db from the backups. I tried to perform the restore from networker recovery wizard but recovery got failed. Please find the below for error logs. Unfortunately there is a limited  information in the NMDA administration guide. Now I'm looking for the necessary procedures and perquisites to perform the recovery successfully for the above scenario. Below are the details of the networker configuration. Networker Server: 9.0.1 buid 636 ( Installed on Windows Server 2012 R2) NMDA version: lgtonmda-9.1.0.2-1 Networker client version: lgtoclnt-9.0.1.1-1, lgtoxtdclnt-9.0.1.1-1 Client O.S : Oracle linux 5 (64 bit architecture) Oracle DB version: 11g RMAN version : Recovery Manager: Release 11.2.0.1.0 Error Logs for restore: The nsrdarc command is starting. The nsrdarc command is starting. Recovery Manager: Release 11.2.0.1.0 - Production on Sat Mar 4 11:38:33 2017 Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved. RMAN> connect ******** 2> 3> RUN { 4>      SHUTDOWN IMMEDIATE; 5>      STARTUP MOUNT; 6> } 7> connected to target database: REST (DBID=2680244252) using target database control file instead of recovery catalog database closed database dismounted Oracle instance shut down connected to target database (not started) Oracle instance started database mounted Total System Global Area     217157632 bytes Fixed Size                     2211928 bytes Variable Size                159387560 bytes Database Buffers              50331648 bytes Redo Buffers                   5226496 bytes Recovery Manager complete. Recovery Manager: Release 11.2.0.1.0 - Production on Sat Mar 4 11:41:57 2017 Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved. RMAN> connect ******** 2> 3> RUN { 4>      ALLOCATE CHANNEL CH1 TYPE 'SBT_TAPE' PARMS 'SBT_PARMS=(NSR_SERVER=darnetworker.alarkan.com,NSR_CLIENT=oratest)'; 5>      ALLOCATE CHANNEL CH2 TYPE 'SBT_TAPE' PARMS 'SBT_PARMS=(NSR_SERVER=darnetworker.alarkan.com,NSR_CLIENT=oratest)'; 6>      ALLOCATE CHANNEL CH3 TYPE 'SBT_TAPE' PARMS 'SBT_PARMS=(NSR_SERVER=darnetworker.alarkan.com,NSR_CLIENT=oratest)'; 7>      ALLOCATE CHANNEL CH4 TYPE 'SBT_TAPE' PARMS 'SBT_PARMS=(NSR_SERVER=darnetworker.alarkan.com,NSR_CLIENT=oratest)'; 8> 9>      RESTORE DATABASE; 10> 11>      RECOVER DATABASE; 12> 13>      RELEASE CHANNEL CH1; 14>      RELEASE CHANNEL CH2; 15>      RELEASE CHANNEL CH3; 16>      RELEASE CHANNEL CH4; 17>      ALTER DATABASE OPEN; 18> 19> } 20> connected to target database: REST (DBID=2680244252, not open) using target database control file instead of recovery catalog allocated channel: CH1 channel CH1: SID=18 device type=SBT_TAPE channel CH1: NMDA Oracle v9.1.0.2 sent command to channel: CH1 allocated channel: CH2 channel CH2: SID=19 device type=SBT_TAPE channel CH2: NMDA Oracle v9.1.0.2 sent command to channel: CH2 allocated channel: CH3 channel CH3: SID=21 device type=SBT_TAPE channel CH3: NMDA Oracle v9.1.0.2 sent command to channel: CH3 allocated channel: CH4 channel CH4: SID=22 device type=SBT_TAPE channel CH4: NMDA Oracle v9.1.0.2 sent command to channel: CH4 Starting restore at 04-MAR-17 creating datafile file number=1 name=/ora_test/oracle/oradata/rest/sys.dbf released channel: CH1 released channel: CH2 released channel: CH3 released channel: CH4 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 03/04/2017 11:41:58 ORA-01180: can not create datafile 1 ORA-01110: data file 1: '/ora_test/oracle/oradata/rest/sys.dbf' Recovery Manager complete. RMAN exited with return code '1'. The recovery did not succeed. Thanks & Regards, Devendra Reddy Chitiki.

Kleinenbroich · Answer

Hi,

I'm not really an Oracle expert, but can you try the following:

1.) Configure the channels:

rman target /

CONFIGURE CHANNEL 1 DEVICE TYPE ‘SBT_TAPE’ PARMS ‘ENV=(NSR_SERVER=darnetworker.alarkan.com, NSR_CLIENT=oratest, NSR_DATA_VOLUME_POOL=name_of_the_used_pool)’;

CONFIGURE CHANNEL 2 DEVICE TYPE ‘SBT_TAPE’ PARMS ‘ENV=(NSR_SERVER=darnetworker.alarkan.com, NSR_CLIENT=oratest, NSR_DATA_VOLUME_POOL=name_of_the_used_pool)’;

2.) The full Oracle database recovery is an offline recovery, Oracle must run in the so called “mount” mode: The database is mounted but not started:

sqlplus / as sysdba

startup mount;

3.) Start the recovery:

rman target /

RESTORE DATABASE;

RECOVER DATABASE;

alter database open resetlogs;

ble1 · Answer

Procedure itself looks ok to me.  The error you get is from RMAN stating it can't create datafile.  You can check if this is related to incarnations (see oracle - ORA-01180 when restoring the database - Database Administrators Stack Exchange)

NetWorker

Was this post helpful?