Oracle RMAN 11g Backup and Recovery (179 page)

Syntax Diagram

,

DEVICE TYPE

deviceSpecifier

RECOVER

recoverSpec

;

recoverSpec Parameter Syntax Diagram

recoverObject

recoverOptionList

blockObject

recoverObject

recoverOptionList

blockObject

592
Part V: Appendixes

recoverObject Parameter Syntax Diagram

’

’

WITH TAG

tag_name

COPY OF dbObject

,

DATAFILECOPY

’

filename

’

dbObject

,

FOREVER

’

’

SKIP

TABLESPACE

tablespace_name

TO RESTORE POINT

restore_point_name

untilClause

dbObject Parameter Syntax Diagram

DATABASE

,

DATAFILE

datafileSpec

,

’

’

TABLESPACE

tablespace_name

blockObject Parameter Syntax Diagram

CORRUPTION LIST

,

TO

integer

DATAFILE

datafileSpec BLOCK

integer

,

’

’

TABLESPACE

tablespace_name

DBA

integer

Appendix A: RMAN Syntax Reference Guide
593

recoverOptionList Parameter Syntax Diagram

ALLOW

integer

CORRUPTION

’

’

ARCHIVELOG TAG

tag_name

AUXILIARY DESTINATION ’

location

’

CHECK LOGICAL

MAXSIZE

sizeSpec

DELETE ARCHIVELOG

FLASHBACK LOG

EXCLUDE

STANDBY

BACKUPSET

FROM

DATAFILECOPY

’

’

FROM TAG

tag_name

NOPARALLEL

NOREDO

integer

PARALLEL

SKIP READONLY

TEST

,

’

’

UNDO TABLESPACE

tablespace_name

VALIDATE HEADER

sizeSpec Parameter Syntax Diagram

G

K

M

integer

Chapter References

The
recover
command is documented in several chapters, such as Chapters 12 and 14.

Examples

recover database;

recover tablespace users;

recover datafile 1;

594
Part V: Appendixes

register database Command

The
register database
command registers the target database in the recovery catalog.

Syntax Diagram

REGISTER DATABASE

;

Chapter Reference

The
register database
command is covered in Chapter 10.

Example

register database;

release channel Command

The
release channel
command is used to release an allocated channel (regular and maintenance).

Channels are generally released automatically by RMAN, so this command is rarely needed in practice.

Syntax Diagram

’

’

RELEASE CHANNEL

channel_id

;

releaseForMaint Parameter Syntax Diagram

RELEASE CHANNEL

;

Example

release channel c1;

repair failure Command

The
repair failure
command is used to correct errors that are identified by the Data Recovery Advisor.

Syntax Diagram

NOPROMPT

USING ADVISE OPTION integer

PREVIEW

REPAIR FAILURE

;

Chapter Reference

The
repair failure
command is covered in Chapter 12.

Example

repair failure;

Appendix A: RMAN Syntax Reference Guide
595

replace script Command

The
replace script
command is used to replace command scripts stored in the recovery catalog.

Syntax Diagram

GLOBAL

’

’

COMMENT

’

comment

’

REPLACE

SCRIPT

script_name

backupCommands

maintenanceCommands

{

}

miscellaneousCommands

restoreCommands

;

FROM FILE

’

filename

’

Chapter Reference

Chapter 10 contains information on this command.

Example

replace script backup full

{ backup device type sbt database plus archivelog; }

report Command

The
report
command is used to provide reporting functionality based on the metadata in the recovery catalog or the database control file. The output from the
report
command can be used to determine the recovery status of the database and its component parts.

Syntax Diagram

needBackupOption

obsOperandList

,

OBSOLETE

forDbUniqueNameOption

DEVICE TYPE

deviceSpecifier

REPORT

;

forDbUniqueNameOption

atClause

SCHEMA

UNRECOVERABLE

reportObject

needBackupOption Parameter Syntax Diagram

DAYS

integer

INCREMENTAL

RECOVERY WINDOW OF integer

DAYS

REDUNDANCY integer

NEED BACKUP

reportObject

596
Part V: Appendixes

reportObject Parameter Syntax Diagram

,

’

’

SKIP TABLESPACE

tablespace_name

DATABASE

,

DATAFILE

datafileSpec

,

’

’

TABLESPACE

tablespace_name

atClause Parameter Syntax Diagram

AT SCN

integer

THREAD

integer

AT SEQUENCE

integer

AT TIME

’

date_string

’

Chapter Reference

Chapter 17 provides information on the
report
command.

Examples

report need backup days 3;

report unrecoverable;

report obsolete;

reset database Command

The
reset database
command is used after you have created a new database incarnation via the use of the
alter database open resetlogs
command. The
reset database
command is also used to reset the database to a prior database incarnation for recovery purposes.

Syntax Diagram

RESET DATABASE TO INCARNATION

primaryKey

;

Chapter Reference

Chapter 14 provides more details on the
reset database
command.

Appendix A: RMAN Syntax Reference Guide
597

Examples

reset database to incarnation 3;

reset database;

restore Command

The
restore
command is used to restore database datafiles, datafile copies, archived redo logs, control files, or SPFILEs from backup media in preparation for recovery.