Go to main content
45/45
Index
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
Z
Symbols
%d substitution variable
BACKUP FORMAT
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
A
ABORT option
SHUTDOWN statement
1
,
2
,
3
about
backing up CDBs
1
backing up PDBs
1
about, flashback database for CDBs
1
about, flashback database for PDBs
1
active database duplication
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 containers
about backing up
1
backing up
1
,
2
complete recovery
1
application errors
1
application PDBs
backing up
1
complete recovery
1
point-in-time recovery
1
application root
backing up
1
complete recovery
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 instance parameter file
with TRANSPORT TABLESPACE
1
availability
of RMAN backups
1
AVAILABLE option
of CHANGE command
1
B
backing up
application containers
1
application PDBs
1
application root
1
database
1
data files in PDBs
1
sparse PDBs
1
tablespaces in PDBs
1
with Oracle Enterprise Manager Cloud Control
1
backup
to Recovery Appliance
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
,
6
,
7
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
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
,
2
backups
backups of
1
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
Recovery Manager
backups
backing up
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
CDB, rewinding
1
CDB restore point
1
CDB restore points, creating
1
CDB restore points, viewing
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
instance recovery
1
performing point-in-time recovery
1
repairing failures
1
reporting
1
transporting across platforms
1
user-managed backups
1
validating
1
CDBs, restore points
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
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
clean PDB restore points
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
CREATE SCRIPT
1
CROSSCHECK
1
DELETE
1
,
2
,
4
DROP CATALOG
1
DROP DATABASE
1
EXECUTE SCRIPT
1
,
2
EXIT
1
FLASHBACK DATABASE
1
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
application containers
1
application PDBs
1
application root
1
overview
1
procedures
1
sparse databases
1
compressed backups
algorithms
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
CREATE DATAFILE clause, ALTER DATABASE statement
1
CREATE SCRIPT command
1
CREATE TABLESPACE statement
1
CREATE TABLE statement
AS SELECT clause
1
creating
virtual private catalogs
1
creating, PDB restore points
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
over the network
1
PDB to a new CDB
1
,
2
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 Home page, accessing
1
database point-in-time recovery
definition
1
Flashback Database and
1
prerequisites
1
user-managed
1
databases
duplicating
1
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
,
4
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
,
4
DBID
determining
1
problems registering copied database
1
DBMS_PIPE package
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
dropped PDB backups
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
duplexing backup sets
1
,
3
,
4
duplicate databases
active database duplication
1
duplicating
databases
1
sparse CDBs
1
sparse databases
1
sparse PDBs
1
tablespaces
1
duplication
SET NEWNAME
1
using encrypted backups
1
DURATION parameter, BACKUP command
1
E
enabling
Flashback Database
1
encrypted backups
backup-based duplication
1
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
duplicating databases
1
multisection incremental backups
1
recovering tables into new schema
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 CDB, using SQL*Plus
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, and PITR for PDBs
1
flashback database, PDBs
1
FLASHBACK DATABASE command
1
flashback database window
1
Flashback Drop
1
,
2
flashback logs
guaranteed restore points and
1
flashback PDB, local undo
1
flashback PDB, shared undo
1
flashback PDB, using SQL*Plus
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
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
listing
dropped PDB backups
1
local undo, flashback PDB operations
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
,
2
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
duplicate database files
1
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
PDB restore points
1
PDB restore points, creating
1
PDB restore points, namespace
1
PDB restore points, viewing
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
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
PDBs, clean PDB restore point
1
PDBs, flashback database and PITR
1
PDBs, flashback database operation
1
PDBs, restore points
1
PDBs, rewinding
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
PITR, for PDBs
1
pluggable databases
1
point-in-time recovery
application PDBs
1
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
new schema
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
Recovery Appliance
backing up to
1
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
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
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
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
dropping
1
flashing back to
1
guaranteed
compared to storage snapshots
1
listing
1
multitenant environment
1
requirements
1
restore points, creating in CDBs
1
restore points, creating in PDBs
1
restore points, in CDBs
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
encrypted backups
1
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
SET command
DBID option
1
return codes
RMAN
1
REVOKE command
1
rewinding
CDBs
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
ENCRYPTION option
1
MAXCORRUPT 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
shared undo, flashback PDB operations
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
sparse backups
1
sparse CDBs
duplicating
1
sparse databases
duplicating
1
sparse data files
backing up
1
sparse PDBs
backing up
1
duplicating
1
sparse tablespaces
backing up
1
split mirrors
suspend/resume mode
1
using as backups
1
SPOOL command
1
standby databases
1
statements, SQL
ALTER DATABASE
1
,
2
,
3
status
dropped PDB backups
1
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
virtual private catalog
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
,
8
,
9
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
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
viewing, CDB restore points
1
viewing, PDB restore points
1
views
for multisection backups
1
views, recovery catalog
1
,
2
virtual private catalogs
creating
1
dropping
1
upgrading
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
Z
Zero Data Loss Recovery Appliance
1
Scripting on this page enhances content navigation, but does not change the content in any way.
