Read Oracle RMAN 11g Backup and Recovery Online
Authors: Robert Freeman
restoring records to control file,
architectures
archivelogRecordSpecifier subclause,
backup challenges of RAC,
restoring with recover
archiving tables, Flashback Data
restoring with restore
archlogRange parameter syntax
as backupset parameter, backup
Oracle and Data Protector
sync and split technology for,
as compressed backupset
Oracle backup and recovery.
archivelog destination to parameter, set
parameter
, 237
See
backup and recovery
ASH (Active Session History),
architecture
ARCHIVELOG mode
V$ACTIVE_SESSION_HISTORY
RMAN.
See
RMAN architecture
view
, 457
case studies in recovery
, 537–
ASM (Automatic Storage Management)
archive log backups in RAC,
archive log deletion policies
configuring RMAN default
creating image copy of archived
FRA
and, 56, 70
database recoveries in, 287–291
restore operations in RAC,
database recovery after restoring
archived redo logs
sharing files across multiple
backup sets, modifying retention
disk-only Oracle-suggested
policy for
, 240
storing block change tracking file
backups from standby database,
testing Oracle installation/
backups in ARCHIVELOG mode,
NOARCHIVELOG mode vs.,
Index
635
B
checking database for errors, 243
atClause parameter syntax diagram, 596
attributes, NetBackup policy
, 161–163
BACKGROUND_DUMP_DEST
auditing tables, Flashback Data
database parameter, alert log
forcing backup of read-only
directory
, 7
autobackup command
backup and recovery architecture
limiting backup impacts,
configure controlfile from, 91
ARCHIVELOG vs.
restore control file from, 273–276
NOARCHIVELOG modes,
limiting size of backup set,
autoBackupOptList parameter syntax
controlling database software,
modifying retention policy for
database physical components,
Automatic Backup Schedule,
high availability
, 5
offline RMAN backups without
automatic checkpoint tuning, 323
logical backup and recovery
, 26
using configured defaults, 235
Automatic Diagnostic Destination
overriding configure exclude
directory
, 461
Automatic Storage Management.
Oracle memory and RMAN,
See
ASM (Automatic Storage
skipping offline, inaccessible or
Management)
auxiliary channel configuration,
using standby database, 498–499
Oracle terminology
, 7–9
validate parameter
, 369
other Oracle components, 31–32
backup command, syntax details,
auxiliary database
physical backup and recovery,
backup control file command, 254
configuring parameter file for
backup control file, defined, 8
duplicating RAC database on
backup current controlfile for standby
duplicating to remote server using
backup database commands
using database and internals,
backing up datafiles based on last
duplicating to same server using
using OEM.
See
OEM (Oracle
datafile backups in RAC,
Enterprise Manager)
RMAN compatibility and, 54, 79
backup and recovery strategy,
auxiliary destination, TSPITR, 357, 359
offline RMAN backups,
auxiliary instance, TSPITR, 357,
backup archivelog all command,
backup ar
chivelog command, 88,
backup datafile command, 250, 450
AVAILABLE status, crosschecking
backup as compressed backupset
backup recovery area command, 66,
AWS (Amazon Web Services)
backup as copy command, 253–254
backup redundancy backup retention
establishing account with, 147
backup backupset command, 252, 481
policy
, 405
Oracle and
Amazon cloud, 145
backup command options, 236–247
backup retention policies, 405–408
archive log deletion policies,
Backup Scheduling W
izard, 330–331
RMAN backup to S3, deploying,
backup selection list, NetBackup,
assigning tags to backups, 238
Simple Storage Service, 138, 145
backing up datafiles based on last backup sets
storing S3 as default SBT
configuring backup in
backing up to specific device
understanding cloud computing,
crosschecking backups, 400–403
capturing elusive control file, 246
636
Oracle RMAN 11
g
: Backup and Recovery
backup sets
(continued)
BACKUP_TAPE_IO_SLAVES parameter,
using RMAN duplication to create
historical subset of target
modifying retention policy,
backupTypeSpec parameter syntax
catalog backupset command, 481
base backup, incremental, 256–257
catalog command
adding RMAN backups to
recovering control file from, 276
binary compression, block-level
recovering SPFILE from specific,
cataloging other backups in
blank errors, media management, 111
recovery catalog views for
, 219
block change tracking file (BCTF),
restoring control file from
recovering deleted backup, 416
block-level backups, RMAN,
registering split mirror copies with
RMAN default settings
block media recovery
, 47
restoring RMAN-related records
block media recovery (BMR), 351–353
Backup Settings page, OEM, 319
blockObject parameter syntax diagram
catalog database, testing RMAN, 630
backup tablespace command,
catalog datafilecopy command, 481
catalog, media manager
, 103–104
backup throttling, and OEM, 321
catalog start with command, 212, 278
backup, using media manager for tape,
BMR (block media recovery), 351–353
broken mirror backups, 518–520
Cell Manager, Data Protector,
backup validate command, 340, 404
backup validate database command,
central agent, Grid Control
C
backupCommands parameter syntax
CF Block Integrity Check, OEM, 336
cancel-based recovery
, 30–31, 349
cfauConf parameter syntax diagram,
backupConf parameter syntax
case studies, RMAN recovery
diagram, configure command, 576
from complete database loss
change backuppiece uncatalog
backupOperand parameter syntax
from complete database loss
change command
backup command.
See
backup
completing failed duplication
recovering older control file
command options
manually
, 547–548
retention policy maintenance
configuring settings in OEM,
from loss of SYSTEM
loss of unarchived online redo
from lost datafile (ARCHIVELOG)
using image copy in FRA,
change vectors, within redo logs, 15
online from loss of datafile or
changeFailure parameter syntax