-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I expect what you're going to have to do is export your oracle database
to a local filesystem (with the CONSISTENT=Y option) just before your
take your snapcopy, and force a disk flush (sync command). So long as
the dump + flush finishes before the snapcopy, you should be able to
restore oracle from the export.
You can probably arrange your export script to send some form of alert
to your snapcopy process when the export is done, using some of the
tools in the s390utils package ('vmur' and send something to the
account's spool, 'vmcp smsg' ...).
- -- Pat
Graves, Aaron wrote:
> Unless you can shut down the zLinux instance when you take your snapcopy, you
> will always be out of sync.
>
> Aaron
>
> -----Original Message-----
> From: Linux on 390 Port [mailto:[email protected]] On Behalf Of Joseph
> Higgins
> Sent: Tuesday, August 10, 2010 8:04 AM
> To: [email protected]
> Subject: Re: Consistency groups for ZLinux Oracle environment
>
> Thank you for the reply.
> This is a little different than a straight backup.
> We are using a snapcopy (Flashcopy, TimeFinder, Shadowimage) to take the PIT
> and the Oracle control files and index are not in sync.
>
> Joseph Higgins
> Account Consultant
> HITACHI DATA SYSTEMS
> 90 Park Avenue
> New York, NY 10016
> P 212 827 1343 / C 201 566 6029
>
> [email protected]
>
>
> -----Original Message-----
> From: Linux on 390 Port [mailto:[email protected]] On Behalf Of
> Shockley, Gerard C
> Sent: Tuesday, August 10, 2010 7:59 AM
> To: [email protected]
> Subject: Re: Consistency groups for ZLinux Oracle environment
>
> Have tried many -:
>
> Use RMAN with the FDR/Upstream interface. Works great.
>
> Several successful recoveries in a wind tunnel (DR site).
>
> Gerard
>
>
> -----Original Message-----
> From: Linux on 390 Port [mailto:[email protected]] On Behalf Of David
> Boyes
> Sent: Monday, August 09, 2010 2:34 AM
> To: [email protected]
> Subject: Re: Consistency groups for ZLinux Oracle environment
>
> How are you taking the backup? If you're using anything but an application
> running inside the virtual machine (eg RMAN to disk, or another app that uses
> the Oracle APIs to get the data), you're going to lose, and you get the
> problem you've observed. The virtual machine probably has loads of stuff in
> RAM which the disk controllers may not know about yet, so your PIT copy is
> missing stuff.
>
> You either have to take the virtual machine down, or do your backups from
> inside the virtual machine. I'd suggest the latter.
>
> --db
>
> On 8/8/10 9:38 PM, "Joseph Higgins" <[email protected]> wrote:
>
>> Hello,
>>
>> Is there any way to maintain consistency for point in time copies
>> without suspending the server IO?
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
iEYEARECAAYFAkxhb/QACgkQNObCqA8uBswjjACePeMj5ISe0vxkNwZxR6zub5c6
a+AAn3qMfbU9+F3l6l4n0BR1RejA+NOp
=DUK0
-----END PGP SIGNATURE-----
----------------------------------------------------------------------
For LINUX-390 subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390
----------------------------------------------------------------------
For more information on Linux on System z, visit
http://wiki.linuxvm.org/
