| Error restoring a cluster DB to a single node in another server [message #240010] |
Wed, 23 May 2007 19:44  |
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
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
