48/48
Index
%
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
%
%b substitution variable
SET NEWNAME
[1]
%d substitution variable
BACKUP FORMAT
[1]
%f substitution variable
SET NEWNAME
[1]
%I substitution variable
SET NEWNAME
[1]
%N substitution variable
SET NEWNAME
[1]
%p substitution variable
BACKUP FORMAT
[1]
%s substitution variable
BACKUP FORMAT
[1]
%t substitution variable
BACKUP FORMAT
[1]
%U substitution variable
BACKUP FORMAT
[1]
SET NEWNAME
[1]
A
ABORT option
SHUTDOWN statement
[1]
,
[2]
,
[3]
about
backing up CDBs
[1]
backing up PDBs
[1]
active database duplication
compressing backup sets
[1]
creating backup sets in parallel
[1]
determining technique used
[1]
Advanced Security Option
[1]
ADVISE FAILURE command
[1]
,
[2]
alert log
[1]
ALLOCATE CHANNEL command
MAXPIECESIZE option
[1]
ALLOW ... CORRUPTION clause, RECOVER command
[1]
ALTER DATABASE statement
CLEAR LOGFILE clause
[1]
END BACKUP clause
[1]
OPEN RESETLOGS clause
[1]
RECOVER clause
[1]
,
[2]
,
[3]
RESETLOGS option
[1]
ALTER SYSTEM statement
KILL SESSION clause
[1]
RESUME clause
[1]
SUSPEND clause
[1]
ALTER TABLESPACE statement
BEGIN BACKUP clause
[1]
,
[2]
END BACKUP option
[1]
application errors
[1]
archival backups
[1]
,
[2]
,
[4]
archived redo log deletion policies
[1]
,
[2]
,
[3]
archived redo log files
applying during media recovery
[1]
,
[2]
,
[3]
backing up
using RMAN
[1]
with other backups
[1]
backing up, in CDBs
[1]
cataloging
[1]
changing default location
[1]
corrupted
[1]
delete after backups
[1]
delete after backups, in CDBs
[1]
deleting
[1]
,
[2]
deletion after backup
[1]
failover
[1]
incompatible format
[1]
location during recovery
[1]
loss of
[1]
restoring using RMAN
[1]
ARCHIVELOG mode
backups in
[1]
AS SELECT clause
CREATE TABLE statement
[1]
autobackups, control file
configuring
[1]
format
[1]
automated repairs
Data Recovery Advisor
[1]
automatic channel allocation
[1]
automatic channels
configuring
[1]
naming conventions
[1]
overriding
[1]
Automatic Diagnostic Repository (ADR)
[1]
,
[2]
,
[3]
,
[4]
,
[5]
,
[6]
,
[7]
Automatic Storage Management (ASM)
backups to
[1]
Automatic Workload Repository (AWR)
[1]
AUTORECOVERY option
SET statement
[1]
auxiliary channels
[1]
auxiliary instance parameter file
with TRANSPORT TABLESPACE
[1]
availability
of RMAN backups
[1]
AVAILABLE option
of CHANGE command
[1]
B
backing up
database
[1]
data files in PDBs
[1]
tablespaces in PDBs
[1]
with Oracle Enterprise Manager Cloud Control
[1]
backup and recovery
definition
[1]
introduction
[1]
solutions
[1]
strategy
[1]
user-managed
[1]
BACKUP command
ALLOW INCONSISTENT option
[1]
ARCHIVELOG option
[1]
,
[2]
AS COMPRESSION BACKUPSET option
[1]
AS COPY option
[1]
,
[2]
BACKUPSET option
[1]
,
[3]
,
[4]
,
[7]
,
[9]
CHANNEL option
[1]
COMPRESSED BACKUPSET option
[1]
COPIES parameter
[1]
,
[2]
COPY OF option
[1]
,
[2]
,
[3]
,
[4]
CURRENT CONTROLFILE option
[1]
,
[2]
DATABASE option
[1]
DATAFILE option
[1]
DATAPUMP option
[1]
,
[2]
,
[4]
DB_FILE_NAME_CONVERT parameter
[1]
DELETE INPUT option
[1]
,
[3]
DELETE option
[1]
DEVICE TYPE clause
[1]
,
[2]
,
[3]
,
[5]
DURATION parameter
[1]
FILESPERSET parameter
[1]
FORMAT parameter
[1]
,
[2]
,
[3]
,
[4]
,
[5]
,
[6]
FOR RECOVER OF COPY option
[1]
FOR TRANSPORT parameter
[1]
,
[2]
INCREMENTAL LEVEL 1 parameter
[1]
,
[3]
INCREMENTAL LEVEL O parameter
[1]
,
[2]
INCREMENTAL option
[1]
,
[3]
,
[4]
,
[5]
,
[6]
KEEP option
[1]
,
[2]
,
[4]
MAXSETSIZE parameter
[1]
NOT BACKED UP clause
[1]
PLUS ARCHIVELOG option
[1]
PROXY ONLY option
[1]
PROXY option
[1]
RECOVERY AREA option
[1]
SECTION SIZE parameter
[1]
,
[2]
,
[3]
SPFILE option
[1]
TABLESPACE option
[1]
TAG parameter
[1]
,
[2]
TO PLATFORM parameter
[1]
,
[2]
VALIDATE option
[1]
,
[2]
,
[3]
,
[4]
BACKUP CONTROLFILE clause
ALTER DATABASE statement
[1]
BACKUP COPIES parameter
CONFIGURE command
[1]
backup encryption
decrypting backups
[1]
default algorithm
[1]
dual-mode
[1]
,
[2]
overview
[1]
password
[1]
,
[2]
transparent
[1]
,
[2]
backup mode
ending with ALTER DATABASE END BACKUP
[1]
for online user-managed backups
[1]
,
[2]
instance failure
[1]
backup optimization
configuring
[1]
,
[2]
definition
[1]
,
[2]
disabling
[1]
,
[2]
enabling
[1]
,
[2]
redundancy and
[1]
retention policies and
[1]
backup pieces
definition
[1]
maximum size
[1]
names
[1]
names on tape
[1]
backup retention policies
affect on backup optimization
[1]
configuring
[1]
configuring for redundancy
[1]
definition
[1]
disabling
[1]
exempt backups
[1]
,
[2]
recovery window
[1]
recovery windows
[1]
redundancy
[1]
,
[2]
backups
archival
[1]
,
[2]
archived redo log files, in CDBs
[1]
archived redo logs
using RMAN
[1]
availability
[1]
backup sets
[1]
backups of
[1]
closed
[1]
consistent
making using RMAN
[1]
control file
[1]
,
[2]
control files
binary
[1]
correlating RMAN channels with
[1]
,
[2]
crosschecking
[1]
cumulative incremental
[1]
data file
using RMAN
[1]
,
[2]
DBVERIFY utility
[1]
default type for RMAN
[1]
determining data file status
[1]
duplexing
[1]
,
[3]
excluding tablespaces from backups
[1]
exempt from retention policy
[1]
expired, deleting
[1]
generating reports for
[1]
,
[2]
image copies
[1]
inconsistent
making using RMAN
[1]
incremental
[1]
,
[2]
,
[3]
,
[4]
incrementally updated
[1]
listing files needed
[1]
logical
[1]
long-term
[1]
managing
[1]
multisection
[1]
,
[2]
,
[3]
NOARCHIVELOG mode
[1]
obsolete
[1]
,
[2]
offline
[1]
offsite
[1]
optimizing
[1]
,
[2]
orphaned
[1]
PDBs, using Oracle Enterprise Manager Cloud Control
[1]
PDBs, using RMAN
[1]
physical
[1]
previewing
[1]
read-only tablespaces
[1]
recovering pre-RESETLOGS
[1]
recovery catalog
[1]
Recovery Manager
[1]
reporting objects needing backups
[1]
restartable
[1]
restoring user-managed
[1]
root
using Oracle Enterprise Manager Cloud Control
[1]
using RMAN
[1]
server parameter files
[1]
skipping files during
[1]
split mirror
using RMAN
[1]
stored scripts
[1]
,
[2]
tablespace
using RMAN
[1]
,
[2]
,
[3]
testing RMAN
using media manager
[1]
user-managed
[1]
using storage snapshots
[1]
validating
[1]
,
[3]
verifying
[1]
whole CDB
[1]
whole database
[1]
,
[3]
backup sets
backing up
[1]
,
[3]
compressed
[1]
,
[2]
,
[3]
configuring as default
[1]
configuring maximum size
[1]
crosschecking
[1]
duplexing
[1]
how RMAN generates
[1]
limiting size
[1]
maximum size
[1]
,
[2]
multiplexed
[1]
,
[2]
,
[3]
,
[4]
,
[5]
naming
[1]
overview
[1]
specifying maximum size
[1]
specifying number
[1]
testing restore of
[1]
Backup Solutions Program (BSP)
[1]
backup strategy
fast recovery area
[1]
backup tags, RMAN
[1]
backup techniques, comparison
[1]
backup windows
[1]
BEGIN BACKUP clause
ALTER TABLESPACE statement
[1]
binary compression for backups
[1]
block change tracking
disk space used for
[1]
enabling and disabling
[1]
,
[3]
moving the change tracking file
[1]
block corruptions
stored in V$DATABASE_BLOCK_CORRUPTION
[1]
block media recovery
automatic
[1]
BSP
[1]
C
cancel-based media recovery
[1]
canceling RMAN commands
[1]
CATALOG command
START WITH parameter
[1]
CDBs
about backup and recovery of
[1]
backing up
[1]
complete recovery
after switching to a copy
[1]
using Oracle Enterprise Manager Cloud Control
[1]
complete restore
[1]
connecting to
[1]
crash recovery
[1]
Data Recovery Advisor
[1]
diagnose failures
[1]
duplicating
[1]
flashback
[1]
instance recovery
[1]
performing point-in-time recovery
[1]
repairing failures
[1]
reporting
[1]
rewinding beyond PDB point-in-time recovery
[1]
transporting across platforms
[1]
user-managed backups
[1]
validating
[1]
CHANGE command
AVAILABLE option
[1]
DB_UNIQUE_NAME parameter
[1]
RESET DB_UNIQUE_NAME option
[1]
UNCATALOG option
[1]
CHANGE FAILURE command
[1]
channels, RMAN
auxiliary
[1]
configuring
[1]
configuring advanced options
[1]
definition
[1]
generic
[1]
naming conventions
[1]
Oracle RAC environment
[1]
parallel
[1]
character sets
setting for use with RMAN
[1]
circular reuse records
[1]
CLEAR LOGFILE clause
of ALTER DATABASE
[1]
client, RMAN
[1]
,
[3]
,
[4]
cold failover cluster
definition
[1]
command files, RMAN
[1]
command interface
RMAN
[1]
commands, Recovery Manager
ADVISE FAILURE
[1]
,
[2]
ALLOCATE CHANNEL
[1]
,
[2]
,
[3]
,
[4]
BACKUP
PROXY ONLY option
[1]
PROXY option
[1]
BACKUP CURRENT CONTROLFILE
[1]
canceling
[1]
CATALOG
[1]
CHANGE
[1]
,
[2]
CHANGE FAILURE
[1]
CONFIGURE
[1]
,
[2]
,
[3]
,
[4]
,
[5]
,
[6]
,
[7]
,
[8]
CREATE CATALOG
[1]
,
[2]
CREATE SCRIPT
[1]
CROSSCHECK
[1]
DELETE
[1]
,
[2]
,
[4]
DROP CATALOG
[1]
DROP DATABASE
[1]
DUPLICATE
[1]
EXECUTE SCRIPT
[1]
,
[2]
EXIT
[1]
FLASHBACK DATABASE
[1]
GRANT
[1]
,
[2]
how RMAN interprets
[1]
IMPORT CATALOG
[1]
LIST
INCARNATION option
[1]
,
[2]
MAXSETSIZE
[1]
piping
[1]
PRINT SCRIPT
[1]
RECOVER
[1]
REPAIR FAILURE
[1]
,
[2]
REPLACE SCRIPT
[1]
REPORT
NEED BACKUP option
[1]
RESET DATABASE
INCARNATION option
[1]
RESTORE
[1]
RESYNC CATALOG
FROM CONTROLFILECOPY option
[1]
REVOKE
[1]
SET
[1]
SHOW
[1]
,
[2]
SPOOL
[1]
SWITCH
[1]
terminating
[1]
UNREGISTER DATABASE
[1]
UPGRADE CATALOG
[1]
VALIDATE
[1]
,
[2]
,
[3]
commands, SQL*Plus
RECOVER
UNTIL TIME option
[1]
SET
[1]
,
[2]
,
[3]
,
[4]
comments in RMAN syntax
[1]
COMPATIBLE initialization parameter
[1]
complete recovery
overview
[1]
procedures
[1]
compressed backups
algorithms
[1]
compressing
backup sets, during active database duplication
[1]
CONFIGURE command
AUXNAME option
[1]
BACKUP OPTIMIZATION option
[1]
CHANNEL option
[1]
,
[2]
CONTROLFILE AUTOBACKUP option
[1]
,
[2]
DB_UNIQUE_NAME option
[1]
ENCRYPTION option
[1]
EXCLUDE option
[1]
FOR DB_UNIQUE_NAME option
[1]
MAXPIECESIZE option
[1]
MAXSETSIZE option
[1]
RETENTION POLICY clause
[1]
RETENTION POLICY option
[1]
configuring media managers
installing
[1]
prerequisites
[1]
configuring Recovery Manager
autobackups
[1]
,
[2]
,
[3]
backup optimization
[1]
backup retention policies
[1]
backup set size
[1]
default backup type
[1]
default devices
[1]
overview
[1]
shared server
[1]
snapshot control file location
[1]
specific channels
[1]
tablespace exclusion for backups
[1]
connecting
to CDBs
[1]
to PDBs
[1]
consistent backups
using RMAN
[1]
whole database
[1]
CONTROL_FILE_RECORD_KEEP_TIME initialization parameter
[1]
,
[2]
CONTROL_FILES initialization parameter
[1]
,
[2]
,
[3]
control file autobackups
after structural changes to database
[1]
configuring
[1]
,
[4]
,
[6]
default format
[1]
format
[1]
control files
backups
binary
[1]
including within database backup
[1]
manual
[1]
recovery using
[1]
using RMAN
[1]
circular reuse records
[1]
configuring location
[1]
creating after loss of all copies
[1]
finding file names
[1]
multiplexed
loss of
[1]
multiplexing
[1]
re-created
[1]
restoring
[1]
,
[2]
,
[3]
snapshot
specifying location of
[1]
user-managed restore after loss of all copies
[1]
CONVERT command
ALLOW INCONSISTENT option
[1]
COPIES option
BACKUP command
[1]
corrupt blocks
recovering
[1]
RMAN and
[1]
crash recovery
of CDBs
[1]
CREATE CATALOG command
[1]
,
[2]
CREATE DATAFILE clause, ALTER DATABASE statement
[1]
CREATE SCRIPT command
[1]
CREATE TABLESPACE statement
[1]
CREATE TABLE statement
AS SELECT clause
[1]
CROSSCHECK command
[1]
crosschecking, RMAN
definition
[1]
recovery catalog with the media manager
[1]
cross-platform data transport
data pump destination
[1]
cross-platform transport
databases
using backup sets
[1]
using image copies
[1]
data files, using image copies
[1]
inconsistent tablespaces
about
[1]
example
[1]
steps
[1]
methods
using backup sets
[1]
using image copies
[1]
of CDBs
[1]
of PDBs
[1]
read-only tablespaces
using backup sets
[1]
using image copies
[1]
tablespaces, DataPump export dump file
[1]
tablespaces in PDBs
[1]
cross-platform transportable tablespace
[1]
cumulative incremental backups
[1]
,
[2]
,
[3]
,
[4]
D
database connections
Recovery Manager
auxiliary database
[1]
hiding passwords
[1]
without a catalog
[1]
SYSBACKUP required for RMAN
[1]
types in RMAN
[1]
database duplication
initialization parameter file
[1]
starting auxiliary instance
[1]
Database Home page, accessing
[1]
database point-in-time recovery
definition
[1]
Flashback Database and
[1]
prerequisites
[1]
user-managed
[1]
databases
listing for backups
[1]
media recovery procedures, user-managed
[1]
media recovery scenarios
[1]
multitenant container
[1]
recovery
after control file damage
[1]
,
[2]
registering in recovery catalog
[1]
reporting on schemas
[1]
suspending
[1]
transporting across platforms
using backup sets
[1]
using image copies
[1]
unregistering from recovery catalog
[1]
data blocks, corrupted
[1]
,
[2]
,
[3]
,
[4]
,
[5]
,
[6]
,
[7]
,
[8]
,
[9]
,
[10]
data dictionary views
[1]
,
[2]
,
[3]
data files
backing up
[1]
,
[2]
,
[3]
,
[4]
backing up, in PDBs
[1]
determining status
[1]
listing
[1]
losing
[1]
restoring
[1]
transporting across platforms
[1]
Data Guard environment
archived log deletion policies
[1]
changing a DB_UNIQUE_NAME
[1]
configuring RMAN
[1]
reporting in a
[1]
RMAN backups
[1]
RMAN backups, accessibility of
[1]
RMAN backups, association of
[1]
RMAN backups, interchangeability of
[1]
,
[2]
RMAN usage
[1]
data integrity checks
[1]
,
[2]
,
[3]
data preservation, definition of
[1]
data protection
definition
[1]
data pump destination
[1]
Data Recovery Advisor
automated repairs
[1]
data integrity checks
[1]
,
[2]
failure consolidation
[1]
failure priority
[1]
failures
[1]
,
[2]
feasibility checks
[1]
for CDBs
[1]
overview
[1]
purpose
[1]
repairing failures
[1]
repair options
[1]
repairs
[1]
,
[2]
,
[3]
supported configurations
[1]
user interfaces
[1]
data repair
overview
[1]
techniques
[1]
data transfer, RMAN
[1]
DB_BLOCK_CHECKSUM initialization parameter
[1]
DB_CREATE_FILE_DEST initialization parameter
[1]
,
[2]
DB_FILE_NAME_CONVERT initialization parameter
[1]
DB_FLASHBACK_RETENTION_TARGET initialization parameter
[1]
DB_LOST_WRITE_PROTECT initialization parameter
[1]
DB_NAME initialization parameter
[1]
DB_RECOVERY_FILE_DEST_SIZE initialization parameter
[1]
DB_RECOVERY_FILE_DEST initialization parameter
[1]
DB_UNIQUE_NAME initialization parameter
[1]
,
[2]
,
[3]
,
[4]
DBA_DATA_FILES view
[1]
,
[2]
,
[3]
DBID
determining
[1]
problems registering copied database
[1]
DBMS_PIPE package
[1]
DBNEWID utility
[1]
DBPITR
[1]
DBVERIFY utility
[1]
DELETE command
EXPIRED option
[1]
,
[2]
OBSOLETE option
[1]
,
[3]
deleting
archived redo log files
[1]
archived redo log files, in CDBs
[1]
deleting backups
[1]
,
[2]
,
[4]
,
[5]
deletion policies, archived redo log
enabling
[1]
devices, configuring default
[1]
diagnose failures
in CDBs
[1]
differential incremental backups
[1]
,
[2]
,
[3]
direct ancestral path
[1]
,
[2]
,
[3]
disabling
Flashback Database
[1]
disaster recovery
definition
[1]
disconnecting
from Recovery Manager
[1]
disk API
[1]
disk failures
[1]
disk usage
monitoring
[1]
DROP DATABASE command
[1]
dropped tables, retrieving
[1]
dropping a database
[1]
dropping the recovery catalog
[1]
dual mode backup encryption
[1]
dual-mode backup encryption
[1]
dummy API
[1]
duplexing backup sets
[1]
,
[3]
,
[4]
DUPLICATE command
NOOPEN clause
[1]
restarting after a failure
[1]
duplicate databases
active database duplication
advantages of using backup sets
[1]
allocating channels
[1]
configuring channels
[1]
using backup sets
[1]
using image copies
[1]
active database duplication, connecting
[1]
active database duplication, encrypting backup sets
[1]
backup-based duplication
configuring channels
[1]
no target/recovery connection
[1]
no target connection
[1]
target connection
[1]
CDBs
[1]
generating file names
[1]
how RMAN creates
[1]
PDBs
[1]
restarting after failed DUPLICATE
[1]
skipping offline normal tablespaces
[1]
skipping read-only tablespaces
[1]
specifying the state
[1]
tablespaces in PDBs
[1]
duplication
restarting after a failure
[1]
DURATION parameter, BACKUP command
[1]
E
enabling
Flashback Database
[1]
encrypted backups
decrypting
[1]
environment variables
NLS_DATE_FORMAT
[1]
NLS_LANG
[1]
error codes
media manager
[1]
RMAN
[1]
,
[2]
,
[3]
error messages, RMAN
interpreting
[1]
error stacks, RMAN
interpreting
[1]
example
multisection incremental backups
[1]
examples
recovering using third-party snapshots
[1]
rolling forward a physical standby
[1]
EXECUTE SCRIPT command
[1]
EXIT command
[1]
exiting RMAN
[1]
expired backups
deleting
[1]
EXPIRED option
DELETE command
[1]
F
failover, when restoring files
[1]
failures
definition
[1]
media
[1]
failures, Data Recovery Advisor
consolidation
[1]
priority
[1]
fast recovery area
autobackups
[1]
changing locations
[1]
configuring
[1]
definition
[1]
disabling
[1]
effect of retention policy
[1]
enabling
[1]
flashback database window
[1]
maintaining
[1]
monitoring disk usage
[1]
monitoring usage
[1]
Oracle Managed Files
[1]
PDB point-in-time recovery
[1]
permanent and impermanent files
[1]
RMAN files in
[1]
setting location
[1]
setting size
[1]
snapshot control files
[1]
space management
[1]
feasibility checks, Data Recovery Advisor
[1]
file names, listing for backup
[1]
file sections
[1]
,
[2]
,
[3]
,
[4]
flashback
CDB
[1]
flashback data archive
definition
[1]
Flashback Database
determining the flashback database window
[1]
disabling
[1]
enabling
[1]
flashback logs
[1]
,
[2]
limitations
[1]
monitoring
[1]
overview
[1]
prerequisites
[1]
purpose
[1]
requirements
[1]
space management
estimating disk space requirement
[1]
tuning performance
[1]
FLASHBACK DATABASE command
[1]
flashback database window
[1]
Flashback Drop
[1]
,
[2]
flashback logs
guaranteed restore points and
[1]
flashback retention target
[1]
Flashback Table
using
[1]
,
[2]
FLASHBACK TABLE statement
[1]
,
[3]
Flashback Technology
logical features
[1]
overview
[1]
flashback undrop
restoring objects
[1]
foreign data file
[1]
foreign data file copy
[1]
foreign tablespace
[1]
formats, for RMAN backups
[1]
fractured blocks
detection
[1]
full backups
incremental backups and
[1]
G
generic channels
definition
[1]
GRANT command
[1]
,
[2]
groups, redo log
[1]
,
[3]
guaranteed restore points
alternative to storage snapshots
[1]
compared to storage snapshots
[1]
creating
[1]
flashback logs and
[1]
requirements
[1]
space usage in fast recovery area
[1]
H
Health Monitor
[1]
hot backup mode
failed backups
[1]
,
[2]
for online user-managed backups
[1]
I
I/O errors
effect on backups
[1]
image copies
definition
[1]
testing restore of
[1]
IMPORT CATALOG command
[1]
INCARNATION option
LIST command
[1]
,
[2]
RESET DATABASE command
[1]
incarnations
database
[1]
,
[2]
,
[3]
,
[4]
INCLUDE CURRENT CONTROLFILE option
BACKUP command
[1]
incomplete media recovery
[1]
incomplete recovery
defined
[1]
in Oracle Real Application Clusters configuration
[1]
overview
[1]
time-based
[1]
with backup control file
[1]
inconsistent backups
using RMAN
[1]
,
[2]
inconsistent tablespaces
transporting across platforms
[1]
incremental backups
block change tracking
[1]
differential
[1]
how RMAN applies
[1]
making
[1]
multisection incremental backups
[1]
using RMAN
[1]
,
[2]
initialization parameter file
[1]
initialization parameters
CONTROL_FILES
[1]
,
[2]
DB_FILE_NAME_CONVERT
[1]
DB_NAME
[1]
LOG_ARCHIVE_DEST_n
[1]
LOG_ARCHIVE_FORMAT
[1]
LOG_FILE_NAME_CONVERT
[1]
instance failures
backup mode and
[1]
instance recovery
of CDBs
[1]
integrity checks
[1]
interpreting RMAN error stacks
[1]
interrupting media recovery
[1]
J
jobs, RMAN
monitoring progress
[1]
querying details about
[1]
K
KEEP option
BACKUP command
[1]
L
level 0 incremental backups
[1]
,
[2]
,
[4]
level 1 incremental backups
[1]
,
[2]
LIST command
FAILURE option
[1]
INCARNATION option
[1]
LOG_ARCHIVE_DEST_n initialization parameter
[1]
,
[2]
,
[3]
,
[4]
,
[5]
,
[7]
,
[8]
,
[9]
LOG_ARCHIVE_FORMAT initialization parameter
[1]
LOG_FILE_NAME_CONVERT initialization parameter
[1]
logical backups
[1]
logical block corruption
[1]
log sequence numbers
[1]
LOGSOURCE variable
SET statement
[1]
,
[2]
,
[3]
long waits
[1]
loss of
inactive log group
[1]
lost writes, detecting
[1]
M
maintenance commands, RMAN
Data Guard environment
[1]
managing RMAN metadata
[1]
,
[2]
MAXPIECESIZE parameter
SET command
[1]
MAXSETSIZE parameter
BACKUP command
[1]
,
[2]
CONFIGURE command
[1]
media failures
archived redo log file loss
[1]
complete recovery
[1]
complete recovery, user-managed
[1]
control file loss
[1]
datafile loss
[1]
definition
[1]
NOARCHIVELOG mode
[1]
online redo log group loss
[1]
recovery
[1]
recovery procedures
examples
[1]
Media Management Layer (MML) API
[1]
,
[2]
media managers
backing up files
[1]
backup piece names
[1]
Backup Solutions Program
[1]
catalog
[1]
configuring for use with RMAN
[1]
crosschecking
[1]
definition
[1]
error codes
[1]
file restrictions
[1]
installing
[1]
library location
[1]
linking
testing
[1]
linking to software
[1]
,
[2]
multiplexing backups
[1]
prerequisites for configuring
[1]
sbttest program
[1]
testing
[1]
testing backups
[1]
testing the API
[1]
third-party
[1]
troubleshooting
[1]
media recovery
ADD DATAFILE operation
[1]
after control file damage
[1]
,
[2]
applying archived redo logs
[1]
cancel-based
[1]
,
[2]
complete
closed database
[1]
complete, user-managed
[1]
corruption
allowing to occur
[1]
errors
[1]
incomplete
[1]
interrupting
[1]
lost files
lost archived redo log files
[1]
lost data files
[1]
lost mirrored control files
[1]
NOARCHIVELOG mode
[1]
offline tablespaces in open database
[1]
online redo log files
[1]
parallel
[1]
problems
[1]
,
[3]
,
[4]
restarting
[1]
restoring
whole database backups
[1]
resuming after interruption
[1]
roll forward phase
[1]
scenarios
[1]
time-based
[1]
transportable tablespaces
[1]
trial
[1]
,
[3]
troubleshooting
[1]
user-managed
[1]
using Recovery Manager
[1]
metadata, RMAN
[1]
,
[2]
,
[3]
,
[4]
mirrored files
backups using
[1]
splitting
suspend/resume mode
[1]
using RMAN
[1]
monitoring fast recovery area usage
[1]
monitoring RMAN
[1]
MTTR
[1]
multiplexed backup sets
[1]
,
[2]
,
[3]
,
[4]
multiplexed control files
[1]
,
[2]
,
[3]
,
[5]
,
[6]
,
[7]
,
[8]
multisection backups
views
[1]
multisection incremental backups
example
[1]
multitenant container databases
[1]
N
naming backup sets
[1]
NLS_DATE_FORMAT environment variable
[1]
NLS_LANG environment variable
[1]
NOARCHIVELOG mode
backing up
[1]
disadvantages
[1]
recovery
[1]
O
obsolete backups
definition
[1]
deleting
[1]
,
[2]
,
[3]
off-site backups
[1]
online redo logs
active group
[1]
,
[2]
applying during media recovery
[1]
archived group
[1]
,
[2]
clearing
failure
[1]
clearing inactive logs
archived
[1]
unarchived
[1]
configuring location
[1]
current group
[1]
,
[2]
inactive group
[1]
,
[2]
loss of
active group
[1]
all members
[1]
group
[1]
recovery
[1]
loss of group
[1]
multiple group loss
[1]
replacing damaged member
[1]
status of members
[1]
,
[2]
OPEN RESETLOGS clause
ALTER DATABASE statement
[1]
,
[2]
,
[3]
,
[4]
ORA-01578 error message
[1]
Oracle Advanced Compression option
[1]
Oracle Backup Solutions Program (BSP)
[1]
Oracle Data Pump
[1]
,
[2]
Oracle Enterprise Manager Cloud Control
about
[1]
accessing the Database Home page
[1]
Oracle Flashback Database
[1]
Oracle Flashback Drop
[1]
Oracle Flashback Query
[1]
Oracle Flashback Table
[1]
Oracle Flashback Transaction
[1]
Oracle Flashback Transaction Query
[1]
Oracle Flashback Version Query
[1]
Oracle keystore
[1]
Oracle Managed Files
fast recovery
[1]
Oracle Real Application Clusters (Oracle RAC)
RMAN channels and
[1]
Oracle Secure Backup
[1]
,
[2]
Oracle software keystore
and backups
[1]
Oracle VSS writer
[1]
orphaned backups
[1]
P
packages
DBMS_PIPE
[1]
password backup encryption
[1]
password-mode encryption
[1]
passwords
connecting to RMAN
[1]
PDBs
about backup and recovery of
[1]
backing up, using Oracle Enterprise Manager Cloud Control
[1]
backing up, using RMAN
[1]
complete recovery
data files
[1]
tablespaces
[1]
using RMAN
[1]
complete restore
[1]
connecting to
[1]
duplicating
[1]
duplicating tablespaces in
[1]
orphaned backups
[1]
performing point-in-time recovery
[1]
point-in-time recovery and fast recovery area
[1]
recovering table partitions
[1]
recovering tables
[1]
reporting
[1]
restrictions when connected to
[1]
transporting across platforms
[1]
user-managed backups
[1]
validating
[1]
performance tuning
short waits
definition of
[1]
performance tuning, RMAN
backup performance
[1]
long waits
[1]
physical backups
[1]
physical block corruption
[1]
pipe interface, RMAN
[1]
pluggable databases
[1]
point-in-time recovery
of CDBs
[1]
of PDBs
[1]
performing
with current control file
[1]
tablespace
[1]
point of recoverability
recovery window
[1]
previewing backups
[1]
PREVIEW option, RESTORE command
[1]
PRINT SCRIPT command
[1]
proxy copies
[1]
,
[2]
PROXY option
BACKUP command
[1]
Q
QUIT command
[1]
quitting RMAN
[1]
R
raw devices
backing up to
[1]
UNIX backups
[1]
Windows backups
[1]
RC_ARCHIVED_LOG view
[1]
RC_BACKUP_FILES view
[1]
RC_BACKUP_PIECE view
[1]
RC_BACKUP_SET view
[1]
read-only tablespaces
backups
[1]
transporting across platforms
using backup sets
[1]
using image copies
[1]
RECOVER clause
ALTER DATABASE statement
[1]
,
[2]
,
[3]
RECOVER command
COPY option
[1]
FOREIGN DATAFILECOPY clause
[1]
,
[3]
FROM SERVICE parameter
[1]
PARALLEL and NOPARALLEL options
[1]
TEST option
[1]
unrecoverable objects and standby databases
[1]
UNTIL TIME option
[1]
USING BACKUP CONTROLFILE clause
[1]
recovering
table partitions in PDBs
[1]
tables in PDBs
[1]
recovering database file
over the network
[1]
recovering database files
over the network, example
[1]
using physical standby
[1]
recovering files over the network
scenarios
[1]
recovering table partitions
example
[1]
limitations
[1]
overview
[1]
prerequisites
[1]
steps
[1]
recovering tables
example
[1]
limitations
[1]
overview
[1]
prerequisites
[1]
steps
[1]
recovery
ADD DATAFILE operation
[1]
automatically applying archived logs
[1]
cancel-based
[1]
complete
CDBs
[1]
CDBs using Oracle Enterprise Manager Cloud Control
[1]
closed database
[1]
data files in PDBs
[1]
offline tablespaces
[1]
PDBs
[1]
root
[1]
tablespaces in PDBs
[1]
tablespaces in PDBs using Cloud Control
[1]
corruption
intentionally allowing
[1]
database
complete
[1]
in NOARCHIVELOG mode
[1]
database, point-in-time
[1]
,
[2]
database files
how RMAN applies changes
[1]
overview
[1]
data files
[1]
disaster using RMAN
[1]
dropped table
[1]
errors
[1]
failures requiring
[1]
interrupting
[1]
media
[1]
,
[2]
,
[3]
multiple redo threads
[1]
of lost or damaged recovery catalog
[1]
online redo logs
loss of group
[1]
parallel
[1]
preparing for
[1]
problems
fixing
[1]
investigating
[1]
stuck
[1]
third-party snapshots
example
[1]
time-based
[1]
transportable tablespaces
[1]
trial
explanation
[1]
overview
[1]
troubleshooting
[1]
user errors
[1]
user-managed
[1]
,
[2]
,
[3]
using backup control file
without recovery catalog
[1]
using logs in a nondefault location
[1]
using logs in default location
[1]
using logs in nondefault location
[1]
using storage snapshots
[1]
using third-party snapshots
[1]
with Oracle Enterprise Manager Cloud Control
[1]
without a recovery catalog
[1]
RECOVERY_CATALOG_OWNER role
[1]
,
[2]
recovery catalog
backing up
[1]
cataloging backups
[1]
,
[2]
centralization of metadata
[1]
creating
[1]
crosschecking
[1]
DBID problems
[1]
definition
[1]
,
[2]
deleting backups
[1]
deleting records
[1]
dropping
[1]
log switch record
[1]
managing size of
[1]
operating with
[1]
purpose of
[1]
recovery of
[1]
refreshing
[1]
registering databases
[1]
,
[2]
,
[3]
resynchronizing
[1]
,
[2]
space requirements
[1]
stored scripts
creating
[1]
synchronization
[1]
unregistering databases
[1]
updating
after operating system deletions
[1]
upgrading
[1]
,
[2]
views, querying
[1]
virtual private catalogs
[1]
recovery catalogs
backing up
[1]
dropping
[1]
importing
[1]
moving
[1]
Recovery Manager
allocating tape buffers
[1]
archived redo logs
backups
[1]
backups
archived redo logs
[1]
backing up
[1]
,
[2]
batch deletion of obsolete
[1]
control files
[1]
data file
[1]
,
[2]
,
[3]
duplexed
[1]
image copy
[1]
incremental
[1]
,
[2]
,
[3]
optimization
[1]
,
[2]
tablespace
[1]
,
[2]
testing
[1]
,
[2]
,
[4]
validating
[1]
,
[3]
whole database
[1]
channels
naming conventions
[1]
client
[1]
connecting to databases
[1]
corrupt data file blocks
handling I/O errors and
[1]
crosschecking recovery catalog
[1]
database character set
[1]
database connections
auxiliary database
[1]
duplicate database
[1]
hiding passwords
[1]
SYSBACKUP or SYSDBA required for target
[1]
without a catalog
[1]
DBMS_PIPE package
[1]
definition
[1]
disconnecting from
[1]
duplicate databases, overview of
[1]
error codes
message numbers
[1]
errors
interpreting
[1]
file deletion
[1]
fractured block detection in
[1]
image copy backups
[1]
incremental backups
cumulative
[1]
differential
[1]
level 0
[1]
integrity checking
[1]
jobs, monitoring progress
[1]
jobs, querying details of
[1]
lists
[1]
maintenance commands
[1]
media management
backing up files
[1]
Backup Solutions Program (BSP)
[1]
crosschecking
[1]
media manager, linking with a
[1]
metadata
[1]
,
[2]
,
[3]
,
[4]
monitoring
[1]
overview
[1]
,
[2]
performance
monitoring
[1]
pipe interface
[1]
proxy copy
[1]
recovery
after total media failure
[1]
recovery catalog
backing up
[1]
crosschecking
[1]
managing the size of
[1]
operating with
[1]
recovering
[1]
registration of target databases
[1]
,
[2]
,
[3]
resynchronizing
[1]
synchronization
[1]
upgrading
[1]
reports
database schema
[1]
objects needing a backup
[1]
obsolete backups
[1]
repository
[1]
restoring
archived redo logs
[1]
retention policies
configuring
[1]
return codes
[1]
setting time parameters
[1]
snapshot control file location
[1]
starting
[1]
synchronous and asynchronous I/O
[1]
,
[2]
,
[3]
terminating commands
[1]
test disk API
[1]
types of backups
[1]
using RMAN commands
[1]
recovery window
point of recoverability
[1]
RECOVERY WINDOW parameter
CONFIGURE command
[1]
recovery windows
configuring for retention policy
[1]
definition
[1]
recycle bin
restoring objects from
[1]
redo logs
incompatible format
[1]
naming
[1]
parallel redo
[1]
redo records
problems when applying
[1]
REGISTER command
[1]
REPAIR FAILURE command
[1]
,
[2]
repair failures
in CDBs
[1]
repair options, Data Recovery Advisor
[1]
repairs, Data Recovery Advisor
consolidation of
[1]
manual and automatic
[1]
REPLACE SCRIPT command
[1]
REPORT command
NEED BACKUP option
[1]
OBSOLETE option
[1]
reporting
in CDBs
[1]
in PDBs
[1]
reports, RMAN
backup jobs
[1]
database schema
[1]
files needing backups
[1]
obsolete backups
[1]
unrecoverable backups
[1]
repository, RMAN
[1]
RESET DATABASE command
INCARNATION option
[1]
RESETLOGS operation
when necessary
[1]
RESETLOGS option
of ALTER DATABASE
[1]
restartable backups
[1]
restarting
duplication after a failure
[1]
RESTORE command
ALL FOREIGN DATAFILES clause
[1]
BACKUPSET clause
[1]
DATAPUMP clause
[1]
DATAPUMP DESTINATION clause
[1]
,
[2]
DUMPFILE clause
[1]
,
[2]
,
[3]
FORCE option
[1]
FOREIGN DATABASE clause
[1]
,
[2]
FOREIGN DATAFILE clause
[1]
,
[2]
FOREIGN TABLESPACE clause
[1]
,
[2]
FROM BACKUPSET clause
[1]
FROM PLATFORM parameter
[1]
FROM SERVICE parameter
[1]
NOIMPORT option
[1]
PREVIEW option
[1]
,
[2]
VALIDATE HEADER option
[1]
,
[2]
restore optimization
[1]
restore points
creating
[1]
flashing back to
[1]
guaranteed
compared to storage snapshots
[1]
listing
[1]
requirements
[1]
restore validation
[1]
restoring
control files
to default location
[1]
to nondefault location
[1]
database
to default location
[1]
database files
[1]
,
[2]
,
[3]
server parameter files
[1]
testing
[1]
,
[2]
user-managed backups
[1]
restoring database file
over the network
[1]
restoring database files
over the network, example
[1]
restoring files over the network
scenarios
[1]
restrictions
PDBs
[1]
RESUME clause
ALTER SYSTEM statement
[1]
resuming recovery after interruption
[1]
RESYNC CATALOG command
FROM CONTROLFILECOPY option
[1]
resynchronizing the recovery catalog
[1]
,
[2]
,
[3]
return codes
RMAN
[1]
REVOKE command
[1]
RMAN
[1]
RMAN repository
[1]
,
[2]
RMAN sessions
[1]
,
[2]
root
backing up
using Oracle Enterprise Manager Cloud Control
[1]
using RMAN
[1]
complete recovery
[1]
complete restore
[1]
S
SBT
[1]
,
[2]
,
[3]
sbttest program
[1]
scenarios, Recovery Manager
NOARCHIVELOG backups
[1]
recovering pre-resetlogs backup
[1]
,
[2]
recovery after total media failure
[1]
scripts, RMAN
substitution variables in
[1]
server parameter files
autobackups
[1]
backups
[1]
configuring autobackups
[1]
,
[2]
,
[3]
restoring
[1]
server sessions, Recovery Manager
[1]
session architecture, Recovery Manager
[1]
SET command
DBID option
[1]
ENCRYPTION option
[1]
MAXCORRUPT option
[1]
NEWNAME option
[1]
SET statement
AUTORECOVERY option
[1]
LOGSOURCE variable
[1]
,
[2]
,
[3]
shadow copies
[1]
shared server
configuring for use with RMAN
[1]
configuring RMAN
[1]
short waits
definition
[1]
SHOW command
[1]
,
[3]
SHUTDOWN statement
ABORT option
[1]
,
[2]
,
[3]
size of backup sets, setting
[1]
skipping files in RMAN backups
[1]
snapshot control file
specifying location
[1]
specifying location in Oracle Real Application Clusters environment
[1]
snapshot control files
[1]
,
[2]
snapshots
backing up using third-party technologies
[1]
using Storage Snapshot Optimization
[1]
split mirrors
suspend/resume mode
[1]
using as backups
[1]
SPOOL command
[1]
standby databases
creating with DUPLICATE
[1]
statements, SQL
ALTER DATABASE
[1]
,
[2]
,
[3]
Storage Snapshot Optimization
[1]
storage snapshots
recovering
[1]
stored scripts
creating RMAN
[1]
deleting
[1]
dynamic
[1]
executing
[1]
listing names of
[1]
managing
[1]
printing
[1]
substitution variables in
[1]
stuck recovery
[1]
substitution variables, FORMAT parameter
[1]
,
[2]
,
[3]
substitution variables, stored scripts
[1]
suspend/resume mode
[1]
SUSPEND clause
ALTER SYSTEM statement
[1]
suspending a database
[1]
SWITCH command
[1]
SYSBACKUP privilege
[1]
system backup to tape
[1]
system time
changing
effect on recovery
[1]
T
tables, recovery of dropped
[1]
tablespace point-in-time recovery
performing on dropped tablespaces
[1]
planning
[1]
preparing the auxiliary instance
[1]
restrictions
[1]
why perform
[1]
tablespaces
backups
offline
[1]
online
[1]
backups, in PDBs
[1]
backups using RMAN
[1]
excluding from backups
[1]
excluding from RMAN backups
[1]
read/write
backing up
[1]
read-only
backing up
[1]
recovering accessible
when database is open
[1]
recovering in PDBs
using Cloud Control
[1]
recovering offline in open database
[1]
transporting across platforms, in PDBs
[1]
transporting with RMAN
[1]
user-managed backups, in CDBs
[1]
user-managed backups, in PDBs
[1]
tape devices
[1]
target database
connecting to
[1]
definition
[1]
,
[2]
terminating RMAN commands
[1]
test disk API
[1]
testing RMAN
backups
[1]
,
[2]
,
[4]
with media management API
[1]
third-party snapshots
specifying recovery time
[1]
time-based recovery
[1]
time format
RECOVER DATABASE UNTIL TIME statement
[1]
time parameters
setting for Recovery Manager use
[1]
trace files, RMAN
[1]
transparent backup encryption
[1]
transparent-mode backup encryption
[1]
transportable tablespaces
creating with RMAN
and Data Pump Export
[1]
and past points in time
[1]
auxiliary destination
[1]
auxiliary instance parameter file
[1]
,
[2]
file locations
[1]
initialization parameters
[1]
cross-platform
[1]
recovery
[1]
transporting tablespaces
[1]
trial recovery
[1]
,
[2]
,
[3]
tuning Recovery Manager
V$ views
[1]
U
UNAVAILABLE option
of CHANGE
[1]
UNCATALOG option
CHANGE command
[1]
deleting repository records
[1]
undo optimization, backup
[1]
,
[2]
unrecoverable objects
recovery
[1]
UNREGISTER DATABASE command
[1]
unregistering databases
[1]
UNTIL TIME option
RECOVER command
[1]
upgrading the recovery catalog
[1]
user errors
definition
[1]
recovery from
[1]
user-managed backups
backup mode
[1]
,
[2]
control files
[1]
definition
[1]
determining data file status
[1]
hot backups
[1]
,
[2]
listing files before
[1]
of CDBs
[1]
offline tablespaces
[1]
of PDBs
[1]
read-only tablespaces
[1]
tablespaces
[1]
tablespaces in CDBs
[1]
tablespaces in PDBs
[1]
verifying
[1]
whole database
[1]
user-managed recovery
ADD DATAFILE operation
[1]
complete
[1]
incomplete
[1]
interrupting
[1]
scenarios
[1]
user-managed restore operations
[1]
V
V$ARCHIVED_LOG view
listing all archived logs
[1]
V$BACKUP_ASYNC_IO view
[1]
V$BACKUP_DATAFILE view
[1]
,
[2]
V$BACKUP_FILES view
[1]
,
[2]
,
[3]
V$BACKUP_PIECE view
[1]
,
[2]
V$BACKUP_REDOLOG view
[1]
V$BACKUP_SET view
[1]
,
[2]
V$BACKUP_SPFILE view
[1]
V$BACKUP_SYNC_IO view
[1]
V$BACKUP view
[1]
V$BLOCK_CHANGE_TRACKING view
[1]
V$CONTROLFILE view
[1]
V$DATABASE_BLOCK_CORRUPTION view
[1]
,
[2]
,
[3]
,
[4]
,
[6]
,
[7]
,
[9]
,
[10]
V$DATABASE_INCARNATION view
[1]
V$DATABASE view
[1]
,
[2]
,
[3]
V$DATAFILE_HEADER view
[1]
,
[2]
V$DATAFILE view
listing files for backups
[1]
V$DIAG_INFO view
[1]
V$EVENT_NAME view
[1]
V$FLASHBACK_DATABASE_LOG view
[1]
,
[2]
,
[3]
V$FLASHBACK_DATABASE_STAT view
[1]
V$INSTANCE view
[1]
V$LOG_HISTORY view
listing all archived logs
[1]
V$LOGFILE view
[1]
,
[2]
,
[3]
V$PARAMETER view
[1]
V$PROCESS view
[1]
,
[2]
V$RECOVER_FILE view
[1]
,
[2]
V$RECOVERY_AREA_USAGE view
[1]
V$RECOVERY_FILE_DEST
[1]
V$RECOVERY_FILE_DEST view
[1]
V$RECOVERY_LOG view
listing logs needed for recovery
[1]
V$RESTORE_POINT view
[1]
V$RMAN_BACKUP_JOB_DETAILS view
[1]
V$RMAN_BACKUP_SUBJOB_DETAILS view
[1]
V$RMAN_ENCRYPTION_ALGORITHMS view
[1]
,
[2]
,
[3]
V$RMAN_OUTPUT view
[1]
V$RMAN_STATUS view
[1]
V$SESSION_LONGOPS view
[1]
V$SESSION_WAIT view
[1]
V$SESSION view
[1]
,
[2]
,
[3]
V$SGASTAT view
[1]
V$SYSSTAT view
[1]
V$TABLESPACE view
[1]
,
[2]
VALIDATE command
SECTION SIZE parameter
[1]
VALIDATE HEADER option, RESTORE command
[1]
validating
CDBs
[1]
PDBs
[1]
validation, RMAN
backups
[1]
,
[2]
,
[6]
database files
[1]
,
[2]
restore operations
[1]
views
for multisection backups
[1]
views, recovery catalog
[1]
,
[2]
virtual private catalogs
dropping
[1]
Volume Shadow Copy Service (VSS)
[1]
,
[2]
W
whole database backups
ARCHIVELOG mode
[1]
inconsistent
[1]
NOARCHIVELOG mode
[1]
preparing for
[1]
using RMAN
[1]
Scripting on this page enhances content navigation, but does not change the content in any way.