RE: Snapshots and Oracle - toasters

14 Aug 2000

      All:
The TR refers to the major Oracle backup and recovery guide and assumes that the
reader has access to that material. As such, there is no attempt to elaborate on
items which are thoroughly covered in that medium.
Backing up an Oracle database which is stored on a filer using hot backups is
very comparable to doing so with conventional local disk - other than the fact
that the period during which the affected tablspaces are in hot backup mode is
dramatically shorter on a filer, due to the functionality of snapshots. Issues
such as backing up the control file, switching log files, etc., are identical to
local disk.
Jeff
-----Original Message-----
From: Clarke, Bruce 
Sent: Friday, August 11, 2000 7:20 PM
To: Browning, Jeff
Subject: FW: Snapshots and Oracle
As you are the author of the mentioned paper, would you
care to respond?
Bruce
-----Original Message-----
From: X X [mailto:gynt@post.com]
Sent: Friday, August 11, 2000 2:37 AM
To: toasters@mathworks.com
Subject: RE: Snapshots and Oracle
...

Does a hot backup (as described on

http://www.netapp.com/tech_library/3049.html) present any
restoration problems? Has anyone done a restore from a hot
backup?
How about handling of the control files?
In other hot-backup schemes I have seen, there are
a lot of stuff on how and when to do the
"ALTER DATABASE BACKUP CONTROLFILE ... ..." command.
Also also some stuff on "ALTER SYSTEM SWITCH LOGFILE" or
"ARCHIVE LOG NEXT"
None of these are mentioned in the above TechLibrary
article.
/Gynt
______________________________________________
FREE Personalized Email at Mail.com
Sign up at http://www.mail.com/?sr=signup
______________________________________________
FREE Personalized Email at Mail.com
Sign up at http://www.mail.com/?sr=signup