OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Database cloning

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator