Home » RDBMS Server » Server Administration » Unable to startup database :ORA-38760: This database instance failed to turn on flashback database (oracle 10g)
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
zafiq
Messages: 9
Registered: July 2008
Location: malaysia
Junior Member

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

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Re: Unable to startup database :ORA-38760: This database instance failed to turn on flashback databa [message #336928 is a reply to message #336919] Tue, 29 July 2008 06:55 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Well known oracle bug. If flashback enabled and you delete logs manually then instance crashes. To able to start your database disable flashback.


startup mount;
alter database flashback off;
alter database flashback on;
alter database open;
Re: Unable to startup database :ORA-38760: This database instance failed to turn on flashback databa [message #336935 is a reply to message #336928] Tue, 29 July 2008 07:17 Go to previous messageGo to next message
zafiq
Messages: 9
Registered: July 2008
Location: malaysia
Junior Member

Dear Arju,

Below is the output.

SQL> startup mount;
ORACLE instance started.

Total System Global Area 1.4798E+10 bytes
Fixed Size 2046472 bytes
Variable Size 671090168 bytes
Database Buffers 1.4110E+10 bytes
Redo Buffers 14729216 bytes
Database mounted.
SQL> alter database flashback off;

Database altered.

SQL> alter database flashback on;
alter database flashback on
*
ERROR at line 1:
ORA-38760: This database instance failed to turn on flashback database


SQL>
Re: Unable to startup database :ORA-38760: This database instance failed to turn on flashback databa [message #336936 is a reply to message #336919] Tue, 29 July 2008 07:20 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Check the flash recovery area. I guess oracle can't find flash recovery area. Set it to proper location and then turn on flashback. For details see alert log.
Re: Unable to startup database :ORA-38760: This database instance failed to turn on flashback databa [message #336937 is a reply to message #336919] Tue, 29 July 2008 07:23 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

By the way after turning off flashback try to open the database. If you want to make on flashback shutdown database and again try to turn off flashback.
Re: Unable to startup database :ORA-38760: This database instance failed to turn on flashback databa [message #336938 is a reply to message #336919] Tue, 29 July 2008 07:23 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
After
SQL> alter database flashback off;

Do
SQL>after database open;
Re: Unable to startup database :ORA-38760: This database instance failed to turn on flashback databa [message #336942 is a reply to message #336938] Tue, 29 July 2008 07:31 Go to previous messageGo to next message
zafiq
Messages: 9
Registered: July 2008
Location: malaysia
Junior Member

Dear Arju and varu123,

I try to open database after off flashback but still can't open database.. Help.. TQ..

SQL> startup mount;
ORACLE instance started.

Total System Global Area 1.4798E+10 bytes
Fixed Size 2046472 bytes
Variable Size 671090168 bytes
Database Buffers 1.4110E+10 bytes
Redo Buffers 14729216 bytes
Database mounted.
SQL> alter database flashback off;

Database altered.

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-38760: This database instance failed to turn on flashback database


SQL>
Re: Unable to startup database :ORA-38760: This database instance failed to turn on flashback databa [message #336946 is a reply to message #336919] Tue, 29 July 2008 07:36 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

flashback off>shutdown database> try to open database.

By the way do you have any guaranteed restore point?
Re: Unable to startup database :ORA-38760: This database instance failed to turn on flashback databa [message #336950 is a reply to message #336919] Tue, 29 July 2008 07:44 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Check alert log for additional mesages.
Re: Unable to startup database :ORA-38760: This database instance failed to turn on flashback databa [message #336951 is a reply to message #336946] Tue, 29 July 2008 07:46 Go to previous messageGo to next message
zafiq
Messages: 9
Registered: July 2008
Location: malaysia
Junior Member

Still can't open my database.. ?? TQ..

SQL> startup mount;
ORACLE instance started.

Total System Global Area 1.4798E+10 bytes
Fixed Size 2046472 bytes
Variable Size 671090168 bytes
Database Buffers 1.4110E+10 bytes
Redo Buffers 14729216 bytes
Database mounted.
SQL> alter database flashback off;

Database altered.

SQL> select flashback_on from v$database;

FLASHBACK_ON
------------------
RESTORE POINT ONLY


SQL> shutdown;
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.

Total System Global Area 1.4798E+10 bytes
Fixed Size 2046472 bytes
Variable Size 671090168 bytes
Database Buffers 1.4110E+10 bytes
Redo Buffers 14729216 bytes
Database mounted.
ORA-38760: This database instance failed to turn on flashback database


SQL> select * from v$flashback_database_log;

OLDEST_FLASHBACK_SCN OLDEST_FL RETENTION_TARGET FLASHBACK_SIZE
-------------------- --------- ---------------- --------------
ESTIMATED_FLASHBACK_SIZE
------------------------
0 0 1.3167E+10
0


SQL>
Re: Unable to startup database :ORA-38760: This database instance failed to turn on flashback databa [message #336957 is a reply to message #336919] Tue, 29 July 2008 07:58 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Check guaranteed restore point as I mentioned you in previous post.
Check Alert_log.

Drop guaranteed restore point.
Start up the database.
Re: Unable to startup database :ORA-38760: This database instance failed to turn on flashback databa [message #336964 is a reply to message #336957] Tue, 29 July 2008 08:14 Go to previous messageGo to next message
zafiq
Messages: 9
Registered: July 2008
Location: malaysia
Junior Member

sorry.. how to check restore point and drop restore point. note: I attacht my aler log.. TQ...
Re: Unable to startup database :ORA-38760: This database instance failed to turn on flashback databa [message #336967 is a reply to message #336919] Tue, 29 July 2008 08:19 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

To check guaranteed restore point,
Quote:
select NAME,SCN,GUARANTEE_FLASHBACK_DATABASE,DATABASE_INCARNATION# from v$restore_point;


Then drop it and start your database.

Change your db_recovery_file_dest location to a valid and accessible location.

[Updated on: Tue, 29 July 2008 22:09]

Report message to a moderator

Re: Unable to startup database :ORA-38760: This database instance failed to turn on flashback databa [message #336969 is a reply to message #336967] Tue, 29 July 2008 08:24 Go to previous messageGo to next message
zafiq
Messages: 9
Registered: July 2008
Location: malaysia
Junior Member

How to change my db_recovery_file_dest? Sorry..


SQL> select NAME,SCN,GUARANTEE_FLASHBACK_DATABASE,DATABASE_INCARNATION# from v$restore_point;

NAME
--------------------------------------------------------------------------------
SCN GUA DATABASE_INCARNATION#
---------- --- ---------------------
AGPROD_09062008
5406151 YES 2

AGPROD_11062008
5679810 YES 2

AGPROD_03062008
4748595 NO 2


SQL>
Re: Unable to startup database :ORA-38760: This database instance failed to turn on flashback databa [message #337015 is a reply to message #336969] Tue, 29 July 2008 11:53 Go to previous message
zafiq
Messages: 9
Registered: July 2008
Location: malaysia
Junior Member

Dear All,

TQ for the help.. I already solve this prob. I just turn off flashback and drop restore point before succesfully startup my database. TQ for the help.. I really appreciate it..
Previous Topic: ORA-12514
Next Topic: How to find version
Goto Forum:
  


Current Time: Tue Dec 06 16:13:08 CST 2016

Total time taken to generate the page: 0.11315 seconds