Re: Recover using RMAN with NOCATALOG option

Ok, I found way.
If any is interested then here goes explanation:

1. svrmgr> startup nomount
2. rman> run { allocate channel d1 type disk; replicate controlfile from '/RMANBKP/control_full.bkpcf''; release channel d1; }
3. rman> alter database open
4. rman> run { allocate channel d1 type disk; restore database; recover database; release channel d1; } It gives you message RMAN-06054: media recovery requesting unknown log: thread 1scn 53226
5. svrmgr> recover database using backup controlfile auto :))))
6. svrmgr> alter database open resetlogs;

"Edward Rusu" <erusu_at_softcomputer.com> wrote in message news:3afafabc$1_at_smtp2.softcomputer.com...
> Hi All,
> I use rman utility to make daily a full database backup using the
 following
> script,
> without using recovery catalog(NOCALATOG option):
> run
> {
> allocate channel d1 type disk;
> backup full format '/RMANBKP/%d_s%s_p%p.bkpdf' (database);
> sql 'alter system archive log current';
> backup format '/RMANBKP/%d_s%s_p%p.bkpal' (archivelog all delete input);
> copy current controlfile to '/RMANBKP/control_full.bkpcf';
> release channel d1;
> }
>
> Let's imagine that all datafiles, control files and online redolog files
 are
> lost.
> All I have is rman's backupsets in /RMANBKP and archived redologs
 generated
> since last backup.
> I can restrore control file from last backup and recover database to the
> time of last backup.
> But I cannot apply archived redolog files because there is no
> information about them in restored contol file.
> I think it is possible to apply archived redologs if I could extract SCN
> from last archived
> redolog and modify control file to have that extracted SCN. Probably I can
> do it
> with support from Oracle, but I just wonder is there any tools or strategy
> to recover
> database to the last archived redolog using above mentioned backup
 strategy?
>
> Thanks in advance,
> Edward Rusu
>
>
>
>
>
Received on Thu May 10 2001 - 16:12:19 CDT