XP1024 Business copy and oracle

[McKesson SystemCare UNI]

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

[Vincent Fleming]

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!

[Vincent Fleming]

Bill,

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

Vince

[Andreas Greibahn]

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

[Ashwani Kashyap]

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 .

[Joaquin Gil de Vergara]

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