[oracle@l004020 ~]$ export $ORACLE_SID=oratmp
[oracle@l004020 ~]$ nid target=sys/sys_password dbname=oratmp
DBNEWID: Release 10.2.0.2.0 - Production on Sat Oct 9 11:37:47 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to database ORA8I (DBID=152116074)
Connected to server version 10.2.0
Control Files in database:
/u02/oradata/oratmp/control01.ctl
/u02/oradata/oratmp/control02.ctl
/u02/oradata/oratmp/control03.ctl
Change database ID and database name ORA8I to ORATMP? (Y/[N]) => y
Proceeding with operation
Changing database ID from 152116074 to 3320092043
Changing database name from ORA8I to ORATMP
Control File /u02/oradata/oratmp/control01.ctl - modified
Control File /u02/oradata/oratmp/control02.ctl - modified
Control File /u02/oradata/oratmp/control03.ctl - modified
Datafile /u02/oradata/oratmp/system01.dbf - dbid changed, wrote new name
Datafile /u02/oradata/oratmp/undotbs01.dbf - dbid changed, wrote new name
Datafile /u02/oradata/oratmp/sysaux01.dbf - dbid changed, wrote new name
Datafile /u02/oradata/oratmp/users01.dbf - dbid changed, wrote new name
Datafile /u02/oradata/ora8i/temp01.dbf - dbid changed, wrote new name
Control File /u02/oradata/oratmp/control01.ctl - dbid changed, wrote new name
Control File /u02/oradata/oratmp/control02.ctl - dbid changed, wrote new name
Control File /u02/oradata/oratmp/control03.ctl - dbid changed, wrote new name
Instance shut down
Database name changed to ORATMP.
Modify parameter file and generate a new password file before restarting.
Database ID for database ORATMP changed to 3320092043.
All previous backups and archived redo logs for this database are unusable.
Database has been shutdown, open database with RESETLOGS option.
Succesfully changed database name and ID.
DBNEWID - Completed succesfully.
[oracle@l004020 ~]$ sqlplus / as sysdba
SQL> shutdown immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup mount ;
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 2069648 bytes
Variable Size 104860528 bytes
Database Buffers 50331648 bytes
Redo Buffers 10510336 bytes
ORA-01103: database name 'ORATMP' in control file is not 'ORA8I'
SQL> alter system set db_name='oratmp' scope=spfile;
System altered.
SQL> shutdown immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup mount ;
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 2069648 bytes
Variable Size 104860528 bytes
Database Buffers 50331648 bytes
Redo Buffers 10510336 bytes
Database mounted.
SQL> alter database open ;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> alter database open resetlogs ;
Database altered.
#再看看hc文件。
[oracle@l004020 dbs]$ ls -lth hc*
-rw-rw---- 1 oracle dba 1.6K 10-09 11:49 hc_oratmp.dat
-rw-rw---- 1 oracle dba 1.6K 10-09 11:34 hc_ora8i.dat
本站僅提供存儲服務(wù),所有內(nèi)容均由用戶發(fā)布,如發(fā)現(xiàn)有害或侵權(quán)內(nèi)容,請
點(diǎn)擊舉報(bào)。