Avatar of tnowacoski
tnowacoski
 asked on

Oracle 9i - Best way to clone a Database and apply Archive Logs

Every night I make a cold copy of our entire Oracle 9i production system and move it to off-site disk (including Create scripts, Control Files, and Init files).  During the day, Archive logs are copied to the same off-site location.  What would be the best way to bring up another instance of the production system (with a different SID name) and apply all archive logs for a Disaster Recover operation?
Oracle Database

Avatar of undefined
Last Comment
Mark Geerlings

8/22/2022 - Mon
johnsmith1962

Rman can handle this, there are numerous sites on the internet explaining how to do it.  What is the operating system?  I can give better directions once I know the OS.
David VanZandt

Perhaps a better, easier practice could be enjoyed by using Data Guard to replicate your archive logs to a standby database.  In this way, your changes are AUTOMATICALLY captured; your failover procedure becomes one five to ten minute process.  Say goodbye to full database nightly copies.
There is a slew of EE articles on DataGuard, also on technology.oracle.com.  I have in front of me Bipul Kumar's book from Rampant Press -- Burleson's group.   Not to rain on your parade, but I think you are about to discover an "ahah" moment.  HTH
 
tnowacoski

ASKER
FYI, We are not currently using RMAN.  Our Backup Window has allowed us to be able to down the entire production system and cold copy the folder structure.  We are on Windows 2003.  The DR operation would have a similar server with Windows 2003 and Oracle 9i already loaded.  I know I can rename the SID and mount it as another instance but I am not sure what the best was to apply Archive log would be.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
tnowacoski

ASKER
dvz:  Due to financial restrictions, I am stuck with the current configuration that I have.  We are running on an Application Specific License with no change for configuration change.  This is why I am using a Cold Copy and a home-grown app to "sync" archive logs to the off-site location.
Mark Geerlings

I think the easiest way may be with RMAN.  But I used to do this with our 9i database that was also on WindowsServer2003 without RMAN, so it certainly can be done that way.  I did have ours set up as a Standby Database with the archived redo logs automatically applied.  I also took a complete cold backup of production each weekend, and copied that to the standby server (those tasks were both automated) then manually stopped the standby each Monday morning, moved the backup files into the standard file locations, then restarted it as a standby to apply the new archived redo logs as they arrived.

We upgraded to Oracle10 though on Linux instead of Windows more than three years ago, and I rebuilt our old standby server as a Linux server, so I no longer have the scripts that I used for this process on Windows.
johnsmith1962

Ok.  I think I see the question now.  If you shutdown the db, do a cold copy, and start it up as another name, you cannot apply archive logs.  As far as Oracle is concerned, this is a new instance.  If you want to roll the db forward each night as you describe, you must set up some form of dataguard, which as dvz notes, is documented in many different places on the internet.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
tnowacoski

ASKER
Could I bring the copied database up on another server as the same name without conflicting with the actual production database...as long as tnsnames points to the production server?
David VanZandt

I sympathize with the restrictions -- but it does seem the cost savings would cause some higher-up to take notice of your ideas.  Your hardware is in place, and apparently you have a Net 8 TCP/IP connection between the hosts.  Although it's been many years since I handled contracts and/or our business continuity plans (for an Alcoa aerospace plant), we had terms in place that the DR instance was not charged against our license -- it would not be up unless the primary instance was hosed.
Just a side question, when was the last time your powers-that-be authorized a live-fire simulation?  As with combat fire fights, battle plans seldom survive the initial contact.
ASKER CERTIFIED SOLUTION
Mark Geerlings

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.