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