Home » RDBMS Server » Backup & Recovery » Backup Method To Read Only Database
Backup Method To Read Only Database [message #53748] Wed, 09 October 2002 08:17 Go to next message
Andrew Ford
Messages: 18
Registered: November 2001
Junior Member
Hi,

I am wanting to do a backup of a large production system. With this backup I am wanting to update another read only database (copy of the production system) on a daily basis. A cold backup is out of the question because it is a 24/7 system so the 2 options are.

1. Hot backup.
2. Export/Import

What is the best choice? Would prefer to do an Export/Import but is there any way of making sure you get a consistent view of the data eg. when taking an export a transaction is taking place that updates 2 tables and only 1 of these updates takes place (Inconsistency!!).

Regards

Andrew.
Re: Backup Method To Read Only Database [message #53749 is a reply to message #53748] Wed, 09 October 2002 08:21 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
i would prefer a cloning/duplicate database using RMAN
Previous Topic: regarding backup
Next Topic: copy or ocopy with hotbackup on Win2K?
Goto Forum:
  


Current Time: Thu Mar 28 21:21:04 CDT 2024