RE: For those using snapshots of Prod Disk Groups - Question
Date: Wed, 10 Jan 2018 15:52:56 +0000
Message-ID: <17345_1515599589_5A5636E5_17345_2694_1_ECDEF0CC6716EC4596FCBC871F48292AB192F4E7_at_ZRH-S231>
I’m using the following process for snapshoting database in archivelog mode without stopping it:
Alter database begin backup;
Snapshot file systems with data files and online redo logs
Alter database end backup;
alter database backup controlfile to trace as .. ;
alter system archive log current ;
Snapshot file systems with the archivelogs
In the case of rollback:
Stop the database
Rollback all file systems
Recreate controlfile and recover
(Change dbid to avoid conflicts in RMAN)
I also use snapshots for “database cloning” where a new database is created based on the snapshot. The process is similar to rollback except that new file systems are created based on the snapshot and the controlfile backup (as trace) has to be edited to reflect the name of the new database and new file locations.
In case that you’re stopping the source database when doing the snapshot, the FRA is not necessary.
I rely on ZFS instead of storage copy-on-write functionality.
Last but not least, as you correctly mentioned, snapshotting is no replacement for backup/recovery, but is very useful when doing application and database upgrades. It is also invaluable for quick provisioning of development databases.
Best regards,
Nenad
http://nenadnoveljic.com/blog/
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Chris Taylor
Sent: Mittwoch, 10. Januar 2018 16:21
To: ORACLE-L
Subject: For those using snapshots of Prod Disk Groups - Question
For those of you utilizing storage snapshots of your Prod disk groups, do you also include the FRA contents in your snapshots?
There's an open question we're discussing about whether we need the FRA contents as part of the snapshot.
I'm thinking the FRA contents don't need to be part of the snapshot but I could be mistaken.
Chris
Please consider the environment before printing this e-mail. Bitte denken Sie an die Umwelt, bevor Sie dieses E-Mail drucken.
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">p { font-family: Arial;font-size:9pt }</style>
</head>
<body>
<p>
<br>Important Notice</br>
<br>This message is intended only for the individual named. It may contain confidential or privileged information. If you are not the named addressee you should in particular not disseminate, distribute, modify or copy this e-mail. Please notify the sender immediately by e-mail, if you have received this message by mistake and delete it from your system.</br>
<br>E-mail transmission may not be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete. Also processing of incoming e-mails cannot be guaranteed. All liability of the Vontobel Group and its affiliates for any damages resulting from e-mail use is excluded. You are advised that urgent and time sensitive messages should not be sent by e-mail and if verification is required please request a printed version.<br/>
</p>
</body>
</html>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 10 2018 - 16:52:56 CET