Disk Arrays
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle on EVA4000 on Solaris , and BC

SOLVED
Go to solution
aTo_1
Advisor

Oracle on EVA4000 on Solaris , and BC

Hi all ,

I'd really appreciate your help on this one please .

- Can you safely take a snapshot or a snapclone using BC , of a vdisk on EV4K presented to a solaris 10 host running oracle 9i or 10g ? ie while the database is online and running ? without shuting down the database and unmounting the presented disk ?

- is there any best practices or critical conditions to be checked especially for the EVA4000 on with Solaris 9 , 10 ? , I mean in addition to the basic eva solaris connectivity requirements being met ?

Mega Thanks to you all , and appreciate your help .
was it something I said ...!!! ;-(
8 REPLIES
Steven E. Protter
Exalted Contributor

Re: Oracle on EVA4000 on Solaris , and BC

Shalom,

Snapshot yes.

While the database is runing presents problems.

1) The snapshot will be fuzzy and may not be usable. If you shut down the database, take the snapshot and then bring it back up, this will work.

2) Note that oracle 9i can't read or mount data that has been converted to 10g so what data can be presented to what database is limited by this factor.

Best Practices:
1) Do realistic backup/restore failure tests.
2) Keep the EVA firmware and management software up to date.
3) Keep the OS(Solaris) up to date on patches, however Solaris handles that.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Zinky
Honored Contributor
Solution

Re: Oracle on EVA4000 on Solaris , and BC

Banzai aTo!

Yes you can.. and it's fully documented and your DBA's should know about it.

Steps:

1.) Place DB in hotbackup mode (DB must have already been in ARCHIVELOG mode)

2.) Use EVA CV (either GUI or CVLI) to create a "snapclone"

3.) Take DB our of hotbackup mode.

All the above should happen in a matter of a few seconds to no more than a few minutes depending on how large or how many your DB Table spaces.

AND there should be no disruption to your DB operations --- all will appear normal and online.

Then the snapclone can be mounted on the same server (using diff mount points) or on a different server.
Hakuna Matata

Favourite Toy:
AMD Athlon II X6 1090T 6-core, 16GB RAM, 12TB ZFS RAIDZ-2 Storage. Linux Centos 5.6 running KVM Hypervisor. Virtual Machines: Ubuntu, Mint, Solaris 10, Windows 7 Professional, Windows XP Pro, Windows Server 2008R2, DOS 6.22, OpenFiler
aTo_1
Advisor

Re: Oracle on EVA4000 on Solaris , and BC

Greetings Steven , and thanks for your reply .

actually this is my point , this fuzzy status that is concluded , should it always be a completely disfunctional database on worst cases ? I know this might be more of an oracle question than an HP one ;-) , but there is no considerations or recommendations from HP EVA side to be taken on Oracle inorder to yield a functional database on that snapshot or snapclone , without the need to shutdown the database once taking it everytime ?

Thanks again and Regards
was it something I said ...!!! ;-(
aTo_1
Advisor

Re: Oracle on EVA4000 on Solaris , and BC

Konichiwa Nelson SAN :-) ,

Thanks I posted my reply to steve before reading yours .

so that is what's supposed to be done , otherwise , we always end up with a corrupted system.dbf file or so ?

Thanks , I'll surely try it and confirm back if it worked .

Cheers
was it something I said ...!!! ;-(
aTo_1
Advisor

Re: Oracle on EVA4000 on Solaris , and BC

Mega Thanks to everyone ,

we've actually not yet tested that , as we are still 9i , and we need to upgrade to 10g inorder to try the command which allows you to put the whole database , not just table spaces , into hot abckup mode . but I allready fount an oracle document confirming what you said Nelson .

Thanks again Nelson .

Regards

was it something I said ...!!! ;-(
aTo_1
Advisor

Re: Oracle on EVA4000 on Solaris , and BC

Thanks Nelson
was it something I said ...!!! ;-(
Zinky
Honored Contributor

Re: Oracle on EVA4000 on Solaris , and BC

Now what about a l'il point or 2.. -- if I helped.

;^)
Hakuna Matata

Favourite Toy:
AMD Athlon II X6 1090T 6-core, 16GB RAM, 12TB ZFS RAIDZ-2 Storage. Linux Centos 5.6 running KVM Hypervisor. Virtual Machines: Ubuntu, Mint, Solaris 10, Windows 7 Professional, Windows XP Pro, Windows Server 2008R2, DOS 6.22, OpenFiler
aTo_1
Advisor

Re: Oracle on EVA4000 on Solaris , and BC

:-) , yes actually I did , you deserve them , Thanks again .
was it something I said ...!!! ;-(