Veritas-bu
[Top] [All Lists]
<prev [Date] next>
[Advanced]
 <prev [Thread] next>

[Veritas-bu] Failed to restore to different client using Netbackup for SAP on oracle db with RMAN

2007-04-01 04:02:54
Subject: [Veritas-bu] Failed to restore to different client using Netbackup for SAP on oracle db with RMAN
From: shaharul.ismail at gmail.com (Shaharul Anuar)
Date: Sun, 1 Apr 2007 16:02:54 +0800 
hi all, 

 

I am trying to restore oracle database from production server into uat
server using sap agent with rman option. The source & destination server
have similar hardware platform, oracle and nbu level. I've shut down the
database and installed the archivelogs and control file using NBU backup,
restore & archive option. i then duplicate the control file "cntrlP01.dbf"
to two other locations (/oracle/P01/sapdata1/cntrl/ and
/oracle/P01/origlogA/cntrl/..). I restart the database using command startup
and proceed with "brrestore -d rman_util -b last -m full -c force" but
failed. fyi, i have no experience in oracle as all dbas are away for the
weekend holiday. Please help me. Thank you. 

 

sapl02:orap01 56> sqlplus /nolog

SQL*Plus: Release 9.2.0.6.0 - Production on Sun Apr 1 14:12:26 2007

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area  569337496 bytes
Fixed Size                   743064 bytes
Variable Size             268435456 bytes
Database Buffers          298835968 bytes
Redo Buffers                1323008 bytes
ORA-00214: controlfile '/oracle/P01/saparch/cntrl/cntrlP01.dbf' version
43406
inconsistent with file '/oracle/P01/sapdata1/cntrl/cntrlP01.dbf' version
43131


SQL> shutdown immediate
ORA-01507: database not mounted


ORACLE instance shut down.
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit
Production
With the Partitioning and OLAP options
JServer Release 9.2.0.6.0 - Production
sapl02:orap01 57> cd /oracle/P01/saparch/cntrl/
sapl02:orap01 58> ls -al
total 24828
drwxr-xr-x  2 orap01 dba    4096 2006-12-09 15:03 .
drwxr-xr-x  3 orap01 dba   53248 2007-04-01 12:15 ..
-rw-r-----  1 orap01 dba 8757248 2007-04-01 12:56 cntrlP01.dbf
-rw-r-----  1 orap01 dba 8282112 2007-03-31 09:36 cntrlP01.dbf.31032007
-rw-r-----  1 orap01 dba 8282112 2007-01-05 05:55 cntrlP01.dbf.bak
sapl02:orap01 59> cp cntrlP01.dbf /oracle/P01/sapdata1/c
clud_1/  clui_1/  cntrl/
sapl02:orap01 59> cp cntrlP01.dbf /oracle/P01/sapdata1/cntrl/cntrlP01.dbf
sapl02:orap01 60> cp cntrlP01.dbf /oracle/P01/origlogA/cntrl/cntrlP01.dbf
sapl02:orap01 61> sqlplus /nolog

SQL*Plus: Release 9.2.0.6.0 - Production on Sun Apr 1 14:14:48 2007

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area  569337496 bytes
Fixed Size                   743064 bytes
Variable Size             268435456 bytes
Database Buffers          298835968 bytes
Redo Buffers                1323008 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '/oracle/P01/sapdata1/system_1/system.data1'


SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit
Production
With the Partitioning and OLAP options
JServer Release 9.2.0.6.0 - Production
sapl02:orap01 62> brrestore -d rman_util -b last -m full -c force
BR401I BRRESTORE 6.20 (114)
BR405I Start of file restore: rduydtqn.rsb 2007-04-01 14.17.53

BR564W File /oracle/P01/sapbackup/cntrlP01.dbf cannot be restored/verified
with other data files
BR564W File /oracle/P01/sapdata1/cntrl/cntrlP01.dbf cannot be
restored/verified with other data files
BR564W File /oracle/P01/origlogA/cntrl/cntrlP01.dbf cannot be
restored/verified with other data files
BR564W File /oracle/P01/saparch/cntrl/cntrlP01.dbf cannot be
restored/verified with other data files
BR567I Please restore/verify these files in a separate run
BR565W Due to running database instance control file cannot be restored
during restore using RMAN
BR566I Stop the database instance and restore the control file separately
BR456I Probably the database must be recovered due to restore from online
backup

BR280I Time stamp 2007-04-01 14.17.53
BR407I Restore of database: P01
BR408I BRRESTORE action ID: rduydtqn
BR409I BRRESTORE function ID: rsb
BR449I Restore mode: FULL
BR419I Files will be restored from backup: bduhjwje.fnr 2007-01-02 22.09.34
BR416I 41 files found to restore, total size 132700.320 MB
BR424I Files will not be decompressed
BR421I Restore device type: rman_util
BR134I Unattended mode with 'force' active - no operator confirmation
allowed

BR280I Time stamp 2007-04-01 14.17.53
BR554I Starting restore from full database backup using RMAN...
BR278E Command output of 'SHELL=/bin/sh /oracle/P01/920_64/bin/rman
nocatalog':

Recovery Manager: Release 9.2.0.6.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

RMAN>
RMAN> connect target system/*******;
connected to target database: P01 (DBID=1321861136)
using target database controlfile instead of recovery catalog

RMAN> **end-of-file**

RMAN>
host command complete

RMAN> 2> 3> 4> 5> 6> 7>
allocated channel: sbt_1
channel sbt_1: sid=11 devtype=SBT_TAPE
channel sbt_1: VERITAS NetBackup for Oracle - Release 6.0 (2005090703)

Starting restore at 01-APR-07

released channel: sbt_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 04/01/2007 14:18:02
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 20 found to restore
RMAN-06023: no backup or copy of datafile 15 found to restore
RMAN-06023: no backup or copy of datafile 14 found to restore
RMAN-06023: no backup or copy of datafile 21 found to restore
RMAN-06023: no backup or copy of datafile 29 found to restore
RMAN-06023: no backup or copy of datafile 28 found to restore
RMAN-06023: no backup or copy of datafile 18 found to restore
RMAN-06023: no backup or copy of datafile 19 found to restore
RMAN-06023: no backup or copy of datafile 26 found to restore
RMAN-06023: no backup or copy of datafile 41 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore
RMAN-06023: no backup or copy of datafile 17 found to restore
RMAN-06023: no backup or copy of datafile 10 found to restore
RMAN-06023: no backup or copy of datafile 37 found to restore
RMAN-06023: no backup or copy of datafile 24 found to restore
RMAN-06023: no backup or copy of datafile 12 found to restore
RMAN-06023: no backup or copy of datafile 27 found to restore
RMAN-06023: no backup or copy of datafile 30 found to restore
RMAN-06023: no backup or copy of datafile 8 found to restore
RMAN-06023: no backup or copy of datafile 16 found to restore
RMAN-06023: no backup or copy of datafile 40 found to restore
RMAN-06023: no backup or copy of datafile 13 found to restore
RMAN-06023: no backup or copy of datafile 23 found to restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 11 found to restore
RMAN-06023: no backup or copy of datafile 9 found to restore
RMAN-06023: no backup or copy of datafile 25 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 5 found to restore
RMAN-06023: no backup or copy of datafile 39 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 34 found to restore
RMAN-06023: no backup or copy of datafile 6 found to restore
RMAN-06023: no backup or copy of datafile 38 found to restore
RMAN-06023: no backup or copy of datafile 22 found to restore
RMAN-06023: no backup or copy of datafile 33 found to restore
RMAN-06023: no backup or copy of datafile 32 found to restore
RMAN-06023: no backup or copy of datafile 36 found to restore
RMAN-06023: no backup or copy of datafile 31 found to restore
RMAN-06023: no backup or copy of datafile 7 found to restore
RMAN-06023: no backup or copy of datafile 35 found to restore

RMAN>

Recovery Manager complete.
BR280I Time stamp 2007-04-01 14.18.03
BR279E Return code from 'SHELL=/bin/sh /oracle/P01/920_64/bin/rman
nocatalog': 1
BR536E RMAN call for database instance P01 failed

BR280I Time stamp 2007-04-01 14.18.03
BR556E Restore from full database backup using RMAN failed

BR406I End of file restore: rduydtqn.rsb 2007-04-01 14.18.03
BR280I Time stamp 2007-04-01 14.18.03
BR404I BRRESTORE terminated with errors

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: 
http://mailman.eng.auburn.edu/pipermail/veritas-bu/attachments/20070401/83a639c5/attachment.htm
[More with this subject...]
<Prev in Thread] Current Thread [Next in Thread>
  • [Veritas-bu] Failed to restore to different client using Netbackup for SAP on oracle db with RMAN, Shaharul Anuar <=
Next by Date:  [Veritas-bu] Multiple Retention Levels, Whelan, Patrick
Next by Thread:  [Veritas-bu] Multiple Retention Levels, Whelan, Patrick
Indexes:  [Date] [Thread] [Top] [All Lists]