| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Easy way to copy databases when using RMAN?
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 samedbid from step 3)
SQL> shutdown normal SQL> startup mount SQL> exec dbms_backup_restore.zeroDbid(0); SQL> shutdown normal
SQL> startup nomount SQL> @c.sql SQL> alter database open resetlogs; SQL> select name, dbid from v$database. (There should be the new name, andnew dbid)
-----Original Message-----
From: Wolfson Larry - lwolfs [mailto:lawrence.wolfson_at_acxiom.com]
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.
 |
 |