- Do an 'Alter database backup control file to trace'
- Shutdown immediate
- Take a Backup of your database.
- Move all your files and filenames to new locations and names if
need be.
- Edit the backup control file trace file to do a
Create control file reuse
......
......
set database new_name
Logfile
group 1 '.....',
group 2 '.....'
datafiles
'datafile1_new_location',
'datafile2_new_location'
;
Remove the 'Recover Database' statement.
Remove the 'Alter System Archive Log all' statement.
Make sure there is an 'Alter database open resetlogs;'
- Setup your new environment, i.e. .ora files.
- Set your ORACLE_SID to the new SID.
- Start the database in no mount
- Run the editted create control file. If it errors, most likely is
a problem with datafile location or naming.
HTH,
Pete's
"Giorgio P." <alfatar_at_register.com> wrote in message news:<9lg6ce$oba$1_at_fe1.cs.interbusiness.it>...
> I need to change the INSTANCE_NAME parameter of my Oracle 8.1.7 database
> server installation.
> Is there some other parameter that I have to change in order to assure the
> server will work properly?
> Thank you.
Received on Fri Aug 17 2001 - 07:55:46 CDT