Re: What to do with archived redo-logs ?

This is a weird thread,

its very simple, if you run in archive log mode, and for any reason turn off archive log, and at a later stage want to turn it back on again, you HAVE to make a FULL OFFLINE backup of your database, and then start up. you cannot have any missing archived redo logfiles when you do recovery.

In theory, if you start up your database in archive log mode and do not have a backup, and at point 1, you make a full online backup, and at a later stage something goes wrong and you have all the archived files since point 1, I guess you can just restore that and go ahead, but this is Not the way to go, always start from a full offline working backup, and if anything goes wrong at some point you can always fall back from there and recover across all archived files until where you want to be. If you have an online backup, and one of the files was not backed up or what not, you're in trouble. and you don't want that on a production environment. Never think it will not happen to you...

Running batch jobs means that there is going to be massive redolog generation... yes. but its a small price to pay for consistency and safety if anything goes wrong...

Wim Received on Sat Jan 10 1998 - 00:00:00 CST