| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re[2]: Again RMAN - how to restore DB on another server?
Hi Folks,
Many thanks for your help. I just want to add a few more things: 1. I am staying with RH Linux Adv Server 2.0. 2. rman doesn't have the recovery catalog.
Q: Do I need to know exact location of all files of crushed database before I start recovery?
Alex.
Sunday, April 20, 2003, 1:36:39 AM, you wrote:
DW> Alex DW> Just a warning. If your original server is gone, you may have problems. DW> What you are describing is essentially a disaster recovery process. I've had DW> to run through that several times, each time finding a file or something DW> missing. DW> Did you perform your RMAN backup using the control file or a catalog? DW> You don't say what type of system you are using, Unix or NT. My DW> experience relates only to Unix. DW> First, can you place the RMAN backup pieces in the same location as they DW> were on the original machine. Or create a link to that path? DW> Second, do the file locations for all the database files exist? DW> If those conditions are met, then you basically need to create a database DW> with the same SID as the other database had, then start RMAN and recover the DW> database. You will probably discover some minor issues, but probably not DW> anything you can't overcome. DW> Dennis Williams DW> DBA, 40%OCP, 100% DBA
DW> -----Original Message----- DW> Sent: Saturday, April 19, 2003 8:57 AM DW> To: Multiple recipients of list ORACLE-L
DW> Hello List,
DW> I have a question about database recovery with RMAN, Oracle 9i R2.
DW> I have a full database backup done with rman command "backup database" DW> It includes original control file and spfile and all datafiles. DW> Primary server has gone. DW> How to run recovery process using this backupset on another machine with the DW> same Oracle version and OS? I suppose I don't need to create any DW> database on new place. I have to start some idle instance and use rmanDW> to restore and recovery files. Am I right? What are the necessary DW> steps I have to do?
DW> Thank you for your help in advance. DW> -- DW> Best regards, DW> Alex mailto:alex_a_at_pisem.net DW> -- DW> Please see the official ORACLE-L FAQ: http://www.orafaq.net DW> --
DW> Fat City Network Services -- 858-538-5051 http://www.fatcity.com DW> San Diego, California -- Mailing list and web hosting services DW> --------------------------------------------------------------------- DW> To REMOVE yourself from this mailing list, send an E-Mail message DW> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in DW> the message BODY, include a line containing: UNSUB ORACLE-L DW> (or the name of mailing list you want to be removed from). You may DW> also send the HELP command for other information (like subscribing). DW> -- DW> Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Best regards,
Alex mailto:alex_a_at_pisem.net
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Alex Andriyashchenko
INET: alex_a_at_pisem.net
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Apr 21 2003 - 02:56:42 CDT
 |
 |