Read Oracle RMAN 11g Backup and Recovery Online
Authors: Robert Freeman
skip parameter
, backup command, 243
operational database online,
skip readonly parameter, backup
restoring database in
skipSpec parameter syntax diagram
startup nomount command, 10–12, 22
SQL
applying to logical standby
startup restrict command, 10, 23
SMON (system monitor) process, 12
creating standby control file, 493
status codes
SMR (server
-managed recovery), 34
enabling tracing of RMAN
assigning to database datafiles, 14
snapshot control file
crosschecking backups, 400–403
654
Oracle RMAN 11
g
: Backup and Recovery
status codes
(continued)
SYS.DBMS_BACKUP_RESTORE
tablespace parameter, backup
modifying archived redo log
package
tablespace point-in-time recovery.
of online redo log groups, 17–18
See
TSPITR (tablespace point-in-time
recovery)
tags
subclause syntax.
See
RMAN
SYS.DBMS_RCVMAN package
subclause syntax details
incrementally updated backups
substitution variables, set newname
tape backups
System Change Number.
See
SCN
support matrix, Oracle and Data
(System Change Number)
in disk backup world,
System Global Area.
See
SGA (System
switch clone tempfile all
Global Area)
duplication to different server
system monitor (SMON) process, 12
switch command, 283–284, 607–608
system Oracle-related files, backing
duplication to same server
switchFile parameter syntax
system oratab file, backing up, 30
impact of multiplexing on, 453
sync and split technology
SYSTEM tablespace, recovery from loss
as broken mirror backups,
T
problems with write
sync and split technology, with Oracle
tables, Flashback T
able, 384–387
remote server duplication
database
tablespace.
See also
TSPITR
(tablespace point-in-time recovery)
same server duplication
ARCHIVELOG recovery
, 29
case study, online recovery from
getting from Oracle software, 527
case study, recovery from loss of
tape channels, RMAN
configuring exclusion policy,
testing with Oracle default SBT
using standby database,
Flashback Database and
configuring recovery catalog
incremental apply
, 527–528
tape I/O slaves, RMAN, 43, 49–50
using VSS for W
indows, 529
creating recovery catalog user
tape management system, retention
synchronization
policy
, 95
cross-platform transportable,
tape-only Oracle-suggested backup,
RMAN metadata and Data
Protector
, 187
target database
synchronous backup I/O, 457–458
case study, using RMAN
syntax.
See
RMAN syntax
incremental backups of, 258–259
duplication to create historical
reference guide
listing backups by name of, 430
SYS packages, used by RMAN, 43–44
connecting to for RMAN
sysdba privileges, RMAN
always connecting to database
creating RMAN backup account,
auxiliary database requiring, 52
making changes on OEM
recovery catalog views for
, 222
Recovery Settings page
restoring using Data Protector
managing restore points in
specifically excluding during
RMAN compatibility and, 53, 79
RMAN process, connecting to, 54
tuning backup and recovery
, 450
Index
655
running crosscheck command
time-based recovery
, 348
TSPITR (tablespace point-in-time
Tivoli Data Protection for Oracle.
See
recovery)
running RMAN locally from,
TDPO (Tivoli Data Protection for
Oracle)
running RMAN remotely to,
Tivoli Storage Manager.
See
TSM
(Tivoli Storage Manager)
manually
, 360–366
target-less duplication in 11g
tnsnames.ora file
media recovery for user error
creating for remote RMAN
using RMAN to create standby
creating single-node standby
where backups come from,
TS_PITR_CHECK view
, 357–358
duplicating RAC database on
TS_PITR_OBJECTS_TO_BE_DROPPED
view
, 358
target-less duplication, in 1
1g, 486
duplication to remote server using
TCP/IP, installing and configuring
U
preparing network for RMAN
TDPO (Tivoli Data Protection for
Undo Segment Integrity Check,
Oracle)
running RMAN locally from target
backing up database objects to
undo segments
UR=A parameter
, 498
configuring for Oracle, 194–198
using RMAN to create standby
Flashback T
able, 384
generating and storing undo in,
deleting database backups, 204
to restore point clause, recover/restore
performing RMAN backup using,
UNIX, RMAN scripts for
, 622–623
unregister database command, 212,
troubleshooting TSM backups,
Transaction Integrity Check,
Unregister Database link, Recovery
tdpoconf utility
, 197
transparent mode encryption, 95
transport tablespace command,
until clause
tempfiles, recovery catalog views
recover copy of database
for
, 222
transportOptionList parameter syntax
templates
Transp_tbs_optlist parameter syntax
until sequence parameter
, 545,
adding to backup selection list,
diagram, transport tablespace
until time parameter, backup
configuring RMAN backup on
troubleshooting
Data Protector
, 179–180
untilClause subclause, RMAN, 619
terminology
, Oracle, 7–9
RMAN recovery
, 334–336
unused block compression, block-level
test environment setup, 625–631
TSM (Tivoli Storage Manager),
unused online redo log group, 18
matching your production
Administration Center and Web
upgrade catalog command,
Oracle configuration,
UR=A parameter, tnsnames.ora
configuring TDPO for Oracle,
USE_DB_RECOVERY_FILE_DEST
deleting database backups, 204
parameter
, 323
user accounts, creating
tiers
performing RMAN backup using
tape channels with Oracle default
server system objects, 190–193
user class, OSB user rights, 122
656
Oracle RMAN 11
g
: Backup and Recovery
User Directed Recovery, OEM,
V$DATABASE view
, 220, 372
V$RMAN_BACKUP_JOB_DETAILS
V$DATABASE_BLOCK_CORRUPTION
view
, 455
user errors.
See
Flashback Technology
V$RMAN_CONFIGURATION
V$DATAFILE view
, 220
view
, 221
USER_RECYCLEBIN view
, 390
V$DATAFILE_COPY view
, 219, 220
V$RMAN_ENCRYPTION_
using backup controlfile
V$DIAG_INFO view
, 75
ALGORITHMS view
, 96–97
verdeleted attribute, TSM copy
V$RMAN_OUTPUT view
, 227–228
V$SESSION view
, 42, 456
V
verification, of database restorability,
V$SESSION_LONGOPS view
V$ views, for reporting, 441–442
VERITAS NetBackup for Oracle.
See