Database Software

Hi All,

I've setting my physical database and standby database, This issue occur after I restore data file from physical database backup.
I've encountered this error
---------------------------------------
ORA-01034: ORACLE not available
Detailed OCI error val is 1034 and errmsg is 'ORA-01034
----------------------------------------------------------------------------
I've read from other thread but seems the issues still occur.

I can't open my standby database with read only mode too, and below error occur
-------------------------------------------------------
alter database open read only
*
ERROR at line 1:
ORA-16004: backup database requires recovery
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/fin01/oradata/FIN/system01.dbf'
-----------------------------------------------------------

Anything wrong with my setting?

Primary database setting
------------------------------------
O7_DICTIONARY_ACCESSIBILITY=TRUE
aq_tm_processes=0
background_dump_dest=/orafin/findb/10.2.0/admin/FIN/bdump
compatible=10.2.0.1.0
control_files=/fin01/oradata/FIN/control01.ctl, /fin02/oradata/FIN/control02.ctl,/fin03/oradata/FIN/control03.ctl
core_dump_dest=/orafin/findb/10.2.0/admin/FIN/cdump
cursor_sharing=EXACT
db_block_size=8192
db_domain=''
db_file_multiblock_read_count=8
db_files=400
db_name=FIN
db_unique_name=FIN
disk_asynch_io=FALSE
dml_locks=10000
filesystemio_options=none
instance_name=FIN
java_pool_size=4194304
job_queue_processes=2
large_pool_size=8388608
#log_archive_dest='/arc_beportal/'
db_recovery_file_dest='/orafin/flash_recovery_area'
db_recovery_file_dest_size=2147483648
db_flashback_retention_target=4320
log_archive_format=arc_fin1%t_%r_%s.log
log_buffer=14477312
log_checkpoint_interval=100000
log_checkpoint_timeout=1200
log_checkpoints_to_alert=TRUE
#log_file_name_convert = '/redobeportal/redo01.log','/redobeportal/redostand4','/redobeportal/redo02.log','/redobeportal/redostand5','/redobeportal/redo03.log','/redobeportal/redostand6'
log_archive_config='DG_CONFIG=(FIN,FINST)'
LOG_ARCHIVE_DEST_1='LOCATION=/arc_fin VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=FIN'
LOG_ARCHIVE_DEST_2='SERVICE=FINST LGWR SYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=FINST'
#log_archive_dest='LOCATION=/oracle/dbportal/oradata/DBPORTAL/arc'
log_archive_dest_state_1='ENABLE'
log_archive_dest_state_2='ENABLE'
log_archive_max_processes=30
standby_file_management=auto
standby_archive_dest='/arc_fin'
fal_client='FIN'
fal_server='FINST'
max_dump_file_size=20480
nls_comp=binary
nls_date_format="DD-MON-RR"
nls_language="american"
nls_length_semantics=BYTE
nls_numeric_characters=".,"
nls_sort=binary
nls_territory="america"
open_cursors=300
optimizer_mode=choose
parallel_max_servers=2
parallel_min_servers=0
pga_aggregate_target=209715200
processes=150
query_rewrite_enabled=true
remote_login_passwordfile='EXCLUSIVE'
resource_limit=TRUE
resource_manager_plan=""
session_max_open_files=20
sessions=300
sga_target=612368384
shared_pool_size=209715200
streams_pool_size=50331648
timed_statistics=TRUE
undo_management=AUTO
undo_retention=900
undo_tablespace=UNDOTBS1
user_dump_dest=/orafin/findb/10.2.0/admin/FIN/udump
utl_file_dir=/usr/tmp, /orafin/findb/10.2.0/appsutil/outbound/FIN_beprdabc, /orafin/findb/10.2.0/admin/FIN/bdump
workarea_size_policy=auto
service_names=FIN

Standby database setting
O7_DICTIONARY_ACCESSIBILITY=TRUE
aq_tm_processes=0
background_dump_dest=/orafin/findb/10.2.0/admin/FIN/bdump
compatible=10.2.0.1.0
control_files=/fin01/oradata/FIN/ctrl1.ctl, /fin02/oradata/FIN/ctrl2.ctl, /fin03/oradata/FIN/ctrl3.ctl
core_dump_dest=/orafin/findb/10.2.0/admin/FIN/cdump
cursor_sharing=EXACT
db_block_size=8192
db_domain=''
db_file_multiblock_read_count=8
db_files=400
db_name=FIN
db_unique_name=FINST
disk_asynch_io=FALSE
dml_locks=10000
filesystemio_options=none
#instance_name=FINST
java_pool_size=4194304
job_queue_processes=2
large_pool_size=8388608
#log_archive_dest='/arc_fin/'
log_archive_format=arc_fin%t_%r_%s.log
log_buffer=14477312
log_checkpoint_interval=100000
log_checkpoint_timeout=1200
log_checkpoints_to_alert=TRUE
#log_file_name_convert = '/redobeportal/redo01.log','/redobeportal/redostand4','/redobeportal/redo02.log','/redobeportal/redostand5','/redobeportal/redo03.log','/redobeportal/redostand6'
log_archive_config='DG_CONFIG=(FINST,FIN)'
LOG_ARCHIVE_DEST_1='LOCATION=/arc_fin VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=FINST'
LOG_ARCHIVE_DEST_2='SERVICE=FIN LGWR SYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=FIN'
#log_archive_dest='LOCATION=/oracle/dbportal/oradata/DBPORTAL/arc'
log_archive_dest_state_1='ENABLE'
log_archive_dest_state_2='ENABLE'
#db_file_name_convert = 'FIN','FINST'
#log_file_name_convert = 'FIN','FINST'
log_archive_max_processes=30
standby_file_management=auto
standby_archive_dest='/arc_fin'
fal_client='FINST'
fal_server='FIN'
max_dump_file_size=20480
nls_comp=binary
nls_date_format="DD-MON-RR"
nls_language="american"
nls_length_semantics=BYTE
nls_numeric_characters=".,"
nls_sort=binary
nls_territory="america"
open_cursors=300
optimizer_mode=choose
parallel_max_servers=2
parallel_min_servers=0
pga_aggregate_target=209715200
processes=150
query_rewrite_enabled=true
remote_login_passwordfile='EXCLUSIVE'
resource_limit=TRUE
resource_manager_plan=""
session_max_open_files=20
sessions=300
sga_target=612368384
shared_pool_size=209715200
streams_pool_size=50331648
timed_statistics=TRUE
undo_management=AUTO
undo_retention=900
undo_tablespace=UNDOTBS1
user_dump_dest=/orafin/findb/10.2.0/admin/FIN/udump
utl_file_dir=/usr/tmp, /orafin/findb/10.2.0/admin/appsutil/outbound/FIN_devabc, /orafin/findb/10.2.0/admin/FIN/bdump
workarea_size_policy=auto
service_names=FINST


Thanks a lot!