RE: Duplicating a Database and Changig SID

[Sonja Sehovic]

Hi!   Before I tell you procedure, be aware that when you make a clone of your database DBID remains the same, which is a problem if you use RMAN for you backups.   Steps are: 0. On your database issue:      alter database backup controlfile to trace resetlogs; 1. Backup your database. 2. Shutdown database (shutdown immediate) 3. Copy all your datafile, logfiles, controlfiles to the new location 4. Edit your new init.ora file and change DB_NAME, DB_BLOCK_SIZE must be the same,     change path for controlfiles, user_dump_dest, background_dump_dest, core_dump_dest 5. Edit  your new controlfile (which you get in step 0) and change it in:         CREATE CONTROLFILE REUSE SET DATABASE 'NEWSID' RESETLOGS     and change the path of datafiles and logs 6. Recreate you control file. 7. Change your tnsnames.ora and sqlnet.ora files.   This should do. I had no problems in doing that   HTH,     Sonja   -----Original Message----- From: MRaval [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 7:55 PM To: Multiple recipients of list ORACLE-L Subject: Duplicating a Database and Changig SID Hi Guys,   I am newbie oracle DBA and want to duplicate my  development database to Test database and want to change ORACLE_SID, Could anyone tell exact steps that I have to follow. My database is on SUN 5.6 and oracle 8.1.6.   Thanks,