NID

====================
NID  : DBID
=====================
oracle@lab-mtlunt96@MGTST (/home/oracle)$ nid target=sys

DBNEWID: Release 11.2.0.3.0 - Production on Mon Nov 11 13:42:34 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Password:
Connected to database MGTST (DBID=1864518327)

Connected to server version 11.2.0

Control Files in database:
    +RADIXQADATA/mgtst/controlfile/current.284.801243959
    +RADIXQADATA/mgtst/controlfile/current.285.801243959

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

Proceeding with operation
Changing database ID from 1864518327 to 1894472279
    Control File +RADIXQADATA/mgtst/controlfile/current.284.801243959 - modified
    Control File +RADIXQADATA/mgtst/controlfile/current.285.801243959 - modified
    Datafile +RADIXQADATA/mgtst/datafile/system.361.80139858 - dbid changed
    Datafile +RADIXQADATA/mgtst/datafile/sysaux.360.80139860 - dbid changed
    Datafile +RADIXQADATA/mgtst/datafile/undotbs1.358.80139862 - dbid changed
    Datafile +RADIXQADATA/mgtst/datafile/users.282.80139862 - dbid changed
    Datafile +RADIXQADATA/mgtst/datafile/radair_fq.601.81790495 - dbid changed
    Datafile +RADIXQADATA/mgtst/datafile/radair_fqp1.593.81790496 - dbid changed
    Datafile +RADIXQADATA/mgtst/datafile/radair_fqp2.437.81790497 - dbid changed
    Datafile +RADIXQADATA/mgtst/datafile/radair_fqp3.603.81790497 - dbid changed
    Datafile +RADIXQADATA/mgtst/datafile/radair_fqp4.590.81790498 - dbid changed
    Datafile +RADIXQADATA/mgtst/tempfile/temp.452.80124405 - dbid changed
    Control File +RADIXQADATA/mgtst/controlfile/current.284.801243959 - dbid cha                                                                                                                               nged
    Control File +RADIXQADATA/mgtst/controlfile/current.285.801243959 - dbid cha                                                                                                                               nged
    Instance shut down

Database ID for database MGTST changed to 1894472279.
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.

oracle@lab-mtlunt96@MGTST (/home/oracle)$ sqlplus  / as  sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Mon Nov 11 13:43:26 2013

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

Connected to an idle instance.

SQL> startup   mount
ORACLE instance started.

Total System Global Area 5227814912 bytes
Fixed Size                  2237488 bytes
Variable Size            3892317136 bytes
Database Buffers         1325400064 bytes
Redo Buffers                7860224 bytes
Database mounted.
SQL> alter  database  open  resetlogs;

Database altered.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning and Automatic Storage Management options
oracle@lab-mtlunt96@MGTST (/home/oracle)$ sqlplus  / as  sysdba
oracle@lab-mtlunt96@MGTST (/home/oracle)$ rman   target /

Recovery Manager: Release 11.2.0.3.0 - Production on Mon Nov 11 13:44:39 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: MGTST (DBID=1894472279)

RMAN> exit


Recovery Manager complete.


===================
nid  dbid + db_name
======================
oracle@lab-mtlunt96@MGTST (/home/oracle)$ nid target=sys

DBNEWID: Release 11.2.0.3.0 - Production on Mon Nov 11 13:42:34 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Password:
Connected to database MGTST (DBID=1864518327)

Connected to server version 11.2.0

Control Files in database:
    +RADIXQADATA/mgtst/controlfile/current.284.801243959
    +RADIXQADATA/mgtst/controlfile/current.285.801243959

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

Proceeding with operation
Changing database ID from 1864518327 to 1894472279
    Control File +RADIXQADATA/mgtst/controlfile/current.284.801243959 - modified
    Control File +RADIXQADATA/mgtst/controlfile/current.285.801243959 - modified
    Datafile +RADIXQADATA/mgtst/datafile/system.361.80139858 - dbid changed
    Datafile +RADIXQADATA/mgtst/datafile/sysaux.360.80139860 - dbid changed
    Datafile +RADIXQADATA/mgtst/datafile/undotbs1.358.80139862 - dbid changed
    Datafile +RADIXQADATA/mgtst/datafile/users.282.80139862 - dbid changed
    Datafile +RADIXQADATA/mgtst/datafile/radair_fq.601.81790495 - dbid changed
    Datafile +RADIXQADATA/mgtst/datafile/radair_fqp1.593.81790496 - dbid changed
    Datafile +RADIXQADATA/mgtst/datafile/radair_fqp2.437.81790497 - dbid changed
    Datafile +RADIXQADATA/mgtst/datafile/radair_fqp3.603.81790497 - dbid changed
    Datafile +RADIXQADATA/mgtst/datafile/radair_fqp4.590.81790498 - dbid changed
    Datafile +RADIXQADATA/mgtst/tempfile/temp.452.80124405 - dbid changed
    Control File +RADIXQADATA/mgtst/controlfile/current.284.801243959 - dbid cha                                                                                                                               nged
    Control File +RADIXQADATA/mgtst/controlfile/current.285.801243959 - dbid cha                                                                                                                               nged
    Instance shut down

Database ID for database MGTST changed to 1894472279.
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.

oracle@lab-mtlunt96@MGTST (/home/oracle)$ mmm
-ksh: mmm: not found [No such file or directory]
oracle@lab-mtlunt96@MGTST (/home/oracle)$ sqlplus  / as  sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Mon Nov 11 13:43:26 2013

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

Connected to an idle instance.

SQL> startup   mount
ORACLE instance started.

Total System Global Area 5227814912 bytes
Fixed Size                  2237488 bytes
Variable Size            3892317136 bytes
Database Buffers         1325400064 bytes
Redo Buffers                7860224 bytes
Database mounted.
SQL> alter  database  open  resetlogs;

Database altered.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning and Automatic Storage Management options
oracle@lab-mtlunt96@MGTST (/home/oracle)$ sqlplus  / as  sysdba
oracle@lab-mtlunt96@MGTST (/home/oracle)$ rman   target /

Recovery Manager: Release 11.2.0.3.0 - Production on Mon Nov 11 13:44:39 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: MGTST (DBID=1894472279)

RMAN> exit


Recovery Manager complete.