| rman restore to another box [message #54301] |
Sat, 09 November 2002 13:00  |
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 #54318 is a reply to message #54312] |
Mon, 11 November 2002 07:02  |
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 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
