SQLPlus Recover

RECOVER Command Syntax:

RECOVER {general | managed | END BACKUP}

General clause syntax:

[AUTOMATIC] [FROM location]
{ {full_database_recovery | partial_database_recovery |LOGFILE filename}
[ {TEST | ALLOW integer CORRUPTION } [TEST | ALLOW integer CORRUPTION ]…]
|CONTINUE [DEFAULT]|CANCEL}

Managed clause syntax:

MANAGED STANDBY DATABASE
[ {NODELAY | [TIMEOUT] integer | CANCEL [IMMEDIATE] [NOWAIT]}
| [DISCONNECT [FROM SESSION] ] [FINISH [NOWAIT] ] ]

RECOVER Command Examples:

Recover the entire database: RECOVER DATABASE
Recover the a datafile from the database: RECOVER DATAFILE ‘datafile.db’
Recover the database using time: RECOVER DATABASE UNTIL TIME 09-DEC-2011:08:30:00
Recover the two tablespaces from the database: RECOVER TABLESPACE t_customers, t_sales