Oracle RMAN 11g Backup and Recovery (177 page)

COMMENT ’ comment

’

CREATE

SCRIPT

script_name

backupCommands

maintenanceCommands

{

}

miscellaneousCommands

restoreCommands

;

FROM FILE

’

filename

’

Chapter Reference

The
create script
command is referenced in Chapter 10.

Example

create script backup db {backup database plus archivelog delete input;}

crosscheck Command

The
crosscheck
command is used to verify that existing backup sets and backup set pieces listed in the control file or recovery catalog exist on the backup media. Any physical backup file (backup set piece, copy, and so forth) that is not found on backup media is marked as EXPIRED

and will not be considered by RMAN for recovery operations. If the backup file later appears, then it will be marked AVAILABLE during a subsequent
crosscheck
operation.

Appendix A: RMAN Syntax Reference Guide
581

Syntax Diagram

CROSSCHECK

maintSpec

;

maintSpec Parameter Syntax Diagram

OF

listObjList

BACKUP

maintQualifier

archivelogRecordSpecifier

OF

listObjList

COPY

foreignlogRecordSpecifier

,

DEVICE TYPE

deviceSpecifier

recordSpec

Chapter Reference

The
crosscheck
command is covered in Chapter 16.

Examples

crosscheck backup;

crosscheck backup completed between 'sysdate' and 'sysdate-30';

crosscheck archivelog all;

crosscheck archivelog time between 'sysdate' and 'sysdate-30';

delete Command

The
delete
command allows you to mark backups and copies in the recovery catalog or control file with a status of DELETED. Once backups or copies are marked DELETED, the status cannot be changed. Objects that are marked as EXPIRED (via the
crosscheck
command) or OBSOLETE (via predefined retention criteria) can be marked DELETED with the
delete
command.

Syntax Diagram

EXPIRED

forDbUniqueNameOption

FORCE

maintSpec

NOPROMPT

,

DELETE

;

obsOperandList

DEVICE TYPE

deviceSpecifier

OBSOLETE

582
Part V: Appendixes

maintSpec Parameter Syntax Diagram

OF

listObjList

BACKUP

maintQualifier

archivelogRecordSpecifier

OF

listObjList

COPY

foreignlogRecordSpecifier

,

DEVICE TYPE

deviceSpecifier

recordSpec

forDBUniqueNameOption Parameter Syntax Diagram

DB_UNIQUE_NAME ALL

FOR

’

’

DB_UNIQUE_NAME

db_unique_name

Chapter Reference

The
delete
command is covered in Chapter 16.

Examples

delete expired backup;

delete expired archivelog;

delete script Command

The
delete script
command allows you to delete any existing RMAN script stored in the recovery catalog.

Syntax Diagram

GLOBAL

’

’

DELETE

SCRIPT

script_name

;

Chapter Reference

The
delete script
command is covered in Chapter 10.

Example

delete script backup;

drop catalog Command

The
drop catalog
command is used to drop the recovery catalog schema.

Appendix A: RMAN Syntax Reference Guide
583

Syntax Diagram

;

DROP CATALOG

Chapter Reference

The
drop catalog
command is covered in Chapter 10.

Example

drop catalog;

drop database Command

The
drop database
command is used to remove the target database. If connected to a recovery catalog, the database will also be unregistered. When dropped, RMAN will remove all datafiles, online logs, and control files belonging to the target database.

Syntax Diagram

INCLUDING BACKUPS

NOPROMPT

DROP DATABASE

;

Chapter Reference

The
drop database
command is discussed in Chapter 16.

Example

drop database;

duplicate Command

The
duplicate
command is used to create either a duplicate database (with a new DBID) or a standby database (with the same DBID) using RMAN backups of a given target database.

Syntax Diagram

’

’

DBID integer

INCARNATION primaryKey

database_name

DATABASE

TARGET DATABASE

DUPLICATE

FOR STANDBY

dupOptionList

;

’

’

TO

database_name

584
Part V: Appendixes

dupOptionList Parameter Syntax Diagram

’

’

BACKUP LOCATION

backup_location

,

DEVICE TYPE

deviceSpecifier

DORECOVER

fileNameConversionSpec

FROM ACTIVE DATABASE

,

INSTANCE

’

name

’

LOGFILE

logSpec

NOFILENAMECHECK

NOREDO

NORESUME

OPEN RESTRICTED

PASSWORD FILE

’

’

PFILE

filename

SKIP READONLY

,

’

’

SKIP TABLESPACE

tablespace_name

setParameter

,

(

’

’

)

setParameter

PARAMETER_VALUE_CONVERT

string_pattern

SPFILE

,

TABLESPACE

’

’

tablespace_name

UNDO TABLESPACE

TO RESTORE POINT

restore_point_name

untilClause

SetParameter Parameter Syntax Diagram

,

identifier

COMMENT quoted_string

SET

string

quoted_string

identifier

RESET

quoted_string

Appendix A: RMAN Syntax Reference Guide
585

logSpec Parameter Syntax Diagram

REUSE

’

filename

’

SIZE

sizeSpec

,

REUSE

GROUP

integer

(

’

filename ’

)

SIZE

sizeSpec

dupOptionList Parameter Syntax Diagram

’

’

BACKUP LOCATION

backup_location

,

DEVICE TYPE

deviceSpecifier

DORECOVER

fileNameConversionSpec

FROM ACTIVE DATABASE

,

INSTANCE

’

name

’

LOGFILE

logSpec

NOFILENAMECHECK

NOREDO

NORESUME

OPEN RESTRICTED

PASSWORD FILE

’

’

PFILE

filename

SKIP READONLY

,

’

’

SKIP TABLESPACE

tablespace_name

setParameter

,

(

’

’

)

setParameter

PARAMETER_VALUE_CONVERT

string_pattern

SPFILE

,

TABLESPACE

’

’

tablespace_name

UNDO TABLESPACE

TO RESTORE POINT

restore_point_name

untilClause