November 2001
Intermediate to advanced
126 pages
3h
English
Content preview from Oracle RMAN Pocket Reference
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Common Keywords
Many keywords are used in many different commands throughout this syntax section. To save space, we list these common keywords first.
- allocOperand
See allocOperand later in Section 1.9.3.
- DBID
A unique number that identifies a database.
- BACKUPSET
Specifies the backup set to be used for an operation.
- CHANNEL
channel_id Specifies a communication channel that RMAN uses to communicate with an I/O device.
- CHECK LOGICAL
Tests blocks for logical corruption, which is then logged in the alert log and trace files. Additionally, the ranges of corrupt blocks can be queried in V$BACKUP_CORRUPTION. Ranges of corrupt blocks can be recovered with the Oracle9i BLOCK RECOVER command.
- DATAFILE
Specifies a datafile by name or by number.
- DATAFILECOPY
Indicates that image copies of datafiles should be used.
- DEVICE TYPE
deviceSpecifier Indicates the type of device that should be used for an operation.
- FORMAT
'format_string' Specifies the name and location for backup pieces. Various masks, described in Table 1-1, can be used as part of the format string.
- LEVEL
integer Indicates the backup level to perform.
- TABLESPACE
tablespace_name Specifies a tablespace name.
- TAG
tag_name Specifies an arbitrary tag name for backups, file copies, archived logs, and control file copies.
- UNTIL
untilClause Used by various RMAN commands to specify an upper limit for time, System Change Number (SCN), or log sequence numbers.
Table 1-1. Format string masks
|
Mask |
Description |
|
%c |
Copy number of the backup piece |
|
%d |
Database name ... |
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.