Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: RMAN archivelog restore

Re: RMAN archivelog restore

From: <sybrandb_at_yahoo.com>
Date: 10 Aug 2005 05:32:21 -0700
Message-ID: <1123677141.780921.20120@z14g2000cwz.googlegroups.com>


Complete recovery is not an option for you anymore in this situation as you don't have a current controlfile. If you are not using a catalog, you *always* need to dump the controlfile to <filename> *after* any relevant backup.

Incomplete recovery is your only choice. You don't need to specify any backup sets, you need to specify until which logsequence you want to proceed, using the set until logseq <sequence#>.
Basically you are going to
run
{
set until logseq <your log sequence>;
restore database;
recover database using backup controlfile; alter database open resetlogs; -- noresetlogs is going to fail }

and that will be all.
Evidently this is documented in the Backup and Recovery Manual, in the 'performing incomplete recovery' section. If you don't have all your archivelogs anymore (you are vague about that), the recovery procedure doesn't allow you to skip archives.

Hth

-- 
Sybrand Bakker
Senior Oracle DBA
Received on Wed Aug 10 2005 - 07:32:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US