Brad,

Have you considered Data Guard?



Michael Messina
Senior Consultant
Work: (630) 960-2909
Mobile: (812) 606-0120
Email: [Email address protected]
[Email address protected]
IM: mrmessiniu (AIM)
http://www.linkedin.com/in/michaelmessina

TUSC
377 E. Butterfield Road
Lombard, IL 6014 US

Want a signature like this?
-----Original Message-----
From: BHoff [mailto:oracledba-ezmlmshield-x166730.[Email address protected]
Sent: Tuesday, October 09, 2007 3:48 PM
To: LazyDBA Discussion
Subject: Copying all tablespaces nightly

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





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page