Ejemplo de Ejecución de NID

 #######################

Ejemplo de Ejecución de NID

######################

############################################################
#             INITNEWBD.ORA                                #
############################################################

NewBD.__java_pool_size=67108864
NewBD.__large_pool_size=16777216
NewBD.__oracle_base='/ruta/software/oracle_base/'#ORACLE_BASE set from environment
NewBD.__pga_aggregate_target=1493172224
NewBD.__sga_target=2801795072
NewBD.__shared_io_pool_size=0
NewBD.__shared_pool_size=553648128
NewBD.__streams_pool_size=0
*.audit_file_dest='/ruta/destino/audit/'
*.audit_trail='DB'
*.compatible='11.1.0'
*.control_files='/ruta/control/control01.ctl','/ruta/control/control02.ctl','/ruta/control/control03.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='NewBD'
*.db_recovery_file_dest_size=1G
*.db_recovery_file_dest=' '
*.diagnostic_dest='/ruta/directorio/trazas'
*.dispatchers='(PROTOCOL=TCP)'
*.fast_start_mttr_target=20
*.log_archive_dest='/ruta/archivado'
*.log_archive_format='NewBD%t_%s_%r.arc'
*.memory_max_target=4294967296
*.memory_target=4294967296
*.open_cursors=500
*.processes=750
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_servers=0
*.undo_retention=900
*.undo_tablespace='UNDOTBS1'

############################################################
#             Ejecución del NID                            #
############################################################

$ nid TARGET=system/ DBNAME=NewBd

DBNEWID: Release 11.2.0.3.0 - Production on Sat Mar 2 03:28:15 2013

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

Connected to database OldBd(DBID=2961963351)
Connected to server version 11.2.0
Control Files in database:
    /ruta/control/control01.ctl
    /ruta/control/control01.ctl
    /ruta/control/control03.ctl

Change database ID and database name OldBd to NewBd ? (Y/[N]) => Y

Proceeding with operation
Changing database ID from 2961963351 to 1165696271
Changing database name from OldBd to NewBd
    Control File /ruta/control/control01.ctl - modified
    Control File /ruta/control/control01.ctl - modified
    Control File /ruta/control/control03.ctl - modified
    Datafile /ruta/system/system01.db - dbid changed, wrote new name
    Datafile /ruta/sysaux/sysaux01.db - dbid changed, wrote new name
    Datafile /ruta/undo/undotbs01.db - dbid changed, wrote new name
    Datafile /ruta/users/users01.db - dbid changed, wrote new name
    Datafile /ruta/tools/tools01.db - dbid changed, wrote new name
    Datafile /ruta/temp/temp01.db - dbid changed, wrote new name
    Control File /ruta/control/control01.ctl - dbid changed, wrote new name
    Control File /ruta/control/control02.ctl - dbid changed, wrote new name
    Control File /ruta/control/control03.ctl - dbid changed, wrote new name
    Instance shut down

Database name changed to NewBd.

Modify parameter file and generate a new password file before restarting.
Database ID for database NewBd changed to 1165696271.
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 name and ID.

DBNEWID - Completed succesfully.

############################################################
#             Levantando la BBDD                           #
############################################################

$ export ORACLE_SID=NewBd
sqlplus "/As sysdba"

SQL*Plus: Release 11.2.0.3.0 Production on Sat Mar 2 18:45:11 2013

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL > startup mount;
ORACLE instance started.

Total System Global Area 4275781632 bytes
Fixed Size                  2189440 bytes
Variable Size            2130708352 bytes
Database Buffers         2130706432 bytes
Redo Buffers               12177408 bytes
Database mounted.

SQL > alter database open RESETLOGS;

Database altered.

############################################################
#             Depuración de Errores                        #
############################################################

Ejecución del NID con la Base de Datos Abierta


$ nid TARGET=system/ DBNAME=NewBd
DBNEWID: Release 11.2.0.3.0 - Production on Sat Mar 2 03:15:51 2013

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

Connected to database OldBd(DBID=2961963351)

NID-00121: Database should not be open

Change of database name failed during validation - database is intact.
DBNEWID - Completed with validation errors.