Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> backup and online reso logs question
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