RE: an interview question

From: Jeremiah Wilton <jeremiah_at_ora-600.net>
Date: Wed, 16 Jul 2008 12:00:42 -0700
Message-ID: <01a801c8e776$4004c230$c00e4690$@net>


Prabhu, Krishnaswamy wrote:

> Is it possible to recover a database whose couple of datafiles , all
multiplexed
> controlfiles and rman catalog repository are lost. A complete rman backup
exists
> but catalog and control files are lost.

RMAN> restore controlfile from <backuppiece>;

Something easy to find with google or the documentation.

IIRC in 8i it used to require some effort and calls directly to dbms_backup_restore.

Jeremiah Wilton
ORA-600 Consulting
http://www.ora-600.net

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jul 16 2008 - 14:00:42 CDT

Original text of this message