Unable to startup database :ORA-38760: This database instance failed to turn on flashback database [message #336919] |
Tue, 29 July 2008 06:30 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
zafiq
Messages: 9 Registered: July 2008 Location: malaysia
|
Junior Member |
![a_zafiq83](/forum/theme/orafaq/images/yahoo.png)
|
|
Dear All,
Please help me..
I can't open my database..
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =36
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 300
sessions = 335
__shared_pool_size = 637534208
__large_pool_size = 16777216
__java_pool_size = 16777216
__streams_pool_size = 0
sga_target = 14797504512
control_files = /oradata1/agprod/control01.ctl, /oradata2/agprod/control02.ctl, /oradata3/agprod/control03.ctl
control_file_record_keep_time= 14
db_block_size = 8192
__db_cache_size = 14109638656
compatible = 10.2.0.1.0
log_archive_dest_1 = LOCATION=/DBarchive/agprod/arch
log_archive_format = %t_%s_%r.dbf
db_file_multiblock_read_count= 16
db_recovery_file_dest = /DBarchive/flash_recovery_area
db_recovery_file_dest_size= 59055800320
db_flashback_retention_target= 0
undo_management = AUTO
undo_tablespace = UNDOTBS1
_kgl_large_heap_warning_threshold= 8388608
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=agprodXDB)
job_queue_processes = 10
background_dump_dest = /oracle/admin/agprod/bdump
user_dump_dest = /oracle/admin/agprod/udump
core_dump_dest = /oracle/admin/agprod/cdump
audit_file_dest = /oracle/admin/agprod/adump
db_name = agprod
open_cursors = 300
pga_aggregate_target = 526385152
PMON started with pid=2, OS id=377066
PSP0 started with pid=3, OS id=372738
MMAN started with pid=4, OS id=344284
DBW0 started with pid=5, OS id=340170
LGWR started with pid=6, OS id=336066
CKPT started with pid=7, OS id=331954
SMON started with pid=8, OS id=303326
RECO started with pid=9, OS id=315422
CJQ0 started with pid=10, OS id=381154
MMON started with pid=11, OS id=217300
Tue Jul 29 19:09:58 2008
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=274624
Tue Jul 29 19:09:58 2008
starting up 1 shared server(s) ...
Tue Jul 29 19:09:58 2008
ALTER DATABASE MOUNT
Tue Jul 29 19:10:02 2008
Setting recovery target incarnation to 2
Tue Jul 29 19:10:02 2008
Successful mount of redo thread 1, with mount id 1905766406
Tue Jul 29 19:10:02 2008
Allocated 15937344 bytes in shared pool for flashback generation buffer
Starting background process RVWR
RVWR started with pid=16, OS id=401420
Tue Jul 29 19:10:02 2008
Errors in file /oracle/admin/agprod/udump/agprod_ora_409616.trc:
ORA-38701: Flashback database log 402 seq 402 thread 1: "/DBarchive/flash_recovery_area/AGPROD/flashback/o1_mf_47cqbhb5_.flb"
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
Tue Jul 29 19:10:02 2008
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|