Backup/Recovery

RMAN> validate spfile;

Starting validate at 23-OCT-15
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=23 device type=DISK
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
including current SPFILE in backup set
channel ORA_DISK_1: validation complete, elapsed time: 00:00:01
List of Control File and SPFILE
===============================
File Type    Status Blocks Failing Blocks Examined
------------ ------ -------------- ---------------
SPFILE       OK     0              2
Finished validate at 23-OCT-15

Restore DDL of dropped_object

SQL> select dbms_metadata.get_ddl('INDEX', 'ALLOCATED_I056', 'DAVINCI_MASTER') from dual;
ERROR:
ORA-31603: object "ALLOCATED_I056" of type INDEX not found in schema
"DAVINCI_MASTER"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 2805
ORA-06512: at "SYS.DBMS_METADATA", line 4333
ORA-06512: at line 1



no rows selected

SQL> exec dbms_flashback.disable;

PL/SQL procedure successfully completed.

SQL> exec dbms_flashback.ENABLE_AT_TIME(sysdate - 3/24);

PL/SQL procedure successfully completed.

SQL> select dbms_metadata.get_ddl('INDEX', 'ALLOCATED_I056', 'DAVINCI_MASTER') from dual;

DBMS_METADATA.GET_DDL('INDEX','ALLOCATED_I056','DAVINCI_MASTER')
--------------------------------------------------------------------------------

  CREATE BITMAP INDEX "DAVINCI_MASTER"."ALLOCATED_I056" ON "DAVINCI_MASTER"."AL