Read Oracle RMAN 11g Backup and Recovery Online
Authors: Robert Freeman
’
’
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
’
’