Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Can someone check my logic here?

Can someone check my logic here?

From: <matthew_at_mattshouse.com>
Date: Tue, 17 Nov 1998 14:43:22 GMT
Message-ID: <72s22a$p69$1@nnrp1.dejanews.com>


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 - 08:43:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US