Re: Restoring RMAN backups to different host ......solved

2002-09-12 Thread Yechiel Adar
If I remember correctly netbackup can restore oracle DB only to the original machine. By setting this environment variable you trick it to think that this is the original machine. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent:

Re: Restoring RMAN backups to different host ......

2002-09-06 Thread Jay Hostetter
Babu, You need to copy your backup files to HOST_B. If your file systems are different thant HOST_A, create symbolic links for the directories where rman expects to find the backups. Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 09/05/02 08:13PM

RE: Restoring RMAN backups to different host ......

2002-09-06 Thread DENNIS WILLIAMS
Babu I agree with Jay, you need to create symbolic links that mimic the locations RMAN hopes to find the backup files. I was unable to get RMAN to restore the control file. The problem I encountered was that RMAN required the target database to be mounted first, but without a control file I

Re: Restoring RMAN backups to different host ......

2002-09-06 Thread ltiu
About restoring controlfiles, if I remember this correctly as I did just this a few months ago: You have to startup database nomount. Then restore controlfile. Then alter database mount. Then restore database. ltiu DENNIS WILLIAMS wrote: Babu I agree with Jay, you need to create

RE: Restoring RMAN backups to different host ......solved

2002-09-06 Thread Janardhana Babu Donga
Dear List, Thanks for all those who replied. One of my collegue helped me in resolving the issue yesterday. Iam using Veritas Netbackup software. If I set the UNIX env variable NB_ORA_CLIENT=host_A and also in RMAN script parms, then it is restoring the backups from host_A. run { allocate

Restoring RMAN backups to different host ....

2002-09-05 Thread Janardhana Babu Donga
Dear List, I have a database 'rtest' and catalog database 'rcat' on machine: A and Iam taking regular RMAN TAPE backups of 'rtest' database using the catalog database 'rcat'. I need to restore the latest RMAN tape backup of 'rtest' database onto another brand new box: B. Is there a way to

Restoring RMAN backups to different host ......

2002-09-05 Thread Janardhana Babu Donga
Dear List, Iam following the procedure to restore database from RMAN backup from HOST_A to HOST_B with a recovery catalog. 1. I copied the init.ora file to HOST_B 2. on HOST_B, I made an entry in oratab for 'rtest' database and switch to 'rtest' database using . oraenv 3. issued: rman target /

Re: Restoring RMAN backups to different host ......

2002-09-05 Thread zhu chao
Janardhana Babu Donga, hi, which backup software are u using? as far as i know, you must setup something in the second node so that MML software can THINK it is the node that is backed up, so it can restore back. Regards zhu chao Eachnet DBA 86-21-32174588-667 [EMAIL PROTECTED]