RE: RMAN Recovery without Catalog
- From: Montgomerie Steve <steve.montgomerie@xxxxxxxxxxx>
- To: "'H elp_me'" <good_dba@xxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Thu, 15 Apr 2004 05:40:54 -0400
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@xxxxxxxxxxx]
Sent: Thursday, April 15, 2004 3:09 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxx>
>Reply-To: oracle-l@xxxxxxxxxxxxx
>To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
>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@xxxxxxxxxxx]
>Sent: Wednesday, April 14, 2004 8:40 PM
>To: oracle-l@xxxxxxxxxxxxx
>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@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@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@xxxxxxxxxxxxx
>put 'unsubscribe' in the subject line.
>--
>Archives are at //www.freelists.org/archives/oracle-l/
>FAQ is at //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@xxxxxxxxxxxxx
>put 'unsubscribe' in the subject line.
>--
>Archives are at //www.freelists.org/archives/oracle-l/
>FAQ is at //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.
-- 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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
