Oracle RMAN DB disaster recovery procedure and prerequisites

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.