Antwort: RMAN Restore Scenario: all copies of control files are lost
From: Martin Klier <Martin.Klier_at_klug-is.de>
Date: Fri, 20 Nov 2009 18:17:48 +0100
Message-ID: <OFD984CFF5.849C67AF-ONC1257674.005EE536-C1257674.005F03B0_at_klug-is.de>
I'd do something similar, but use the RMAN capabilities a bit better:
Date: Fri, 20 Nov 2009 18:17:48 +0100
Message-ID: <OFD984CFF5.849C67AF-ONC1257674.005EE536-C1257674.005F03B0_at_klug-is.de>
I'd do something similar, but use the RMAN capabilities a bit better:
rman target /
startup nomount;
restore controlfile from '/oradata/controlfile.bak'
...
-- Mit freundlichem Gruß Martin Klier Senior Oracle Database Administrator ------------------------------------------------------------------------------ Klug GmbH integrierte Systeme Lindenweg 13, D-92552 Teunz Tel.: +49 9671/9216-245 Fax.: +49 9671/9216-112 mailto: martin.klier_at_klug-is.de www.klug-is.de ------------------------------------------------------------------------------ Geschäftsführer: Johann Klug, Roman Sorgenfrei Sitz der Gesellschaft: Teunz, USt-ID-Nr. DE175481608, HRB Nr. 2037, Amtsgericht Amberg oracle-l-bounce_at_freelists.org schrieb am 20.11.2009 17:53:01:Received on Fri Nov 20 2009 - 11:17:48 CST
> Von:
>
> Roger Xu <wellmetus_at_gmail.com>
>
> An:
>
> oracle-l_at_freelists.org
>
> Datum:
>
> 20.11.2009 17:56
>
> Betreff:
>
> RMAN Restore Scenario: all copies of control files are lost
>
> Gesendet von:
>
> oracle-l-bounce_at_freelists.org
>
> Hi RMAN gurus,
>
> Say one backs up a database using the following RMAN block daily:
>
> backup database archive log all;
> SQL 'alter database backup controlfile to '/oradata/controlfile.bak';
>
> All copies of the current control files were in the same disk and
> the disk crashed.
> Assuming other parts of the database are fine, will the following
> steps work to restore
> the database to the minute when the disk crashed?
>
> 1) copy /oradata/controlfile.bak to the control_files location
> specified in the SPFILE (or PFILE);
> 2) startup mount;
> 3) find out the most recent archived redo log sequence number
> (12345) in log_archive_dest_1;
> 4) restore database until sequence 12346;
> 5) alter database open resetlogs;
>
> The reason this may work is that RMAN automatically searches for
> archived and online redo logs that are not recorded
> in the RMAN repository (in this case the backup controlfile).
>
> Do you think this is one of the many advantages using RMAN vs user-
> managed backup?
>
> Thanks,
>
> Roger Xu
>
>
-- http://www.freelists.org/webpage/oracle-l