| REPORT Reports backup status of your database: which files are in the database, which files need backups, and which backups are obsolete or unrecoverable. REPORT { { NEED BACKUP [ { INCREMENTAL | DAYS } [=] integer | REDUNDANCY [=] integer | RECOVERY WINDOW OF integer DAYS) ] | UNRECOVERABLE } reportObject | SCHEMA [atClause] | OBSOLETE [obsOperandList] } [ DEVICE TYPE deviceSpecifier [,deviceSpecifier]... ] reportObject::= [ DATAFILE datafileSpec [, datafileSpec]... | TABLESPACE ['] tablespace_name ['] [, ['] tablespace_name [']]... | DATABASE [SKIP TABLESPACE ['] tablespace_name ['] [, ['] tablespace_name [']]...] ] atClause::= { AT TIME [=] 'date_string' | AT SCN [=] integer | AT SEQUENCE [=] integer THREAD [=] integer } obsOperandList::= [ REDUNDANCY [=] integer | RECOVERY WINDOW OF integer DAYS ]... RESTORE Restores RMAN backups and copies. RESTORE [(] restoreObject [(restoreSpecOperand [restoreSpecOperand]...] [)]... [ CHANNEL ['] channel_id ['] | PARMS [=] 'channel_parms' | FROM { BACKUPSET | DATAFILECOPY } | untilClause | FROM TAG [=] ['] tag_name ['] | VALIDATE | DEVICE TYPE deviceSpecifier [, deviceSpecifier]... . . . ]...; restoreObject::= { CONTROLFILE [TO 'filename'] | DATABASE [SKIP [FOREVER] TABLESPACE ['] tablespace_name ['] [, ['] tablespace_name [']]... ] | DATAFILE datafileSpec [, datafileSpec]... | TABLESPACE ['] tablespace_name ['] [, ['] tablespace_name [']]... | archivelogRecordSpecifier | SPFILE [TO [PFILE] 'filename'] } restoreSpecOperand::= { CHANNEL ['] channel_id ['] | FROM TAG [=] ['] tag_name ['] | PARMS [=] 'channel_parms' | FROM { AUTOBACKUP [{ MAXSEQ | MAXDAYS } [=] integer)]... | 'media_handle' } } |

