DataBase Cloning. [message #49907] |
Sun, 17 February 2002 19:08 |
kiran
Messages: 503 Registered: July 2000
|
Senior Member |
|
|
Hi all,
I have a database instance called Eximdm .
I want to clone the database with other name on the Same machine.
I do not want to use the export and import it is very time consuming as the datbase is very large.
Is there any good method to duplicate a database.
Thanks in Advance
B.kiran Kumar
DBA
Satyam computer Services Ltd.
|
|
|
|
Re: DataBase Cloning. [message #49924 is a reply to message #49907] |
Mon, 18 February 2002 16:46 |
freedba
Messages: 9 Registered: September 2000
|
Junior Member |
|
|
To clone the database. Below is the step
UNIX
1. Backup the control file for Eximdm with this command.
ALTER DATABASE <Eximdm> BACKUP CONTROLFILE TO TRACE.
this command will create the controlfile(text) in trace directory. In this file, keep database structure of Eximdm. To clone the database, you must change database name and other setting for new database in this file.
2. Shutdown the Eximdm, duplicate database file, redo log file and parameter file to new path. Edit controlfile to new path for database file, redo log file and parameter file. And also edit parameter file for clone database.
3. Environment setting for new close database especially ORACLE_SID = 'new oracle is similar to editing controlfile'.
Note: be careful for this setting, this might cause collapse of product database if same ORACLE_SID is used to clone new database.
4. Start to create the clone database.
- logon in svrmgrl as sysdba;
svrmgrl>
svrmgrl> connect / as sysdba;
- start database ( new ORACLE_SID =<clone database> unmount.
svrmgrl>startup pfile=<filepath to new clone init.ora> unmount;
- create new clone database. execute the controlfile for new database.
svrmgrl>@<path><controlfile for new database>
Note:makesure all of setting is in this controlfile is correct.
- if it doesn't have any error. the clone database is created and you can open this clone database.
svrmgrl> alter database open;
NT/Windows2000.
In NT/Windows2000 is almost similar to UNIX. But the difference is Oracle Service. User need to create the service for clone database first before create clone database.
1. Similar
2. Similar
3. Similar e.g set ORACLE_SID='clone sid'
3a(Extra step).
- create Oracle service in NT/Windows2000. Using below command.
oradimxx -new -sid <new_sid> -intpwd <password> - startmode auto -pfile <path_name>
Note; find this new Oracle Service in Control Panel(Services) after created.
- start Oracle Service
Net start <oracle services for clone database>
4. Similar
Hope this will provide some information for you.
|
|
|
|
Re: DataBase Cloning. [message #49960 is a reply to message #49929] |
Wed, 20 February 2002 16:01 |
seng
Messages: 191 Registered: February 2002
|
Senior Member |
|
|
No need to do anything in tnsname and listner in UNIX. TNSNAMES and just need to do some setting on tnsname and listner setting to use this clone database. e.g differencet port,new sid .. thanks
|
|
|