support.
__data_transfer_cache_size=0
support.__db_cache_size=25367150592
support.__java_pool_size=805306368
support.__large_pool_size=402653184
support.__oracle_base='/oracle'#ORACLE_BASE set from environment
support.__pga_aggregate_target=11408506880
support.__sga_target=39325794304
support.__shared_io_pool_size=536870912
support.__shared_pool_size=11811160064
support.__streams_pool_size=268435456
*.archive_lag_target=0
*.audit_file_dest='/oracle/admin/support/adump'
*.audit_trail='db'
*.compatible='12.1.0.2.0'
*.control_file_record_keep_time=7
*.control_files='/oracle/oradata/support/control01.ctl','/oracle/
fast_recovery_area/support/control02.ctl'#Restore Controlfile
*.db_block_size=8192
*.db_domain=''
*.db_file_name_convert='/u01/app/oracle/oradata/drsupport','/oracle/oradata/
support'
*.db_flashback_retention_target=4320
*.db_name='support'
*.db_recovery_file_dest='/oracle/fast_recovery_area'
*.db_recovery_file_dest_size=85899345920
*.dg_broker_start=TRUE
*.diagnostic_dest='/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=supportXDB)'
*.fal_server='drsupport'
*.log_archive_config='dg_config=(support,drsupport)'
*.log_archive_dest_1='location=USE_DB_RECOVERY_FILE_DEST','valid_for=(ALL_LOGFILES,
ALL_ROLES)'
*.log_archive_dest_2='service="drsupport"','ASYNC NOAFFIRM delay=0 optional
compression=disable max_failure=0 max_connections=1 reopen=300
db_unique_name="drsupport" net_timeout=30','valid_for=(online_logfile,all_roles)'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_format='%t_%s_%r.arc'
support.log_archive_format='%t_%s_%r.arc'
*.log_archive_max_processes=4
*.log_archive_min_succeed_dest=1
support.log_archive_trace=0
*.log_file_name_convert='/u01/app/oracle/oradata/drsupport','/oracle/oradata/
support'
*.open_cursors=3000
*.pga_aggregate_limit=22721372160
*.pga_aggregate_target=11360686080
*.plsql_code_type='NATIVE'
*.processes=500
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=555
*.sga_max_size=42949672960
*.sga_target=39325794304
*.smtp_out_server='mail.ibnsinapharma.com:25'
*.standby_file_management='AUTO'
*.undo_tablespace='UNDOTBS1'
[oracle@clonedb dbs]$ vi initclonedb.ora
*.archive_lag_target=0
*.audit_file_dest='/oracle/admin/clonedb/adump'
*.audit_trail='db'
*.compatible='12.1.0.2.0'
*.control_file_record_keep_time=7
*.control_files='/oracle/oradata/clonedb/control01.ctl','/oracle/
fast_recovery_area/clonedb/control02.ctl'#Restore Controlfile
*.db_block_size=8192
*.db_domain=''
*.db_file_name_convert='/u01/app/oracle/oradata/clonedb','/oracle/oradata/clonedb'
*.db_flashback_retention_target=4320
*.db_name='support'
*.db_unique_name='clonedb'
*.db_recovery_file_dest='/oracle/fast_recovery_area'
*.db_recovery_file_dest_size=85899345920
*.diagnostic_dest='/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=clonedbXDB)'
*.fal_server='drclonedb'
*.log_archive_config='dg_config=(clonedb,drclonedb)'
*.log_archive_dest_1='location=USE_DB_RECOVERY_FILE_DEST','valid_for=(ALL_LOGFILES,
ALL_ROLES)'
*.log_archive_dest_2='service="clonedb"','ASYNC NOAFFIRM delay=0 optional
compression=disable max_failure=0 max_connections=1 reopen=300
db_unique_name="clonedb" net_timeout=30','valid_for=(online_logfile,all_roles)'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_format='%t_%s_%r.arc'
clonedb.log_archive_format='%t_%s_%r.arc'
*.log_archive_max_processes=4
*.log_archive_min_succeed_dest=1
clonedb.log_archive_trace=0
*.open_cursors=3000
*.pga_aggregate_limit=22721372160
*.pga_aggregate_target=11360686080
*.plsql_code_type='NATIVE'
*.processes=500
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=555
*.sga_max_size=42949672960
*.sga_target=39325794304
*.smtp_out_server='mail.ibnsinapharma.com:25'
*.standby_file_management='AUTO'
*.undo_tablespace='UNDOTBS1'
DUPLICATE TARGET DATABASE
FOR STANDBY
FROM ACTIVE DATABASE
DORECOVER
SPFILE
SET db_unique_name='cdb1_stby' COMMENT 'Is standby'
SET db_file_name_convert='/original/directory/path1/','/new/directory/
path1/','/original/directory/path2/','/new/directory/path2/'
SET log_file_name_convert='/original/directory/path1/','/new/directory/
path1/','/original/directory/path2/','/new/directory/path2/'
SET job_queue_processes='0'
NOFILENAMECHECK;
DUPLICATE TARGET DATABASE TO 'clonedb' FROM ACTIVE DATABASE nofilenamecheck;
DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE NOFILENAMECHECK;
