Re: how to backup ASM diskgroup
Date: Wed, 16 Jul 2014 13:28:18 -0500
Message-ID: <CAO9=aUzPRqfO-K=KUz9QAxK9iuUYCG8M17Z_DKaYy+3F=xuneg_at_mail.gmail.com>
I'm assuming you're using Enterprise Edition since you mentioned Data Guard is in use. Enterprise Edition comes with quite a few built in solutions for fixing logical corruption.
You may want to look at using flashback technologies to reverse the corruption. You can also set a time delay on your standby. For example, if you set a time delay of 2 hours, then if logical corruption occurs on the primary it won't apply on the standby until 2 hours later.
If features like this could work for you, you could avoid the complex set up work and instead develop tested procedures for reversing logical corruption based on features that are already a part of the database.
On Tue, Jul 15, 2014 at 6:46 PM, amihay gonen <agonenil_at_gmail.com> wrote:
> Hi Chirs , thanks for your questions .
>
> Let me provide more deails , as you've asked.
>
> I've been request to aid a small team of QA developers in one of the
> startup i work at.
> They are testing a product base on Dataguard which aim to ensure that
> customer won't have not data loss , even if DG work in "maximum
> performance" . During there test they sometime "corrupt" on propose the
> Primary-Standby environment . Since they lack the dba knowledge, I've been
> request to come up with a easy and simple soulation to quick restore the
> environment.
>
>
> Since it is a development environment , I'm allow to do a cold backup of
> the databases. Databases are not big (20-30Gb) , backup/restore time is not
> an issue.
>
> as I far as i can see there are 3 options:
> 1. develop a home make script which use rman to backup PR+standby files
> (including control file,spfile etc..)
> 2. use snapshot option of vmware or SAN snapshot
> 3. DD of the ASM diskgroup (we've only one disk and one diskgroup).
>
>
> option 1 - This option required development effort .
> opton 2 - our storage is JBOD so we don't have snapshot option , I agree
> that this is the best option for testing (also snapshots may require more
> space depends on amount of change).
> A side note - maybe it worth to use a software solution
> like openfiler with snapshot capabilities over the JBOD
>
> option 3 - I'm not sure if this is possible , and I'm concern of the
> backup size , since I back the entire disk (device).
>
> anyhow, regarding option 3 - I wonder how simple it will be to the
> following script as backup :
> 1. stop oracle instances+asm instance
> 2. dd + gzip the asm disk
>
>
>
>
>
>
> On Tue, Jul 15, 2014 at 8:34 PM, Ruel, Chris <Chris.Ruel_at_lfg.com> wrote:
>
>> How loosely are you using the term “snapshot”? Are you just saying you
>> want to take a baseline cold backup that you can revert to if you screw up
>> the database with your testing?
>>
>>
>>
>> How big is the database? Are you concerned about the backup taking a
>> long time?
>>
>>
>>
>> What is the primary reason you are looking for alternatives to RMAN?
>>
>>
>>
>> Back to the term “snapshot”...are you considering a backend SAN
>> technology for snapping the disks? We use NetApp Snapshots for backups
>> (not DR backups) for quick recoveries and cloning. It can be done with the
>> database running or closed (cold with ASM disk groups stopped).
>>
>>
>>
>> Chris..
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> Chris Ruel * Oracle Database Administrator
>>
>> cruel_at_lfg.com * Desk:317.759.2172 * Cell 317.523.8482
>>
>>
>>
>> *From:* oracle-l-bounce_at_freelists.org [mailto:
>> oracle-l-bounce_at_freelists.org] *On Behalf Of *amihay gonen
>> *Sent:* Tuesday, July 15, 2014 12:25 PM
>> *To:* ORACLE-L
>> *Subject:* how to backup ASM diskgroup
>>
>>
>>
>> HI all ,
>>
>> I would like to be able to "snapshot" primary database and standby that
>> are using ASM.
>>
>>
>>
>>
>>
>> since this is a testing environment , I've option to shutdown both
>> databases and to do cold backup via rman .
>>
>>
>>
>> I was thinking if it will be easier just close the database (shutdown
>> immediate) and backup of the askdism group .
>>
>> assuming the following :
>>
>> 1. I've only one disk in the diskgroup
>>
>> 2. I'll shutdown the asm instance as well
>>
>>
>>
>>
>>
>> Notice of Confidentiality: **This E-mail and any of its attachments may
>> contain
>> Lincoln National Corporation proprietary information, which is
>> privileged, confidential,
>> or subject to copyright belonging to the Lincoln National Corporation
>> family of
>> companies. This E-mail is intended solely for the use of the individual
>> or entity to
>> which it is addressed. If you are not the intended recipient of this
>> E-mail, you are
>> hereby notified that any dissemination, distribution, copying, or action
>> taken in
>> relation to the contents of and attachments to this E-mail is strictly
>> prohibited
>> and may be unlawful. If you have received this E-mail in error, please
>> notify the
>> sender immediately and permanently delete the original and any copy of
>> this E-mail
>> and any printout. Thank You.**
>>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jul 16 2014 - 20:28:18 CEST