nid target=/ dbname=JOSHIN
SQL> shu immediate;
Database closed.
Database dismounted.
SQL> shu immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 1728053248 bytes
Fixed Size 2925264 bytes
Variable Size 1073745200 bytes
Database Buffers 637534208 bytes
Redo Buffers 13848576 bytes
Database mounted.
SQL> exit
localhost:/home/oracle/joshi:$ echo $ORACLE_SID
JOSHIN
localhost:/home/oracle/joshi:$ echo $ORACLE_HOME
/instora/product/db12102_TST
localhost:/home/oracle/joshi:$ nid target=/ dbname=JOSHIN
DBNEWID: Release 12.1.0.2.0 - Production on Mon Feb 20 08:24:39 2017
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
Connected to database TEST (DBID=1883339165)
Connected to server version 12.1.0
Control Files in database:
/oradata05/JOSHIN/control01.ctl
/oradata06/JOSHIN/control02.ctl
Change database ID and database name TEST to JOSHIN? (Y/[N]) => Y
Proceeding with operation
Changing database ID from 1883339165 to 2634151111
Changing database name from TEST to JOSHIN
Control File /oradata05/JOSHIN/control01.ctl - modified
Control File /oradata06/JOSHIN/control02.ctl - modified
Datafile /oradata06/JOSHIN/system01.db - dbid changed, wrote new name
Datafile /oradata06/JOSHIN/sysaux01.db - dbid changed, wrote new name
Datafile /oradata06/JOSHIN/undotbs1.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/eoeclrg_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/eocmlrg_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/audit_dat_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/eolarge_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/hrwork_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/ptlock_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/ptwork_enc.db - dbid changed, wrote new name
Datafile /oradata05/JOSHIN/z_archive_dat_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/cularg2_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/cularg3_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/bdapp_enc.db - dbid changed, wrote new name
Datafile /oradata05/JOSHIN/tllarge_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/hr_32m_dat1_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/hrapp2_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/psimage_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/eocmwrk_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/eocuapp_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/eoculrg_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/eodsapp_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/pttlrg_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/eodslrg_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/eoecwrk_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/eoditbl_enc.db - dbid changed, wrote new name
Datafile /oradata05/JOSHIN/z_bow_sec_tbl_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/eoeilrg_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/eplarge_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/eoewlrg_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/epapp_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/eoewwrk_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/eoiuapp_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/eoiuwrk_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/erlarge_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/eoiulrg_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/pvapp_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/giapp_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/psimgr_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/ptprc_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/fsapp_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/ptamsg_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/erwork_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/gpdeapp_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/ptaudit_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/ptapp_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/eotplrg_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/ptappe_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/hrapp_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/hricmailchangelog_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/eoewapp_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/tl_32m_dat1_enc.db - dbid changed, wrote new name
Datafile /oradata06/JOSHIN/audit_idx_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/pttbl_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/hrapp5_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/hrapp1_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/coapp_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/eoecapp_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/stlarge_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/stwork_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/poapp_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/tlapp_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/app_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/ewapp_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/cuaudit_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/py0lrg_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/cularge_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/pilarge_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/diapp_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/bnlarge_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/inapp_enc.db - dbid changed, wrote new name
Datafile /oradata06/JOSHIN/psindex32_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/ptcmstar_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/pylarge_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/hrapp4_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/piwork_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/ptrpts_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/waapp_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/piapp_enc.db - dbid changed, wrote new name
Datafile /oradata06/JOSHIN/psdefault.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/paapp_enc.db - dbid changed, wrote new name
Datafile /oradata03/JOSHIN/pi_32m_dat1_enc.db - dbid changed, wrote new name
Datafile /oradata06/JOSHIN/pi_32m_idx4_enc.db - dbid changed, wrote new name
Datafile /oradata06/JOSHIN/pi_32m_idx5_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/hpapp_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/hrapp6_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/pcapp_enc.db - dbid changed, wrote new name
Datafile /oradata03/JOSHIN/pi_32m_dat4_enc.db - dbid changed, wrote new name
Datafile /oradata06/JOSHIN/psindex_enc_1.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/cularg1_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/hrapp3_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/tlwork_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/pttree_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/pyapp_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/palarge_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/eoeiapp_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/psaudit_enc.db - dbid changed, wrote new name
Datafile /oradata03/JOSHIN/z_pi_partic_dat_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/htapp_enc.db - dbid changed, wrote new name
Datafile /oradata05/JOSHIN/z_archive_dat_enc2.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/pywork_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/hrlarge_enc.db - dbid changed, wrote new name
Datafile /oradata06/JOSHIN/undotbs2.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/stapp_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/fgapp_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/erapp_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/eoapp_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/amapp_enc.db - dbid changed, wrote new name
Datafile /oradata05/JOSHIN/z_pi_partic_dat_enc_01.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/py_32m_dat1_enc.db - dbid changed, wrote new name
Datafile /oradata03/JOSHIN/z_pi_partic_idx_enc_01.db - dbid changed, wrote new name
Datafile /oradata05/JOSHIN/tl_payable_time_dat_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/psindex_idx2_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/bnapp_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/eotpapp_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/gpapp_enc.db - dbid changed, wrote new name
Datafile /oradata05/JOSHIN/tl_rptd_elptime_dat_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/psindex_idx3_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/aaapp_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/pclarge_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/aalarge_enc.db - dbid changed, wrote new name
Datafile /oradata05/JOSHIN/training_dat_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/adapp_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/avapp_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/ccapp_enc.db - dbid changed, wrote new name
Datafile /oradata06/JOSHIN/hr_32m_idx1_enc.db - dbid changed, wrote new name
Datafile /oradata06/JOSHIN/pi_32m_idx1_enc.db - dbid changed, wrote new name
Datafile /oradata06/JOSHIN/pi_32m_idx2_enc.db - dbid changed, wrote new name
Datafile /oradata06/JOSHIN/pi_32m_idx3_enc.db - dbid changed, wrote new name
Datafile /oradata06/JOSHIN/psindex_enc.db - dbid changed, wrote new name
Datafile /oradata06/JOSHIN/py_32m_idx1_enc.db - dbid changed, wrote new name
Datafile /oradata06/JOSHIN/tl_32m_idx1_enc.db - dbid changed, wrote new name
Datafile /oradata06/JOSHIN/tl_payable_time_idx_enc.db - dbid changed, wrote new name
Datafile /oradata06/JOSHIN/tl_rptd_elptime_idx_enc.db - dbid changed, wrote new name
Datafile /oradata06/JOSHIN/training_idx_enc.db - dbid changed, wrote new name
Datafile /oradata06/JOSHIN/z_archive_idx_enc.db - dbid changed, wrote new name
Datafile /oradata06/JOSHIN/z_pi_partic_idx_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/ptprjwk_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/pi_32m_dat2_enc.db - dbid changed, wrote new name
Datafile /oradata03/JOSHIN/pi_32m_dat3_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/dtapp_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/eobfapp_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/eocfapp_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/eoltapp_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/eoppapp_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/eopplrg_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/faapp_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/falarge_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/fglarge_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/hrapp7_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/hrimage_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/hrlarg1_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/hrsapp_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/hrsarch_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/hrslarge_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/hrswork_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/psimage2_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/psmatvw_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/saapp_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/sacapp_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/salarge_enc.db - dbid changed, wrote new name
Datafile /oradata17/JOSHIN/srapp_enc.db - dbid changed, wrote new name
Datafile /oradata13/TEST/pstemp01.db - dbid changed, wrote new name
Control File /oradata05/JOSHIN/control01.ctl - dbid changed, wrote new name
Control File /oradata06/JOSHIN/control02.ctl - dbid changed, wrote new name
Instance shut down
Database name changed to JOSHIN.
Modify parameter file and generate a new password file before restarting.
Database ID for database JOSHIN changed to 2634151111.
All previous backups and archived redo logs for this database are unusable.
Database has been shutdown, open database with RESETLOGS option.
Succesfully changed database name and ID.
DBNEWID - Completed succesfully.
localhost:/home/oracle/joshi:$
localhost:/home/oracle/joshi:$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Mon Feb 20 08:26:09 2017
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 1728053248 bytes
Fixed Size 2925264 bytes
Variable Size 1073745200 bytes
Database Buffers 637534208 bytes
Redo Buffers 13848576 bytes
SQL> show parameter db_name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string TEST
SQL> alter system set db_name=JOSHIN scope=spfile;
System altered.
SQL> shu immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 1728053248 bytes
Fixed Size 2925264 bytes
Variable Size 1073745200 bytes
Database Buffers 637534208 bytes
Redo Buffers 13848576 bytes
SQL> show parameter db_name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string JOSHIN
SQL> alter database mount;
Database altered.
SQL> alter database open RESETLOGS;
Database altered.
SQL> select name,instance_name,open_mode,log_mode,host_name from v$database,v$instance;
NAME INSTANCE_NAME OPEN_MODE LOG_MODE HOST_NAME
--------- ---------------- -------------------- ------------ ----------------------------------------------------------------
JOSHIN JOSHIN READ WRITE ARCHIVELOG localhost
No comments:
Post a Comment