RE: Oracle backup questions...

Of the top of my head

1. Archives are written once the redo log switches in one go
2. If you lose your controlfiles and restore an old one this has no record of "future" archives. To be able to apply these you need to recover using backup controlfile.
3. dunno of the top of my head
4. delete obsolete deletes the backups that are still available but out of retention policy I believe, expired deletes the ones that are removed from the media
5. backup database plus archivelog.

Jack

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mason Loring Bliss
Sent: Wednesday, 19 September 2007 5:04 AM To: oracle-l_at_freelists.org
Subject: Oracle backup questions...

I'm working on Oracle back-up and recovery, and I've run across a few random questions from looking at what other folks do, and from experimenting on my own.

1. What is the on-disk state of archive logs at arbitrary times? Does Oracle only write them out when they are complete and usable, or does it slowly fill them in over time? Recovering the final archive log here seems to consistently fail, until the next archive log is in place, at which time the one that was previously last is imported without issue.
2. Is there any meaningful difference between "recover database" and
   "recover
   database using backup controlfile"?
3. What is "crosscheck archivelog all" as opposed to "crosscheck backup"?
4. How does "delete obsolete" differ from "delete expired backup"?
5. How do we control the frequency of archive log generation? Do I simply say
   "alter system switch logfile" and wait a bit, or does that only affect redo
   logs? Should I "alter system archive log all" instead? In short, what should I do to try to bring the archive logs as close to current as is possible?

Thanks very much for your help!

-- 
Mason Loring Bliss      mason_at_blisses.org        Oderint dum metuant!
http://blisses.org/     awake ? sleep : random() & 2 ? dream : sleep;
--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l