- I have configured RMAN for controlfile autobackup, so that every DB
backup produces a backup of the controlfiles and spfile as well. With
these, I can easily recover from a loss of every single database file.
I can't imagine why anyone wouldn't do it this way (reponses invited).
- MetaLink states that the location of a backup file is embedded in
the file itself, that it can't be used if it's moved to another
location, and that this is a feature (yeah, right). On Unix, symlinks
will do the trick; on Windoze, the suggested workaround is to back up
the backup to another location that matches the one from which you want
to use it. I ran into this when restoring a backup on another system
that had a different drive layout; rather than backing up the backup, I
just juggled drive letters. The lesson here is to ensure that your
backup directories are configured and named consistently across all
database servers.
- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
> Timothy
> I will tell you what I've figured out. Perhaps someone else can
> provide additional information.
>
> 1. Some people have reported success in extracting the control file
> from the RMAN backup. I got stuck on the issue that RMAN wouldn't
> function unless the target instance was up with STARTUP MOUNT, but I
> couldn't mount the database
> until I had a control file to mount. I finally gave up and took the
> expedient of doing a separate SQL BACKUP CONTROLFILE statement, using
> the RMAN backup directory. To perform a disaster recovery, I just
move
> my copy of the control file into position first.
>
> 2. I have not been able to convince RMAN to use a different backup
> location.
> Fortunately with Unix it is easy to create a link that looks like the
> original location.
>
>
>
> Dennis Williams
> DBA, 80%OCP, 100% DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
>
> -----Original Message-----
> Sent: Monday, June 30, 2003 10:35 AM
> To: Multiple recipients of list ORACLE-L
> catalo database
>
>
>
> Hi there everyone,
>
> I have read the documentation and I am missing something, I am stuck
> on two
> points:
>
> (1) How do I recover from a RMAN backup to disk if I have lost all
> the
> original database files (control files, data files and redo logs)
>
> (2) How do I change the location for RMAN to check for the backup up
> file
> i.e. Backup file was on E: but now in F:, when I enter restore it
> only
> checks the original location.
>
>
> Specifications:
> Oracle 8.1.7.4.10
> Windows 2000 SP4
>
>
> I know that in the backup part I can use the FORMAT string to specify
> the
> filename and location.
>
>
> Cheers
> Tim Clarkson
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: DENNIS WILLIAMS
> INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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).
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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 Tue Jul 01 2003 - 10:15:13 CDT
