Read Oracle RMAN 11g Backup and Recovery Online
Authors: Robert Freeman
backing up multinode RAC
view
, 221
RC_OFFLINE_RANGE (V$OFFLINE_
RECOVER status, database
RANGE) view
, 221
coding backup scripts to perform
RC_REDO_LOG (V$LOG,
recover tablespace command, 29, 359
V$LOGFILE) view
, 221
recoverableClause parameter syntax
RC_REDO_THREAD (V$LOG,
V$THREAD) view
, 221
recover
.bsq file, 35
creating virtual private
RC_RESYNC view
, 221
recoverObject parameter syntax
RC_RMAN_CONFIGURATION
(V$RMAN_CONFIGURATION)
recoverOptionList parameter syntax
view
, 221
enabling tracing of RMAN
RC_TABLESPACE (V$TABLESPACE)
recoverSpec parameter syntax
view
, 222
getting started with your database
RC_TEMPFILE (V$TEMPFILE)
recovery
view
, 222
importance of in recovery,
RCVER view
, 227
read consistent images (read
configuring settings in OEM,
READ ONLY
mode, tablespaces, 15
offline RMAN backups
read-only tablespace, recovery
housing files in FRA.
See
FRA
read operations, performance
(flash recovery area)
listing backups eligible for
, 429
problems with read/write
reader class, OSB user rights, 122
maximum length of time allowed
readrate parameter, turning RMAN
for
, 6
querying for stored script
Real Application Clusters.
See
RAC
Oracle Cloud Backup
recovering control file from, 276
(Real Application Clusters)
recovering SPFILE when
record reuse, in control file, 39–40
recovery, advanced RMAN
recovering to previous
ar
chived redo log restores, 350
recover command
cross-platform database
recovering to previous
datafile copy restores, 350–351
datafile copy restores, 350–351
parallel channel operations, 451
incomplete recoveries, 346–349
restoring control file online, 278
recovering to previous
read-only tablespace
recovery
, 350
to restore point clause of, 349
recovering corrupted data blocks,
restoring datafiles with
unregistering database from, 212
recovery to previous incarnation,
utilizing virtual private
tablespace point-in-time recovery.
recover copy of database
See
TSPITR (tablespace point-
views intended for OEM,
in-time recovery)
recover database command
recovery catalog databases, 185, 209
completing repair failure
verifying backups are
Recovery Catalogs link, Recovery
point-of-failure database
recovery area keywords, catalog
Recovery Manager (RMAN).
See
RMAN
troubleshooting recovery in
recovery
, performing in OEM, 334–341
650
Oracle RMAN 11
g
: Backup and Recovery
recovery, performing in OEM
remotely
, running RMAN, 36–37
(continued)
repair failure command, 297, 301, 594
resources
configuring recovery catalogs,
replace script command, 419, 595
report commands, RMAN
distribution of I/O on Oracle
configuring recovery settings,
performing RMAN database
Data Recovery Advisor
, 337–339
high availability solutions, 5
setting scope less than entire
report need backup
Oracle database performance
redundancy
, 439
report need backup redundancy
RMAN performance
Restore
All Datafiles, OEM, 339–340
Recovery Settings page, OEM,
restore and recovery
recovery target, incomplete recoveries,
Data Recovery Advisor
, 297–302
recovery to previous incarnation,
of database in ARCHIVELOG
data dictionary views, 441–442
recovery window backup retention
list commands.
See
list
of database in NOARCHIVELOG
policy
, 92–94, 404–405
commands, RMAN
Recycle Bin, and Flashback Drop,
report commands.
See
report
preparing RMAN for
, 267–268
Redo Integrity Check, OEM, 336
commands, RMAN
redo log files
reportObject parameter syntax
archived.
See
archived redo logs
recovering control file from
changing location of for
repository database, Grid Control, 313
recovering from online redo log
online.
See
online redo logs
recovery catalog, MML layer and,
sequence number
, 18–19
reset database to incarnation
sync and split technology for
, 522
testing RMAN configuration, 630
reset logs operation, recovery based
restore vs. recovery
, 266
restoring control file, 273–274
redundancy-based retention policies,
resetDbUniqueNameOption parameter
syntax diagram, change
tablespace recoveries, 291–292
register database command, 211, 594
using incremental backups, 293
registration
resetlogs command
restore ar
chivelog command, 350–351
database, with recovery
case study, recovery through,
restore clonefile command, 363
restore command
recovery catalog, with OEM,
case study, using Flashback
check logical parameter
, 369–370
Database/media recovery to
check readonly parameter
, 350
split mirror copies with RMAN,
modifying how far back RMAN
incomplete recovery through, 347
looks for control file
unregistering database from
recovering older control file
relationships, processes and database,
recovering to previous
recovering control file from
incarnation before issuing,
release channel command, 594
recovering SPFILE from specific
reliability
, Oracle Cloud Backups, 146
recovering to previous
remote server, RMAN duplication to,
incarnation without recovery
REMOTE_LOGIN_PASSWORDFILE
resetting database incarnation in
restoring datafiles with
parameter
, 82
Index
651
scripts for Windows,
troubleshooting in RMAN,
incrementally updated
restore control file from autobackup
RMAN architecture
restore controlfile command, 354
managing expired backup
restore database command
point-of-failure database
modifying for backup sets,
recovering to previous
database privileges and, 35–36
incarnation with recovery
recovery window backup,
memory
, 47–50
restoring database in
RMAN default settings
network topology of
NOARCHIVELOG mode,
process from start to finish,
tuning backup and recovery
strategy
, 450
restore database validate check logical
RMAN
RMAN utility
, 34–35
adding previous backups to
server-managed recovery
, 34
restore from datafile copy command,
backing up recovery catalog