SQL> select dbid from v$database;

      DBID
----------
2453812621

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area 4194304000 bytes
Fixed Size                  1306448 bytes
Variable Size            1066143920 bytes
Database Buffers         3120562176 bytes
Redo Buffers                6291456 bytes
Database mounted.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining options
g4as702104:10g:pa18oid > nid TARGET=sys/paic1234
DBNEWID: Release 10.1.0.4.0 - 64bit Production
Copyright (c) 2001, 2004, Oracle.  All rights reserved.

Connected to database PA18OID (DBID=2453812621)

Connected to server version 10.1.0

Control Files in database:
    /paic/hq/pa18oid/data/oradata/pa18oid/control01.ctl
    /paic/hq/pa18oid/data/oradata/pa18oid/control02.ctl
    /paic/hq/pa18oid/data/oradata/pa18oid/control03.ctl

Change database ID of database PA18OID? (Y/[N]) => Y

Proceeding with operation
Changing database ID from 2453812621 to 2891754761
    Control File /paic/hq/pa18oid/data/oradata/pa18oid/control01.ctl - modified
    Control File /paic/hq/pa18oid/data/oradata/pa18oid/control02.ctl - modified
    Control File /paic/hq/pa18oid/data/oradata/pa18oid/control03.ctl - modified
    Datafile /paic/hq/pa18oid/data/oradata/pa18oid/system01.dbf - dbid changed
    Datafile /paic/hq/pa18oid/data/oradata/pa18oid/undotbs01.dbf - dbid changed
    Datafile /paic/hq/pa18oid/data/oradata/pa18oid/sysaux01.dbf - dbid changed
    Datafile /paic/hq/pa18oid/data/oradata/pa18oid/users01.dbf - dbid changed
    Datafile /paic/hq/pa18oid/data/oradata/pa18oid/auddata01.dbf - dbid changed
    Datafile /paic/hq/pa18oid/data/oradata/pa18oid/dbadata01.dbf - dbid changed
    Datafile /paic/hq/pa18oid/data/oradata/pa18oid/pausers01.dbf - dbid changed
    Datafile /paic/hq/pa18oid/data/oradata/pa18oid/dmlbakdata01.dbf - dbid changed
    Datafile /paic/hq/pa18oid/data/oradata/pa18oid/portal.dbf - dbid changed
    Datafile /paic/hq/pa18oid/data/oradata/pa18oid/ptldoc.dbf - dbid changed
    Datafile /paic/hq/pa18oid/data/oradata/pa18oid/ptlidx.dbf - dbid changed
    Datafile /paic/hq/pa18oid/data/oradata/pa18oid/ptllog.dbf - dbid changed
    Datafile /paic/hq/pa18oid/data/oradata/pa18oid/ias_meta01.dbf - dbid changed
    Datafile /paic/hq/pa18oid/data/oradata/pa18oid/discopltm1.dbf - dbid changed
    Datafile /paic/hq/pa18oid/data/oradata/pa18oid/discopltc1.dbf - dbid changed
    Datafile /paic/hq/pa18oid/data/oradata/pa18oid/dcm.dbf - dbid changed
    Datafile /paic/hq/pa18oid/data/oradata/pa18oid/oss_sys01.dbf - dbid changed
    Datafile /paic/hq/pa18oid/data/oradata/pa18oid/wcrsys01.dbf - dbid changed
    Datafile /paic/hq/pa18oid/data/oradata/pa18oid/b2b_rt.dbf - dbid changed
    Datafile /paic/hq/pa18oid/data/oradata/pa18oid/b2b_dt.dbf - dbid changed
    Datafile /paic/hq/pa18oid/data/oradata/pa18oid/b2b_idx.dbf - dbid changed
    Datafile /paic/hq/pa18oid/data/oradata/pa18oid/b2b_lob.dbf - dbid changed
    Datafile /paic/hq/pa18oid/data/oradata/pa18oid/orabpel.dbf - dbid changed
    Datafile /paic/hq/pa18oid/data/oradata/pa18oid/bam.dbf - dbid changed
    Datafile /paic/hq/pa18oid/data/oradata/pa18oid/oca.dbf - dbid changed
    Datafile /paic/hq/pa18oid/data/oradata/pa18oid/uddisys01.dbf - dbid changed
    Datafile /paic/hq/pa18oid/data/oradata/pa18oid/attrs1_oid.dbf - dbid changed
    Datafile /paic/hq/pa18oid/data/oradata/pa18oid/battrs1_oid.dbf - dbid changed
    Datafile /paic/hq/pa18oid/data/oradata/pa18oid/gcats1_oid.dbf - dbid changed
    Datafile /paic/hq/pa18oid/data/oradata/pa18oid/gdefault1_oid.dbf - dbid changed
    Datafile /paic/hq/pa18oid/data/oradata/pa18oid/svrmg1_oid.dbf - dbid changed
    Datafile /paic/hq/pa18oid/data/oradata/pa18oid/temp01.dbf - dbid changed
    Control File /paic/hq/pa18oid/data/oradata/pa18oid/control01.ctl - dbid changed
    Control File /paic/hq/pa18oid/data/oradata/pa18oid/control02.ctl - dbid changed
    Control File /paic/hq/pa18oid/data/oradata/pa18oid/control03.ctl - dbid changed
    Instance shut down

Database ID for database PA18OID changed to 2891754761.
All previous backups and archived redo logs for this database are unusable.
Database is not aware of previous backups and archived logs in Recovery Area.
Database has been shutdown, open database with RESETLOGS option.
Succesfully changed database ID.
DBNEWID - Completed succesfully.

g4as702104:10g:pa18oid > sqlplus '/as sysdba'

SQL*Plus: Release 10.1.0.4.0 - Production on Wed Nov 17 18:24:16 2010

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup mount;
ORACLE instance started.

Total System Global Area 4194304000 bytes
Fixed Size                  1306448 bytes
Variable Size            1066143920 bytes
Database Buffers         3120562176 bytes
Redo Buffers                6291456 bytes
Database mounted.
SQL> ALTER DATABASE OPEN RESETLOGS;

Database altered.

SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /paic/hq/pa18oid/log/pa18oid
Oldest online log sequence     1
Next log sequence to archive   1
Current log sequence           3
SQL>