Read Oracle RMAN 11g Backup and Recovery Online
Authors: Robert Freeman
restore operations
case studies.
See
case studies,
RMAN recovery
RMAN configuration
using Data Protector GUI,
controlling overall impact of
in ARCHIVELOG mode.
See
ARCHIVELOG mode,
restore points
Data Guard and.
See
Data Guard
configuring database in
and RMAN
database security
, 81–82
Data Protector, configuring
database user
, 80–81
Fault Diagnosability
Data Protector, integrating with
Data Protector, running backup of
RMAN command line,
restore spfile from autobackup
integrated Oracle database,
setting CONTROL_FILE_
restoreCommands parameter syntax
deleting expired backups,
RECORD_KEEP_TIME
parameter
, 82–83
restoreObject parameter syntax
deploying backup to AWS S3,
restoreSpecOperand parameter syntax
enhancing with VERITAS
RMAN configuration, default settings,
NetBackup.
See
NetBackup for
resync catalog command
Oracle
ar
chive log deletion policies, 97
manual resynchronizing recovery
and memory
, 13–14
automated backups of control file
metadata, and Data Protector
resyncing, recovery catalog, 50,
performing backups using OSB
retention policies
physical backup and recovery.
archive log deletion policies,
See
physical backup and
recovery
repository
, 208
652
Oracle RMAN 11
g
: Backup and Recovery
RMAN subclause syntax details
specifying OSB Cloud Module
security
each time you allocate
configuring database in
archivelogRecordSpecifier,
storing S3 as default SBT
completedT
imeSpec, 614
server
mounting split mirror volume on
deviceSpecifier
, 615
other
, 523–524
schedule backup daemon, OSB, 119
NetBackup software
scheduled backups
foreignlogRecordSpecifier
, 615
creating RMAN script job,
RMAN duplication to remote,
RMAN duplication to same,
maintQualifier
, 617
RMAN backup on Data
server
-managed recovery (SMR), 34
Protector
, 183
SERVER=dedicated syntax, Shared
RMAN backup on Data Protector-
integrated Oracle database,
service backup daemon, OSB, 119
Session Manager, Data Protector
, 176
sessions, tracing RMAN, 460–462
RMAN syntax reference guide
schema objects, 9, 210–21
1, 440
set backup copies parameter, backup
schtasks utility, W
indows, 623
command list syntax.
See
SCN (System Change Number)
set command
command list syntax details
archivelog destination to
parameter
, 350
specifier and operands list, 563
incomplete recoveries and,
robotic interface, media management
information stored in control
establishing recovery tar
get, 347
server
, 104
rollback segments, Flashback and,
performing Flashback Database,
set dbid command
recovering control file from
round-robin style of writing, log
SPFILE recovery from autobackup
row history
, 380–384
recovering to previous
incarnation with recovery
unregistering database from
scripts
S
adding to backup selection list,
set encryption on identified by
S3 (Simple Storage Service), Amazon
disk-only Oracle-suggested
set encryption on identified by
backup over Internet or from
set newname for clone command, 364
backups using OSB Cloud
RMAN backups vs. backups,
set newname for database command,
set until restore point
persistently storing as default SBT
RMAN scripts for UNIX,
setParameter parameter syntax
RMAN scripts for Windows,
diagram, duplicate command, 584
SBT API
setRmanOption parameter syntax
Index
653
setRmanorRunOption parameter
performing Flashback Table from,
syntax diagram, set command, 604
configuring RMAN default
setRunOption parameter syntax
tuning backup and recovery
, 449
SG (SCSI Generic) driver
, OSB, 122
sql command
SGA (System Global Area)
software, controlling database, 10–1
1
defining memory allocations
source host credentials, database
speed, split mirror backups and, 523
Standard Editions, RMAN included
SPFILE
standard policy domain, TSM, 192
disk-only Oracle-suggested
standby database.
See also
Data Guard
RMAN memory utilization,
and RMAN
duplicating RAC database on
archive logs backups from,
testing Oracle installation/
duplication to remote server using
backing up multinode RAC
duplication to same server using
show all command, 204, 221–222
getting started with your database
Oracle sync and split and,
shutdown abort command, 11, 23
shutdown command
recovery catalog views for
, 219
offline RMAN backups, 23, 229,
RMAN automated backups of,
using Flashback Database for
RMAN process from start to
start with option, catalog
shutdown immediate command, 11,
recovery from autobackup using
startup command
shutdown normal command, 294–295
recovery from complete database
shutdown transactional command, 11
loss (ARCHIVELOG),
startup for
ce command, 11
Simple Storage Service.
See
S3 (Simple
recovery from complete database
startup mount command
Storage Service), Amazon
ARCHIVELOG mode full
since time option, backup command,
recovery from specific backup
recovery
, 29
sizeSpec parameter syntax diagram
recovery when using recovery
loss of current online redo log
offline RMAN backups,
restoring backed up SPFILE with