データベース名を変更せずに、データベースIDを変更するには、「DBIDおよびデータベース名の変更」の手順に従ってください。ただし、手順3では、オプションのデータベース名(DBNAME)を指定しません。次に、データベースIDのみを変更した場合に生成される出力例を示します。
. . . Connected to database PROD (DBID=86997811) . . . Control Files in database: /oracle/TEST_DB/data/cf1.dbf /oracle/TEST_DB/data/cf2.dbf The following datafiles are offline clean: /oracle/TEST_DB/data/tbs_61.dbf (23) /oracle/TEST_DB/data/tbs_62.dbf (24) /oracle/TEST_DB/data/temp3.dbf (3) These files must be writable by this utility. The following datafiles are read-only: /oracle/TEST_DB/data/tbs_51.dbf (15) /oracle/TEST_DB/data/tbs_52.dbf (16) /oracle/TEST_DB/data/tbs_53.dbf (22) These files must be writable by this utility. Changing database ID from 86997811 to 4004383693 Control File /oracle/TEST_DB/data/cf1.dbf - modified Control File /oracle/TEST_DB/data/cf2.dbf - modified Datafile /oracle/TEST_DB/data/tbs_01.dbf - dbid changed Datafile /oracle/TEST_DB/data/tbs_ax1.dbf - dbid changed Datafile /oracle/TEST_DB/data/tbs_02.dbf - dbid changed Datafile /oracle/TEST_DB/data/tbs_11.dbf - dbid changed Datafile /oracle/TEST_DB/data/tbs_12.dbf - dbid changed Datafile /oracle/TEST_DB/data/temp1.dbf - dbid changed Control File /oracle/TEST_DB/data/cf1.dbf - dbid changed Control File /oracle/TEST_DB/data/cf2.dbf - dbid changed Instance shut down Database ID for database TEST_DB changed to 4004383693. All previous backups and archived redo logs for this database are unusable. Database has been shutdown, open database with RESETLOGS option. Succesfully changed database ID. DBNEWID - Completed succesfully.