topic Re: XP1024 Business copy and oracle in Disk Enclosures

XP1024 Business copy and oracle

McKesson SystemCare UNI — Wed, 28 Aug 2002 14:54:57 GMT

I am trying to use Businees copy with an oracle database. I do not have the luxury to stop the database and unmout the filesystems before I make the split. Is there a way to Quiesce the database and split the copy which will guarantee a clean copy? Are there any white papers on this?
Thanks
bill

Re: XP1024 Business copy and oracle

Vincent Fleming — Wed, 28 Aug 2002 15:09:52 GMT

Oracle has a feature called RMAN (Recovery Manager) that is used for this as well as backup.

HP has two products/services that you can purchase, Zero-downtime Backup (ZDB), Instant Recovery solutions that include setting up what you describe.

See http://www.oracle.com/ip/deploy/database/features/recovery/index.html?recovery.html for more details on RMAN.

I hope this helps. Good luck!

Re: XP1024 Business copy and oracle

Vincent Fleming — Wed, 28 Aug 2002 15:17:31 GMT

Bill,

See the attached - I think it might be helpful to you.

Vince

Re: XP1024 Business copy and oracle

Andreas Greibahn — Thu, 03 Oct 2002 15:30:22 GMT

Bill

You need to ensure that your Oracle database is in archived log mode if you are going to use on-line copies. You can do the following to check from the Oracle command:

svrmgrl
connect internal
archive log list;

This will tell you if you are in the correct mode. As mentioned, RMAN will let you do online backups and will call the correct command to put the database into backup mode.

Andreas

Re: XP1024 Business copy and oracle

Ashwani Kashyap — Thu, 03 Oct 2002 16:56:51 GMT

Use oracle online backup .
YOu can set the table spaces in backup mode ...
ALTER TABLESPACE....... BEGIN BACKUP .

Split the BC copy .

ALTER TABLESPACE ......... END BACKUP .
Reset the tablespaces to normal status .

Re: XP1024 Business copy and oracle

Joaquin Gil de Vergara — Fri, 04 Oct 2002 08:08:23 GMT

resync BC pairs

make a begin backup in all tablespaces

then suspend database

split BC pairs

resume database

end backup in all tablespaces

now in S-VOLs you have a consistent freezed database. Import disks in vgs, mount it and copy to tape

database must be in archive log mode to do this