| 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: RMAN Recovery without Catalog
Content-Type: text/plain
We're on windooze using a catalog but I believe the catalog or lack thereof
makes no matter in this instance
For example, normally we create backupsets on f:\oracle\backups on Production server. When we do disaster recovery testing we ensure that a f:\oracle\backups directory exists on the restore server and then copy the backup sets to that location on the restore server . From there on the restore server I can issue restore database and the catalog knows to look in f:\oracle\backups for the backups sets and then to initiate the restore
regards
steve
Steve Montgomerie
PeopleSoft/Oracle Administrator
SIEMENS Shared Services, LLC
4400 Alafaya Trail, M/S AL-222
Orlando, FL 32826
Phone: 407 487-5219
Cell : 407 810-8387
Fax: 407 487-5833
-----Original Message-----
From: H elp_me [mailto:good_dba_at_hotmail.com]
Sent: Thursday, April 15, 2004 3:09 AM
To: oracle-l_at_freelists.org
Cc: Montgomerie Steve
Subject: RE: RMAN Recovery without Catalog
Hello Steve,
Thanks for the reply.. I am still not clear.. will it read it from HOST_A ? What if i have already backed up using RMAN but for recovery don't have the catalog.
Say : Backuped up HOST_A database using RMAN to DISK1.
Now when I restore without catalog.. will it read from DISK1 or HOST_A ?
Well, if i duplicate the database using RMAN.. it should read from HOST_A directly.
Thanks agian.
NIk
>From: Montgomerie Steve <steve.montgomerie_at_siemens.com>
>Reply-To: oracle-l_at_freelists.org
>To: "'oracle-l_at_freelists.org'" <oracle-l_at_freelists.org>
>Subject: RE: RMAN Recovery without Catalog
>Date: Wed, 14 Apr 2004 21:13:56 -0400
>
>My doubt here is .. how will RMAN get the files ? Where will it go and find
>/read the files from ?
>..........it will look in the same dest on the target as was specified on
>the source
>Steve Montgomerie
>PeopleSoft/Oracle Administrator
>SIEMENS Shared Services, LLC
>4400 Alafaya Trail, M/S AL-222
>Orlando, FL 32826
>Phone: 407 487-5219
>Cell : 407 810-8387
>Fax: 407 487-5833
>
>
>-----Original Message-----
>From: H elp_me [mailto:good_dba_at_hotmail.com]
>Sent: Wednesday, April 14, 2004 8:40 PM
>To: oracle-l_at_freelists.org
>Subject: RMAN Recovery without Catalog
>
>
>
>
>Hello All,
>
>NOTE : This is Recover a databse on ANOTHER node using RMAN WITHOUT
Recovery
>Catalog.
>
>I am trying to recover and create a database from Host A to Host B
>
>Here are the steps.. I found in oracle documentation but am confused a
bit..
>
>
>1. Copy the control file using OS copy utility.
>
>2. Copy INIT File using OS copy utility.
>
>3. connect with rman to target with nocatalog
>
>rman target sys/pw_at_host_b[1] nocataclog
>
>startup mount;
>
>now
>
>allocate appropriate channel and all that..
>
>restore database;
>
>recover database;
>
>alter database open resetlogs;
>
>
>
>My doubt here is .. how will RMAN get the files ? Where will it go and find
>/read the files from ?
>
>Let me know if someone has performed NOCATALOG RECOVERY and has steps
>documented which work.
>
>Thanks
>
>Nik
>
>
>
>
>
>
>
>---------------------------------------------------------------------------
-
>Get rid of annoying pop-up ads with the new MSN Toolbar - FREE![2]
>
>--- Links ---
> 1 mailto:sys/pw_at_host_b
> 2 http://g.msn.com/8HMAENUS/2752??PS=
>----------------------------------------------------------------
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>----------------------------------------------------------------
>To unsubscribe send email to: oracle-l-request_at_freelists.org
>put 'unsubscribe' in the subject line.
>--
>Archives are at http://www.freelists.org/archives/oracle-l/
>FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
>-----------------------------------------------------------------
>
>
>
>-- Binary/unsupported file stripped by Ecartis --
>-- Type: application/octet-stream
>-- File: Montgomerie Steve.vcf
>
>
>----------------------------------------------------------------
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>----------------------------------------------------------------
>To unsubscribe send email to: oracle-l-request_at_freelists.org
>put 'unsubscribe' in the subject line.
>--
>Archives are at http://www.freelists.org/archives/oracle-l/
>FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
>-----------------------------------------------------------------
Check out MSN PC Safety <http://g.msn.com/8HMBENUS/2749??PS=> & Security to help ensure your PC is protected and safe.
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Thu Apr 15 2004 - 04:37:55 CDT
 |
 |