Hi Bhoff,
As you are using RMAN duplicating your database
http://download-east.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmd
updb006.htm on a daily basis will accomplish what you want on a daily
basis but ideally, you should be looking to make your secondary server
run a Standby (Dataguard) DB alongside your primary server.
http://download-east.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmd
updb006.htm
Cheers,
trub3101
-----Original Message-----
From: BHoff
[mailto:oracledba-ezmlmshield-x166730.[Email address protected]
Sent: 09 October 2007 20:48
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
This e-mail (and any attachments) is confidential and may contain
personal views which are not the views of the BBC unless specifically
stated.
If you have received it in error, please delete it from your system.
Do not use, copy or disclose the information in any way nor act in
reliance on it and notify the sender immediately. Please note that the
BBC monitors e-mails sent or received.
Further communication will signify your consent to this.
Oracle LazyDBA home page