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

XP1024 Business copy and oracle

McKesson SystemCare UNI
Occasional Advisor

XP1024 Business copy and oracle

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
5 REPLIES
Vincent Fleming
Honored Contributor

Re: XP1024 Business copy and oracle

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!


No matter where you go, there you are.
Vincent Fleming
Honored Contributor

Re: XP1024 Business copy and oracle

Bill,

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

Vince
No matter where you go, there you are.
Andreas Greibahn
Frequent Advisor

Re: XP1024 Business copy and oracle

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
Honored Contributor

Re: XP1024 Business copy and oracle

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
Respected Contributor

Re: XP1024 Business copy and oracle

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





Teach is the best way to learn