Oracle RMAN 11g Backup and Recovery (176 page)

’

’

TO

db_unique_name

RESET DB_UNIQUE_NAME

changeFailure Parameter Syntax Diagram

ALL

CRITICAL

,

HIGH

EXCLUDE FAILURE

failureNumber

CLOSED

NOPROMPT

FAILURE

LOW

HIGH

PRIORITY

,

LOW

failureNumber

Chapter Reference

Chapter 16 contains a discussion on the use of the
change
command.

Example

change backup tag 'Gold Backup' keep forever nologs;

configure Command

The
configure
command allows you to configure persistent RMAN configuration settings. These settings apply to all RMAN sessions, unless they are changed or disabled. These settings are stored in the database control file.

Appendix A: RMAN Syntax Reference Guide
575

Syntax Diagram

’

’

CLEAR

DB_UNIQUE_NAME

db_unique_name

CONNECT IDENTIFIER

quoted_string

delalConf

CLEAR

AUXNAME FOR DATAFILE

datafileSpec

TO

’

filename

’

backupConf

cfauConf

CLEAR

TRUE

COMPRESSION ALGORITHM

OPTIMIZE FOR LOAD

CONFIGURE

FALSE

AS OF RELEASE

quoted_string

quoted_string

deviceConf

CLEAR

ALGORITHM

quoted_string

ENCRYPTION

DATABASE

ON

FOR

’

’

OFF

TABLESPACE

tablespace_name

CLEAR

CLEAR

SNAPSHOT CONTROLFILE NAME

TO

’

filename

’

forDbUniqueNameOption

;

576
Part V: Appendixes

delalConf Parameter Syntax Diagram

CLEAR

ALL

ARCHIVELOG DELETION POLICY

APPLIED ON

STANDBY

BACKED UP

integer

TIMES TO DEVICE TYPE deviceSpecifier

TO

NONE

ALL

SHIPPED TO

STANDBY

backupConf Parameter Syntax Diagram

ARCHIVELOG

CLEAR

BACKUP COPIES FOR DEVICE TYPE

deviceSpecifier

DATAFILE

TO

integer

ON

BACKUP OPTIMIZATION

OFF

CLEAR

’

’

CLEAR

EXCLUDE FOR TABLESPACE

tablespace_name

CLEAR

MAXSETSIZE

sizeSpec

TO

UNLIMITED

CLEAR

RETENTION POLICY

NONE

TO

RECOVERY WINDOW OF

integer

DAYS

REDUNDANCY

integer

cfauConf Parameter Syntax Diagram

ON

OFF

CONTROLFILE AUTOBACKUP

CLEAR

CLEAR

FORMAT FOR DEVICE TYPE

deviceSpecifier

TO

formatSpec

Appendix A: RMAN Syntax Reference Guide
577

deviceConf Parameter Syntax Diagram

AUXILIARY

integer

allocOperandList

CHANNEL

DEVICE TYPE

deviceSpecifier

CLEAR

CLEAR

DEFAULT DEVICE TYPE

TO

deviceSpecifier

CLEAR

COMPRESSED

DEVICE TYPE

deviceSpecifier

BACKUPSET

BACKUP TYPE TO

COPY

PARALLELISM

integer

forDbUniqueNameOption Parameter Syntax Diagram

DB_UNIQUE_NAME ALL

FOR

’

’

DB_UNIQUE_NAME

db_unique_name

Chapter Reference

The
configure
command is covered in Chapter 3 in detail.

Examples

configure retention policy to recovery window of 180 days;

configure backup optimization off;

configure default device type to 'sbt tape';

configure controlfile autobackup on;

configure controlfile autobackup format for

device type 'sbt tape' ''%f'';

configure controlfile autobackup format for device type disk to

'/oradata/oraback/rman/robone/%f';

configure device type 'sbt tape' parallelism 4;

configure device type disk parallelism 2;

configure datafile backup copies for device type 'sbt tape' to 1;

configure datafile backup copies for device type disk to 1;

configure archivelog backup copies for device type 'sbt tape' to 1;

configure archivelog backup copies for device type disk to 1;

configure channel device type 'sbt tape' parms

'env (tdpo optfile /opt/oracle/rman/tdpo a273.opt)'

rate 9 g format 'a273 %u' maxpiecesize 20 g maxopenfiles 64;

configure channel device type disk format

'/oradata/orabck01/rman/a273/ora a273 df%t s%s s';

configure auxiliary channel device type 'sbt tape' parms

'env (tdpo optfile /opt/oracle/rman/tdpo a273 dup.opt)'

578
Part V: Appendixes

rate 99 g format 'a273 %u' maxpiecesize 20 g maxopenfiles 64;

configure maxsetsize to 20 g;

configure snapshot controlfile name to

'/oradata/orabck01/rman/a273/snapcf a273.f';

configure channel 1 device type sbt

connect 'sys/robert@test1' parms 'env (nsr server bktest1)';

connect Command

The
connect
command is used to connect to the target database, the recovery catalog, or the auxiliary instance from the RMAN prompt.

Syntax Diagram

CONNECT AUXILIARY

connectStringSpec

CONNECT CATALOG

;

connectStringSpec

CONNECT TARGET

Chapter References

Examples of the
connect
command can be found in many of the chapters in this book.

Examples

connect target sys/Robert@maindb

connect catalog rman/rman@rmancat

convert Command

The
convert
command is used when moving tablespaces and databases across platforms. If the source and destination platforms are of a different byte-ordering format (endian), then the
convert
command must be used to make the datafiles compatible with the new platform.

The
convert
command can also be used to move datafiles in and out of ASM storage.

Syntax Diagram

transportOptionList

DATABASE

convertOptionList

,

convertOptionList

convertOptionList

CONVERT

DATAFILE

’

filename

’

;

,

’

’

TABLESPACE

tablespace_name

convertOptionList

Appendix A: RMAN Syntax Reference Guide
579

transportOptionList Parameter Syntax Diagram

’

’

NEW DATABASE

database_name

’

’

CONVERT SCRIPT

script_name

ON DESTINATION PLATFORM

skipSpec

SKIP UNNECESSARY DATAFILES

’

’

TRANSPORT SCRIPT

script_name

skipSpec Parameter Syntax Diagram

INACCESSIBLE

SKIP

OFFLINE

READONLY

convertOptionList Parameter Syntax Diagram

fileNameConversionSpec

FORMAT

formatSpec

FROM PLATFORM

’

platform

’

PARALLELISM

integer

TO PLATFORM

’

platform

’

Chapter Reference

The
convert
command is covered in Chapter 14 in more detail.

Examples

-- Copy regular datafiles into ASM storage

convert datafile '/disk1/oracle/dbs/my tbs f1.df',

'/disk1/oracle/dbs/t ax1.f'

format '+asmfile';

-- Copy a tablespace from ASM storage to disk.

convert tablespace tbs 2 format '/tmp/tbs 2 %U.df';

-- Convert a database, moving it to a new platform

convert database new database 'convdb'

transport script '/ora01/scripts/transport/transportscript'

to platform 'Microsoft Windows IA (32-bit)'

db file name convert '/ora01/oracle/dbs' '/newora/converted';

580
Part V: Appendixes

create catalog Command

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

Syntax Diagram

VIRTUAL

;

CREATE

CATALOG

Chapter Reference

The
create catalog
command is covered in Chapter 10.

Example

create catalog tablespace rec cat;

create script Command

The
create script
command allows you to create a stored command script within RMAN. You must have a recovery catalog to use this command.

Syntax Diagram

GLOBAL

’

’