Re: RMAN Recovery Question: Restore with loss of control files an

I'm now working on the problem of restoring a database from one server to another, with different directory locations and names. ( on Windoze )

I've got the syntax down, but there's something missing in the Veritas docs, and I'm not quite there yet.

Guess I'll have to call Veritas support now. If you've ever complained about Oracle support...

I'll post the solution when done.

Jared

On Tuesday 01 July 2003 08:40, Paul Baumgartel wrote:
> 1. 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).
>
> 2. 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: Jared Still
  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).