Home » RDBMS Server » Backup & Recovery » Error restoring a cluster DB to a single node in another server
Error restoring a cluster DB to a single node in another server [message #240010] Wed, 23 May 2007 19:44 Go to next message
Eddy67
Messages: 2
Registered: July 2005
Location: Santo Domingo
Junior Member
I am restoring a 9i cluster to a single node DB in another server and get this error. I first tried the DUPLICATE and fail with the same error.

RMAN> connect catalog rman/rman@rman;
2> connect target sys/oracle@nwbd;
3>
5>
6> run
7> {
8> allocate channel t1 type 'SBT_TAPE'
9> parms 'ENV=(NSR_SERVER=serverbck, NSR_CLIENT=prod01)';
10> allocate channel t2 type 'SBT_TAPE'
11> parms 'ENV=(NSR_SERVER=serverbck, NSR_CLIENT=prod01)';
12> allocate channel t3 type 'SBT_TAPE'
13> parms 'ENV=(NSR_SERVER=serverbck, NSR_CLIENT=prod01)';
14> allocate channel t4 type 'SBT_TAPE'
15> parms 'ENV=(NSR_SERVER=serverbck, NSR_CLIENT=prod01)';
20>
21> restore controlfile;
22> sql "alter database mount";
23> restore database;
24> recover database;
25> sql "alter database open resetlogs";
26> }
27>
28>
connected to recovery catalog database

connected to target database: nwdb (not mounted)

allocated channel: t1
channel t1: sid=11 devtype=SBT_TAPE
channel t1: NMO v4.2.0.0

allocated channel: t2
channel t2: sid=12 devtype=SBT_TAPE
channel t2: NMO v4.2.0.0

allocated channel: t3
channel t3: sid=13 devtype=SBT_TAPE
channel t3: NMO v4.2.0.0

allocated channel: t4
channel t4: sid=14 devtype=SBT_TAPE
channel t4: NMO v4.2.0.0

Starting restore at 23-MAY-07

channel t1: starting datafile backupset restore
channel t1: restoring controlfile
output filename=/oradata/nwdb/nwdb_control_1.ctl
channel t1: restored backup piece 1
piece handle=NWDB_623275315_2116_24iicr9j tag=TAG20070522T200151 params=NULL
channel t1: restore complete
replicating controlfile
input filename=/oradata/nwdb/nwdb_control_1.ctl
output filename=/oradata/nwdb/nwdb_control_2.ctl
output filename=/oradata/nwdb/nwdb_control_3.ctl
Finished restore at 23-MAY-07

sql statement: alter database mount

Starting restore at 23-MAY-07

channel t1: starting datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
restoring datafile 00003 to /oradata/nwdb/nwdb_data_01.dbf
channel t4: starting datafile backupset restore
restoring datafile 00029 to /oradata/nwdb/indx4.dbf
restoring datafile 00031 to /oradata/nwdb/nwdb_users_04.dbf
channel t1: restored backup piece 1
piece handle=NWDB_623275322_2117_25iicr9q tag=TAG20070522T200151 params=NULL
channel t1: restore complete
channel t2: restored backup piece 1
piece handle=NWDB_623275330_2118_26iicra2 tag=TAG20070522T200151 params=NULL
channel t2: restore complete
channel t3: restored backup piece 1
piece handle=NWDB_623275333_2119_27iicra5 tag=TAG20070522T200151 params=NULL
channel t3: restore complete
channel t4: restored backup piece 1
piece handle=NWDB_623275315_2116_24iicr9j tag=TAG20070522T200151 params=NULL
channel t4: restore complete
Finished restore at 23-MAY-07

Starting recover at 23-MAY-07

starting media recovery

channel t1: starting archive log restore to default destination
channel t2: starting archive log restore to default destination
channel t3: starting archive log restore to default destination
channel t4: starting archive log restore to default destination
channel t1: restoring archive log
archive log thread=1 sequence=11344
channel t2: restoring archive log
archive log thread=2 sequence=12280
channel t3: restoring archive log
archive log thread=2 sequence=12281
channel t4: restoring archive log
archive log thread=1 sequence=11345
channel t5: restoring archive log
archive log thread=2 sequence=12282
channel t6: restoring archive log
archive log thread=1 sequence=11346
Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/oradata/nwdb/nwdb_system_01.dbf'

released channel: t1
released channel: t2
released channel: t3
released channel: t4
released channel: t5
released channel: t6
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/23/2007 19:44:23
ORA-19507: failed to retrieve sequential file, handle="2ciict2o_1_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
Could not locate the LNM save file '2ciict2o_1_1' on server 'serverbck'. (2:9:0)

Recovery Manager complete.


The same happened with the duplicate.

Any help will be apreciated.

TIA

Re: Error restoring a cluster DB to a single node in another server [message #240229 is a reply to message #240010] Thu, 24 May 2007 07:26 Go to previous messageGo to next message
coolbalaga
Messages: 24
Registered: September 2006
Junior Member
you should check with the third party vendor who has provided the SBT library.
Re: Error restoring a cluster DB to a single node in another server [message #240267 is a reply to message #240229] Thu, 24 May 2007 08:55 Go to previous message
Eddy67
Messages: 2
Registered: July 2005
Location: Santo Domingo
Junior Member
I can complete either the duplicate or the restore manually so the backups exists, but that's not the idea.
Previous Topic: Database is in 9i and catalog on 10g
Next Topic: Backing up and Restoring/Recovering an Oracle 9i Database
Goto Forum:
  


Current Time: Mon Dec 05 10:57:03 CST 2016

Total time taken to generate the page: 0.10315 seconds