Re: Oracle backups using Snapshot Technology

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

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