Home » RDBMS Server » Backup & Recovery » rman restore to another box
rman restore to another box [message #54301] Sat, 09 November 2002 13:00 Go to next message
Imran
Messages: 56
Registered: November 2001
Member
Hi,
I am trying to restore a rman back to another unix box. This is just a test for d/r plan.The production database is up and running when I tried to restore it to another box.File system is same on both the boxes.Database in test box is in no mount stage. I tried to restore only control file and getting an error:

Recovery Manager: Release 8.1.7.3.0 - Production

RMAN-06006: connected to target database: TRNG (not mounted)
RMAN-06008: connected to recovery catalog database

RMAN> run {
2> set until time "to_date('Nov 07 2002 22:00:00','Mon DD YYYY HH24:MI:SS')";
3> allocate channel t1 type 'sbt_tape' parms
4> 'ENV=(TDPO_OPTFILE=/users/oracle/scripts/backup/tdpo.opt)';
5> allocate channel t2 type 'sbt_tape' parms
6> 'ENV=(TDPO_OPTFILE=/users/oracle/scripts/backup/tdpo.opt)';
7> restore controlfile;
8> release channel t1;
9> release channel t2;
10> }
11>
RMAN-03022: compiling command: set

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: t1
RMAN-08500: channel t1: sid=17 devtype=SBT_TAPE
RMAN-08526: channel t1: Tivoli Data Protection for Oracle: version 2.2.0.0

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: t2
RMAN-08500: channel t2: sid=16 devtype=SBT_TAPE
RMAN-08526: channel t2: Tivoli Data Protection for Oracle: version 2.2.0.0

RMAN-03022: compiling command: restore
RMAN-08030: allocated channel: t2
RMAN-08500: channel t2: sid=16 devtype=SBT_TAPE
RMAN-08526: channel t2: Tivoli Data Protection for Oracle: version 2.2.0.0

RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08016: channel t1: starting datafile backupset restore
RMAN-08502: set_count=313 set_stamp=477294320 creation_time=07-NOV-02
RMAN-08021: channel t1: restoring controlfile
RMAN-08505: output filename=/u01/oradata/TRNG/control01.ctl
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: t1
RMAN-08031: released channel: t2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03007: retryable error occurred during execution of command: IRESTORE
RMAN-07004: unhandled exception during command execution on channel t1
RMAN-10035: exception raised in RPC: ORA-19507: failed to retrieve sequential fi
le, handle="9pe75rng_1_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.RESTOREBACKUPP
Re: rman restore to another box [message #54312 is a reply to message #54301] Mon, 11 November 2002 05:33 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10706
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
are u running any other media management / backup utilities ( like netbackup) too?
if so, please check for the similiar meesages in those logs also?
Re: rman restore to another box [message #54318 is a reply to message #54312] Mon, 11 November 2002 07:02 Go to previous messageGo to next message
Imran
Messages: 56
Registered: November 2001
Member
Mahesh,
Thanks for your reply. I am using tivoli storage manager. This is the only error I am getting. On Tivoli side there is connection but died right away.
Any advise will grestly be appreciated.
Thanks
Imran
Re: rman restore to another box [message #56322 is a reply to message #54301] Wed, 19 March 2003 08:20 Go to previous message
Ed Hain
Messages: 1
Registered: March 2003
Junior Member
Imran,
Did you ever find a solution to the ORA-19507 error? We're getting the same error trying to do the same thing--i.e., rman restore using Tivoli to another box for a d/r test. If you did find a solution, I'd appreciate it if you could pass along the solution to us via email. We've been trying for days to get past this error without success. Thanks much.
Ed Hain
Previous Topic: Number of Channel Limit for RMAN RESTORE
Next Topic: Hot Backup Urgent help please
Goto Forum:
  


Current Time: Fri Jun 02 06:37:12 CDT 2023