Hello eveyone,
Can anyone tell me how to add datafile and resize in primary database in same location?
Oracle version is Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production on windows.
Below is init.ora file of prod & DR db.
init.ora file in PRODUCTION :
==========================================
ebt.__db_cache_size=1157627904
ebt.__java_pool_size=33554432
ebt.__large_pool_size=16777216
ebt.__oracle_base='E:\oracle\product'#ORACLE_BASE set from environment
ebt.__pga_aggregate_target=1493172224
ebt.__sga_target=2801795072
ebt.__shared_io_pool_size=0
ebt.__shared_pool_size=1543503872
ebt.__streams_pool_size=16777216
*.archive_lag_target=0
*.compatible='11.2.0'
*.control_files='E:\oracle\oradata\EBT\control01.ctl','E:\oracle\oradata\EBT\control02.ctl','E:\oracle\oradata\EBT\control03.ctl'
*.db_block_size=4096
*.db_cache_size=200m
*.db_domain=''
*.db_name='EBT'
*.db_unique_name='ebt'
*.dg_broker_start=FALSE
*.fal_server='ebtdr'
*.instance_name='EBT'
*.java_pool_size=31457280
*.job_queue_processes=1000
*.log_archive_config='dg_config=(EBT,ebtdr)'
*.log_archive_dest_1='LOCATION=e:\oracle\oradata\ebt\archive\ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=ebt'
*.log_archive_dest_2='service="ebtdr"','LGWR ASYNC NOAFFIRM delay=0 optional compression=disable max_failure=0 max_connections=1 reopen=300 db_unique_name="ebtdr" net_timeout=30','valid_for=(all_logfiles,primary_role)'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'
ebt.log_archive_format='ARC%S_%R.%T'
*.log_archive_max_processes=4
*.log_archive_min_succeed_dest=1
ebt.log_archive_trace=0
*.memory_max_target=4G
*.memory_target=4G
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=500m
*.standby_file_management='AUTO'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS'
SQL> select name from v$datafile;
NAME
--------------------------------------------
E:\ORACLE\ORADATA\EBT\SYSTEM01.DBF
E:\ORACLE\ORADATA\EBT\UNDOTBS01.DBF
E:\ORACLE\ORADATA\EBT\INDX01.DBF
E:\ORACLE\ORADATA\EBT\TOOLS01.DBF
E:\ORACLE\ORADATA\EBT\USERS01.DBF
E:\ORACLE\ORADATA\EBT\USERS02.DBF
E:\ORACLE\ORADATA\EBT\USERS03.DBF
E:\ORACLE\ORADATA\EBT\USERS04.DBF
E:\ORACLE\ORADATA\EBT\USERS05.DBF
E:\ORACLE\ORADATA\EBT\USERS06.DBF
E:\ORACLE\ORADATA\EBT\USERS07.DBF
NAME
--------------------------------------------
E:\ORACLE\ORADATA\EBT\SYSAUX01.DBF
12 rows selected.
init.ora in DR:
===============================
ebt.__db_cache_size=1778384896
ebt.__java_pool_size=33554432
ebt.__large_pool_size=16777216
ebt.__oracle_base='E:\oracle\product'#ORACLE_BASE set from environment
ebt.__pga_aggregate_target=1728053248
ebt.__sga_target=2566914048
ebt.__shared_io_pool_size=0
ebt.__shared_pool_size=704643072
ebt.__streams_pool_size=0
*.compatible='11.2.0'
*.control_files='E:\oracle\oradata\EBT\control01.ctl','E:\oracle\oradata\EBT\control02.ctl','E:\oracle\oradata\EBT\control03.ctl'
*.db_block_size=4096
*.db_cache_size=200m
*.db_domain=''
*.db_name='EBT'
*.db_unique_name='EBTDR'
*.java_pool_size=31457280
*.job_queue_processes=1000
*.log_archive_config='DG_CONFIG=(ebt,ebtdr)'
*.log_archive_dest_1='LOCATION=e:\oracle\oradata\ebt\archive\ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=ebtdr'
*.log_archive_dest_2='SERVICE=ebt ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=ebt'
*.memory_max_target=4G
*.memory_target=4G
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.shared_pool_size=500m
*.standby_file_management='AUTO'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS'
SQL> sho parameter standby_file_management
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
standby_file_management string AUTO
SQL> sho parameter db_file_name_convert
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert string
SQL> sho parameter log_file_name_convert
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_file_name_convert string
Do I need to add any other parameter in init.ora file?
Please provide me steps how to add it
Thanks,
Meenakshy