Re: Can someone check my logic here?

I would add to the excellent advice that if you have the space, keep the archive logs on the e: drive. If there is a failure, you do not have to worry about restoring them from tape (if they copied correctly). Whenever possible I keep on disk the archive log files needed to bring back the database from the last hot or cold backup, even though they also go to take. Also remember to make a copy of your initSID.ora file, a copy of your control files (alter database backup controlfile to 'e:\ctlSID.ctl' reuse;)
and a text copy of your control file (alter database backup controlfile to trace;) This will put a trace file containing the sql to recreate your controlfile where your user traces go.

matthew_at_mattshouse.com wrote:
: I'm setting up a backup procedure, and I would like someone to check for flaws
: in my plan. Also, I have a couple of questions at the end.

: Every Sunday we stop the database and initiate a cold backup. Monday -
: Saturday we only backup the archived logs. Technically, should disaster
: strike, we should be able to restore the cold backup and import the archived
: logs. This will give us up-to-the-minute recovery.

: Here is the output that I receive when I do an 'archive log list':

: SVRMGR> archive log list;
: Database log mode Archive Mode
: Automatic archival Enabled
: Archive destination e:\backup
: Oldest online log sequence 12801
: Next log sequence to archive 12802
: Current log sequence 12802

: Sure enough, there are archive logs in the e:\backup directory. Do I have
: everything that I need? Can I just send the archived logs to tape, or do I
: have to tell the database that I'm backing them up? After I send them to
: tape, can I delete them?

: Matthew

: -----------== Posted via Deja News, The Discussion Network ==----------
: http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

-- Received on Tue Nov 17 1998 - 18:05:00 CST