Read Oracle RMAN 11g Backup and Recovery Online
Authors: Robert Freeman
duplicating RAC database on
database cloning from, 343–344
online redo logs
ARCHIVELOG mode physical
noncir
cular reuse records, 40
nonredo parameter, recover
case study, recovery from loss of
Oracle database/file system
unar
chived, 544–545
noprompt parameter
checks occurring during
change command,
performing Flashback Table,
as database physical component,
performing Flashback Versions
not backed up option, backup
Query
, 380–384
performing recovery
, 334–341
notBackedUpSpec parameter syntax
recovery catalog views, 222–223
using Cloud Module for OSB
recovering from loss of,
NULL
data block compression, 45,
utilizing Flashback Transaction
ONLINE status, database datafiles, 14
O
offline (cold) backups
operating systems
consistent vs. inconsistent state
OAS (Oracle Application Server), and
troubleshooting TSM backups,
objects
performing with Data
operator class, OSB user rights, 122
creating recovery catalog schema,
Protector
, 175
optimization, backup
testing RMAN configuration, 630
Index
647
forcing backup of read-only
installing and configuring Grid
limitations of conventional
using OSB Cloud Module,
running RMAN locally from target
understanding cloud computing,
ORA-19511 errors, media
testing Oracle installation/
OSB (Oracle Secure Backup)
ORA-27206 errors, media
output buffers, tape backups, 108
Oracle
orapwd utility
, 81–82
architecture.
See
backup and
OSB (Oracle Secure Backup)
overriding, configure exclude
recovery architecture
database physical components,
command-line interface
P
establishing account with, 147
support for recovery
, 533
packages
sync and split.
See
sync and split
technology
downloading and installing,
testing installation/configuration,
parameter files, online backups,
fast database backup
Oracle 10g RMAN Backup &
Parameters tab, RMAN Script job, 333
Recovery
, 493
password file
Oracle 9i RMAN Backup &
building for RMAN duplication,
Recovery
, 626
installing and configuring,
Oracle
Advanced Compression, 46
configuring database for
, 81–82
Oracle Application Server (OAS), and
configuring TDPO for Oracle,
media management solution, 102
oracle class, OSB user rights, 122
NDMP
hosts, 121
operating system accounts,
creating single-node standby
Oracle Cluster File System
Oracle database/file system
creating standby database with
Oracle Database 10g High Availability
with RAC, Flashback, & Data Guard
duplicating RAC database on
Oracle Database Configuration
running RMAN locally from target
Oracle Enterprise Manager.
See
OEM
(Oracle Enterprise Manager)
OSB (Oracle Secure Backup) Cloud
password mode encryption, 95, 120
Oracle Enterprise Manager Grid
Module
performance gains, block-level
Control 10g Handbook (Oracle
installing and using for OSB
performance tuning, RMAN, 445–462
Oracle Inventory
, backing up, 30
OSB (Oracle Secure Backup) Cloud
Oracle Management Service (OMS),
Module, backups to Amazon Web
database-RMAN related issues,
Oracle Secure Backup.
See
OSB
(Oracle Secure Backup)
MML layer
, 454
Oracle T
otal Recall, 397–398
tracing RMAN sessions,
ORACLE_HOME
Amazon S3 backup over Internet
Database Control
or from
Amazon EC2, 145–146
deploying RMAN backups to
performance tuning, RMAN views
duplication to same server, with
V$ACTIVE_SESSION_HISTORY
view
, 457
648
Oracle RMAN 11
g
: Backup and Recovery
performance tuning, RMAN views
point-of-failure database recoveries,
creating single-node standby
(continued)
V$BACKUP_ASYNC_IO view,
policies
duplicating RAC database to
V$BACKUP_SYNC_IO view,
policies, NetBackup
V$RMAN_BACKUP_JOB_DETAILS
defining NetBackup schedules,
restore and recovery challenges,
view
, 456
V$SESSION view
, 456
managing expired backup
storing block change tracking file
V$SESSION_LONGOPS
in ASM for
, 256
view
, 456
NetBackup configuration,
unique backup challenges,
PGA (Private Global Area)
portability
, tape backups, 103
rate parameter
RMAN memory utilization,
A Practical Guide to Performance
T
uning & Diagnostics (Shee), 446
physical backup and recovery
raw partitions, archive log backups in
ARCHIVELOG mode full
primary database, 494, 498–500
recovery
, 29
primary key
, backup set, 404–405
ARCHIVELOG mode physical
print script command, 420, 590–591
RC_ARCHIVED_LOG (V$ARCHIVED_
Private Global Area.
See
PGA (Private
LOG) view
, 217
ARCHIVELOG mode
Global Area)
RC_BACKUP_CONTROLFILE
privileges, RMAN and database, 35–36
(V$BACKUP_DATAFILE) view
, 218
ARCHIVELOG point-in-time
RC_BACKUP_CORRUPTION
processes
(V$BACKUP_CORRUPTION)
ARCHIVELOG tablespace and
changing data in database, 24–25
view
, 218
datafile recovery
, 29–30
database relationships and, 23–24
RC_BACKUP_DATAFILE (V$BACKUP_
flashback functionality
, 31
DATAFILE) view
, 218
NOARCHIVELOG mode physical
RC_BACKUP_FILES (V$BACKUP_
FILES) view
, 218–219
NOARCHIVELOG mode
RC_BACKUP_PIECE (V$BACKUP_
RMAN server
, 42
PIECE) view
, 219
user and server
, 12
RC_BACKUP_REDOLOG
physical components, Oracle
processor speed, test environment
(V$BACKUP_REDOLOG) view
, 219
RC_BACKUP_SET (V$BACKUP_SET)
physical corruption, checking
progress logs, NetBackup, 169–170
view
, 219
only
, 404
RC_BACKUP_SPFILE (V$BACKUP_
physical standby database, 492, 498
pur
ge command, Recycle Bin, 390
SPFILE) view
, 219
PITR (point-in-time recovery)
RC_CONTROLFILE_COPY
Q
(V$DATAFILE_COPY) view
, 219
for auxiliary databases and
RC_COPY_CORRUPTION (V$COPY_
CORRUPTION) view
, 219
benefits of split mirror
RC_DATABASE (V$DATABASE)
R
view
, 220
RC_DATABASE_BLOCK_
tablespace.
See
TSPITR
RAC (Real Application Clusters),
CORRUPTION (V$DATABASE_
(tablespace point-in-time
BLOC_CORRUPTION) view
, 220
recovery)
RC_DATAFILE (V$DATAFILE)
backing up multinode RAC
view
, 220
using restore points to define, 349
RC_DATAFILE_COPY (V$DATAFILE_
plan, backup and recovery
, 7
checks occurring during
COPY) view
, 220
Index
649
RC_LOGFILE (V$LOG_HISTORY)
recover database noredo command,