Read Oracle RMAN 11g Backup and Recovery Online
Authors: Robert Freeman
586
Part V: Appendixes
sizeSpec Parameter Syntax Diagram
G
K
M
integer
Chapter References
The
duplicate
command is covered in Chapters 19 and 20.
Example
duplicate target database to copydb
db file name convert
('/ora01/oracle/oradata/olddb/','/ora02/oracle/oradata/newdb/')
until time 'sysdate- 5'
skip tablespace oldusers, test
pfile ?/dbs/initcopydb.ora
logfile
group 1 ('/ora01/oraredo/newdb/redo01 1.f',
'/ora02/oraredo/newdb/redo01 2.f') size 200k,
group 2 ('/ora01/oraredo/newdb/redo02 1.f',
'/ora02/oraredo/newdb/redo02 2.f') size 200k,
group 3 ('/ora01/oraredo/newdb/redo03 1.f',
'/ora02/oraredo/newdb/redo03 2.f') size 200k reuse;
execute script Command
The
execute script
command is used to execute a stored RMAN script.
Syntax Diagram
string_or_identifier
USING
GLOBAL
’
’
integer
EXECUTE
SCRIPT
script_name
;
Chapter Reference
The
execute script
command is covered in Chapter 10.
Example
execute script my script;
exit Command
The
exit
command terminates the operation of your RMAN session and returns you to the OS
prompt.
Appendix A: RMAN Syntax Reference Guide
587
Chapter Reference
The
exit
command is covered in Chapter 3.
flashback database Command
The
flashback database
command allows RMAN to manage Oracle Flashback Database operations. This allows you to reset the database to some previous time or SCN.
Syntax Diagram
,
DEVICE TYPE
deviceSpecifier
FLASHBACK
DATABASE
TO BEFORE SCN
integer
THREAD
integer
TO BEFORE SEQUENCE
integer
TO BEFORE RESETLOGS
TO BEFORE TIME
’
date_string
’
;
TO SCN
integer
THREAD
integer
TO SEQUENCE
integer
TO RESTORE POINT
restore_point_name
TO TIME
’
date_string
’
Chapter Reference
Chapter 15 contains a great deal of information on the
flashback
command.
Examples
flashback database to scn 669605;
flashback database to timestamp (sysdate-2);
flashback database to timestamp
to timestamp('2006-01-03 15:00:00', 'yyyy-mm-dd hh24:mi:ss');
flashback database to restore point “gold copy”;
flashback database to before resetlogs;
grant Command
The
grant
command is associated with the RMAN recovery catalog and a feature called a virtual private catalog. This feature provides the ability to restrict access to recovery catalog records by user. The
grant
command provides the means to grant privileges to users to see records in the recovery catalog when a virtual private catalog has been configured.
588
Part V: Appendixes
Syntax Diagram
’
’
database_name
CATALOG FOR DATABASE
TO
integer
GRANT
userid
;
REGISTER DATABASE TO
Chapter Reference
Chapter 9 contains information on the
grant
command and on using a virtual private catalog.
Example
grant catalog for database mydb to operator1;
host Command
The
host
command invokes the OS command-line subshell from within RMAN. The
host
command also allows you to run a specific OS command from the RMAN prompt.
Syntax Diagram
’
command
’
HOST
;
Chapter Reference
Examples of the
host
command can be found in Chapter 16.
Examples
host 'dir';
Host 'ls –al';
host
import catalog Command
The
import catalog
command imports the metadata from one recovery catalog schema into a different catalog schema.
Syntax Diagram
,
DBID
integer
,
’
’
DB_NAME
database_name
NO UNREGISTER
IMPORT CATALOG connectStringSpec
;
Appendix A: RMAN Syntax Reference Guide
589
Chapter Reference
Examples of the
import catalog
command can be found in Chapter 10.
Example
import catalog cat owner@oldcatdb;
list Command
The
list
command provides information on RMAN backups, such as when they occurred, what files they contain, and how long they took.
Syntax Diagram
ALL
DB_UNIQUE_NAME
’
’
database_name
OF DATABASE
maintQualifier
recoverableClause
listObjectSpec
forDbUniqueNameOption
EXPIRED
recordSpec
ALL
CRITICAL
HIGH
LOW
,
failureNumber
,
LIST
;
CLOSED
EXCLUDE FAILURE
failureNumber
DETAIL
FAILURE
’
’
database_name
OF DATABASE
INCARNATION
maintQualifier
recoverableClause
listObjectSpec
recordSpec
forDbUniqueNameOption
RESTORE POINT
restore_point_name
RESTORE POINT ALL
ALL
GLOBAL
SCRIPT NAMES
590
Part V: Appendixes
maintQualifier Parameter Syntax Diagram
completedTimeSpec
,
DEVICE TYPE
deviceSpecifier
LIKE
’
string_pattern
’
BACKED UP
integer
TIMES TO DEVICE TYPE
deviceSpecifier
’
’
TAG
tag_name
listObjectSpec Parameter Syntax Diagram
OF listObjList
listBackupOption
BACKUP
archivelogRecordSpecifier
OF
listObjList
COPY
foreignlogRecordSpecifier
recoverableClause Parameter Syntax Diagram
TO RESTORE POINT
restore_point_name
untilClause
RECOVERABLE
listBackupOption Parameter Syntax Diagram
BY FILE
SUMMARY
Chapter Reference
Chapter 17 contains information on the RMAN
list
command.
Examples
list backup of database;
list backup of database summary;
list backup of datafile;
list backup of archivelog all;
print script Command
The
print script
command allows you to display a stored script.
Appendix A: RMAN Syntax Reference Guide
591
Syntax Diagram
GLOBAL
’
’
TO FILE
’
filename
’
PRINT
SCRIPT
script_name
;
Chapter Reference
Chapter 10 provides more detail on the
print script
command.
Example
print script booga booga;
quit Command
Use the
quit
command to exit the RMAN executable.
Chapter Reference
The
quit
command is covered in Chapter 3.
recover Command
The
recover
command is used after a restore to complete recovery of a database, tablespace, or datafile. The
recover
command will extract needed archived redo logs during the recovery process and apply the undo as required.