Index

A B C D E F G H I J K L M N O P Q R S T U V W

Symbols

%b substitution variable

SET NEWNAME, 26.1.1.1

%d substitution variable

BACKUP FORMAT, 2.4.3

%f substitution variable

SET NEWNAME, 26.1.1.1

%I substitution variable

SET NEWNAME, 26.1.1.1

%N substitution variable

SET NEWNAME, 26.1.1.1

%p substitution variable

BACKUP FORMAT, 2.4.3

%s substitution variable

BACKUP FORMAT, 2.4.3

%t substitution variable

BACKUP FORMAT, 2.4.3

%U substitution variable, 9.2.3.1

BACKUP FORMAT, 2.4.3

SET NEWNAME, 26.1.1.1

A

ABORT option

SHUTDOWN statement, 30.5, 31.1.1, 31.1.2

about

backing up CDBs, 4.2.6.1

backing up PDBs, 4.2.6.1

active database duplication, 4.2.5, 25.1.2.1.1

compressing backup sets, 25.2.1.2

creating backup sets in parallel, 25.2.1.3

determining technique used, 25.1.2.1.1

Advanced Security Option, 8.3.5

ADVISE FAILURE command, 15.1.2.4, 15.4

alert log, 12.2.2, 24.1.1

ALLOCATE CHANNEL command, 5.1.4.1, 6.1.1, 9.2.3.1

MAXPIECESIZE option, 6.2.2

ALLOW ... CORRUPTION clause, RECOVER command, 30.6.5

ALTER DATABASE statement

CLEAR LOGFILE clause, 31.7.2.1.3

END BACKUP clause, 29.4.2.3.1

OPEN RESETLOGS clause, 13.8.5

RECOVER clause, 30.2.4.2, 30.3.1, 30.3.2

RESETLOGS option, 30.5

ALTER SYSTEM statement

KILL SESSION clause, 24.4.1

RESUME clause, 29.8.2

SUSPEND clause, 29.8.2, 29.8.2

ALTER TABLESPACE statement

BEGIN BACKUP clause, 29.4.2.1, 29.4.2.2.2

END BACKUP option, 29.4.2.2.2

application errors, 1.1.1.3

archival backups, 1.1.2, 9.7.1, 9.7.1, 12.4.2.2

archived redo log deletion policies, 5.7.1, 5.7.2, 9.5.4

archived redo log files

applying during media recovery, 30.2.1, 30.2.3, 30.2.4.2

backing up, 9.5.3

using RMAN, 9.5

with other backups, 9.5.1.2

backing up, in CDBs, 9.5.5

cataloging, 12.4.3

changing default location, 30.2.4.1

corrupted, 30.6.1

delete after backups, 9.5.6

delete after backups, in CDBs, 9.5.7

deleting, 14.3.1, 30.3.1

deletion after backup, 9.5.1

failover, 9.5.1.1

incompatible format, 30.6.1

location during recovery, 30.2.1

loss of, 30.4

restoring using RMAN, 17.2.5

ARCHIVELOG mode

backups in, 2.4.1

AS SELECT clause

CREATE TABLE statement, 31.5

autobackups, control file, 8.6, 8.6, 9.3.3, 9.7.2

configuring, 5.1.5

format, 5.1.5.1

automated repairs

Data Recovery Advisor, 1.4

automatic channel allocation, 6.1.1

automatic channels, 3.3, 3.3.2

configuring, 6.1.2

naming conventions, 3.3.2

overriding, 6.1

Automatic Diagnostic Repository (ADR), 5.2.4.1, 8.6.2, 12.2.1, 15.1.2.2, 16.1.2.2, 16.1.2.4, 24.1.1

Automatic Storage Management (ASM)

backups to, 9.2.3

Automatic Workload Repository (AWR), 7.5.4

AUTORECOVERY option

SET statement, 30.2.2

auxiliary channels, 25.1.2.3

auxiliary instance parameter file

with TRANSPORT TABLESPACE, 27.2

availability

of RMAN backups, 12.4.2.1

AVAILABLE option

of CHANGE command, 12.4.2.1

B

backing up

data files in PDBs, 9.4.7

database, 9

tablespaces in PDBs, 9.4.7

with Oracle Enterprise Manager Cloud Control, 1.5.3

backup and recovery

definition, 1.1

introduction, 1

solutions, 1.2

strategy, 1.1.1

user-managed, 1.2

BACKUP command, 2.4, 2.4.1, 2.4.2, 3.3.2, 3.7.2.3, 5.4.5, 5.6.1, 6.1.1, 6.2.1, 6.2.4, 8.1, 8.1, 8.3, 9.1.2, 9.5.4

ALLOW INCONSISTENT option, 28.10.1.1, 28.10.1.1

ARCHIVELOG option, 9.5.1.2, 9.5.3

AS COMPRESSION BACKUPSET option, 9.2.5

AS COPY option, 2.4, 8.4.1, 8.4.1

BACKUPSET option, 6.2.6.1, 6.2.6.1, 8.5, 8.5.2.1, 8.5.2.1, 8.5.2.1, 9.8.1, 9.8.1, 9.8.2

CHANNEL option, 5.1.4.3

COMPRESSED BACKUPSET option, 9.2.5

COPIES parameter, 8.5, 8.5.1

COPY OF option, 8.5, 8.5.2.2, 9.8.1, 9.8.3

CURRENT CONTROLFILE option, 9.3.3, 9.3.3.2

DATABASE option, 9.3.1

DATAFILE option, 9.3.2

DATAPUMP option, 28.6.3, 28.8.1, 28.8.1, 28.10.2

DB_FILE_NAME_CONVERT parameter, 8.4.1, 8.4.1

DELETE INPUT option, 9.5.6, 9.5.6, 12.5.1.1

DELETE option, 9.5.1

DEVICE TYPE clause, 5.1.2, 5.6.1, 9.2.1, 9.2.1, 9.3.3.2

DURATION parameter, 10.8.2

FILESPERSET parameter, 8.3.9

FOR RECOVER OF COPY option, 9.6.4.1

FOR TRANSPORT parameter, 28.6.2, 28.7.1

FORMAT parameter, 2.4.3, 5.2.3, 5.2.5.1, 8.3.6, 8.5.1, 9.2.3

INCREMENTAL LEVEL 1 parameter, 28.10.1.1, 28.10.1.1, 28.10.2, 28.10.2

INCREMENTAL LEVEL O parameter, 28.10.1.1, 28.10.2

INCREMENTAL option, 2.4.4, 2.4.4, 2.4.4.1, 9.6, 9.6.3, 9.6.3.1

KEEP option, 9.7.1, 9.7.3.1, 9.7.3.1, 9.7.4

MAXSETSIZE parameter, 10.1

NOT BACKED UP clause, 9.5.4

PLUS ARCHIVELOG option, 9.5.1.2, 9.5.1.2

PROXY ONLY option, 8.3.10, 8.3.10

PROXY option, 8.3.10

RECOVERY AREA option, 9.8.1

SECTION SIZE parameter, 8.3.1, 9.2.6, 10.1.3

SPFILE option, 9.3.4

TABLESPACE option, 9.3.2

TAG parameter, 2.4.3, 9.2.4.1, 9.2.4.1

TO PLATFORM parameter, 28.6.2, 28.8.1

VALIDATE option, 2.4.5, 15.1.2.2, 15.3, 16.2

BACKUP CONTROLFILE clause

ALTER DATABASE statement, 29.1.1, 29.1.1

BACKUP COPIES parameter

CONFIGURE command, 6.2.3

backup encryption, 6.2.6.1, 8.3.5, 14.2.1

decrypting backups, 17.2.6

default algorithm, 6.2.6

dual-mode, 6.2.6.1.3, 10.6.4

overview, 10.6

password, 6.2.6.1.2, 10.6.3

transparent, 6.2.6.1.1, 10.6.2

backup mode, 8.4.2

ending with ALTER DATABASE END BACKUP, 29.4.2.3.1

for online user-managed backups, 29.4.2.1, 29.10

instance failure, 29.4.2.3

backup optimization, 9.5.4

configuring, 5.6, 10.2

definition, 5.6.1, 9.5.4

disabling, 5.6.1, 5.6.3

enabling, 5.6.1, 5.6.3

redundancy and, 5.6.2.2

retention policies and, 5.6.2

backup pieces, 8.3.1

definition, 2.4

maximum size, 6.2.2

names, 8.3.6

names on tape, 5.2.5.1

backup retention policies, 1.1.2, 3.6, 5.4.1

affect on backup optimization, 5.6.2

configuring, 5.5, 5.5

configuring for redundancy, 5.5.1

definition, 8.8

disabling, 5.5.3

exempt backups, 9.7.1, 12.4.2.2

recovery window, 8.8

recovery windows, 5.5.2

redundancy, 8.8, 8.8.2

backup sets, 2.4, 8.1

backing up, 8.5.2.1, 8.5.2.1, 9.8.1

compressed, 5.1.3, 6.2.5, 9.2.5

configuring as default, 5.1.3

configuring maximum size, 6.2.1

crosschecking, 12.4.1.1

duplexing, 10.4

how RMAN generates, 8.3.8

limiting size, 8.3.8

maximum size, 6.2.1, 10.1

multiplexed, 2.4, 6.2.1, 8.3.9, 9.2.4.2, 23.2.1.1

naming, 8.3.6

overview, 8.3

specifying maximum size, 8.3.7

specifying number, 8.3.8

testing restore of, 17.2.4

Backup Solutions Program (BSP), 3.5.3, 3.5.3

backup strategy

fast recovery area, 5.4

backup tags, RMAN, 9.2.4

backup techniques, comparison, 1.2

backup windows, 10.8.1

backups

archival, 1.1.2, 9.7.1

archived redo log files, in CDBs, 9.5.5

archived redo logs

using RMAN, 9.5

availability, 12.4.2.1

backup sets, 9.8.1

backups of, 8.5.2.1

closed, 29.2

consistent, 29.2, 29.2

making using RMAN, 8.1.1

control file, 9.3.3, 29.6

control files, 29.6

binary, 29.6.1

correlating RMAN channels with, 24.2.2.2.1, 24.2.2.2.2

crosschecking, 12.4.1, 12.4.1

cumulative incremental, 8.7.1.2

data file

using RMAN, 9.8.2, 9.8.3

DBVERIFY utility, 29.11

default type for RMAN, 5.1.3

determining data file status, 29.1.2

duplexing, 6.2.3, 6.2.3, 10.4

excluding tablespaces from backups, 6.2.4

exempt from retention policy, 12.4.2.2

expired, deleting, 12.5.4

generating reports for, 11.1.2, 11.3.1

image copies, 8.4

inconsistent, 29.2

making using RMAN, 8.1.1

incremental, 8.7.1.1, 9.6, 10.4.1, 10.4.2

incrementally updated, 9.6.4

listing files needed, 29.1

logical, 1.1.1

long-term, 1.1.2

managing, 12.1.1

multisection, 3.3.2, 8.3.1, 16.2

NOARCHIVELOG mode, 9.3.5

obsolete, 8.8.3, 12.5.5

offline, 29.4.1, 29.4.1, 29.4.1

offsite, 17.2.3.1

optimizing, 5.6.1, 9.5.4

orphaned, 14.3.2.4

PDBs, using Oracle Enterprise Manager Cloud Control, 9.4.6

PDBs, using RMAN, 9.4.5

physical, 1.1.1

previewing, 17.2.3

read-only tablespaces, 29.4.2.4

recovering pre-RESETLOGS, 18.6.3

recovery catalog, 13.6.1, 13.6.1

Recovery Manager, 9.1.2

reporting objects needing backups, 11.3.2

restartable, 10.7.1

restoring user-managed, 30.2.1

root

using Oracle Enterprise Manager Cloud Control, 9.4.4

using RMAN, 9.4.3

server parameter files, 9.3.4

skipping files during, 10.3

split mirror, 8.4.2

using RMAN, 10.5

stored scripts, 13.1.2.4, 13.7.1

tablespace, 29.4.2.2

using RMAN, 9.3.2, 9.8.2, 9.8.3

testing RMAN, 16.1.2.4, 16.2, 16.2, 16.3, 16.3

using media manager, 5.2.4.2

user-managed, 29

using storage snapshots, 29.10

validating, 16.2, 16.2, 16.3, 16.3

verifying, 29.11

whole CDB, 9.4.2

whole database, 9.3.1, 9.3.1, 29.2

BEGIN BACKUP clause

ALTER TABLESPACE statement, 29.4.2.1

binary compression for backups, 9.2.5

block change tracking, 1.2, 8.7.2, 9.6.5, 9.6.5

disk space used for, 9.6.5.1.3

enabling and disabling, 9.6.5.2, 9.6.5.2, 9.6.5.3, 9.6.5.3

moving the change tracking file, 9.6.5.5

block corruptions, 1.1.1.3

stored in V$DATABASE_BLOCK_CORRUPTION, 16.2

block media recovery, 1.1.1.3, 16.1.2.4

automatic, 19.1.2

BSP, 3.5.3

C

cancel-based media recovery, 30.4.2

canceling RMAN commands, 24.4

CATALOG command, 12.4.3, 12.4.3

START WITH parameter, 13.4

CDBs

about backup and recovery of, 4.2.6.1

backing up, 9.4.2

complete recovery, 17.4.1

after switching to a copy, 17.4.7

using Oracle Enterprise Manager Cloud Control, 17.4.4

complete restore, 17.4

connecting to, 4.2.6

crash recovery, 30.3.3

Data Recovery Advisor, 15.1.4

diagnose failures, 15.1.4

duplicating, 25.1.4

flashback, 18.4.3

instance recovery, 30.3.3

performing point-in-time recovery, 18.5.3.1

repairing failures, 15.1.4

reporting, 11.1.4.1

rewinding beyond PDB point-in-time recovery, 18.4.3

transporting across platforms, 28.11.1

user-managed backups, 29.3

validating, 16.5.1

CHANGE command

AVAILABLE option, 12.4.2.1

DB_UNIQUE_NAME parameter, 13.8.3

RESET DB_UNIQUE_NAME option, 3.7.2.2

UNCATALOG option, 12.4.4.1

CHANGE FAILURE command, 15.6

channels, RMAN, 3.3, 3.3

auxiliary, 25.1.2.3

configuring, 5.1.4

configuring advanced options, 6.1

definition, 3.3

generic, 5.1.4.1

naming conventions, 3.3.2

Oracle RAC environment, 6.1.2

parallel, 5.1.4.3

character sets

setting for use with RMAN, 4.4

circular reuse records, 12.2.1

CLEAR LOGFILE clause

of ALTER DATABASE, 31.7.2.1.3

client, RMAN, 2.1, 2.1, 3.1, 3.5

cold failover cluster

definition, 29.4.2.3

command files, RMAN, 2.4.6

command interface

RMAN, 3.2

commands, Recovery Manager

ADVISE FAILURE, 15.1.2.4, 15.4

ALLOCATE CHANNEL, 5.1.4.1, 6.1.1, 6.2.2, 9.2.3.1

BACKUP, 2.4, 2.4, 2.4.1, 2.4.2, 2.4.3, 2.4.4, 2.4.4, 2.4.4.1, 2.4.5, 3.3.2, 3.7.2.3, 5.1.2, 5.1.4.3, 5.2.3, 5.2.5.1, 5.4.5, 5.4.5, 5.6.1, 5.6.1, 6.1.1, 6.2.1, 6.2.4, 6.2.6.1, 8.1, 8.3, 8.3.1, 8.3.9, 8.3.10, 8.3.10, 8.4.1, 8.4.1, 8.5, 8.5, 8.5.1, 8.5.1, 8.5.2.1, 8.5.2.2, 9.1.2, 9.2.1, 9.2.4.1, 9.2.5, 9.3.1, 9.3.2, 9.3.2, 9.3.3, 9.3.3.2, 9.3.4, 9.5.1, 9.5.1.2, 9.5.1.2, 9.5.4, 9.5.4, 9.5.6, 9.6, 9.6.3, 9.6.3.1, 9.6.4.1, 9.7.1, 9.7.3.1, 9.7.4, 9.8.1, 9.8.1, 9.8.1, 9.8.2, 9.8.3

PROXY ONLY option, 8.3.10

PROXY option, 8.3.10

BACKUP CURRENT CONTROLFILE, 9.3.3.2

canceling, 24.4

CATALOG, 12.4.3, 12.4.3, 12.4.3

CHANGE, 3.7.2.2, 12.4.1, 12.4.1

CHANGE FAILURE, 15.6

CONFIGURE, 3.7.1, 5.1.4.1, 5.5, 5.8, 6.1.1, 6.2.2, 6.2.6.2, 6.3

CREATE CATALOG, 13.2.3, 13.5.2.3

CREATE SCRIPT, 13.7.2

CROSSCHECK, 12.4.1, 12.4.1

DELETE, 12.4.1.1, 12.4.3.1, 12.4.3.1, 12.5

DROP CATALOG, 13.9

DROP DATABASE, 12.6

DUPLICATE, 25

EXECUTE SCRIPT, 13.7.1, 13.7.4

EXIT, 2.2

FLASHBACK DATABASE, 13.8.5

GRANT, 13.5.2.2, 13.5.3.1

how RMAN interprets, 3.2

IMPORT CATALOG, 13.8.7

LIST, 2.5.1, 2.5.1, 11.1.2, 11.2, 11.2, 11.2.1, 13.8.5, 15.2

INCARNATION option, 11.2.4, 13.8.5

MAXSETSIZE, 6.2.1

piping, 4.6

PRINT SCRIPT, 13.7.6

RECOVER, 14.3

REPAIR FAILURE, 15.5.1, 15.6

REPLACE SCRIPT, 13.7.3

REPORT, 2.5.2, 11.3.1, 11.3.2

NEED BACKUP option, 11.3.2

RESET DATABASE

INCARNATION option, 13.8.5

RESTORE, 17.2.1.2, 17.2.1.2

RESYNC CATALOG, 13.6.2, 13.8.2, 13.8.2.3

FROM CONTROLFILECOPY option, 13.6.2

REVOKE, 13.5.2.4

SET, 6.2.6.1.2

SHOW, 2.3, 5.1.1

SPOOL, 15.5.1

SWITCH, 17.3.4

terminating, 24.4, 24.4

UNREGISTER DATABASE, 13.8.4

UPGRADE CATALOG, 13.8.6.1

VALIDATE, 15.1.2.2, 15.3, 16.2

commands, SQL*Plus

RECOVER

UNTIL TIME option, 30.4.2

SET, 30.2.2, 30.2.4.2, 30.3.1, 30.3.2

comments in RMAN syntax, 4.5.3

COMPATIBLE initialization parameter, 6.2.6.1

complete recovery

overview, 17.1

procedures, 30.3

compressed backups, 5.1.3, 9.2.5

algorithms, 6.2.5

compressing

backup sets, during active database duplication, 25.2.1.2

CONFIGURE command

AUXNAME option, 6.3

BACKUP OPTIMIZATION option, 5.6.3

CHANNEL option, 5.1.4.1, 6.1.1

CONTROLFILE AUTOBACKUP option, 8.6.1, 9.7.2

DB_UNIQUE_NAME option, 5.8

ENCRYPTION option, 6.2.6.2

EXCLUDE option, 6.2.4

FOR DB_UNIQUE_NAME option, 3.7.1

MAXPIECESIZE option, 6.2.2

MAXSETSIZE option, 6.2.1

RETENTION POLICY clause, 8.8

RETENTION POLICY option, 5.5

configuring media managers, 5.2.3

installing, 5.2.1

prerequisites, 5.2.1

configuring Recovery Manager

autobackups, 5.1.5, 5.1.5.1, 8.6

backup optimization, 5.6

backup retention policies, 5.5

backup set size, 6.2.1

default backup type, 5.1.3

default devices, 5.1.2

overview, 5.1

shared server, 6.5

snapshot control file location, 6.4

specific channels, 6.1.2

tablespace exclusion for backups, 6.2.4

connecting

to CDBs, 4.2.6

to PDBs, 4.2.6

consistent backups, 8.1.1

using RMAN, 8.1.1

whole database, 29.2

control file autobackups, 12.2.3

after structural changes to database, 8.6

configuring, 5.1.5, 5.1.5, 5.1.5, 5.1.5.1, 5.1.5.1, 8.6, 8.6

default format, 8.6.2

format, 5.1.5.1

control files

backups, 29.1.1, 29.6

binary, 29.6.1

including within database backup, 9.3.3.1

manual, 9.3.3.2

recovery using, 20.3.1

using RMAN, 9.3.3

circular reuse records, 12.2.1

configuring location, 5.4.4

creating after loss of all copies, 31.3

finding file names, 29.1.1

multiplexed, 5.4.1, 5.4.4, 12.2.3, 17.2.1.1, 29.1.1, 30.2.1, 31.1.1

loss of, 31.1

multiplexing, 12.2.3

re-created, 31.3

restoring, 20.3.1.1, 31.1.1, 31.1.2

snapshot, 13.8.2.1

specifying location of, 6.4

user-managed restore after loss of all copies, 31.3

CONTROL_FILE_RECORD_KEEP_TIME initialization parameter, 12.2.1, 12.2.2, 13.8.2.2.4

CONTROL_FILES initialization parameter, 5.4.4.2, 20.3.1.1, 21.6.1.2, 31.1.2

CONVERT command

ALLOW INCONSISTENT option, 28.10.1.1, 28.10.1.1

COPIES option

BACKUP command, 10.4.2

corrupt blocks, 14.1.1.2, 16.1.2.1, 30.6.1

recovering, 19.1.2.1, 19.1.2.1

RMAN and, 10.7.1

crash recovery

of CDBs, 30.3.3

CREATE CATALOG command, 13.2.3, 13.5.2.3

CREATE DATAFILE clause, ALTER DATABASE statement, 31.4

CREATE SCRIPT command, 13.7.2

CREATE TABLE statement

AS SELECT clause, 31.5

CREATE TABLESPACE statement, 31.2.3

CROSSCHECK command, 12.4.1, 12.4.1

crosschecking, RMAN, 2.6, 12.1.2.2.1, 12.4.1, 12.4.1

definition, 12.4.1.1

recovery catalog with the media manager, 12.4.1.1

cross-platform data transport

data pump destination, 28.6.1

cross-platform transport

data files, using image copies, 28.4

databases

using backup sets, 28.7

using image copies, 28.5

inconsistent tablespaces, 28.10

about, 28.9

example, 28.10.2

steps, 28.10.1

methods, 28.1.2

using backup sets, 28.6

using image copies, 28.2

of CDBs, 28.11.1

of PDBs, 28.11.2

read-only tablespaces

using backup sets, 28.8

using image copies, 28.3

tablespaces in PDBs, 28.11.3

tablespaces, DataPump export dump file, 28.6.3

cross-platform transportable tablespace, 28

cumulative incremental backups, 2.4.4, 2.4.4.1, 8.7.1, 8.7.1.2

D

data blocks, corrupted, 1.1.1.3, 1.2, 2.7.1, 2.9.4, 14.1.1.2, 15.3, 15.6, 16.2, 19.1.1, 30.6.1, 30.6.1

data dictionary views, 29.4.1, 29.4.2.1, 29.4.2.4

data files

backing up, 9.3.2, 9.8.2, 9.8.3, 29.4.1

backing up, in PDBs, 9.4.7

determining status, 29.1.2

listing, 29.1

losing, 30.2.1

restoring, 14.2

transporting across platforms, 28.4

Data Guard environment, 3.7.2.3

archived log deletion policies, 5.7.1.2

changing a DB_UNIQUE_NAME, 13.8.3

configuring RMAN, 5.8

reporting in a, 11.1.3

RMAN backups, 9.1.2

RMAN backups, accessibility of, 3.7.2.3

RMAN backups, association of, 3.7.2.2

RMAN backups, interchangeability of, 3.7.2.1, 9.3.3

RMAN usage, 3.7

data integrity checks, 1.4, 15.1.2.2, 15.3

data preservation, definition of, 1.1.2

data protection

definition, 1.1.1

data pump destination, 28.6.1

Data Recovery Advisor, 2.7, 11.2.1, 14.1.2

automated repairs, 1.4

data integrity checks, 15.1.2.2, 15.3

failure consolidation, 15.1.2.3.3

failure priority, 15.1.2.3.2

failures, 15.1.2.1, 15.1.2.3

feasibility checks, 15.1.2.4

for CDBs, 15.1.4

overview, 1.4

purpose, 15.1.1

repair options, 15.4

repairing failures, 15.5.1

repairs, 15.1.2.1, 15.1.2.4, 15.1.2.4.1

supported configurations, 15.1.2.5

user interfaces, 15.1.2.1

data repair

overview, 14.1.1

techniques, 14.1.2

data transfer, RMAN, 1.1.3

database connections

Recovery Manager

auxiliary database, 4.2.5

hiding passwords, 4.2.7

without a catalog, 4.2

SYSBACKUP required for RMAN, 4.2.2

types in RMAN, 4.2.1

database duplication

initialization parameter file, 25.2.7

starting auxiliary instance, 25.2.7

Database Home page, accessing, 1.5.2

database point-in-time recovery, 18, 18.5, 18.5

definition, 18.1.2.1

Flashback Database and, 7.1.1

prerequisites, 18.5.1

user-managed, 30.4

databases

listing for backups, 29.1

media recovery procedures, user-managed, 30

media recovery scenarios, 31

multitenant container, 9.4

recovery

after control file damage, 31.1.1, 31.1.2

registering in recovery catalog, 13.3.2, 13.3.2

reporting on schemas, 11.3.5

suspending, 29.8.1

transporting across platforms

using backup sets, 28.7

using image copies, 28.5

unregistering from recovery catalog, 13.8.4

DB_BLOCK_CHECKSUM initialization parameter, 16.1.2.1

DB_CREATE_FILE_DEST initialization parameter, 5.4.4.1, 9.6.5.2, 17.3.2

DB_FILE_NAME_CONVERT initialization parameter, 21.6.1.2

DB_FLASHBACK_RETENTION_TARGET initialization parameter, 5.4.2, 5.4.2.1, 5.4.2.3

DB_LOST_WRITE_PROTECT initialization parameter, 6.6

DB_NAME initialization parameter, 21.6.1.2

DB_RECOVERY_FILE_DEST initialization parameter, 2.1, 5.4.2, 5.4.4.1

DB_RECOVERY_FILE_DEST_SIZE initialization parameter, 2.1, 5.4.2

DB_UNIQUE_NAME initialization parameter, 3.7, 3.7.2.2, 5.8, 11.1.3

DBA_DATA_FILES view, 29.4.1, 29.4.2.1, 29.4.2.4

DBID

determining, 17.2.2

problems registering copied database, 13.1.2.1

setting with DBNEWID, 13.3.1

DBMS_PIPE package, 4.6, 4.6

DBNEWID utility, 13.3.1, 25.1.1

DBPITR, 18.5

DBVERIFY utility, 29.11

DELETE command, 12.4.3.1, 12.5, 12.5.3

EXPIRED option, 12.4.1.1, 12.5.4

OBSOLETE option, 8.8.3, 8.8.3, 12.5.5

deleting

archived redo log files, 9.5.6

archived redo log files, in CDBs, 9.5.7

deleting backups, 2.6.2, 12.5, 12.5, 12.5.1.1, 12.5.3

deletion policies, archived redo log, 5.7.1

enabling, 5.7.2

devices, configuring default, 5.1.2

diagnose failures

in CDBs, 15.1.4

differential incremental backups, 2.4.4, 8.7.1, 8.7.1.1

direct ancestral path, 14.3.2.2, 18.4.2, 18.6.2

disabling

Flashback Database, 7.5.2

disaster recovery, 1.1.2

definition, 1.1.1.1

disconnecting

from Recovery Manager, 2.2

disk API, 5.2.4

disk failures, 1.1.1.1

disk usage

monitoring, 12.3.2

DROP DATABASE command, 12.6

dropped tables, retrieving, 18.3.1

dropping a database, 12.6

dropping the recovery catalog, 13.9

dual mode backup encryption, 6.2.6.1.3, 6.2.6.1.3

dual-mode backup encryption, 10.6.4

dummy API, 5.2.4

duplexing backup sets, 6.2.3, 6.2.3, 8.5.1, 10.4

DUPLICATE command, 25

NOOPEN clause, 25.2.1.4

restarting after a failure, 25.6

duplicate databases

active database duplication, 4.2.5, 25.1.2.1.1

advantages of using backup sets, 25.1.2.1.1

allocating channels, 25.4.2

configuring channels, 25.4.2

using backup sets, 25.1.2.1.1

using image copies, 25.1.2.1.1

active database duplication, connecting, 25.3, 25.3

active database duplication, encrypting backup sets, 25.2.1.1

backup-based duplication, 25.1.2.1.2

configuring channels, 25.4.1

no target connection, 25.1.2.1.2

no target/recovery connection, 25.1.2.1.2

target connection, 25.1.2.1.2

CDBs, 25.1.4

generating file names, 25.2.2

how RMAN creates, 25.1.2.3

PDBs, 25.1.5

restarting after failed DUPLICATE, 25.6

skipping offline normal tablespaces, 26.5.2

skipping read-only tablespaces, 26.5

specifying the state, 25.2.1.4

tablespaces in PDBs, 25.1.5

duplication

restarting after a failure, 25.6

DURATION parameter, BACKUP command, 10.8.2

E

enabling

Flashback Database, 7.5.1

encrypted backups, 10.6, 14.2.1

decrypting, 17.2.6

environment variables

NLS_DATE_FORMAT, 4.4

NLS_LANG, 4.4

error codes

media manager, 24.1.3.2

RMAN, 24.1, 24.1.3, 24.1.3.1

error messages, RMAN

interpreting, 24.1.4

error stacks, RMAN

interpreting, 24.1.4

example

multisection incremental backups, 9.2.6

examples

recovering using third-party snapshots, 30.2.5

rolling forward a physical standby, 20.6.5

EXECUTE SCRIPT command, 13.7.4

EXIT command, 2.2

exiting RMAN, 2.2

expired backups, 8.8, 12.4.1.1

deleting, 12.5.4

EXPIRED option

DELETE command, 12.5.4

F

failover, when restoring files, 14.2.2

failures

definition, 1.1.1

media, 1.1.1.1

failures, Data Recovery Advisor, 15.1.2.1, 15.1.2.3

consolidation, 15.1.2.3.3

priority, 15.1.2.3.2

fast recovery area, 3.1, 3.6, 18.1.2.3.1

autobackups, 5.1.5.1

changing locations, 12.3.5

configuring, 5.4

definition, 2.1

disabling, 12.3.6

effect of retention policy, 8.8.4

enabling, 5.4.2

flashback database window, 7.1.2

maintaining, 12.3

monitoring disk usage, 12.3.2

monitoring usage, 12.3.2

Oracle Managed Files, 5.4.1.1

PDB point-in-time recovery, 18.5.3

permanent and impermanent files, 5.4.1

RMAN files in, 5.4.5

setting location, 5.4.2.2

setting size, 5.4.2.1

snapshot control files, 6.4

space management, 5.4.1.2

feasibility checks, Data Recovery Advisor, 15.1.2.4

file names, listing for backup, 29.1

file sections, 8.3.7, 8.3.9, 10.1.3, 16.2

flashback

CDB, 18.4.3

flashback data archive

definition, 1.3.1

Flashback Database, 1.3.2, 2.8, 14.1.2, 18

determining the flashback database window, 18.4.2

disabling, 7.5.2

enabling, 7.5.1

flashback logs, 1.3.2, 7.2.1

limitations, 7.1.3

monitoring, 7.5.4

overview, 1.3.2

prerequisites, 18.4.1

purpose, 18.1.1

requirements, 7.3

space management, 12.3.3

estimating disk space requirement, 5.4.2.3

tuning performance, 7.5.3

FLASHBACK DATABASE command, 18.4.2

flashback database window, 7.1.2

Flashback Drop, 18.1.2.3.2, 18.3.1

flashback logs, 1.3.2, 2.8, 7.1.1, 12.3.3, 18.1.2.3.1

guaranteed restore points and, 7.1.5

flashback retention target, 7.1.1

Flashback Table, 18.1.2.3.2

using, 18.2.1, 18.2.2

FLASHBACK TABLE statement, 18.2.1, 18.2.1, 18.2.2

Flashback Technology, 18.1.2

logical features, 18.1.2.3.2

overview, 1.3

flashback undrop

restoring objects, 18.3.3

foreign data file, 28.6.1

foreign data file copy, 28.6.1

foreign tablespace, 28.6.1

formats, for RMAN backups, 9.2.3

fractured blocks, 8.2

detection, 8.2

full backups, 8.7

incremental backups and, 2.4.4

G

generic channels

definition, 5.1.4.1

GRANT command, 13.5.2.2, 13.5.3.1

groups, redo log, 31.7.1, 31.7.1, 31.7.2, 31.7.2

guaranteed restore points, 1.3.2, 5.4.2.1

alternative to storage snapshots, 7.1.5.1

compared to storage snapshots, 7.1.5.1

creating, 7.4.1

flashback logs and, 7.1.5

requirements, 7.3

space usage in fast recovery area, 7.4.2

H

Health Monitor, 15.1.2.2

hot backup mode

failed backups, 29.4.2.3, 29.4.2.3.1

for online user-managed backups, 29.4.2.1

I

image copies, 2.4, 8.1, 8.4

definition, 8.4

testing restore of, 17.2.4

IMPORT CATALOG command, 13.8.7

INCARNATION option

LIST command, 11.2.4, 13.8.5

RESET DATABASE command, 13.8.5, 13.8.5

incarnations

database, 11.2.4, 14.3.2, 18.4.2, 18.6.2

INCLUDE CURRENT CONTROLFILE option

BACKUP command, 9.3.3.1

incomplete media recovery, 30.4

incomplete recovery

defined, 18.5

in Oracle Real Application Clusters configuration, 30.2.2.2

overview, 14.3

time-based, 30.4.2

with backup control file, 30.2.2.2

inconsistent backups, 8.1.2

using RMAN, 2.4.1, 8.1.1

inconsistent tablespaces

transporting across platforms, 28.10

incremental backups, 2.4.4, 9.6

block change tracking, 9.6.5

differential, 8.7.1.1

how RMAN applies, 14.3.1

making, 9.6

multisection incremental backups, 9.2.6

using RMAN, 10.4.1, 10.4.2

initialization parameter file, 14.3

initialization parameters

CONTROL_FILES, 20.3.1.1, 31.1.2

DB_FILE_NAME_CONVERT, 21.6.1.2

DB_NAME, 21.6.1.2

LARGE_POOL_SIZE, 23.4.3

LOCK_NAME_SPACE, 21.6.1.2

LOG_ARCHIVE_DEST_n, 30.2.3

LOG_ARCHIVE_FORMAT, 30.2.3

LOG_FILE_NAME_CONVERT, 21.6.1.2

instance failures

backup mode and, 29.4.2.3

instance recovery

of CDBs, 30.3.3

integrity checks, 16.1.2

interpreting RMAN error stacks, 24.1.4

interrupting media recovery, 30.2.6

I/O errors

effect on backups, 10.7.1

J

jobs, RMAN

monitoring progress, 23.3.1

querying details about, 11.4.1

K

KEEP option

BACKUP command, 12.4.2.2

L

level 0 incremental backups, 2.4.4, 8.7.1, 8.7.1, 8.7.2

level 1 incremental backups, 8.7.1.1, 8.7.1.2

LIST command, 2.5.1, 11.1.2, 11.2, 11.2.1

FAILURE option, 15.2

INCARNATION option, 13.8.5

LOCK_NAME_SPACE initialization parameter, 21.6.1.2

log sequence numbers, 30.2.1

LOG_ARCHIVE_DEST_n initialization parameter, 5.4.4.3, 5.4.5, 17.2.5, 30.2.2, 30.2.3, 30.2.3, 30.3.1, 30.4.1, 30.4.2

LOG_ARCHIVE_FORMAT initialization parameter, 30.2.3

LOG_FILE_NAME_CONVERT initialization parameter, 21.6.1.2

logical backups, 1.1.1

logical block corruption, 16.1.2.2

LOGSOURCE variable

SET statement, 30.2.4.2, 30.3.1, 30.3.2

long waits, 23.3.2.2

loss of

inactive log group, 31.7.2.1

lost writes, detecting, 6.6

M

maintenance commands, RMAN, 2.6, 3.3.2, 12.1.2

Data Guard environment, 12.1.2.2

managing RMAN metadata, 11, 12, 12

MAXPIECESIZE parameter

SET command, 5.2.5.1

MAXSETSIZE parameter

BACKUP command, 6.2.1, 10.1

CONFIGURE command, 6.2.1

media failures, 1.1.1

archived redo log file loss, 30.4

complete recovery, 30.3

complete recovery, user-managed, 30.3

control file loss, 31.3

datafile loss, 30.2.1

definition, 1.1.1.1

NOARCHIVELOG mode, 30.5

online redo log group loss, 31.7.2

recovery, 30.3

recovery procedures

examples, 30.2.1

Media Management Layer (MML) API, 3.5, 6.2.2

media managers, 3.1, 3.3.1, 3.5, 3.5.2

backing up files, 3.5.1

backup piece names, 5.2.5.1

Backup Solutions Program, 3.5.3

catalog, 3.1

configuring for use with RMAN, 5.2.3

crosschecking, 12.4.1.1

definition, 2.1

error codes, 24.1.3.2

file restrictions, 5.2.5.1

installing, 5.2.1

library location, 5.2.2

linking

testing, 5.2.4

linking to software, 3.5.2, 5.2.2

multiplexing backups, 8.3.9

prerequisites for configuring, 5.2.1

sbttest program, 24.3.1

testing, 5.2.4

testing backups, 5.2.4.2

testing the API, 24.3

third-party, 5.2

troubleshooting, 5.2.4.2

media recovery, 8.7.4

ADD DATAFILE operation, 31.2.3

after control file damage, 31.1.1, 31.1.2

applying archived redo logs, 30.2.1

cancel-based, 30.4, 30.4.2

complete, 30.3

closed database, 30.3.1

complete, user-managed, 30.3

corruption

allowing to occur, 30.6.4

errors, 30.6.1

incomplete, 30.4

interrupting, 30.2.6

lost files

lost archived redo log files, 30.4

lost data files, 30.2.1

lost mirrored control files, 31.1

NOARCHIVELOG mode, 30.5, 30.5

offline tablespaces in open database, 30.3.2

online redo log files, 31.7

parallel, 30.2.7

problems, 30.6.1, 30.6.1, 30.6.2, 30.6.3

restarting, 30.2.6

restoring

whole database backups, 30.5

resuming after interruption, 30.2.6

roll forward phase, 30.2.1

scenarios, 31

time-based, 30.4

transportable tablespaces, 31.6

trial, 30.6.6, 30.6.6, 30.6.6.1

troubleshooting, 30.6.1, 30.6.1

user-managed, 30

using Recovery Manager, 14.3

metadata, RMAN, 3.4, 11, 12, 13

mirrored files

backups using, 10.5

splitting, 29.8.1

suspend/resume mode, 29.8.1

using RMAN, 10.5

monitoring fast recovery area usage, 12.3.2

monitoring RMAN, 24.2

MTTR, 15.1.1

multiplexed backup sets, 6.2.1, 8.3.9, 9.2.4.2, 23.2.1.1

multiplexed control files, 5.4.1, 5.4.4, 12.2.3, 12.2.3, 17.2.1.1, 29.1.1, 30.2.1, 31.1.1

multisection backups, 3.3.2, 8.3.1, 8.3.7, 8.3.9, 10.1.3, 16.2

views, 9.2.6, 9.2.6

multisection incremental backups, 9.2.6

example, 9.2.6

multitenant container databases, 4.2.6

N

naming backup sets, 8.3.6

NLS_DATE_FORMAT environment variable, 4.4

NLS_LANG environment variable, 4.4

NOARCHIVELOG mode

backing up, 9.3.5

disadvantages, 30.5

recovery, 30.5

O

obsolete backups, 8.8

definition, 8.8

deleting, 2.6.2, 8.8.3, 12.5.5

off-site backups, 17.2.3.1

online redo logs, 31.7.2.1

active group, 31.7.1, 31.7.2

applying during media recovery, 30.2.1

archived group, 31.7.1, 31.7.2

clearing

failure, 31.7.2.1.3

clearing inactive logs

archived, 31.7.2.1.1

unarchived, 31.7.2.1.2

configuring location, 5.4.4

current group, 31.7.1, 31.7.2

inactive group, 31.7.1, 31.7.2

loss of, 31.7.2.1

active group, 31.7.2.2.1, 31.7.2.2.1

all members, 31.7.2

group, 31.7.2

recovery, 31.7

loss of group, 31.7.2.2.1, 31.7.2.2.1

multiple group loss, 31.7.2.3

replacing damaged member, 31.7.1

status of members, 31.7.1, 31.7.2

OPEN RESETLOGS clause

ALTER DATABASE statement, 13.8.5, 14.3.2.1, 18.4.2, 18.6.1

ORA-01578 error message, 31.5

Oracle Advanced Compression option, 6.2.5.2.2

Oracle Backup Solutions Program (BSP), 3.5.3

Oracle Data Pump, 1.1.1, 18.4.2

Oracle Enterprise Manager Cloud Control

about, 1.5.1

accessing the Database Home page, 1.5.2

Oracle Flashback Database, 1.3.2

Oracle Flashback Drop, 1.3.1

Oracle Flashback Query, 1.3.1

Oracle Flashback Table, 1.3.1

Oracle Flashback Transaction, 1.3.1

Oracle Flashback Transaction Query, 1.3.1

Oracle Flashback Version Query, 1.3.1

Oracle keystore, 6.2.6.1.1

Oracle Managed Files

fast recovery, 5.4.1.1

Oracle Real Application Clusters (Oracle RAC)

RMAN channels and, 6.1.2

Oracle Secure Backup, 3.5.2, 5.2

Oracle software keystore

and backups, 6.2.6.1.1

Oracle VSS writer, 5.4.1

orphaned backups, 14.3.2.4

P

packages

DBMS_PIPE, 4.6, 4.6

password backup encryption, 6.2.6.1.2, 6.2.6.1.2

password-mode encryption, 10.6.3

passwords

connecting to RMAN, 4.2.7

PDBs, 4.2.6

about backup and recovery of, 4.2.6.1

backing up, using Oracle Enterprise Manager Cloud Control, 9.4.6

backing up, using RMAN, 9.4.5

complete recovery

data files, 17.4.5

tablespaces, 17.4.5

using RMAN, 17.4.3

complete restore, 17.4

connecting to, 4.2.6

duplicating, 25.1.5

duplicating tablespaces in, 25.1.5

orphaned backups, 14.3.2.5

performing point-in-time recovery, 18.5.3.2

point-in-time recovery and fast recovery area, 18.5.3

recovering table partitions, 22.4

recovering tables, 22.4

reporting, 11.1.4.2

restrictions when connected to, 4.2.6.2

transporting across platforms, 28.11.2

user-managed backups, 29.3

validating, 16.5.2

performance tuning

short waits

definition of, 23.3.2.2

performance tuning, RMAN

backup performance, 23.4

LARGE_POOL_SIZE initialization parameter, 23.4.3

long waits, 23.3.2.2

physical backups, 1.1.1

physical block corruption, 16.1.2.2

pipe interface, RMAN, 4.6

pluggable databases, 4.2.6

point of recoverability

recovery window, 8.8.1

point-in-time recovery, 30.4

of CDBs, 18.5.3.1

of PDBs, 18.5.3.2

performing

with current control file, 18.5.2

tablespace, 18.1.2

PREVIEW option, RESTORE command, 11.1.2

previewing backups, 17.2.3

PRINT SCRIPT command, 13.7.6

proxy copies, 3.5.1, 8.3.10

PROXY option

BACKUP command, 8.3.10, 8.3.10

Q

QUIT command, 2.2

quitting RMAN, 2.2

R

raw devices

backing up to, 29.9

UNIX backups, 29.9.1

Windows backups, 29.9.2

RC_ARCHIVED_LOG view, 11.5.1.1

RC_BACKUP_FILES view, 11.5.3

RC_BACKUP_PIECE view, 11.5.1

RC_BACKUP_SET view, 12.5.1

read-only tablespaces

backups, 29.4.2.4

transporting across platforms

using backup sets, 28.8

using image copies, 28.3

RECOVER clause

ALTER DATABASE statement, 30.2.4.2, 30.3.1, 30.3.2

RECOVER command, 14.3

COPY option, 9.6.4

FOREIGN DATAFILECOPY clause, 28.10.1.3, 28.10.1.3, 28.10.2, 28.10.2

FROM SERVICE parameter, 20.6.5.1

PARALLEL and NOPARALLEL options, 30.2.7

TEST option, 16.4

unrecoverable objects and standby databases, 31.5

UNTIL TIME option, 30.4.2

USING BACKUP CONTROLFILE clause, 31.2.4

recovering

table partitions in PDBs, 22.4

tables in PDBs, 22.4

recovering database file

over the network, 20.6.2

recovering database files

over the network, example, 20.6.5

using physical standby, 20.6.2

recovering files over the network

scenarios, 20.6.3

recovering table partitions

example, 22.5.2

limitations, 22.1.4

overview, 22.1

prerequisites, 22.2.1

steps, 22.3

recovering tables

example, 22.5.1

limitations, 22.1.4

overview, 22.1

prerequisites, 22.2.1

steps, 22.3

recovery

ADD DATAFILE operation, 31.2.3

automatically applying archived logs, 30.2.2

cancel-based, 30.4.2

complete, 17.1, 30.3

CDBs, 17.4.1

CDBs using Oracle Enterprise Manager Cloud Control, 17.4.4

closed database, 30.3.1

data files in PDBs, 17.4.5

offline tablespaces, 30.3.2

PDBs, 17.4.3

root, 17.4.2

tablespaces in PDBs, 17.4.5

tablespaces in PDBs using Cloud Control, 17.4.6

corruption

intentionally allowing, 30.6.4

data files, 30.2.1

database

complete, 17

in NOARCHIVELOG mode, 20.1

database files

how RMAN applies changes, 14.3.1

overview, 14.3

database, point-in-time, 18, 18.5

disaster using RMAN, 20.4

dropped table, 31.8

errors, 30.6.1

failures requiring, 1.1.1

interrupting, 30.2.6

media, 30, 30.6, 31

multiple redo threads, 30.2.2.2

of lost or damaged recovery catalog, 13.6.2

online redo logs, 31.7

loss of group, 31.7.2

parallel, 30.2.7

preparing for, 17.2.1.2

problems, 30.6.1

fixing, 30.6.3

investigating, 30.6.2

stuck, 30.6.1

third-party snapshots

example, 30.2.5

time-based, 30.4.2

transportable tablespaces, 31.6

trial, 30.6.6

explanation, 30.6.6.1

overview, 30.6.6

troubleshooting, 30.6.1

user errors, 31.8

user-managed, 30, 30.6, 31

using backup control file, 20.3.1

without recovery catalog, 20.3.2

using logs in a nondefault location, 30.2.4.1

using logs in default location, 30.2.3

using logs in nondefault location, 30.2.4.2

using storage snapshots, 30.2.5

using third-party snapshots, 30.2.5

with Oracle Enterprise Manager Cloud Control, 1.5.3

without a recovery catalog, 12.2.3

recovery catalog, 3.4, 13.1

backing up, 13.6.1, 13.6.1

cataloging backups, 12.4.3, 13.4

centralization of metadata, 13.1.2.2

creating, 13.2

crosschecking, 12.4.1.1

DBID problems, 13.1.2.1

definition, 2.1, 3.1

deleting backups, 12.5

deleting records, 12.5.3

dropping, 13.9

log switch record, 12.4.3

managing size of, 13.8.2.2.4

operating with, 3.4

purpose of, 13.1.1

recovery of, 13.6.2

refreshing, 13.8.2

registering databases, 13.1.2.1, 13.3.1, 13.3.2, 13.3.2

resynchronizing, 13.8.2, 13.8.2.1

space requirements, 13.2.1.2

stored scripts, 13.7.1

creating, 13.7.2

synchronization, 13.8.2.1

unregistering databases, 13.8.4

updating

after operating system deletions, 12.4.4.2

upgrading, 13.8.6, 13.8.6.1

views, querying, 11.5

virtual private catalogs, 3.4

recovery catalogs

backing up, 13.6.1

dropping, 13.9

importing, 13.8.7

moving, 13.8.7.5

Recovery Manager

allocating tape buffers, 23.2.3.1.1

archived redo logs

backups, 9.5

backups, 9.1.2

archived redo logs, 9.5.1

backing up, 8.5.2.1, 9.8.1

batch deletion of obsolete, 8.8.3

control files, 9.3.3

data file, 9.3.2, 9.8.2, 9.8.3

duplexed, 8.5.1

image copy, 8.4

incremental, 9.6, 10.4.1, 10.4.2

optimization, 5.6.1, 9.5.4

tablespace, 9.8.2, 9.8.3

testing, 16.1.2.4, 16.2, 16.2, 16.3, 16.3

validating, 16.2, 16.2, 16.3, 16.3

whole database, 9.3.1, 9.3.1

channels, 3.3, 3.3

naming conventions, 3.3.2

client, 2.1

connecting to databases, 2.2

corrupt data file blocks

handling I/O errors and, 10.7.1

crosschecking recovery catalog, 12.4.1.1

database character set, 4.4

database connections, 4.2.1

auxiliary database, 4.2.5

duplicate database, 4.2.5

hiding passwords, 4.2.7

SYSBACKUP or SYSDBA required for target, 4.2.2

without a catalog, 4.2

DBMS_PIPE package, 4.6

definition, 2.1

disconnecting from, 2.2

duplicate databases, overview of, 25.1.2.3

error codes

message numbers, 24.1.3.1

errors, 24.1, 24.1.3

interpreting, 24.1.4

file deletion, 12.5.1.1

fractured block detection in, 8.2

image copy backups, 8.4

incremental backups

cumulative, 8.7.1.2

differential, 8.7.1.1

level 0, 8.7.1

integrity checking, 16.1.2

jobs, monitoring progress, 23.3.1

jobs, querying details of, 11.4.1

lists, 11.2

maintenance commands, 2.6

media management

backing up files, 3.5.1

Backup Solutions Program (BSP), 3.5.3

crosschecking, 12.4.1.1

media manager, linking with a, 5.2.2

metadata, 3.4, 11, 12, 13

monitoring, 24.2

overview, 2.1, 3.2

performance

monitoring, 24.2

pipe interface, 4.6

proxy copy, 3.5.1

recovery

after total media failure, 20.4

recovery catalog, 13.1

backing up, 13.6.1

crosschecking, 12.4.1.1

managing the size of, 13.8.2.2.4

operating with, 3.4

recovering, 13.6.2

registration of target databases, 13.1.2.1, 13.3.1, 13.3.2

resynchronizing, 13.8.2

synchronization, 13.8.2.1

upgrading, 13.8.6.1

reports, 11.3.1

database schema, 11.3.5

objects needing a backup, 11.3.2

obsolete backups, 11.3.4

repository, 3.4

restoring

archived redo logs, 17.2.5

retention policies

configuring, 5.5

return codes, 24.1.5

setting time parameters, 4.4

snapshot control file location, 6.4

starting, 2.2

synchronous and asynchronous I/O, 23.2.1.2, 23.2.1.3, 23.2.3.1.3

terminating commands, 24.4

test disk API, 5.2.4

types of backups, 8.4

using RMAN commands, 3.2

recovery window, 5.5

point of recoverability, 8.8.1

RECOVERY WINDOW parameter

CONFIGURE command, 5.5.2

recovery windows

configuring for retention policy, 5.5.2

definition, 8.8.1

RECOVERY_CATALOG_OWNER role, 13.5.2.2, 13.5.3.1

recycle bin, 18.1.2.3.2, 18.3.2

restoring objects from, 18.3.3

redo logs

incompatible format, 30.6.1

naming, 30.2.3

parallel redo, 30.6.1

redo records

problems when applying, 30.6.1

REPAIR FAILURE command, 15.5.1, 15.6

repair failures

in CDBs, 15.1.4

repair options, Data Recovery Advisor, 15.4

repairs, Data Recovery Advisor, 15.1.2.1

consolidation of, 15.1.2.4.1

manual and automatic, 15.1.2.4

REPLACE SCRIPT command, 13.7.3

REPORT command, 2.5.2, 11.1.2, 11.3.1

NEED BACKUP option, 11.3.2, 11.3.2

OBSOLETE option, 8.8.3, 8.8.3

reporting

in CDBs, 11.1.4.1

in PDBs, 11.1.4.2

reports, RMAN, 2.5, 11.1.2, 11.3.1, 11.3.1

backup jobs, 11.4.1

database schema, 11.3.5

files needing backups, 11.3.2

obsolete backups, 11.3.4

unrecoverable backups, 11.3.4

repository, RMAN, 3.4, 3.4

RESET DATABASE command

INCARNATION option, 13.8.5

RESETLOGS operation

when necessary, 14.3.2.1

RESETLOGS option

of ALTER DATABASE, 30.5

restartable backups, 10.7.1

restarting

duplication after a failure, 25.6

RESTORE command, 14.2, 17.2.1.2

ALL FOREIGN DATAFILES clause, 28.6.5

BACKUPSET clause, 28.6.4

DATAPUMP clause, 28.6.7

DATAPUMP DESTINATION clause, 28.10.1.3, 28.10.2

DUMPFILE clause, 28.6.4, 28.10.1.3, 28.10.2

FORCE option, 14.2.4

FOREIGN DATABASE clause, 28.6.5, 28.7.1

FOREIGN DATAFILE clause, 28.6.5, 28.10.2

FOREIGN TABLESPACE clause, 28.6.5, 28.8.1

FROM BACKUPSET clause, 28.10.1.3

FROM PLATFORM parameter, 28.6.4

FROM SERVICE parameter, 20.6.4

NOIMPORT option, 28.6.7

PREVIEW option, 11.1.2, 17.2.3

VALIDATE HEADER option, 11.1.2, 17.2.3

restore optimization, 14.2.4

restore points, 1.3.2, 2.8

creating, 7.4.1

flashing back to, 18.6.2

guaranteed, 1.3.2, 7.1.5

compared to storage snapshots, 7.1.5.1

listing, 7.4.2

requirements, 7.3

restore validation, 17.2.4

restoring

control files, 20.3.1.1

to default location, 31.1.1

to nondefault location, 31.1.2

database

to default location, 30.5

database files, 14.2, 14.2.1, 14.2.4

server parameter files, 20.2, 20.2

testing, 16.4, 17.2.4

user-managed backups, 30.2.1

restoring database file

over the network, 20.6.1

restoring database files

over the network, example, 20.6.4

restoring files over the network

scenarios, 20.6.3

restrictions

PDBs, 4.2.6.2

RESUME clause

ALTER SYSTEM statement, 29.8.2

resuming recovery after interruption, 30.2.6

RESYNC CATALOG command, 13.8.2, 13.8.2.3

FROM CONTROLFILECOPY option, 13.6.2

resynchronizing the recovery catalog, 3.7.1, 13.8.2, 13.8.2.3

return codes

RMAN, 24.1.5

REVOKE command, 13.5.2.4

RMAN, 3

RMAN repository, 1.2, 2.1

RMAN sessions, 2.7.2, 3.3

root

backing up

using Oracle Enterprise Manager Cloud Control, 9.4.4

using RMAN, 9.4.3

complete recovery, 17.4.2

complete restore, 17.4

S

SBT, 3.3.1, 3.5.2, 5.2.5.2

sbtio.log

and RMAN, 24.1.1

sbttest program, 24.3.1

scenarios, Recovery Manager

NOARCHIVELOG backups, 9.3.5

recovering pre-resetlogs backup, 18.6.3, 20.1

recovery after total media failure, 20.4

scripts, RMAN, 2.4.6

substitution variables in, 9.7.3

server parameter files

autobackups, 8.6

backups, 9.3.4

configuring autobackups, 5.1.5, 5.1.5.1, 8.6

restoring, 20.2, 20.2

server sessions, Recovery Manager, 3.3

session architecture, Recovery Manager, 3.3

SET command

DBID option, 3.7.1

ENCRYPTION option, 6.2.6.1.2

MAXCORRUPT option, 16.1.2.3

NEWNAME option, 26.1.1.1

SET statement

AUTORECOVERY option, 30.2.2

LOGSOURCE variable, 30.2.4.2, 30.3.1, 30.3.2

shadow copies, 9.6.3.1

shared server

configuring for use with RMAN, 6.5

configuring RMAN, 6.5

short waits

definition, 23.3.2.2

SHOW command, 2.3, 2.3, 5.1.1

SHUTDOWN statement

ABORT option, 30.5, 31.1.1, 31.1.2

size of backup sets, setting, 8.3.7

skipping files in RMAN backups, 10.3

snapshot control file

specifying location, 6.4

specifying location in Oracle Real Application Clusters environment, 6.4.2

snapshot control files, 6.4, 13.8.2.1

snapshots

backing up using third-party technologies, 29.10

using Storage Snapshot Optimization, 29.10

split mirrors

suspend/resume mode, 29.8.1

using as backups, 10.5

SPOOL command, 15.5.1

standby databases, 3.1

creating with DUPLICATE, 25.1.1

statements, SQL

ALTER DATABASE, 30.2.4.2, 30.3.1, 30.3.2

Storage Snapshot Optimization, 29.10

storage snapshots, 7.1.5.1, 29.10, 30.2.5

recovering, 30.2.5

stored scripts, 3.4, 9.7.3, 13.1.2.4, 13.7.1, 13.7.1, 13.8.7.1

creating RMAN, 13.7.2

deleting, 13.7.8, 13.7.8

dynamic, 13.7.5

executing, 13.7.9

listing names of, 13.7.7

managing, 13.7.1

printing, 13.7.6

substitution variables in, 13.7.5

stuck recovery, 30.6.1

substitution variables, FORMAT parameter, 5.2.5.1, 8.3.6, 8.4.1

substitution variables, stored scripts, 13.7.5

SUSPEND clause

ALTER SYSTEM statement, 29.8.2, 29.8.2

suspending a database, 29.8.1

suspend/resume mode, 29.8.1

SWITCH command, 17.3.4

SYSBACKUP privilege, 4.2.2.2

system backup to tape, 3.5.2

system time

changing

effect on recovery, 30.4.2

T

tables, recovery of dropped, 31.8

tablespace point-in-time recovery, 18.1.2

performing on dropped tablespaces, 21.1.1

planning, 21.3

preparing the auxiliary instance, 21.6.1

restrictions, 21.2.2

why perform, 21.1.1

tablespaces

backups, 9.8.2, 9.8.3, 29.4.2.2

offline, 29.4.1

online, 29.4.2.2

backups using RMAN, 9.3.2

backups, in PDBs, 9.4.7

excluding from backups, 6.2.4

excluding from RMAN backups, 6.2.4

read-only

backing up, 29.4.2.4

read/write

backing up, 29.4.2.1

recovering accessible

when database is open, 17.3.3

recovering in PDBs

using Cloud Control, 17.4.6

recovering offline in open database, 30.3.2

transporting across platforms, in PDBs, 28.11.3

transporting with RMAN, 27

user-managed backups, in CDBs, 29.5

user-managed backups, in PDBs, 29.5

tape devices, 3.5.2

target database

connecting to, 2.2

definition, 2.1, 3.1

terminating RMAN commands, 24.4

test disk API, 5.2.4

testing RMAN

backups, 16.1.2.4, 16.2, 16.2, 16.3, 16.3

with media management API, 24.3

third-party snapshots

specifying recovery time, 30.2.5

time format

RECOVER DATABASE UNTIL TIME statement, 30.4.2

time parameters

setting for Recovery Manager use, 4.4

time-based recovery, 30.4.2

trace files, RMAN, 24.1.1

transparent backup encryption, 6.2.6.1.1

transparent-mode backup encryption, 10.6.2

transportable tablespaces

creating with RMAN, 27.1.1

and Data Pump Export, 27.5.2

and past points in time, 27.5.1

auxiliary destination, 27.1.2

auxiliary instance parameter file, 27.2, 27.2.2

file locations, 27.5.3

initialization parameters, 27.2.1

cross-platform, 28

recovery, 31.6

transporting tablespaces, 27

trial recovery, 16.4, 30.6.6, 30.6.6.1

tuning Recovery Manager

V$ views, 24.2

U

UNAVAILABLE option

of CHANGE, 12.4.2.1

UNCATALOG option

CHANGE command, 12.4.4.1

deleting repository records, 12.4.4.1

undo optimization, backup, 5.6.1, 8.3.4

unrecoverable objects

recovery, 31.5, 31.5

UNREGISTER DATABASE command, 13.8.4

unregistering databases, 13.8.4

UNTIL TIME option

RECOVER command, 30.4.2

upgrading the recovery catalog, 13.8.6.1

user errors

definition, 1.1.1.2

recovery from, 31.8

user-managed backups, 29, 29.2

backup mode, 29.4.2.1, 29.4.2.3

control files, 29.6, 29.6

definition, 8.4.2

determining data file status, 29.1.2

hot backups, 8.2, 29.4.2.3.1

listing files before, 29.1

of CDBs, 29.3

of PDBs, 29.3

offline tablespaces, 29.4.1, 29.4.1

read-only tablespaces, 29.4.2.4

tablespaces, 29.4.2.2

tablespaces in CDBs, 29.5

tablespaces in PDBs, 29.5

verifying, 29.11

whole database, 29.2

user-managed recovery, 30.4

ADD DATAFILE operation, 31.2.3

complete, 30.3

incomplete, 30.4

interrupting, 30.2.6

scenarios, 31

user-managed restore operations, 30.2.1

V

V$ARCHIVED_LOG view, 5.4.2.3, 11.5.1.1, 18.5.2

listing all archived logs, 29.7

V$BACKUP view, 29.1.2

V$BACKUP_ASYNC_IO view, 23.3.2

V$BACKUP_DATAFILE view, 9.6.2, 12.4.3.3

V$BACKUP_FILES view, 5.5.2, 12.4.1.1, 12.4.3.2

V$BACKUP_PIECE view, 11.5.1, 12.4.3.3

V$BACKUP_REDOLOG view, 12.4.3.3

V$BACKUP_SET view, 12.4.3.3, 12.5.1

V$BACKUP_SPFILE view, 12.4.3.3

V$BACKUP_SYNC_IO view, 23.3.2

V$BLOCK_CHANGE_TRACKING view, 9.6.5.4

V$CONTROLFILE view, 9.3.3

V$DATABASE view, 11.5.2, 18.2.2, 18.6.1

V$DATABASE_BLOCK_CORRUPTION view, 1.2, 2.9.4, 16.1.2.4, 16.2, 16.2, 19, 19.1.2.1, 19.1.2.1, 19.3, 19.4

V$DATABASE_INCARNATION view, 13.8.5

V$DATAFILE view, 17.2.1.2.2, 21.6.1.2, 29.1.1

listing files for backups, 29.1

V$DATAFILE_HEADER view, 11.1.2, 17.2.1.2.2, 17.2.1.2.2

V$DIAG_INFO view, 19.3.1

V$EVENT_NAME view, 24.2.1

V$FLASHBACK_DATABASE_LOG view, 5.4.2.3, 18.4.2, 18.6.1

V$FLASHBACK_DATABASE_STAT view, 7.5.4

V$INSTANCE view, 17.2.1.2.2

V$LOG_HISTORY view

listing all archived logs, 30.3.1

V$LOGFILE view, 21.6.1.2, 31.7.1, 31.7.2

V$PARAMETER view, 18.2.2

V$PROCESS view, 11.1.2, 24.2, 24.2.2

V$PROXY_ARCHIVEDLOG view, 8.3.10

V$PROXY_DATAFILE view, 8.3.10

V$RECOVER_FILE view, 17.2.1.2.2, 30.3.1

V$RECOVERY_AREA_USAGE view, 12.3.2, 12.3.2

V$RECOVERY_FILE_DEST, 12.3.2

V$RECOVERY_FILE_DEST view, 12.3.2, 12.3.2

V$RECOVERY_LOG view

listing logs needed for recovery, 30.3.1

V$RESTORE_POINT view, 18.2.2

V$RMAN_BACKUP_JOB_DETAILS view, 11.4.1

V$RMAN_BACKUP_SUBJOB_DETAILS view, 11.4.1

V$RMAN_ENCRYPTION_ALGORITHMS view, 6.2.6.1, 6.2.6.1, 6.2.6.3, 23.2.2

V$RMAN_OUTPUT view, 11.5.2

V$RMAN_STATUS view, 24.1.1

V$SESSION view, 6.5, 11.1.2, 24.2, 24.2.2

V$SESSION_LONGOPS view, 23.3.1

V$SESSION_WAIT view, 24.2, 24.2.1

V$SGASTAT view, 23.4.3

V$SYSSTAT view, 7.5.4

V$TABLESPACE view, 17.2.1.2.2, 29.1.1

VALIDATE command, 15.1.2.2, 15.3, 16.2, 17.2.1.2.1

SECTION SIZE parameter, 16.2

VALIDATE HEADER option, RESTORE command, 11.1.2

validating

CDBs, 16.5.1

PDBs, 16.5.2

validation, RMAN, 15.3

backups, 2.4.5, 16.2, 16.2, 16.2, 16.2, 16.3, 16.3, 16.3, 16.3

database files, 2.4.5, 16.2

restore operations, 17.2.4

views

for multisection backups, 9.2.6, 9.2.6

views, recovery catalog, 11.1.2, 11.5

virtual private catalogs, 3.4

dropping, 13.5.2.5

Volume Shadow Copy Service (VSS), 5.4.1, 9.6.3.1

W

whole database backups

ARCHIVELOG mode, 29.2

inconsistent, 29.2

NOARCHIVELOG mode, 29.2

preparing for, 29.2

using RMAN, 9.3.1, 9.3.1