Just got out of a meeting with the systems group. The Incremental backup
was not working because the command was written wrong. There has been a
decision to do cold backups each night.
The system people swear that the OpenVms can successfully backup an
open file (datafile) and have it recovered
Ron,
While Vms *can* backup the open datafile, it is worthless when you need to
recover it. I know, I've been there. Worked on Open Vms for about 8 years,
including Oracle for 3 years. The file would need recovery immediately upon
an attempt to open it. And I would not bet my job that I could
Ron - Yes they can back it up and recover it from their perspective. You've
brightened my day. Let us know if you want some more explanations to discuss
this with them again. ;-)
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, February
Ron -
the text below is from the fine VMS manual. I suspect your SAs are
referring to the backup/ignore=interlock command. I certainly would not
rely on it as part of my Oracle Disaster Recovery plan. The cold backup
decision sounds to me like a wise one.
BACKUP
Invokes the Backup
I'd tell them, great, then lets test it.
Trust no one.
Robert
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 2/12/2003 10:23 AM
Just got out of a meeting with the systems group. The Incremental backup
was not working because the command was written wrong. There has
Ron,
Back when we had Oracle on VMS (Oracle 7.1 - pre RMAN), we used this backup command
for each datafile:
backup/log/ignore=(interlock,nobackup)/new
This will backup open files. But if your tablespace isn't in hot backup mode, it
doesn't help you for database recovery. You might get
Ron - Thought of a simple way to explain the situation to your VMS
administrators. I've simplified a few things, but it should suffice. If I've
missed anything critical, someone will correct me ;-)
Each Oracle datafile has a transaction number recorded. The Oracle
control file has a transaction
Ron, the analogy I always use is who has to recover the database when it crashes?
When they say, well, YOU, then I say Fine. We are going to back it up the way I see
fit. End of story. Have fun testing~!!
Good Luck.
Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
5259
