Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: RMAN archivelog restore
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 DBAReceived on Wed Aug 10 2005 - 07:32:21 CDT
![]() |
![]() |