Read Oracle RMAN 11g Backup and Recovery Online
Authors: Robert Freeman
current online redo log group, 17, 294,
configuring RMAN backup on,
Database Configuration Assistant
Database Control, OEM
D
integration of Oracle and,
daemons, Oracle Secure Backup, 119
media management
configuring backup settings,
data
synchronization and Oracle
Oracle Integration agent,
installing and configuring,
preserving lost tablespace, 358
restoring objects using GUI and
data block backups
RMAN backup methods,
checking for physical corruption
database control, vs. grid control, 311
database IDs.
See
DBIDs (database IDs)
Database Utilities suite, 34–35
NULL data block compression,
Data Recovery Advisor.
See
DRA (Data
database writer processes (DBWn), 12
Recovery Advisor)
DATABASE_INCARNATION
only on changed database blocks. database
(V$DATABASE_INCARNATION)
See
incremental backups
view
, 220
datafile parameter, backup
potential problems with
clones.
See
cloned database;
duplication, RMAN
datafileCopySpec parameter syntax
configuring recovery catalog, 209
RMAN process from start to
control file.
See
control file
datafiles
ARCHIVELOG recovery
, 29–30
RMAN vs. other backup
datafiles.
See
datafiles
backups based on last backup
Data Block Integrity Check, OEM, 336
incremental backups of, 258–259
backups from standby
data dictionary views, 302, 441–442
creating standby database,
performance tuning of, 448–450
case study, online recovery from
creating standby database using
processes relationships, 23–24
case study, recovery in
datafile backups from standby
recovery catalog views for
, 220
ARCHIVELOG using FRA from
restoring using Data Protector
duplicate...for standby command,
case study, running production
640
Oracle RMAN 11
g
: Backup and Recovery
datafiles
(continued)
DBIDs (database IDs)
DB_UNIQUE_NAME initialization
automated backups of SPFILE and
parameter
, 499
DBWn (database writer processes), 12
in database open process, 22–23
generating with DBNEWID
DBWR_IO_SLAVES parameter,
duplicate for standby command,
utility
, 473
recording for recovery
forcing backup of read-only
, 244
incremental backups of, 258–259
recovering control file from
DEFAUL
T compression type, 237
listing backups by
, 426
delalConf parameter syntax diagram,
listing backups of specific,
recovering SPFILE from
delete ar
chivelog command, 97
recovering SPFILE from specific
delete command
recovery from complete database
purging recovery catalog
recovery catalog views for
, 218,
RMAN duplication and, 466–467,
recovery from previously
target-less duplication in 11g
delete input option, backup archivelog
recovery of read-only
, 350
unregistering database from
delete input option, backup set
restoring from datafile copy,
DBMS_BACKUP_RESTORE package,
delete obsolete command
ar
chive log deletion policies, 97
restoring to different location,
dbms_backup_restore procedure, 278
default retention policies, 94
DBMS_RCVCA
T package, 50–51
removing obsolete archived redo
restoring using Data Protector
DBMS_RCVMAN package, 43, 50–51
DB_NAME parameter, standby
retention policy
restoring using incremental
DBNEWID utility
delete parameter, change command,
completing failed duplication
manually
, 547
delete script command, 419, 421, 582
RMAN process from start to
DELETE status, cross-checking RMAN
incomplete duplication and,
skipping offline, inaccessible or
deleting database backups, TSM or
read-only
, 243–244
dbObject parameter syntax diagram
sync and split technology for,
destination directories, configuring
database in
ARCHIVELOG, 62–64
db_recovery_file_dest keywords,
device agent, media management
DB Structure Integrity Check,
server
, 104
DB_RECOVERY_FILE_DEST
device configuration
parameter, FRA
DBA_DATA_FILE view
, 363
configuring Flashback Database,
DBA_HIST_LOG view
, 65
DBA_OUTSTANDING_ALERTS view,
location defined by
, 64
device type parameter, backup
setting initialization
DBA_RECYCLEBIN view
, 390
deviceConf parameter syntax diagram,
DB_BLOCK_SIZE parameter
, 8
DB_RECOVERY_FILE_DEST_SIZE
deviceSpecifier subclause, 615
DBCA (Database Configuration
parameter, FRA
DIAGNOSTIC_DEST parameter
, 74,
DB_CREATE_ONLINE_LOG_DEST_n
configuring Flashback Database,
Dictionary Integrity Check, OEM, 337
parameter
, 20
DB_FILE_NAME_CONVERT parameter,
setting initialization parameters, 56
directories, OSB, 119–120, 123–124
disaster recovery
, 263
Index
641
disk backups
duplication to same server using
Oracle Secure Backup, 115–1
16,
configuring backup sets in OEM,
file location considerations, 475
Oracle Secure Backup, using
Cloud Module for
, 138
duplication to remote server
testing RMAN configuration, 630
duplicate for standby command, 494
duplication to same server using,
duplication, RMAN
Enterprise Editions, RMAN included
building password file, 479–481
Enterprise Manager.
See
EM (Enterprise
problems with write
case study, creating historical
Manager)
subset of target database,
environment, tuning backup and
recovery
, 449
disk devices, memory buffers for
, 449
case study, manually completing
errors
disk groups,
ASM, 70
incomplete, using DBNEWID
RMAN setup and
disk-only Oracle-suggested
utility
, 488–489
location considerations,
surviving user.
See
Flashback
disk space, test environment and, 628
Technology
troubleshooting TSM backups,
DML (Data Manipulation Language),
of RAC database on single-node
events, tracing RMAN sessions, 460–461
double at sign (@@) command, 564
executable file, RMAN utility
, 35, 53
DRA (Data Recovery Advisor)
reasons for
, 466–467
to remote server
, 484–487
execute script command, 420–421
to same server
, 481–484
performing recovery
, 337–339
target-less in 1
1g, 487
expired backup images, managing,
using Perform Recovery
dupOptionList parameter syntax
expired backups, listing, 430–431, 433
diagram, duplicate command,
EXPIRED status, backups
drop catalog command, 211–212,
duration parameter, backup command,
recovering older control files, 275
drop database command, 421, 583
F
dropped tablespaces, TSPITR unable to
E
recover
, 366