Read Oracle RMAN 11g Backup and Recovery Online
Authors: Robert Freeman
failover features
dsm.opt file, TDPO for Oracle, 197
EBS (Elastic Block Store), A
WS, 145
dsm.sys file, TDPO for Oracle,
EC2 (Elastic Compute Cloud), AWS,
RMAN, RAC and Net
elasticity, of Oracle Cloud
fast database backup compression, 116
duplicate command, RMAN
FAST_START_MTTR_TARGET, instance
EM (Enterprise Manager)
recovery
, 322–323
creating clones in OEM vs., 343
Fault Diagnosability Infrastructure,
creating single-node standby
database from RAC
running RMAN backup of Data
file location considerations
Protector-integrated
restore operations in RAC, 507
creating standby database,
RMAN duplication to remote
emca command-line tool, 315–318
server
, 476
creating standby database using
EMCA (Enterprise Manager
RMAN duplication to same
Configuration Assistant), 316–318
server
, 475
duplicating RAC database on
file restore command, duplication, 476
encryption
file system
duplication ar
chitecture, 469
configuring RMAN default
case study, recovery from
duplication to remote server using
complete database loss
Oracle Enterprise Manager
, 321
642
Oracle RMAN 11
g
: Backup and Recovery
file system
(continued)
Flashback Transaction
exploring Flashback Versions
recovery from complete database
using Oracle Secure Backup,
Query
, 383–384
recovery from complete database
loss (NOARCHIVELOG),
fileNameConversionSpec
Flashback Versions Query
, 380–384
flashback window
, 379
restore operations in RAC,
fileperset parameter
, 449, 452–453
for standby clause, current controlfile
flash recovery area.
See
FRA (flash
parameter of backup command, 251
retention policy maintenance for,
recovery area)
force parameter
, 545
Flash Recovery, OEM Recovery
forDbUniqueNameOption parameter
syntax diagram
Flashback Data Ar
chive, 397–398
Flashback Database
from backup clause, restore command,
benefits of Oracle sync and split,
forDBUniqueNameOption
full database recoveries, 287–291
case study, opening database with
foreignlogRecordSpecifier
G
forever option, keep parameter of
General tab, RMAN Script job, 332
implementing flashback logs,
getting started, RMAN backups,
format command, offline RMAN
format string specification, 88–90
point-in-time recovery in
forRecoverOfSpec parameter syntax
Grid Control, OEM
for standby database
cloning database with, 343–344
FRA (flash recovery area)
tuning and tweaking,
archive log backups in RAC with
Oracle testing process with, 629
flashback database command,
avoiding ar
chival backups, 240
case study, recovery from lost
H
Flashback Query
datafile using image copy in,
implementing Flashback Versions
HA
(high availability) solutions, 5
Query
, 380–384
case study, running production
hardware
configuring RMAN backup on
configuring in OEM Recovery
Data Protector
, 181–182
time required to replace
flashback retention target, Flashback
tuning backup and recovery,
Flashback T
able, 379–380, 384–387
disk-only Oracle-suggested
Flashback Technology
health checkers, OEM.
See
Flashback Data Archive (Oracle
checkers, OEM
home clusters, and test
manually removing files from, 69
Flashback Query
, 378–384
Flashback T
able, 384–387
Flashback Transaction,
host security, running RMAN
putting database in ARCHIVELOG
locally
, 38
surviving user errors with, 378
host_sid name, Database Control, 314
Index
643
hot backup mode.
See
online (hot)
disk-only Oracle-suggested
L
backups
HP Data Protector.
See
Data Protector
incrementally updated backups,
large pool
hybrid Oracle-suggested backup,
tuning backup and recovery
I
recover command determining
image for
, 281
LARGE_POOL_SIZE parameter
, 50
LGWR (log writer) process
using for sync and split, 236–237,
IDB (Internal Database), Data
Protector
, 176
using in restore and recovery
, 293
writing to online redo logs, 15,
image copies
incremental parameter, backup
case study, recovery from lost
libobk files, 157–159, 178–179
incrementally updated backups,
library
, NetBackup, 170
case study, recovery from running
licensing
production datafile out of FRA,
init.ora file
creating single-node standby
links
crosschecking backups, 400–403
configuring TDPO for
duplicating RAC database on
images, managing expired backup,
Oracle to NetBackup media
duplication ar
chitecture, 468
manager
, 157–159
import catalog command, 214, 588
duplication to remote server using list backup command, RMAN
inaccessible parameter, backup
duplication to same server using
recovery catalog view
, 218–219
inactive online redo log group, 18,
using RMAN to create standby
using change command with, 414
include current controlfile option,
viewing backup IDs for removal,
input memory buffers, 47–48, 108
including backups parameter, drop
instance
list archive all command,
incomplete duplication, DBNEWID
utility
, 488–489
recovery
, 23, 322–323
list backup by file
incomplete recoveries
startup (startup nomount),
cancel-based recovery
, 349
list backup of controlfile
establishing point for
, 347–348
Internal Database (IDB), Data
list backup of datafile command,
Protector
, 176
ISC (Integrated Solutions Console),
list backup of spfile command,
list backup of tablespace
J
inconsistent state vs. consistent
list backup of tablespace users
restore and recovery and,
list backup summary
, 425
K
keep forever option, change
list copy of archive all command,
block change tracking file,
keep parameter, backup command,
list copy of controlfile command,
differential vs. cumulative,
list copy of database
644
Oracle RMAN 11
g
: Backup and Recovery
list commands, RMAN
(continued)
log sequence-based recovery
, 349
cross-checking RMAN backups,
list copy of datafile
recovery from complete database
list copy of tablespace
loss (ARCHIVELOG) with