rman restore

[kpate]

why rman looks for previous backup and not current backups.we backup to tape and every day tape goes offsite and was trying to restore todays backup for creating duplicate database.Somehow rman looks for previous backup which is not there in tape library and
throws error "not to able to find sequential file ........"

[marist89]

crystal ball broken today, please ask clear question.

The simple answer is because it's needed.

What's your backup strategy?

[kpate]

full backup everday

[adewri]

Originally posted by kpate
full backup everday

Wow... thats a lot of information... overwhelming.

Your backup scripts would be helpful senor... and if possible your DB version, your OS etc etc... whether using any media manager like legato etc...

also the error number, please...

[kpate]

we run on win2000 adv. server oracle8.1.7.3 .Below is the backup script
run {
allocate channel d1 type ='sbt_tape';
allocate channel d2 type ='sbt_tape';
sql "ALTER SYSTEM ARCHIVE LOG CURRENT";
backup archivelog all format 'ar_%d_%s_%p_%t';
backup incremental level 0 tag = 'Full Level 0' database
include current controlfile
filesperset = 15
format 'db_%d_%s_%p_%t';
release channel d1;
release channel d2;
}
after backup i do resync catalog,crosscheck backup and archivelogs

[kpate]

is it a bug.It still does that lools for previous day backup while restore.I do a full backup everday to tape we use syncsort for that .

[kgb]

Hi, Kpate
I think you have to backup controlfile separately (after the full backup), because in your case controlfile has previous backup information and does not have the current one - that is why RMAN asks for previous backup. In your case FULL restore without previous backup is not possible.
Regards,

[BV1963]

KGB,

Will using a recovery catalog fix this problem? I guess it was not used in this case.

[kpate]

thanks,kgb
i also backup control file after full backup seprately everyday.also i am using catalog

[kgb]

Please, Show me the script you use for restoring database.
How often do you resync catalog?
How much archived redo log data (and how many archived redo log files) is generated for 24 hours?