Database cloning [message #170286] |
Wed, 03 May 2006 02:52 |
gajini
Messages: 262 Registered: January 2006
|
Senior Member |
|
|
Hi,
I've read the following steps for the database cloning.
1. Shutdown StandBy database – Source
2. Backup the files (controlfiles, datafiles, redologfiles and tempfiles) – Source
3. Restore all the files (controlfiles, datafiles, redologfiles and tempfiles) from standby cold backup to target machine. In case of restoring the files in source machine then instance name and database name should be changed.
4. Change the instance parameters in new DB init file – controlfile, bdump, udump. Cdump & utl_file
5. Startup nomount
6. Alter database mount standby database;
7. Rename the datafiles to new location in mount state
8. Execute alter database activate standby database;
9. Shutdown the database
10. Startup Nomount
11. Re-create controlfile using set database clause if database name has to be changed, else Alter Database mount
12. Alter open database resetlogs;
I'm not able to understand,why they have used the statements "alter database mount standby database;" & "alter database activate standby database".
Can anyone explain me,why these statements are used & what kind of cloning setup it is?what is the aim of this cloning setup?
Thanks,
Gajini
|
|
|
Re: Database cloning [message #170364 is a reply to message #170286] |
Wed, 03 May 2006 08:12 |
|
Mahesh Rajendran
Messages: 10707 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
>> I've read the following
Where?
The said steps might be for a standby database.
For a regular database, you do not need them.
|
|
|