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 ........"
crystal ball broken today, please ask clear question.
The simple answer is because it's needed.
What's your backup strategy?
Wow... thats a lot of information... overwhelming.
Originally posted by kpate
full backup everday
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...
"There is a difference between knowing the path and walking the path."
we run on win2000 adv. server oracle220.127.116.11 .Below is the backup script
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
release channel d1;
release channel d2;
after backup i do resync catalog,crosscheck backup and archivelogs
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 .
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.
Last edited by kgb; 12-30-2003 at 10:58 AM.
Will using a recovery catalog fix this problem? I guess it was not used in this case.
One, who thinks that the other one who thinks that know and does not know, does not know either!
i also backup control file after full backup seprately everyday.also i am using catalog
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?
Last edited by kgb; 12-31-2003 at 05:32 AM.
Click Here to Expand Forum to Full Width