Oracle RMAN 11g Backup and Recovery (182 page)

Transp_tbs_optlist Parameter Syntax Diagram

AUXILIARY DESTINATION ’

location

’

’

’

DATAPUMP DIRECTORY

datapump_directory

DUMP FILE

EXPORT LOG

’

filename

’

IMPORT SCRIPT

’

’

TABLESPACE DESTINATION

tablespace_destination

TO RESTORE POINT

restore_point_name

untilClause

Chapter Reference

Chapter 14 covers transportable tablespaces and RMAN.

Example

transport tablespace tbs 2, tbs 3

tablespace destination '/disk1/transportdest'

auxiliary destination '/disk1/auxdest'

UNTIL SCN 251982;

unregister database Command

The
unregister database
command removes a database and its associated records from the recovery catalog.

Syntax Diagram

’

’

database_name

NOPROMPT

DATABASE

;

UNREGISTER

NOPROMPT

INCLUDING BACKUPS

’

’

DB_UNIQUE_NAME

db_unique_name

;

NOPROMPT

Chapter Reference

The
unregister database
command is covered in Chapter 3.

Examples

unregister database;

unregister database oldprod;

610
Part V: Appendixes

upgrade catalog Command

The
upgrade catalog
command is used to upgrade the recovery catalog from an older version of RMAN to a newer version of RMAN.

Syntax Diagram

;

UPGRADE CATALOG

Chapter Reference

Chapter 10 contains information on the
upgrade catalog
command.

Example

upgrade catalog;

validate Command

The
validate
command is used to check and validate that a given backup set can be restored. All pieces of that backup set will be scanned by RMAN during the operation.

Syntax Diagram

validateOperand

INCLUDE CURRENT CONTROLFILE

PLUS ARCHIVELOG

validateObject

VALIDATE

;

INCLUDE CURRENT CONTROLFILE

PLUS ARCHIVELOG

validateObject

validateOperand

Appendix A: RMAN Syntax Reference Guide
611

validateObject Parameter Syntax Diagram

archivelogRecordSpecifier

,

BACKUPSET

primaryKey

CONTROLFILECOPY

’

filename

’

ALL

CONTROLFILECOPY

LIKE

’

string_pattern

’

copyOfSpec

blockObject

CURRENT CONTROLFILE

DATABASE

datafileCopySpec

,

DATAFILE

datafileSpec

RECOVERY AREA

DB_RECOVERY_FILE_DEST

RECOVERY FILES

SPFILE

,

’

’

TABLESPACE

tablespace_name

copyOfSpec Parameter Syntax Diagram

DATABASE

,

DATAFILE

datafileSpec

COPY OF

,

’

’

TABLESPACE

tablespace_name

612
Part V: Appendixes

blockObject Parameter Syntax Diagram

CORRUPTION LIST

,

TO

integer

DATAFILE

datafileSpec BLOCK

integer

,

’

’

TABLESPACE

tablespace_name

DBA

integer

validateOperand Parameter Syntax Diagram

CHECK LOGICAL

,

DEVICE TYPE

deviceSpecifier

NOEXCLUDE

SECTION SIZE

sizeSpec

skipSpec

skipSpec Parameter Syntax Diagram

INACCESSIBLE

SKIP

OFFLINE

READONLY

Chapter Reference

Chapter 16 contains information on the
validate
command.

Example

validate backup set 1330;

RMAN Subclauses Syntax Details

These subclauses appear in a number of different RMAN commands, so they are all listed in this common section for ease of reference. See the corresponding section of any related commands for examples on the use of these subclauses.

allocOperandList

This operand specifies control options related to a channel.

Appendix A: RMAN Syntax Reference Guide
613

Syntax Diagram

CONNECT

connectStringSpec

,

formatSpec

AUXILIARY FORMAT

NEW

,

FORMAT

formatSpec

,

TO DESTINATION

toDestSpec

MAXOPENFILES

integer

MAXPIECESIZE

sizeSpec

PARMS

’

channel_parms

’

RATE

sizeSpec

SEND

’

command

’

archivelogRecordSpecifier

This subclause is used to define the recovery period or archived redo logs to be applied during recovery.

Syntax Diagram

ALL

THREAD

integer

ARCHIVELOG

LIKE

’

string_pattern

’

archlogRange

LIKE

’

string_pattern

’

614
Part V: Appendixes

archlogRange Parameter Syntax Diagram

FROM SCN

SCN BETWEEN

integer AND

integer

UNTIL SCN

ALL

FROM SEQUENCE

INCARNATION

CURRENT

SEQUENCE

THREAD

integer

integer

integer

SEQUENCE BETWEEN

integer AND

UNTIL SEQUENCE

FROM TIME

TIME BETWEEN

’

date_string

’

AND

’

date_string

’

UNTIL TIME

completedTimeSpec

This command is used to define when a backup or copy was completed. It is commonly used with the
list
,
crosscheck
, and
delete
commands.

Syntax Diagram

AFTER

COMPLETED

BEFORE

’

date_string

’

BETWEEN

’

date_string

’

AND

connectStringSpec

This subclause is used to define the username, password, and Oracle Net service name when connecting to a target database, a recovery catalog, or an auxiliary database.

Syntax Diagram

password

’

userid

/

@

net_service_name

’

datafileSpec

This subclause is used to define a datafile by filename or datafile number for various operations, such as datafile recovery.

Syntax Diagram

’

filename

’

integer

Appendix A: RMAN Syntax Reference Guide
615

deviceSpecifier

This subclause defines the type of storage to be used by the given RMAN operation.

Syntax Diagram

DISK

’

’

media_device

fileNameConversionSpec

This specification defines patterns that should be used to generate new datafile names based on old datafile names. See the sections for the
backup
,
convert
, and
duplicate
commands for more details.

Syntax Diagram

,

(

’

’

)

DB_FILE_NAME_CONVERT

string_pattern

forDbUniqueNameOption

This subclause is used to specify if all databases or a specific database is being addressed in a specific RMAN-related Data Guard operation.

Syntax Diagram

DB_UNIQUE_NAME ALL

FOR

’

’

DB_UNIQUE_NAME

db_unique_name

foreignlogRecordSpecifier

This subclause defines a specific set of foreign archived redo logs to be used in the operation.

Syntax Diagram

ALL

THREAD

integer

FOREIGN ARCHIVELOG

LIKE

’

string_pattern

’

archlogRange

LIKE

’

string_pattern

’

,

DBID

integer

616
Part V: Appendixes

formatSpec

This specifier is used to define a specific filename format. This can include normal file names or ASM disk groups.

Syntax Diagram

’

format_string

’

keepOption

This subclause is used to define the retention policy related to a given backup or copy.

Syntax Diagram

FOREVER

RESTORE POINT

restore_point_name

KEEP

UNTIL TIME

’

date_string

’

NOKEEP

listObjList

This subclause is used to indicate specific datafiles and archived redo logs to be affected by the parent command.

Syntax Diagram

archivelogRecordSpecifier

CONTROLFILE

,

’

’

DATABASE SKIP TABLESPACE

tablespace_name

dbObject

foreignlogRecordSpecifier

SPFILE

dbObject Parameter Syntax Diagram

DATABASE

,

DATAFILE

datafileSpec

,

’

’

TABLESPACE

tablespace_name

Appendix A: RMAN Syntax Reference Guide
617

maintQualifier

This subclause is used to define database files or archived redo logs in specific RMAN commands such as
list
,
crosscheck
,
delete
, and
switch
.

Syntax Diagram

completedTimeSpec

,

DEVICE TYPE

deviceSpecifier

LIKE

’

string_pattern

’

BACKED UP

integer

TIMES TO DEVICE TYPE

deviceSpecifier

’

’

TAG

tag_name

maintSpec

This subclause is used to define database files or archived redo logs in specific RMAN commands such as
change
,
crosscheck
, and
delete
.

Syntax Diagram

OF

listObjList

BACKUP

maintQualifier

archivelogRecordSpecifier

OF

listObjList

COPY

foreignlogRecordSpecifier

,

DEVICE TYPE

deviceSpecifier

recordSpec

obsOperandList

This subclause is used to define criteria used to mark backups and datafile copies as OBSOLETE.

Syntax Diagram

RECOVERY WINDOW OF integer

DAYS

REDUNDANCY integer

618
Part V: Appendixes

recordSpec

This subclause defines which objects that commands such as
change
,
crosscheck
,
delete
, and
list
will work on.

Syntax Diagram

,

’

filename

’

ARCHIVELOG

,

primaryKey

,

BACKUPSET

primaryKey

,

’

media_handle

’

,

BACKUPPIECE

primaryKey

PROXY

’

’

TAG

tag_name

,

’

filename

’

,

primaryKey

CONTROLFILECOPY

,

DATAFILECOPY

’

’

NODUPLICATES

TAG

tag_name

ALL

NODUPLICATES

DATAFILECOPY

LIKE