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 -> backup and online reso logs question

backup and online reso logs question

From: michael.cooke <michael.cooke_at_tinyworld.co.uk>
Date: Sat, 27 Apr 2002 23:40:08 +0100
Message-ID: <3ccb28e1_1@mk-nntp-1.news.uk.worldonline.com>


Oracle 7.3.3 NT4sp6a (Veritas backup exec 8.6) currently generating a hot backup nightly using alter tablespace ...... begin backup for all tablespaces at the same time
running NTbackup to xcopy all datafiles, controlfile, online redolog files etc to another PC. alter tablespace ...... end backup, logswitch backup control to trace etc the backup copy is then copied to tape along with the archived redo logs.
I then load the content of the tape to a sandalone test server open the database after using the recover database option and am able to use it for test purposes in the knowledge that I have a fully recoverable backup. I am going over to a new server soon and will be using veritas backup exec 8.6 with the oracle agent. I have tested the backup process using this option and notice it does not backup the online redo logs or controlfile (creates a copies a backup). To be able to carryout a full recovery (if you lose the server completely) you need the online logfiles as well as all the others else you cannot open the db. does anyone out there use veritas to create hot backups and have they had any problems recovering a full dbase as I will still need to be able to restory onto my test server? how did you get around the online redologs not being backed up?

sorry its a bit like war & peace and hope someone has the patients to read an answer it.

regds
Mick Received on Sat Apr 27 2002 - 17:40:08 CDT

Original text of this message

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