Oracle RMAN 11g Backup and Recovery (175 page)

Read Oracle RMAN 11g Backup and Recovery Online

Authors: Robert Freeman

BOOK: Oracle RMAN 11g Backup and Recovery

3.47Mb size Format: txt, pdf, ePub

Read Book Download Book

Syntax Diagram

AUXILIARY

’

ALLOCATE

CHANNEL

channel_id

allocOperandList

DEVICE TYPE deviceSpecifier

;

Chapter References

Several chapters reference the
allocate channel
command. Chapter 3 discusses automatic channel configuration, which eliminates the need for
allocate channel
most of the time. Chapters 11, 12, and 14 in particular provide direction on the use of the
allocate channel
command.

Examples

allocate channel c1 device type disk format '/u01/orabackup/robprod/robprod %U'; allocate channel t1 DEVICE TYPE 'SBT TAPE' PARMS

'ENV (TDPO OPTFILE /opt/oraback/rman/delta ${ORACLE SID}.opt)'

RATE 1 G FORMAT '${ORACLE SID} %U' MAXPIECESIZE 20 G MAXOPENFILES 64;

allocate channel for maintenance Command

The
allocate channel for maintenance
command is used to allocate a channel in preparation for issuing maintenance commands such as
change
,
crosscheck
, or
delete
. If you have automated channels configured, you should not need to use this command.

Syntax Diagram

ALLOCATE CHANNEL FOR MAINTENANCE

allocOperandList

DEVICE TYPE

deviceSpecifier

;

Chapter Reference

We do not cover the
allocate channel for maintenance
command in this book, since we expect you are using automated channel allocation. Automated channel allocation is recommended by Oracle.

Example

allocate channel for maintenance device type sbt;

566
Part V: Appendixes

alter database Command

The
alter database
command allows you to mount or open the target database that RMAN is connected to.

Syntax Diagram

MOUNT

ALTER DATABASE

;

RESETLOGS

OPEN

Chapter References

The
alter database
command is demonstrated in Chapters 11, 12, and 14.

Example

alter database open resetlogs;

backup Command

The
backup
command allows you to back up the database. The
backup
command supports online and offline backups and also supports backups of database files, copies of database files, archived logs, and backup sets.

Syntax Diagram

backupOperand

BACKUP

backupSpec

backupSpecOperand

PLUS ARCHIVELOG

;

Appendix A: RMAN Syntax Reference Guide
567

backupOperand Parameter Syntax Diagram

backupTypeSpec

’

CHANNEL

channel_id

CHECK LOGICAL

COPIES

integer

CUMULATIVE

DEVICE TYPE

deviceSpecifier

DISKRATIO

integer

duration

fileNameConversionSpec

FILESPERSET

integer

FORCE

formatSpec

AUXILIARY FORMAT

NEW

FORMAT

formatSpec

TO DESTINATION

toDestSpec

forRecoveryOfSpec

FULL

LEVEL

INCREMENTAL

integer

FROM SCN

keepOption

MAXSETSIZE

sizeSpec

notBackedUpSpec

NOCHECKSUM

NOEXCLUDE

POOL

integer

ONLY

PROXY

REUSE

SECTION SIZE

sizeSpec

skipSpec

’

TAG

tag_name

VALIDATE

568
Part V: Appendixes

backupSpec Parameter Syntax Diagram

archivelogRecordSpecifier

ALL

completedTimeSpec

’

BACKUPSET

FROM TAG

tag_name

primaryKey

’

filename

’

CONTROLFILECOPY

ALL

’

string_pattern

’

(

copyOfSpec

backupSpecOperand

)

CURRENT CONTROLFILE

DATABASE

datafileCopySpec

DATAFILE

datafileSpec

RECOVERY AREA

DB_RECOVERY_FILE_DEST

RECOVERY FILES

SPFILE

’

TABLESPACE

tablespace_name

Appendix A: RMAN Syntax Reference Guide
569

backupSpecOperand Parameter Syntax Diagram

’

CHANNEL

channel_id

ALL

DELETE

INPUT

DISKRATIO

integer

FILESPERSET

integer

FORCE

formatSpec

AUXILIARY FORMAT

NEW

FORMAT

formatSpec

TO DESTINATION

toDestSpec

’

FROM TAG

tag_name

INCLUDE CURRENT CONTROLFILE

keepOption

MAXSETSIZE

sizeSpec

notBackedUpSpec

NOEXCLUDE

POOL

integer

REUSE

SECTION SIZE

sizeSpec

skipSpec

’

TAG

tag_name

570
Part V: Appendixes

backupTypeSpec Parameter Syntax Diagram

COMPRESSED

BACKUPSET

COPY

copyOfSpec Parameter Syntax Diagram

DATABASE

DATAFILE

datafileSpec

COPY OF

’

TABLESPACE

tablespace_name

datafileCopySpec Parameter Syntax Diagram

’

filename

’

ALL

DATAFILECOPY

’

string_pattern

’

NODUPLICATES

’

FROM TAG

tag_name

duration Parameter Syntax Diagram

LOAD

MINIMIZE

TIME

PARTIAL

DURATION integer

integer

Appendix A: RMAN Syntax Reference Guide
571

forRecoverOfSpec Parameter Syntax Diagram

DATAFILECOPY FORMAT formatSpec

’

WITH TAG

tag_name

COPY

FOR RECOVER OF

’

TAG

tag_name

notBackedUpSpec Parameter Syntax Diagram

integer

TIMES

SINCE TIME

’

date_string

’

NOT BACKED UP

sizeSpec Parameter Syntax Diagram

integer

skipSpec Parameter Syntax Diagram

INACCESSIBLE

SKIP

OFFLINE

READONLY

Chapter Reference

The
backup
command is covered in detail in Chapter 11.

Examples

backup database plus archivelog delete input;

backup tablespace users, system;

backup as copy datafile 1,2,3;

backup incremental level 0 check logical database plus archivelog;

572
Part V: Appendixes

catalog Command

The
catalog
command allows you to do the following:

■ Add metadata about backup pieces and image copies to the database control file and recovery catalog

■ Catalog valid backup sets, datafile copies, and archived redo logs in the flash recovery area (FRA)

■ Catalog valid backups in ASM, OMF, and user-defined disk locations

■ Record a datafile copy as a level 0 backup in the RMAN repository, so you can use that backup as the source of an incremental backup

Syntax Diagram

ARCHIVELOG

BACKUPPIECE

’ filename

’

CONTROLFILECOPY

LEVEL

integer

CATALOG

’

;

TAG

tag_name

DATAFILECOPY

’ filename

’

RECOVERY AREA

NOPROMPT

DB_RECOVERY_FILE_DEST

START WITH

’

string_pattern

’

Chapter Reference

Chapter 16 provides more information on the
catalog
command.

Examples

catalog recovery area noprompt;

catalog datafilecopy 'd:\oracle\oraback\system01.bak'

'd:\oracle\oraback\users01.bak' level 0;

Appendix A: RMAN Syntax Reference Guide
573

change Command

The
change
command is used to mark backup pieces, image copies, and archived redo logs with a status of AVAILABLE if they currently have a status of UNAVAILABLE. Additionally, this command can totally remove a backup or copy from a repository, and can also be used to modify the retention policy that is effective for a given backup or copy.

Syntax Diagram

AVAILABLE

keepOption

forDbUniqueNameOption

DEVICE TYPE

deviceSpecifier

maintSpec

resetDbUniqueNameOption

UNAVAILABLE

UNCATALOG

CHANGE

;