RE: Duplicating a Database and Changig SID

[SARKAR, Samir]

Same here Ron.....will really appreciate it if u could send me the file at my email id as an attachment......I think the LIST doesnt support attachments......else, a text file will also help.   Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email :  [EMAIL PROTECTED]             [EMAIL PROTECTED] Phone : +44 (0) 115 - 95 76217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018            -----Original Message----- From: Prakriteswar Santikary [mailto:[EMAIL PROTECTED]] Sent: 30 November 2001 16:21 To: Multiple recipients of list ORACLE-L Subject: RE: Duplicating a Database and Changig SID Ron,   I was trying to open your attached document. I get this error:     <encoded content removed -- binaries not allowed by ListGuru>   Could you pl. send this doc as .txt file to me ? I would really appreciate that.   thanks Santi -----Original Message----- From: Ron Yount [mailto:[EMAIL PROTECTED]] Sent: Friday, November 30, 2001 7:41 AM To: Multiple recipients of list ORACLE-L Subject: RE: Duplicating a Database and Changig SID Sonja,   Here are my rough instructions for how to duplicate a database (by copying files) and then how to alter the database name (typically referred to as "cloning" a database).    At the end, you will find how to alter the dbid so that RMAN will see it as a new database.   Be sure to bounce the instance as instructed.   -Ron- -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Sonja Sehovic Sent: Friday, November 30, 2001 3:11 AM To: Multiple recipients of list ORACLE-L Subject: RE: Duplicating a Database and Changig SID Yes, please, I'm very interested.   Sonja -----Original Message----- From: Ron Yount [mailto:[EMAIL PROTECTED]] Sent: Friday, November 30, 2001 12:50 AM To: Multiple recipients of list ORACLE-L Subject: RE: Duplicating a Database and Changig SID If you are using RMAN and would like some direction on how to change the DBID as well, let me know and I will send you some directions/steps for that as well.   -Ron- -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Sonja Sehovic Sent: Thursday, November 29, 2001 5:45 AM To: Multiple recipients of list ORACLE-L Subject: RE: Duplicating a Database and Changig SID 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, ___________________________________________________________________________ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___________________________________________________________________________