RE: Easy way to copy databases when using RMAN?
- From: "Hand, Michael T" <HANDM@xxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 6 May 2004 10:42:34 -0400
The following is from 8/8i. Don't know of things have changed in 9i and
have no database to test against.
Changing the Dbid of copied database: Ron Yount from the Oracle-L provided
the following steps if it becomes necessary to change the Dbid of a copied
database to allow an RMAN catalog to backup both source and target database.
This should occur at the tail of the SAP Database Copy procedure.
[Tested successfully on XXX database refresh 5/13/02]
Use sqlplus to connect internal (if using sqlplus comment # must be changed
to 'rem' or '--')
SQL> startup nomount
SQL> @c.sql /* script to recreate controlfile */
SQL> select name,dbid from v$database. (There should be a new name, but same
dbid from step 3)
SQL> shutdown normal
SQL> startup mount
SQL> exec dbms_backup_restore.zeroDbid(0);
SQL> shutdown normal
Rename the control files from the new instance, so they will appear to be
missing.
SQL> startup nomount
SQL> @c.sql
SQL> alter database open resetlogs;
SQL> select name, dbid from v$database. (There should be the new name, and
new dbid)
-----Original Message-----
From: Wolfson Larry - lwolfs [mailto:lawrence.wolfson@xxxxxxxxxx]
Subject: Easy way to copy databases when using RMAN?
Hi, guys!
I I've got a number of servers to create multiple 9i databases.
--
This transmission is intended only for use by the addressee(s) named herein and
may contain information that is proprietary, confidential and/or legally
privileged. If you are not the intended recipient, you are hereby notified that
any disclosure, copying, distribution, or use of the information contained
herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received
this transmission in error, please immediately contact the sender and destroy
the material in its entirety, whether in electronic or hard copy format. Thank
you.
----------------------------------------------------------------
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:
