I am fairly new to Oracle, but I am trying to ramp up quickly.



(all servers are 10g running on Windows 2003 R2)



I have a primary Oracle server that is our production database. I also
have a secondary Oracle server at our backup location that serves as our
DR solution. The problem is that I need to ensure that the DR site has
good accurate data from the primary site.



My plan is to make a copy of the tablespaces from the primary to the
secondary site every night, while still keeping the secondary databases
unique SID and so forth. I cannot shutdown the primary production
database.



I have tried to do an EXP/IMP, but that requires me to wipe out the
database first, at least as far as I know.



I have taken a full online backup of the primary database, but do not
know how to restore that to the secondary database.



If anyone can please help me, I need the most intelligent solution for
this problem.



The RMAN script I used to do the backup is as follows:



run {

allocate channel oem_backup_disk1 type disk format 'I:\Test\%U';

backup as COMPRESSED BACKUPSET tag 'FULL_BACKUP' database include
current controlfile;

release channel oem_backup_disk1;

}





Thanks,

Brad




Oracle LazyDBA home page