Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle backups using Snapshot Technology

Re: Oracle backups using Snapshot Technology

From: Yechiel Adar <adar666_at_inter.net.il>
Date: Thu, 09 Nov 2006 17:27:39 +0200
Message-ID: <455348EB.7050503@inter.net.il>


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
Received on Thu Nov 09 2006 - 09:27:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US