Antwort: RMAN Restore Scenario: all copies of control files are lost
- From: "Martin Klier" <Martin.Klier@xxxxxxxxxx>
- To: wellmetus@xxxxxxxxx
- Date: Fri, 20 Nov 2009 18:17:48 +0100
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@xxxxxxxxxx
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@xxxxxxxxxxxxx schrieb am 20.11.2009 17:53:01:
> Von:
>
> Roger Xu <wellmetus@xxxxxxxxx>
>
> An:
>
> oracle-l@xxxxxxxxxxxxx
>
> Datum:
>
> 20.11.2009 17:56
>
> Betreff:
>
> RMAN Restore Scenario: all copies of control files are lost
>
> Gesendet von:
>
> oracle-l-bounce@xxxxxxxxxxxxx
>
> 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
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » Antwort: RMAN Restore Scenario: all copies of control files are lost - Martin Klier
