Re: duplicating a database
- From: "Philip Douglass" <philip.douglass@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 23 Mar 2004 13:11:50 -0500
Shouldn't you have created your new control-files with this?
CREATE CONTROLFILE SET DATABASE "PROD-site" RESETLOGS ...
why would you create the new controlfiles with the old database name?
Also, there's a lot of other work that needs to be done if you changed the
SID too.
Other than that, what you did is fine. I've done similar things myself on
8.0 databases, but it did require me to search/replace many references to
the old SID. I've since become fond of using RMAN to duplicate databases,
since I can do it without taking down my source db.
In any case, I really hope you turn on archive logging on your production
box, at least.
----- Original Message -----
From: "Markus Reger" <Reger@xxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Tuesday, March 23, 2004 10:29 AM
Subject: duplicating a database
what I did (regardless of what I should or shouldn't) was:
made a cold backup of a 92030 instance. for the sake of explanation call it
DEV-site
moved it to a 92040 site, let's call it PROD-site. on the PROD-site I
replaced all files with those from the DEV-site (except control-files).
I created new control-files (CREATE CONTROLFILE SET DATABASE "DEV-site"
RESETLOGS NOARCHIVELOG. .... )
then I started up in migrate, ran "@?/rdbms/admin/catpatch.sql" - as
supposed when applying patch set 92040 on a 92 instance.
platforms on both sites are Solaris 9.
Everything looks alright. How did I get the idea? studied to many papers
about (physical) standbys.
BUT: may I sleep well?
pleading forgiveness if this is just a stupid question. if so - even rebukes
are welcome ... or some sleeping pills
kr MReger
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
