Re: Oracle backups using Snapshot Technology

  • From: Yechiel Adar <adar666@xxxxxxxxxxxx>
  • Date: Thu, 09 Nov 2006 17:27:39 +0200

Jesse, Rich wrote:


Hey Dianna,

So for our 9.2.0.5.0 DB, we have a nightly script that:

1)  Shuts down the secondary instance.  (which obviously didn't exist
the first time this was run!)
2)  umounts it's mount point.
3)  Drops the FlashCopy (IBM's FAStT name for snapshot) logical drive.
4)  Sets all TSs in the primary DB to begin backup.
5)  Recreates the FlashCopy logical drive.
6)  Remounts the secondary mount point.
7)  Ends backup mode on primary TSs.
8)  Tivoli backs up secondary DB MP (and archived redo, backup control
file, etc).
9)  Starts up secondary instance with recovery.

Steps 6/7 may be reversed -- I forget.  Anyway, this satisfies our
requirements.


Hello Jesse
I think that you need to split the copy after step 5. After that the order of steps 6 and 7 does not matter as they are performed on different copies. 

Adar Yechiel
Rechovot, Israel



--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 11-2006