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
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,