Antwort: RMAN Restore Scenario: all copies of control files are lost

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:



> 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