>sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Wed Jun 16 23:36:30 2010
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup pfile='/evm05/u0001/oracle/product/10.2.0/db_1/dbs/initNEWDB.ora' mount;
ORACLE instance started.
Total System Global Area 2013265920 bytes
Fixed Size 2041720 bytes
Variable Size 922753160 bytes
Database Buffers 1073741824 bytes
Redo Buffers 14729216 bytes
Database mounted.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
HOSTNAME(NEWDB) /export/home/oracle
>nid target=sys/dba2hire@NEWDB dbname=NEWDB
DBNEWID: Release 10.2.0.4.0 - Production on Wed Jun 16 23:37:05 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to database OLDDB (DBID=1847680250)
Connected to server version 10.2.0
Control Files in database:
+EVM03_REDO_01/NEWDB/controlfile/current.262.698751897
+EVM03_REDO_02/NEWDB/controlfile/current.257.698751897
Change database ID and database name OLDDB to NEWDB? (Y/[N]) => Y
Proceeding with operation
Changing database ID from 1847680250 to 2196540583
Changing database name from OLDDB to NEWDB
Control File +EVM03_REDO_01/NEWDB/controlfile/current.262.698751897 - modified
Control File +EVM03_REDO_02/NEWDB/controlfile/current.257.698751897 - modified
Datafile +EVM03_DATA_01/NEWDB/datafile/system.264.698752361 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/undo.310.698757225 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/sysaux.266.698752335 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/evm_data.282.698754487 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/evm_index.294.698755755 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/tools.290.698754583 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/users.314.698757431 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/cbar_default_data.292.698755751 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/cbar_default_idx.303.698756719 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/evm_data.283.698754489 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/evm_index.302.698756717 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/evm_data.272.698751923 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/evm_index.280.698754481 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/large_data.300.698756275 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/large_data.298.698755761 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/large_data.313.698757427 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/large_data.312.698757409 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/cbar_default_data.285.698754493 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/evm_data.304.698756721 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/evm_data.275.698753195 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/cbar_default_data.297.698755759 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/evm_data.311.698757279 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/cbar_default_idx.270.698751929 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/evm_data.276.698753197 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/evm_data.305.698756723 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/evm_data.271.698751927 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/evm_index.293.698755753 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/evm_data.307.698756725 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/evm_index.287.698754495 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/cbar_default_data.274.698753193 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/evm_data.268.698751931 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/evm_data.299.698756141 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/cbar_default_idx.278.698753199 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/evm_data.260.698753191 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/evm_index.273.698751921 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/cbar_default_data.291.698755747 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/large_data.279.698753407 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/cbar_default_idx.306.698756723 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/undo.267.698752293 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/evm_index.277.698753197 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/cbar_default_data.269.698751929 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/cbar_default_data.309.698757203 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/cbar_default_data.281.698754483 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/evm_data.261.698753187 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/cbar_default_idx.286.698754495 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/evm_index.262.698753183 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/mydvr_data.288.698754569 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/evm_data.265.698751915 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/evm_index.301.698756713 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/undo.296.698755757 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/evm_index.284.698754491 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/evm_index.308.698756725 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/large_data.289.698754577 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/evm_data.263.698751919 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/evm_index.295.698755757 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/evm_data.317.719316783 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/datafile/evm_data.318.719316813 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/tempfile/temp.316.699704527 - dbid changed, wrote new name
Datafile +EVM03_DATA_01/NEWDB/tempfile/temp.315.699704525 - dbid changed, wrote new name
Control File +EVM03_REDO_01/NEWDB/controlfile/current.262.698751897 - dbid changed, wrote new name
Control File +EVM03_REDO_02/NEWDB/controlfile/current.257.698751897 - dbid changed, wrote new name
Instance shut down
Database name changed to NEWDB.
Modify parameter file and generate a new password file before restarting.
Database ID for database NEWDB changed to 2196540583.
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.
HOSTNAME(NEWDB) /export/home/oracle
>sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Wed Jun 16 23:40:22 2010
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup pfile='/evm05/u0001/oracle/product/10.2.0/db_1/dbs/initNEWDB.ora' mount;
ORACLE instance started.
Total System Global Area 2013265920 bytes
Fixed Size 2041720 bytes
Variable Size 922753160 bytes
Database Buffers 1073741824 bytes
Redo Buffers 14729216 bytes
Database mounted.
SQL> show parameter db_name
NAME TYPE
------------------------------------ --------------------------------
VALUE
------------------------------
db_name string
NEWDB
SQL> alter database open resetlogs;
Database altered.
SQL> create spfile from pfile;
File created.
SQL> shutdown immediate;
Experience: is what you get soon after you need it.
****************Got the opportunity to pen a Book on Database Cloud Services.......More details to follow.***************
Title : Database Cloud Revealed
Publisher : Apress
Release Date : Jan-2020
**********************************************************************************
My Cloud Certifications:
AWS Certified Solutions Architect Associate
Azure Certified Architect
Azure Certified Administrator
Oracle Cloud Infrastructure 2018 Certified Architect Associate.
Oracle Cloud Infrastructure Classic 2018 Certified Architect Associate.
Oracle Database Cloud Administrator Certified Professional.
Oracle Database Cloud Service Operations Certified Associate.

No comments:
Post a Comment