bation with rman

 

 

 

 

 

 

 

 

 

 

 

Documented : RMAN DATA VALIDATION FOR  ENOVIA                 Prepared By :  Amin Ali Ansari

Dated            :   06-July-2018

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Data Backup Validation Of Enovia Database

 

 

Details:

 

Platform:

Linux ENOVIA-DB-SRV.ttps.toshiba-india.com 2.6.32-431.el6.x86_64 #1 SMP Sun Nov 10 22:19:54 EST 2013 x86_64 x86_64 x86_64 GNU/Linux

 

Production Server: 10.116.8.9

Test Server : 10.116.8.6

 

Prod user: oracle

Test User: enotest

 

 

Steps to Clone an Oracle Database Instance

This procedure documents the steps to follow when cloning an Oracle database instance.

 

 

1.Check the database name.

select name from v$database;

ORCL

 

2.Check the Listener service.

Lsnrctl status ORCL

[oracle@ENOVIA-DB-SRV ~]$ lsnrctl status ORCL

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 12-JUN-2018 14:53:07

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ENOVIA-DB-SRV.ttps.toshiba-india.com)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl.ttps.toshiba-india.com)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production

Start Date                07-JUN-2018 09:47:46

Uptime                    28 days 5 hr. 5 min. 21 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora

Listener Log File         /u01/app/oracle/diag/tnslsnr/ENOVIA-DB-SRV/listener/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))

Services Summary...

Service "orcl.ttps.toshiba-india.com" has 1 instance(s).

  Instance "orcl", status READY, has 1 handler(s) for this service...

Service "orclXDB.ttps.toshiba-india.com" has 1 instance(s).

  Instance "orcl", status READY, has 1 handler(s) for this service...

The command completed successfully

1. Copy the password file orapwd  to the Test Server. Create directory for your as per your CLONED database location and rename it to as per New Oracle Database SID name. This will be updated  later . It should look like:

First we must create a password file for the duplicate instance.

      export ORACLE_SID=ORCL orapwd file=orapwORCL password=manager entries=5 force=y

2.  Create an Initialization Parameter File for the Test Instance Enotest.

Check database , which parameter file its using.If its spfile then create pfile from below sql query .

Show parameter spfile;

SQL> create pfile from spfile;

Pfile created.

3.Make necessary changes in parameter file for test instance.

*.__db_cache_size=4672M

orcl.__db_cache_size=1140850688

*.__java_pool_size=64M

orcl.__java_pool_size=67108864

*.__large_pool_size=64M

orcl.__large_pool_size=67108864

*.__oracle_base='/u01/app/oracle'# ORACLE_BASE set from environment

*.__pga_aggregate_target=4800M

orcl.__pga_aggregate_target=4294967296

*.__sga_target=8064M

orcl.__sga_target=3221225472

*.__shared_io_pool_size=0

orcl.__shared_io_pool_size=0

*.__shared_pool_size=3G

orcl.__shared_pool_size=1879048192

*.__streams_pool_size=128M

orcl.__streams_pool_size=0

*._aggregation_optimization_settings=0

*._always_anti_join='CHOOSE'

*._always_semi_join='CHOOSE'

*._and_pruning_enabled=TRUE

*._b_tree_bitmap_plans=TRUE

*._bloom_filter_enabled=TRUE

*._bloom_folding_enabled=TRUE

*._bloom_pruning_enabled=TRUE

*._complex_view_merging=TRUE

*._compression_compatibility='11.2.0.0.0'

*._connect_by_use_union_all='TRUE'

*._convert_set_to_join=FALSE

*._cost_equality_semi_join=TRUE

*._cpu_to_io=0

*._dimension_skip_null=TRUE

*._eliminate_common_subexpr=TRUE

*._enable_type_dep_selectivity=TRUE

*._fast_full_scan_enabled=TRUE

*._first_k_rows_dynamic_proration=TRUE

*._gby_hash_aggregation_enabled=TRUE

*._generalized_pruning_enabled=TRUE

*._globalindex_pnum_filter_enabled=TRUE

*._gs_anti_semi_join_allowed=TRUE

*._improved_outerjoin_card=TRUE

*._improved_row_length_enabled=TRUE

*._index_join_enabled=TRUE

*._ksb_restart_policy_times='0','60','120','240'# internal update to set default

*._left_nested_loops_random=TRUE

*._local_communication_costing_enabled=TRUE

*._minimal_stats_aggregation=TRUE

*._mmv_query_rewrite_enabled=TRUE

*._new_initial_join_orders=TRUE

*._new_sort_cost_estimate=TRUE

*._nlj_batching_enabled=1

*._optim_adjust_for_part_skews=TRUE

*._optim_enhance_nnull_detection=TRUE

*._optim_new_default_join_sel=TRUE

*._optim_peek_user_binds=TRUE

*._optimizer_adaptive_cursor_sharing=TRUE

*._optimizer_better_inlist_costing='ALL'

*._optimizer_cbqt_no_size_restriction=TRUE

*._optimizer_coalesce_subqueries=TRUE

*._optimizer_complex_pred_selectivity=TRUE

*._optimizer_compute_index_stats=TRUE

*._optimizer_connect_by_combine_sw=TRUE

*._optimizer_connect_by_cost_based=TRUE

*._optimizer_connect_by_elim_dups=TRUE

*._optimizer_correct_sq_selectivity=TRUE

*._optimizer_cost_based_transformation='LINEAR'

*._optimizer_cost_hjsmj_multimatch=TRUE

*._optimizer_cost_model='CHOOSE'

*._optimizer_dim_subq_join_sel=TRUE

*._optimizer_distinct_agg_transform=TRUE

*._optimizer_distinct_elimination=TRUE

*._optimizer_distinct_placement=TRUE

*._optimizer_eliminate_filtering_join=TRUE

*._optimizer_enable_density_improvements=TRUE

*._optimizer_enable_extended_stats=TRUE

*._optimizer_enhanced_filter_push=TRUE

*._optimizer_extend_jppd_view_types=TRUE

*._optimizer_extended_cursor_sharing='UDO'

*._optimizer_extended_cursor_sharing_rel='SIMPLE'

*._optimizer_extended_stats_usage_control=224

*._optimizer_fast_access_pred_analysis=TRUE

*._optimizer_fast_pred_transitivity=TRUE

*._optimizer_filter_pred_pullup=TRUE

*._optimizer_fkr_index_cost_bias=10

*._optimizer_group_by_placement=TRUE

*._optimizer_improve_selectivity=TRUE

*._optimizer_join_elimination_enabled=TRUE

*._optimizer_join_factorization=TRUE

*._optimizer_join_order_control=3

*._optimizer_join_sel_sanity_check=TRUE

*._optimizer_max_permutations=2000

*._optimizer_mode_force=TRUE

*._optimizer_multi_level_push_pred=TRUE

*._optimizer_native_full_outer_join='FORCE'

*._optimizer_new_join_card_computation=TRUE

*._optimizer_null_aware_antijoin=TRUE

*._optimizer_or_expansion='DEPTH'

*._optimizer_order_by_elimination_enabled=TRUE

*._optimizer_outer_to_anti_enabled=TRUE

*._optimizer_push_down_distinct=0

*._optimizer_push_pred_cost_based=TRUE

*._optimizer_rownum_bind_default=10

*._optimizer_rownum_pred_based_fkr=TRUE

*._optimizer_skip_scan_enabled=TRUE

*._optimizer_sortmerge_join_inequality=TRUE

*._optimizer_squ_bottomup=TRUE

*._optimizer_star_tran_in_with_clause=TRUE

*._optimizer_system_stats_usage=TRUE

*._optimizer_table_expansion=TRUE

*._optimizer_transitivity_retain=TRUE

*._optimizer_try_st_before_jppd=TRUE

*._optimizer_undo_cost_change='11.2.0.1'

*._optimizer_unnest_corr_set_subq=TRUE

*._optimizer_unnest_disjunctive_subq=TRUE

*._optimizer_use_cbqt_star_transformation=TRUE

*._optimizer_use_feedback=TRUE

*._or_expand_nvl_predicate=TRUE

*._ordered_nested_loop=TRUE

*._parallel_broadcast_enabled=TRUE

*._partition_view_enabled=TRUE

*._pga_max_size=960M

*._pivot_implementation_method='CHOOSE'

*._pre_rewrite_push_pred=TRUE

*._pred_move_around=TRUE

*._push_join_predicate=TRUE

*._push_join_union_view=TRUE

*._push_join_union_view2=TRUE

*._px_minus_intersect=TRUE

*._px_pwg_enabled=TRUE

*._px_ual_serial_input=TRUE

*._query_rewrite_setopgrw_enable=TRUE

*._remove_aggr_subquery=TRUE

*._replace_virtual_columns=TRUE

*._right_outer_hash_enable=TRUE

*._selfjoin_mv_duplicates=TRUE

*._smm_max_size=491520

*._smm_min_size=1024

*._smm_px_max_size=2457600

*._sql_model_unfold_forloops='RUN_TIME'

*._sqltune_category_parsed='DEFAULT'# parsed sqltune_category

*._subquery_pruning_enabled=TRUE

*._subquery_pruning_mv_enabled=FALSE

*._table_scan_cost_plus_one=TRUE

*._union_rewrite_for_gs='YES_GSET_MVS'

*._unnest_subquery=TRUE

*._use_column_stats_for_function=TRUE

*.aq_tm_processes=1

*.audit_file_dest='/u01/app/oracle/admin/orcl/adump'

*.audit_trail='DB'

*.compatible='11.2.0.0.0'

*.control_files='/u01/app/oracle/oradata/orcl/control01.ctl','/u01/app/oracle/flash_recovery_area/orcl/control02.ctl'

*.control_management_pack_access='NONE'# change default to NONE when system is not EE

*.core_dump_dest='/u01/app/oracle/diag/rdbms/orcl/orcl/cdump'

*.db_block_size=8192

*.db_domain='ttps.toshiba-india.com'

*.db_name='orcl'

*.db_recovery_file_dest_size=3882M

*.db_recovery_file_dest='/mntenovia/rmanbkp'

*.diagnostic_dest='/u01/app/oracle'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'

*.log_archive_dest_1='LOCATION=/u01/archive'

*.log_buffer=4415488# log buffer update

*.memory_target=7168M

*.open_cursors=300

*.optimizer_dynamic_sampling=2

*.optimizer_mode='ALL_ROWS'

*.pga_aggregate_target=4G

*.plsql_warnings='DISABLE:ALL'# PL/SQL warnings at init.ora

*.processes=300

*.query_rewrite_enabled='TRUE'

*.remote_login_passwordfile='EXCLUSIVE'

*.resource_manager_plan=''

*.result_cache_max_size=0

*.skip_unusable_indexes=TRUE

*.undo_tablespace='UNDOTBS1'

 

4.After making changes , parameter file for Enotest is :

 

*.__db_cache_size=4672M

orcl.__db_cache_size=1140850688

*.__java_pool_size=64M

orcl.__java_pool_size=67108864

*.__large_pool_size=64M

orcl.__large_pool_size=67108864

*.__oracle_base='/home/u02/app/'# ORACLE_BASE set from environment

*.__pga_aggregate_target=4800M

orcl.__pga_aggregate_target=4294967296

*.__sga_target=8064M

orcl.__sga_target=3221225472

*.__shared_io_pool_size=0

orcl.__shared_io_pool_size=0

*.__shared_pool_size=3G

orcl.__shared_pool_size=1879048192

*.__streams_pool_size=128M

orcl.__streams_pool_size=0

*._aggregation_optimization_settings=0

*._always_anti_join='CHOOSE'

*._always_semi_join='CHOOSE'

*._and_pruning_enabled=TRUE

*._b_tree_bitmap_plans=TRUE

*._bloom_filter_enabled=TRUE

*._bloom_folding_enabled=TRUE

*._bloom_pruning_enabled=TRUE

*._complex_view_merging=TRUE

*._compression_compatibility='11.2.0.0.0'

*._connect_by_use_union_all='TRUE'

*._convert_set_to_join=FALSE

*._cost_equality_semi_join=TRUE

*._cpu_to_io=0

*._dimension_skip_null=TRUE

*._eliminate_common_subexpr=TRUE

*._enable_type_dep_selectivity=TRUE

*._fast_full_scan_enabled=TRUE

*._first_k_rows_dynamic_proration=TRUE

*._gby_hash_aggregation_enabled=TRUE

*._generalized_pruning_enabled=TRUE

*._globalindex_pnum_filter_enabled=TRUE

*._gs_anti_semi_join_allowed=TRUE

*._improved_outerjoin_card=TRUE

*._improved_row_length_enabled=TRUE

*._index_join_enabled=TRUE

*._ksb_restart_policy_times='0','60','120','240'# internal update to set default

*._left_nested_loops_random=TRUE

*._local_communication_costing_enabled=TRUE

*._minimal_stats_aggregation=TRUE

*._mmv_query_rewrite_enabled=TRUE

*._new_initial_join_orders=TRUE

*._new_sort_cost_estimate=TRUE

*._nlj_batching_enabled=1

*._optim_adjust_for_part_skews=TRUE

*._optim_enhance_nnull_detection=TRUE

*._optim_new_default_join_sel=TRUE

*._optim_peek_user_binds=TRUE

*._optimizer_adaptive_cursor_sharing=TRUE

*._optimizer_better_inlist_costing='ALL'

*._optimizer_cbqt_no_size_restriction=TRUE

*._optimizer_coalesce_subqueries=TRUE

*._optimizer_complex_pred_selectivity=TRUE

*._optimizer_compute_index_stats=TRUE

*._optimizer_connect_by_combine_sw=TRUE

*._optimizer_connect_by_cost_based=TRUE

*._optimizer_connect_by_elim_dups=TRUE

*._optimizer_correct_sq_selectivity=TRUE

*._optimizer_cost_based_transformation='LINEAR'

*._optimizer_cost_hjsmj_multimatch=TRUE

*._optimizer_cost_model='CHOOSE'

*._optimizer_dim_subq_join_sel=TRUE

*._optimizer_distinct_agg_transform=TRUE

*._optimizer_distinct_elimination=TRUE

*._optimizer_distinct_placement=TRUE

*._optimizer_eliminate_filtering_join=TRUE

*._optimizer_enable_density_improvements=TRUE

*._optimizer_enable_extended_stats=TRUE

*._optimizer_enhanced_filter_push=TRUE

*._optimizer_extend_jppd_view_types=TRUE

*._optimizer_extended_cursor_sharing='UDO'

*._optimizer_extended_cursor_sharing_rel='SIMPLE'

*._optimizer_extended_stats_usage_control=224

*._optimizer_fast_access_pred_analysis=TRUE

*._optimizer_fast_pred_transitivity=TRUE

*._optimizer_filter_pred_pullup=TRUE

*._optimizer_fkr_index_cost_bias=10

*._optimizer_group_by_placement=TRUE

*._optimizer_improve_selectivity=TRUE

*._optimizer_join_elimination_enabled=TRUE

*._optimizer_join_factorization=TRUE

*._optimizer_join_order_control=3

*._optimizer_join_sel_sanity_check=TRUE

*._optimizer_max_permutations=2000

*._optimizer_mode_force=TRUE

*._optimizer_multi_level_push_pred=TRUE

*._optimizer_native_full_outer_join='FORCE'

*._optimizer_new_join_card_computation=TRUE

*._optimizer_null_aware_antijoin=TRUE

*._optimizer_or_expansion='DEPTH'

*._optimizer_order_by_elimination_enabled=TRUE

*._optimizer_outer_to_anti_enabled=TRUE

*._optimizer_push_down_distinct=0

*._optimizer_push_pred_cost_based=TRUE

*._optimizer_rownum_bind_default=10

*._optimizer_rownum_pred_based_fkr=TRUE

*._optimizer_skip_scan_enabled=TRUE

*._optimizer_sortmerge_join_inequality=TRUE

*._optimizer_squ_bottomup=TRUE

*._optimizer_star_tran_in_with_clause=TRUE

*._optimizer_system_stats_usage=TRUE

*._optimizer_table_expansion=TRUE

*._optimizer_transitivity_retain=TRUE

*._optimizer_try_st_before_jppd=TRUE

*._optimizer_undo_cost_change='11.2.0.1'

*._optimizer_unnest_corr_set_subq=TRUE

*._optimizer_unnest_disjunctive_subq=TRUE

*._optimizer_use_cbqt_star_transformation=TRUE

*._optimizer_use_feedback=TRUE

*._or_expand_nvl_predicate=TRUE

*._ordered_nested_loop=TRUE

*._parallel_broadcast_enabled=TRUE

*._partition_view_enabled=TRUE

*._pga_max_size=960M

*._pivot_implementation_method='CHOOSE'

*._pre_rewrite_push_pred=TRUE

*._pred_move_around=TRUE

*._push_join_predicate=TRUE

*._push_join_union_view=TRUE

*._push_join_union_view2=TRUE

*._px_minus_intersect=TRUE

*._px_pwg_enabled=TRUE

*._px_ual_serial_input=TRUE

*._query_rewrite_setopgrw_enable=TRUE

*._remove_aggr_subquery=TRUE

*._replace_virtual_columns=TRUE

*._right_outer_hash_enable=TRUE

*._selfjoin_mv_duplicates=TRUE

*._smm_max_size=491520

*._smm_min_size=1024

*._smm_px_max_size=2457600

*._sql_model_unfold_forloops='RUN_TIME'

*._sqltune_category_parsed='DEFAULT'# parsed sqltune_category

*._subquery_pruning_enabled=TRUE

*._subquery_pruning_mv_enabled=FALSE

*._table_scan_cost_plus_one=TRUE

*._union_rewrite_for_gs='YES_GSET_MVS'

*._unnest_subquery=TRUE

*._use_column_stats_for_function=TRUE

*.aq_tm_processes=1

*.audit_file_dest='/home/u02/app/oracle/admin/orcl/adump'

*.audit_trail='DB'

*.compatible='11.2.0.0.0'

*.control_files='/home/u02/app/oracle/oradata/cntrlorcl01.dbf','/home/u02/app/oracle/flash_recovery_area/orcl/control02.dbf'

*.control_management_pack_access='NONE'# change default to NONE when system is not EE

*.core_dump_dest='/home/u02/app/diag/rdbms/orcl/ORCL/cdump'

*.db_block_size=8192

*.db_domain='ttps.toshiba-india.com'

*.db_name='ENOTEST'

*.db_recovery_file_dest_size=3882M

*.db_recovery_file_dest='/home/u02/rmanbkp'

*.diagnostic_dest='/home/u02/app'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'

*.log_archive_dest_1='LOCATION=/home/u02/archive'

*.log_buffer=4415488# log buffer update

*.memory_target=5168M

*.open_cursors=300

*.optimizer_dynamic_sampling=2

*.optimizer_mode='ALL_ROWS'

*.pga_aggregate_target=4G

*.plsql_warnings='DISABLE:ALL'# PL/SQL warnings at init.ora

*.processes=300

*.query_rewrite_enabled='TRUE'

#*.remote_login_passwordfile='EXCLUSIVE'

*.resource_manager_plan=''

*.result_cache_max_size=0

*.skip_unusable_indexes=TRUE

*.undo_tablespace='UNDOTBS1'

 

6. Create Necessary directories as per below:

 

Mkdir –p /home/u02/app/

Mkdir –p /home/u02/app/oracle/admin/orcl/adump'

Mkdir –p /home/u02/app/oracle/oradata/cntrlorcl01.dbf,

Mkdir –p /home/u02/app/oracle/flash_recovery_area/orcl/control02.dbf

Mkdir –p /home/u02/app/diag/rdbms/orcl/ORCL/cdump

Mkdir –p /home/u02/rmanbkp

Mkdir –p /home/u02/archive

 

 

7.Send Oracle_Home file to Test Server location.

 

Take tar file :

 

Send this to test server:

scp -r * root@10.116.8.6:/home/u02/rmanbkp/

 

 

8.Extract in Oracle Home location:

cd /home/u02/app/oracle/product/11.2.0

 

Assigned necessary permission on file.

 

Chmod –R 775 db_1

 

Chown –R enotest:dba db_1

 

export PATH=$ORACLE_HOME/bin:$PATH

export ORACLE_SID=ORCL

 

9.

Send rman files to test Server:

 

 

10.Take archive from date if its exist:

 

 

 

11.

Take rman backup from backup location and send it to test Server.

 

12.Connect database with RMAN with no mount option.

 

SQL> startup nomount pfile='/home/u02/app/oracle/product/11.2.0/db_1/dbs/initorcl.ora';

ORACLE instance started.

 

Total System Global Area 7482626048 bytes

Fixed Size                  2214416 bytes

Variable Size            5637146096 bytes

Database Buffers         1811939328 bytes

Redo Buffers               31326208 bytes

 

13.

$ rman target / nocatalog

Recovery Manager: Release 11.2.0.1.0 - Production on Mon Jun 11 12:03:34 2018

 

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

 

connected to target database: ORCL (not mounted)

using target database control file instead of recovery catalog

 

RMAN> restore controlfile from '/home/u02/rmanbkp/ORCL_Control_file978689059_2434_1';

 

RMAN>

run{

set newname for datafile 4 to '/home/u02/app/oracle/oradata/users01.dbf';

set newname for datafile 3 to '/home/u02/app/oracle/oradata/undotbs01.dbf';

set newname for datafile 2 to '/home/u02/app/oracle/oradata/sysaux01.dbf';

set newname for datafile 1 to '/home/u02/app/oracle/oradata/system01.dbf';

set newname for datafile 5 to '/home/u02/app/oracle/oradata/example01.dbf';

set newname for datafile 6 to '/home/u02/app/oracle/oradata/MX_DATA15X.dbf';

set newname for datafile 7 to '/home/u02/app/oracle/oradata/MX_INDEX15X.dbf';

set newname for datafile 8 to '/home/u02/app/oracle/oradata/dash_TS01.DBF';

set newname for datafile 9 to '/home/u02/app/oracle/oradata/dashadmin_TS01.DBF';

set newname for datafile 10 to '/home/u02/app/oracle/oradata/iam_TS01.DBF';

set newname for datafile 11 to '/home/u02/app/oracle/oradata/iam_admin_TS01.DBF';

set newname for datafile 12 to '/home/u02/app/oracle/oradata/cas_TS01.DBF';

set newname for datafile 13 to '/home/u02/app/oracle/oradata/users02.dbf';

set newname for datafile 14 to '/home/u02/app/oracle/oradata/dashadmin_TS02.DBF';

set newname for datafile 15 to '/home/u02/app/oracle/oradata/dash_TS02.dbf';

set newname for datafile 16 to '/home/u02/app/oracle/oradata/iam_TS02.dbf';

set newname for datafile 17 to '/home/u02/app/oracle/oradata/iam_TS03.dbf';

set newname for datafile 18 to '/home/u02/app/oracle/oradata/iam_admin_TS02.dbf';

set newname for datafile 19 to '/home/u02/app/oracle/oradata/MX_DATA15X1.dbf';

set newname for datafile 20 to '/home/u02/app/oracle/oradata/MX_INDEX15X1.dbf';

set newname for datafile 21 to '/home/u02/app/oracle/oradata/cas_TS02.dbf';

set newname for datafile 22 to '/home/u02/app/oracle/oradata/sysaux02.dbf';

set newname for datafile 23 to '/home/u02/app/oracle/oradata/system02.dbf';

set newname for datafile 24 to '/home/u02/app/oracle/oradata/R2015X/MX_DATA15X.dbf';

set newname for datafile 25 to '/home/u02/app/oracle/oradata/R2015X/MX_INDEX15X.dbf';

set newname for datafile 26 to '/home/u02/app/oracle/oradata/MX_V6DATA15X.dbf';

set newname for datafile 27 to '/home/u02/app/oracle/oradata/MX_V6INDEX15X.dbf';

set newname for datafile 28 to '/home/u02/app/oracle/oradata/system03.dbf';

set newname for datafile 29 to '/home/u02/app/oracle/oradata/sysaux03.dbf';

set newname for datafile 30 to '/home/u02/app/oracle/oradata/MX_INDEX15X02.dbf';

set newname for datafile 31 to '/home/u02/app/oracle/oradata/MX_DATA15X02.dbf';

restore database;

switch datafile all;

}

 

RMAN> recover database;

SQL> alter database open resetlogs;

 

 

 

13. Change database name using "nid" command

 

Now start the database with mount option.

 

SQL>startup mount;

 

 

SQL> select open_mode, name from v$database;

 

OPEN_MODE            NAME

-------------------- ---------

MOUNTED              ORCL

 

 

$ nid TARGET=system DBNAME=ENOTEST

 

DBNEWID: Release 11.2.0.1.0 - Production on Mon Jun 18 11:03:40 2018

 

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

 

Password:

Connected to database ORCL (DBID=1436283480)

 

Connected to server version 11.2.0

 

Control Files in database:

    /home/u02/app/oracle/oradata/cntrlorcl01.dbf

    /home/u02/app/oracle/flash_recovery_area/orcl/control02.dbf

 

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

 

Proceeding with operation

Changing database ID from 1436283480 to 2644297490

Changing database name from ORCL to ENOTEST

    Control File /home/u02/app/oracle/oradata/cntrlorcl01.dbf - modified

    Control File /home/u02/app/oracle/flash_recovery_area/orcl/control02.dbf - mo                                                                                       dified

    Datafile /home/u02/app/oracle/oradata/system01.db - dbid changed, wrote new n                                                                                       ame

    Datafile /home/u02/app/oracle/oradata/sysaux01.db - dbid changed, wrote new n                                                                                       ame

    Datafile /home/u02/app/oracle/oradata/undotbs01.db - dbid changed, wrote new                                                                                        name

    Datafile /home/u02/app/oracle/oradata/users01.db - dbid changed, wrote new na                                                                                       me

    Datafile /home/u02/app/oracle/oradata/example01.db - dbid changed, wrote new                                                                                        name

    Datafile /home/u02/app/oracle/oradata/MX_DATA15X.db - dbid changed, wrote new                                                                                        name

    Datafile /home/u02/app/oracle/oradata/MX_INDEX15X.db - dbid changed, wrote ne                                                                                       w name

    Datafile /home/u02/app/oracle/oradata/dash_TS01.DB - dbid changed, wrote new                                                                                        name

    Datafile /home/u02/app/oracle/oradata/dashadmin_TS01.DB - dbid changed, wrote                                                                                        new name

    Datafile /home/u02/app/oracle/oradata/iam_TS01.DB - dbid changed, wrote new n                                                                                       ame

    Datafile /home/u02/app/oracle/oradata/iam_admin_TS01.DB - dbid changed, wrote                                                                                        new name

    Datafile /home/u02/app/oracle/oradata/cas_TS01.DB - dbid changed, wrote new n                                                                                       ame

    Datafile /home/u02/app/oracle/oradata/users02.db - dbid changed, wrote new na                                                                                       me

    Datafile /home/u02/app/oracle/oradata/dashadmin_TS02.DB - dbid changed, wrote                                                                                        new name

    Datafile /home/u02/app/oracle/oradata/dash_TS02.db - dbid changed, wrote new                                                                                        name

    Datafile /home/u02/app/oracle/oradata/iam_TS02.db - dbid changed, wrote new n                                                                                       ame

    Datafile /home/u02/app/oracle/oradata/iam_TS03.db - dbid changed, wrote new n                                                                                       ame

    Datafile /home/u02/app/oracle/oradata/iam_admin_TS02.db - dbid changed, wrote                                                                                        new name

    Datafile /home/u02/app/oracle/oradata/MX_DATA15X1.db - dbid changed, wrote ne                                                                                       w name

    Datafile /home/u02/app/oracle/oradata/MX_INDEX15X1.db - dbid changed, wrote n                                                                                       ew name

    Datafile /home/u02/app/oracle/oradata/cas_TS02.db - dbid changed, wrote new n                                                                                       ame

    Datafile /home/u02/app/oracle/oradata/sysaux02.db - dbid changed, wrote new n                                                                                       ame

    Datafile /home/u02/app/oracle/oradata/system02.db - dbid changed, wrote new n                                                                                       ame

    Datafile /home/u02/app/oracle/oradata/R2015X/MX_DATA15X.db - dbid changed, wr                                                                                       ote new name

    Datafile /home/u02/app/oracle/oradata/R2015X/MX_INDEX15X.db - dbid changed, w                                                                                       rote new name

    Datafile /home/u02/app/oracle/oradata/MX_V6DATA15X.db - dbid changed, wrote n                                                                                       ew name

    Datafile /home/u02/app/oracle/oradata/MX_V6INDEX15X.db - dbid changed, wrote                                                                                        new name

    Datafile /home/u02/app/oracle/oradata/system03.db - dbid changed, wrote new n                                                                                       ame

    Datafile /home/u02/app/oracle/oradata/sysaux03.db - dbid changed, wrote new n                                                                                       ame

    Datafile /home/u02/app/oracle/oradata/MX_INDEX15X02.db - dbid changed, wrote                                                                                        new name

    Datafile /home/u02/app/oracle/oradata/MX_DATA15X02.db - dbid changed, wrote n                                                                                       ew name

    Datafile /home/u02/app/oracle/oradata/temp001.db - dbid changed, wrote new na                                                                                       me

    Control File /home/u02/app/oracle/oradata/cntrlorcl01.dbf - dbid changed, wro                                                                             te new name

    Control File /home/u02/app/oracle/flash_recovery_area/orcl/control02.dbf - db                                                                                       id changed, wrote new name

    Instance shut down

 

Database name changed to ENOTEST.

Modify parameter file and generate a new password file before restarting.

Database ID for database ENOTEST changed to 2644297490.

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.

Successfully changed database name and ID.

DBNEWID - Completed successfully.

 

 

14.Now start the database.

SQL>startup

 

SQL> select open_mode, name from v$database;

 

OPEN_MODE            NAME

-------------------- ---------

READ WRITE           ENOTEST

 

 

 

15.Check Listener service and release instance for End users.

[enotest@tjps-enovia rmanbkp]$ lsnrctl status LISTENER

 

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 06-JUL-2018 11:17:13

 

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

 

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production

Start Date                18-JUN-2018 10:50:30

Uptime                    18 days 0 hr. 26 min. 44 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /home/u02/app/oracle/product/11.2.0/db_1/network/admin/listener.ora

Listener Log File         /home/u02/app/diag/tnslsnr/tjps-enovia/listener/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.116.8.6)(PORT=1521)))

Services Summary...

Service "ENOTEST.ttps.toshiba-india.com" has 1 instance(s).

  Instance "ENOTEST", status READY, has 1 handler(s) for this service...

Service "orclXDB.ttps.toshiba-india.com" has 1 instance(s).

  Instance "ENOTEST", status READY, has 1 handler(s) for this service...

The command completed successfully