/home/oracle[DEVEL3]$srvctl stop database -d DEVEL

/home/oracle[DEVEL3]$sqlplus '/as sysdba'

SQL*Plus: Release 11.2.0.3.0 Production on Mon Sep 8 10:28:07 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup mount;
ORACLE instance started.

Total System Global Area 1.9241E+11 bytes
Fixed Size                  2232512 bytes
Variable Size            1.4388E+11 bytes
Database Buffers         4.8318E+10 bytes
Redo Buffers              208666624 bytes
Database mounted.
SQL> select name,open_mode from v$database;

NAME      OPEN_MODE
--------- --------------------
DEVEL   MOUNTED

SQL> SELECT OLDEST_FLASHBACK_SCN, OLDEST_FLASHBACK_TIME FROM V$FLASHBACK_DATABASE_LOG;

OLDEST_FLASHBACK_SCN OLDEST_FL
-------------------- ---------
          1410673507 02-SEP-14

SQL> set time on timing on
10:35:00 SQL>
10:35:36 SQL>
10:35:46 SQL> FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP('2014-09-06 17:55:00', 'YYYY-MM-DD HH24:MI:SS');
FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP('2014-09-06 17:55:00', 'YYYY-MM-DD HH24:MI:SS')
*
ERROR at line 1:
ORA-38754: FLASHBACK DATABASE not started; required redo log is not available
ORA-38762: redo logs needed for SCN 1413790251 to SCN End-of-Redo
ORA-38761: redo log sequence 38 in thread 3, incarnation 2 could not be
accessed


Elapsed: 00:00:04.96

10:38:00 SQL> show parameter flashback

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_flashback_retention_target        integer     2880


11:01:45 SQL> show parameter db_recover

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      +FRA_DG1
db_recovery_file_dest_size           big integer 8192G

RMAN> FLASHBACK DATABASE TO TIME "TO_DATE('09/06/14 17:55:00','MM/DD/YY HH24:MI:SS')";

run {
allocate channel t1 type 'SBT_TAPE'
parms 'ENV=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)' maxopenfiles 4;
allocate channel t2 type 'SBT_TAPE'
parms 'ENV=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)' maxopenfiles 4;
allocate channel t3 type 'SBT_TAPE'
parms 'ENV=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)' maxopenfiles 4;
allocate channel t4 type 'SBT_TAPE'
parms 'ENV=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)' maxopenfiles 4;
restore archivelog from sequence 38 thread 3;
}
.
.
.
.Finished restore at 08-SEP-14
released channel: t1
released channel: t2
released channel: t3
released channel: t4


12:25:28 SQL> FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP('2014-09-06 17:55:00', 'YYYY-MM-DD HH24:MI:SS');
FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP('2014-09-06 17:55:00', 'YYYY-MM-DD HH24:MI:SS')
*
ERROR at line 1:
ORA-38754: FLASHBACK DATABASE not started; required redo log is not available
ORA-38762: redo logs needed for SCN 1413790251 to SCN End-of-Redo
ORA-38761: redo log sequence 38 in thread 3, incarnation 2 could not be
accessed

08:34:31 SQL> select * from v$flashback_database_log;

OLDEST_FLASHBACK_SCN OLDEST_FL  RETENTION_TARGET     FLASHBACK_SIZE ESTIMATED_FLASHBACK_SIZE
-------------------- ---------  ----------------     -------------- ------------------------
1415114071           08-SEP-14  2880                 3.7581E+10     1.1621E+10


Elapsed: 00:00:06.07
08:34:53 SQL>
08:34:57 SQL> FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP('2014-09-08 18:22:00', 'YYYY-MM-DD HH24:MI:SS');
FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP('2014-09-08 18:22:00', 'YYYY-MM-DD HH24:MI:SS')
*
ERROR at line 1:
ORA-38754: FLASHBACK DATABASE not started; required redo log is not available
ORA-38762: redo logs needed for SCN 1415205845 to SCN End-of-Redo
ORA-38761: redo log sequence 38 in thread 3, incarnation 2 could not be
accessed


Elapsed: 00:00:02.95