ORA-38760: This database instance failed to turn on flashback database
772262Feb 3 2011 — edited Feb 3 2011[oracle@ccoshs02xvdbs01 rac_binaries]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Thu Feb 3 14:30:11 2011
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
alter session set NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS'
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
14:30:11 SQL> startup mount;
ORACLE instance started.
Total System Global Area 534462464 bytes
Fixed Size 2215064 bytes
Variable Size 411042664 bytes
Database Buffers 113246208 bytes
Redo Buffers 7958528 bytes
Database mounted.
14:30:28 SQL> alter database flashback off;
Database altered.
14:30:40 SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-38760: This database instance failed to turn on flashback database
14:30:46 SQL> alter database flashback on;
alter database flashback on
*
ERROR at line 1:
ORA-38706: Cannot turn on FLASHBACK DATABASE logging.
ORA-38714: Instance recovery required.
14:31:03 SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@ccoshs02xvdbs01 rac_binaries]$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Thu Feb 3 14:44:24 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: DBA01MDM (DBID=2260707724, not open)
RMAN> run
2> {
3> restore database;
4> recover database;
5> }
Starting restore at 03-FEB-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=11 device type=DISK
skipping datafile 1; already restored to file /oradata/data/dba01mdm/DBA01MDM/datafile/o1_mf_system_6jklr4d0_.dbf
skipping datafile 2; already restored to file /oradata/data/dba01mdm/DBA01MDM/datafile/o1_mf_sysaux_6jklr4j4_.dbf
skipping datafile 3; already restored to file /oradata/data/dba01mdm/DBA01MDM/datafile/o1_mf_undotbs1_6jklr4k2_.dbf
skipping datafile 4; already restored to file /oradata/data/dba01mdm/DBA01MDM/datafile/o1_mf_users_6ly72kq6_.dbf
skipping datafile 5; already restored to file /oradata/data/dba01mdm/DBA01MDM/datafile/o1_mf_canvas_p_6jkm64j1_.dbf
skipping datafile 6; already restored to file /oradata/data/dba01mdm/DBA01MDM/datafile/o1_mf_canvas_p_6jkm65ny_.dbf
skipping datafile 7; already restored to file /oradata/data/dba01mdm/DBA01MDM/datafile/o1_mf_mips_mdm_6jkm66m1_.dbf
skipping datafile 8; already restored to file /oradata/data/dba01mdm/DBA01MDM/datafile/o1_mf_mips_mdm_6jkm67mr_.dbf
skipping datafile 9; already restored to file /oradata/data/dba01mdm/DBA01MDM/datafile/o1_mf_mdm_src__6jkm68lb_.dbf
skipping datafile 10; already restored to file /oradata/data/dba01mdm/DBA01MDM/datafile/o1_mf_mdm_src__6jkm69k9_.dbf
skipping datafile 11; already restored to file /oradata/data/dba01mdm/DBA01MDM/datafile/tsp_fdba01.dbf
skipping datafile 12; already restored to file /oradata/data/dba01mdm/DBA01MDM/datafile/o1_mf_test_ts_6mfsxhlh_.dbf
restore not done; all files read only, offline, or already restored
Finished restore at 03-FEB-11
Starting recover at 03-FEB-11
using channel ORA_DISK_1
starting media recovery
media recovery failed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 02/03/2011 14:44:44
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
start
ORA-00283: recovery session canceled due to errors
ORA-38760: This database instance failed to turn on flashback database
RMAN>
How to start database.