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, 25.1.1.1

%d substitution variable

BACKUP FORMAT, 2.4.3

%f substitution variable

SET NEWNAME, 25.1.1.1

%I substitution variable

SET NEWNAME, 25.1.1.1

%N substitution variable

SET NEWNAME, 25.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, 25.1.1.1

A

ABORT option

SHUTDOWN statement, 29.5, 30.1.1, 30.1.2

active database duplication, 4.5.4, 24.1.2.1.1

Advanced Compression Option, 6.2.5.3

Advanced Security Option, 6.2.6.1, 8.3.5

ADVISE FAILURE command, 15.1.2.4, 15.4

alert log, 12.2.2, 23.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, 29.6.5

ALTER DATABASE statement

CLEAR LOGFILE clause, 30.7.2.1.3

END BACKUP clause, 28.3.2.3.1

OPEN RESETLOGS clause, 13.8.5

RECOVER clause, 29.2.4.2, 29.3.1, 29.3.2

RESETLOGS option, 29.5

ALTER SYSTEM statement

KILL SESSION clause, 23.4.1

RESUME clause, 28.6.2

SUSPEND clause, 28.6.2, 28.6.2

ALTER TABLESPACE statement

BEGIN BACKUP clause, 28.3.2.1, 28.3.2.2.2

END BACKUP option, 28.3.2.2.2

application errors, 1.1.1.3

archival backups, 1.1.2, 9.6.1, 9.6.1, 12.4.2.2

archived redo log deletion policies, 5.6.1, 5.6.2, 9.4.3

archived redo log files

applying during media recovery, 29.2.1, 29.2.3, 29.2.4.2

backing up, 9.4.2

using RMAN, 9.4

with other backups, 9.4.1.2

cataloging, 12.4.3

changing default location, 29.2.4.1

corrupted, 29.6.1

deleting, 14.3.1, 29.3.1

deletion after backup, 9.4.1

failover, 9.4.1.1

incompatible format, 29.6.1

location during recovery, 29.2.1

loss of, 29.4

restoring using RMAN, 17.2.5

ARCHIVELOG mode

backups in, 2.4.1

AS SELECT clause

CREATE TABLE statement, 30.5

authentication, RMAN, 2.2

autobackups, control file, 8.6, 8.6, 9.3.3, 9.6.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, 23.1.1

Automatic Storage Management (ASM)

backups to, 9.2.3

Automatic Workload Repository (AWR), 7.5.4

AUTORECOVERY option

SET statement, 29.2.2

auxiliary channels, 24.1.2.3

auxiliary instance parameter file

with TRANSPORT TABLESPACE, 26.2

availability

of RMAN backups, 12.4.2.1

AVAILABLE option

of CHANGE command, 12.4.2.1

B

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.3.5, 5.5.1, 6.1.1, 6.2.1, 6.2.4, 8.1, 8.1, 8.3, 9.1.2, 9.4.3

ARCHIVELOG option, 9.4.1.2, 9.4.2

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.7.1, 9.7.1, 9.7.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.7.1, 9.7.3

CURRENT CONTROLFILE option, 9.3.3, 9.3.3.1

DATABASE option, 9.3.1

DATAFILE option, 9.3.2

DB_FILE_NAME_CONVERT parameter, 8.4.1, 8.4.1

DELETE INPUT option, 9.4.4, 9.4.4, 12.5.1.1

DELETE option, 9.4.1

DEVICE TYPE clause, 5.1.2, 5.5.1, 9.2.1, 9.2.1, 9.3.3.1

DURATION parameter, 10.8.2

FILESPERSET parameter, 8.3.9

FOR RECOVER OF COPY option, 9.5.4.1

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

INCREMENTAL option, 2.4.4, 2.4.4, 2.4.4.1, 9.5, 9.5.3, 9.5.3.1

KEEP option, 9.6.1, 9.6.3.1, 9.6.3.1, 9.6.4

MAXSETSIZE parameter, 10.1

NOT BACKED UP clause, 9.4.3

PLUS ARCHIVELOG option, 9.4.1.2, 9.4.1.2

PROXY ONLY option, 8.3.10, 8.3.10

PROXY option, 8.3.10

RECOVERY AREA option, 9.7.1

SECTION SIZE parameter, 8.3.1, 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

VALIDATE option, 2.4.5, 15.1.2.2, 15.3, 16.2

BACKUP CONTROLFILE clause

ALTER DATABASE statement, 28.1.1, 28.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.3.1.2

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, 6.2.6.1.1, 10.6.2

backup mode, 8.4.2

ending with ALTER DATABASE END BACKUP, 28.3.2.3.1

for online user-managed backups, 8.2, 28.3.2.1

instance failure, 28.3.2.3

backup optimization, 9.4.3

configuring, 5.5, 10.2

definition, 5.5.1, 9.4.3

disabling, 5.5.1, 5.5.3

enabling, 5.5.1, 5.5.3

redundancy and, 5.5.2.2

retention policies and, 5.5.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.3.1

affect on backup optimization, 5.5.2

configuring, 5.4, 5.4

configuring for redundancy, 5.4.1

definition, 8.8

disabling, 5.4.3

exempt backups, 9.6.1, 12.4.2.2

recovery window, 8.8

recovery windows, 5.4.2

redundancy, 8.8, 8.8.2

backup sets, 2.4, 8.1

backing up, 8.5.2.1, 8.5.2.1, 9.7.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, 22.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 strategy

fast recovery area, 5.3

backup tags, RMAN, 9.2.4

backup techniques, comparison, 1.2

backup windows, 10.8.1

backup-based duplication, 24.1.2.1.1

backups

archival, 1.1.2, 9.6.1

archived redo logs

using RMAN, 9.4

availability, 12.4.2.1

backup sets, 9.7.1

backups of, 8.5.2.1

closed, 28.2

consistent, 28.2, 28.2

making using RMAN, 8.1.1

control file, 9.3.3, 28.4

control files, 28.4

binary, 28.4.1

correlating RMAN channels with, 23.2.2.2.1, 23.2.2.2.2

crosschecking, 12.4.1, 12.4.1

cumulative incremental, 8.7.1.2

data file

using RMAN, 9.7.2, 9.7.3

DBVERIFY utility, 28.9

default type for RMAN, 5.1.3

determining data file status, 28.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, 28.2

making using RMAN, 8.1.1

incremental, 8.7.1.1, 9.5, 10.4.1, 10.4.2

incrementally updated, 9.5.4

listing files needed, 28.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, 28.3.1, 28.3.1, 28.3.1

offsite, 17.2.3.1

optimizing, 5.5.1, 9.4.3

orphaned, 14.3.2.3

physical, 1.1.1

previewing, 17.2.3

read-only tablespaces, 28.3.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, 29.2.1

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, 28.3.2.2

using RMAN, 9.3.2, 9.7.2, 9.7.3

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

using media manager, 5.2.4.2

user-managed, 28

validating, 16.2, 16.2, 16.3, 16.3

verifying, 28.9

whole database, 9.3.1, 9.3.1, 28.2

BEGIN BACKUP clause

ALTER TABLESPACE statement, 28.3.2.1

binary compression for backups, 9.2.5

block change tracking, 1.2, 8.7.2, 9.5.5, 9.5.5

disk space used for, 9.5.5.1.3

enabling and disabling, 9.5.5.2, 9.5.5.2, 9.5.5.3, 9.5.5.3

moving the change tracking file, 9.5.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. See Backup Solutions Program (BSP), 3.5.3

C

cancel-based media recovery, 29.4.2

canceling RMAN commands, 23.4

CATALOG command, 12.4.3, 12.4.3

START WITH parameter, 13.4

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, 24.1.2.3

configuring, 5.1.4

configuring advanced options, 6.1

definition, 2.3, 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.3

circular reuse records, 12.2.1

CLEAR LOGFILE clause

of ALTER DATABASE, 30.7.2.1.3

client, RMAN, 2.1, 2.1, 3.1, 3.5

cold failover cluster

definition, 28.3.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.3.5, 5.3.5, 5.5.1, 5.5.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.1, 9.3.4, 9.4.1, 9.4.1.2, 9.4.1.2, 9.4.3, 9.4.3, 9.4.4, 9.5, 9.5.3, 9.5.3.1, 9.5.4.1, 9.6.1, 9.6.3.1, 9.6.4, 9.7.1, 9.7.1, 9.7.1, 9.7.2, 9.7.3

PROXY ONLY option, 8.3.10

PROXY option, 8.3.10

BACKUP CURRENT CONTROLFILE, 9.3.3.1

canceling, 23.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.4, 5.7, 6.1.1, 6.2.2, 6.2.6.2, 6.3

CREATE CATALOG, 13.2.3, 13.5.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, 24

EXECUTE SCRIPT, 13.7.1, 13.7.4

EXIT, 2.2

FLASHBACK DATABASE, 7.1.1, 13.8.5

GRANT, 13.5.2

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.4

SET, 6.2.6.1.2

SHOW, 2.3, 5.1.1

SPOOL, 15.5.1

SWITCH, 17.3.4

terminating, 23.4, 23.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, 29.4.2

SET, 29.2.2, 29.2.4.2, 29.3.1, 29.3.2

comments in RMAN syntax, 4.4.3

COMPATIBLE initialization parameter, 6.2.6.1

complete recovery

overview, 17.1

procedures, 29.3

compressed backups, 5.1.3, 9.2.5

algorithms, 6.2.5

CONFIGURE command

AUXNAME option, 6.3

BACKUP OPTIMIZATION option, 5.5.3

CHANNEL option, 5.1.4.1, 6.1.1

CONTROLFILE AUTOBACKUP option, 8.6.1, 9.6.2

DB_UNIQUE_NAME option, 5.7

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.4

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.5

backup retention policies, 5.4

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

consistent backups, 8.1.1

using RMAN, 8.1.1

whole database, 28.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, 28.1.1, 28.4

binary, 28.4.1

including within database backup, 9.3.3.1

recovery using, 20.3.1

using RMAN, 9.3.3

circular reuse records, 12.2.1

configuring location, 5.3.4

creating after loss of all copies, 30.3

finding file names, 28.1.1

multiplexed, 5.3.1, 5.3.4, 12.2.3, 17.2.1.1, 28.1.1, 29.2.1, 30.1.1

loss of, 30.1

multiplexing, 12.2.3

re-created, 30.3

restoring, 20.3.1.1, 30.1.1, 30.1.2

snapshot, 13.8.2.1

specifying location of, 6.4

user-managed restore after loss of all copies, 30.3

CONTROL_FILE_RECORD_KEEP_TIME initialization parameter, 12.2.1, 12.2.2, 13.8.2.2.4

CONTROL_FILES initialization parameter, 5.3.4.2, 20.3.1.1, 21.6.1.2, 30.1.2

CONVERT command

with tablespaces and data files, 27

COPIES option

BACKUP command, 10.4.2

corrupt blocks, 14.1.1.2, 16.1.2.1, 29.6.1

recovering, 19.1.2.1, 19.1.2.1

RMAN and, 10.7.1

CREATE CATALOG command, 13.2.3, 13.5.3

CREATE DATAFILE clause, ALTER DATABASE statement, 30.4

CREATE SCRIPT command, 13.7.2

CREATE TABLE statement

AS SELECT clause, 30.5

CREATE TABLESPACE statement, 30.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 transportable tablespace, 27

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, 29.6.1, 29.6.1

data dictionary views, 28.3.1, 28.3.2.1, 28.3.2.4

data files

backing up, 9.3.2, 9.7.2, 9.7.3, 28.3.1

determining status, 28.1.2

listing, 28.1

losing, 29.2.1

recovery

without backup, 30.4

re-creating, 30.4

renaming

after recovery, 30.2.3

restoring, 14.2

Data Guard environment, 3.7.2.3

archived log deletion policies, 5.6.1.2

changing a DB_UNIQUE_NAME, 13.8.3

configuring RMAN, 5.7

reporting in a, 11.1.2.1

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 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

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.5.4

hiding passwords, 4.5.5

without a catalog, 4.5

SYSDBA required for RMAN, 4.5.1.1

types in RMAN, 4.5.1

database point-in-time recovery, 18.5

definition, 18.1.2.1

Flashback Database and, 7.1.1, 18.1

prerequisites, 18.5.1

user-managed, 29.4

databases

listing for backups, 28.1

media recovery procedures, user-managed, 29

media recovery scenarios, 30

recovery

after control file damage, 30.1.1, 30.1.2

registering in recovery catalog, 13.3.2, 13.3.2

reporting on schemas, 11.3.5

suspending, 28.6.1

unregistering from recovery catalog, 13.8.4

DB_BLOCK_CHECKSUM initialization parameter, 16.1.2.1

DB_CREATE_FILE_DEST initialization parameter, 5.3.4.1, 9.5.5.2, 17.3.2

DB_FILE_NAME_CONVERT initialization parameter, 21.6.1.2

DB_FLASHBACK_RETENTION_TARGET initialization parameter, 5.3.2, 5.3.2.1, 5.3.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.3.2, 5.3.4.1

DB_RECOVERY_FILE_DEST_SIZE initialization parameter, 2.1, 5.3.2

DB_UNIQUE_NAME initialization parameter, 3.7, 3.7.2.2, 5.7, 11.1.2.1

DBA_DATA_FILES view, 28.3.1, 28.3.2.1, 28.3.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, 24.1.1

DBVERIFY utility, 28.9

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 backups, 2.6.2, 12.5, 12.5, 12.5.1.1, 12.5.3

deletion policies, archived redo log, 5.6.1

enabling, 5.6.2

devices, configuring default, 5.1.2

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

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, 24

restarting after a failure, 24.7

duplicate databases, 3.1

active database duplication, 4.5.4, 24.1.2.1.1

backup-based duplication, 24.1.2.1.2

no target connection, 24.1.2.1.2

no target/recovery connection, 24.1.2.1.2

target connection, 24.1.2.1.2

generating file names, 24.2.2

how RMAN creates, 24.1.2.3

restarting after failed DUPLICATE, 24.7

skipping offline normal tablespaces, 25.5.2

skipping read-only tablespaces, 25.5

duplication

restarting after a failure, 24.7

DURATION parameter, BACKUP command, 10.8.2

E

encrypted backups, 10.6, 14.2.1

decrypting, 17.3.1.2

environment variables

NLS_DATE_FORMAT, 4.3

NLS_LANG, 4.3

error codes

media manager, 23.1.3.2

RMAN, 23.1, 23.1.3, 23.1.3.1

error messages, RMAN

interpreting, 23.1.4

error stacks, RMAN

interpreting, 23.1.4

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

See also recovery

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.2.1

autobackups, 5.1.5.1

changing locations, 12.3.5

configuring, 5.3

definition, 2.1

disabling, 12.3.6

effect of retention policy, 8.8.4

enabling, 5.3.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.3.1.1

permanent and impermanent files, 5.3.1

RMAN files in, 5.3.5

setting location, 5.3.2.2

setting size, 5.3.2.1

snapshot control files, 6.4

space management, 5.3.1.2

feasibility checks, Data Recovery Advisor, 15.1.2.4

file names, listing for backup, 28.1

file sections, 8.3.7, 8.3.9, 10.1.3, 16.2

flashback data archive

definition, 1.3.1

FLASHBACK DATABASE command, 7.1.1, 18.4.2

flashback database window, 7.1.2

Flashback Drop, 18.1.2.2.2, 18.3.1

flashback logs, 1.3.2, 2.8, 7.1.1, 12.3.3, 18.1.2.2.1

guaranteed restore points and, 7.1.5

flashback retention target, 7.1.1

Flashback Table, 18.1.2.2.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.2.2

overview, 1.3

flashback undrop

restoring objects, 18.3.3

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

groups, redo log, 30.7.1, 30.7.1, 30.7.2, 30.7.2

guaranteed restore points, 1.3.2, 5.3.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, 28.3.2.3, 28.3.2.3.1

for online user-managed backups, 28.3.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, 29.4

incomplete recovery

defined, 18.5

in Oracle Real Application Clusters configuration, 29.2.2.2

overview, 14.3

time-based, 29.4.2

with backup control file, 29.2.2.2

inconsistent backups, 8.1.2

using RMAN, 2.4.1, 8.1.1

incremental backups, 2.4.4, 9.5

block change tracking, 9.5.5

differential, 8.7.1.1

how RMAN applies, 14.3.1

making, 9.5

using RMAN, 10.4.1, 10.4.2

initialization parameter file, 14.3

initialization parameters

CONTROL_FILES, 20.3.1.1, 30.1.2

DB_FILE_NAME_CONVERT, 21.6.1.2

DB_NAME, 21.6.1.2

LARGE_POOL_SIZE, 22.4.3

LOCK_NAME_SPACE, 21.6.1.2

LOG_ARCHIVE_DEST_n, 29.2.3

LOG_ARCHIVE_FORMAT, 29.2.3

LOG_FILE_NAME_CONVERT, 21.6.1.2

instance failures

backup mode and, 28.3.2.3

integrity checks, 16.1.2

interpreting RMAN error stacks, 23.1.4

interrupting media recovery, 29.2.5

I/O errors

effect on backups, 10.7.1

J

jobs, RMAN

monitoring progress, 22.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, 29.2.1

LOG_ARCHIVE_DEST_n initialization parameter, 5.3.4.3, 17.2.5, 29.2.2, 29.2.3, 29.2.3, 29.3.1, 29.4.1, 29.4.2

LOG_ARCHIVE_FORMAT initialization parameter, 29.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, 29.2.4.2, 29.3.1, 29.3.2

long waits, 22.3.2.2

loss of

inactive log group, 30.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, 29.4

complete recovery, 29.3

complete recovery, user-managed, 29.3

control file loss, 30.3

data file loss, 29.2.1

definition, 1.1.1.1

NOARCHIVELOG mode, 29.5

online redo log group loss, 30.7.2

recovery, 29.3

recovery procedures

examples, 29.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, 23.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, 23.3.1

testing, 5.2.4

testing backups, 5.2.4.2

testing the API, 23.3

third-party, 5.2

troubleshooting, 5.2.4.2

media recovery, 8.7.4

ADD DATAFILE operation, 30.2.3

after control file damage, 30.1.1, 30.1.2

applying archived redo logs, 29.2.1

cancel-based, 29.4, 29.4.2

complete, 29.3

closed database, 29.3.1

complete, user-managed, 29.3

corruption

allowing to occur, 29.6.4

data files

without backup, 30.4

errors, 29.6.1

incomplete, 29.4

interrupting, 29.2.5

lost files

lost archived redo log files, 29.4

lost data files, 29.2.1

lost mirrored control files, 30.1

NOARCHIVELOG mode, 29.5, 29.5

offline tablespaces in open database, 29.3.2

online redo log files, 30.7

parallel, 29.2.6

problems, 29.6.1, 29.6.1, 29.6.2, 29.6.3

restarting, 29.2.5

restoring

whole database backups, 29.5

resuming after interruption, 29.2.5

roll forward phase, 29.2.1

scenarios, 30

time-based, 29.4

transportable tablespaces, 30.6

trial, 29.6.6, 29.6.6, 29.6.6.1

troubleshooting, 29.6.1, 29.6.1

undamaged tablespaces online, 29.3.2

user-managed, 29

using Recovery Manager, 14.3

metadata, RMAN, 3.4, 11, 12, 13

mirrored files

backups using, 10.5

splitting, 28.6.1

suspend/resume mode, 28.6.1

using RMAN, 10.5

monitoring fast recovery area usage, 12.3.2

monitoring RMAN, 23.2

MTTR, 15.1.1

multiplexed backup sets, 6.2.1, 8.3.9, 9.2.4.2, 22.2.1.1

multiplexed control files, 5.3.1, 5.3.4, 12.2.3, 12.2.3, 17.2.1.1, 28.1.1, 29.2.1, 30.1.1

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

N

naming backup sets, 8.3.6

NLS_DATE_FORMAT environment variable, 4.3

NLS_LANG environment variable, 4.3

NOARCHIVELOG mode

backing up, 9.3.5

disadvantages, 29.5

recovery, 29.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, 30.7.2.1

active group, 30.7.1, 30.7.2

applying during media recovery, 29.2.1

archived group, 30.7.1, 30.7.2

clearing

failure, 30.7.2.1.3

clearing inactive logs

archived, 30.7.2.1.1

unarchived, 30.7.2.1.2

configuring location, 5.3.4

current group, 30.7.1, 30.7.2

inactive group, 30.7.1, 30.7.2

loss of, 30.7.2.1

active group, 30.7.2.2.1, 30.7.2.2.1

all members, 30.7.2

group, 30.7.2

recovery, 30.7

loss of group, 30.7.2.2.1, 30.7.2.2.1

multiple group loss, 30.7.2.3

replacing damaged member, 30.7.1

status of members, 30.7.1, 30.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, 30.5

Oracle Backup Solutions Program (BSP), 3.5.3

Oracle Data Pump, 1.1.1, 18.4.2

Oracle Encryption Wallet

and backups, 6.2.6.1.1

Oracle Flashback Database. See Flashback Database, 2.8, 14.1.2

determining the flashback database window, 18.4.2

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.3.2.3

tuning performance, 7.5.3

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 Managed Files

fast recovery, 5.3.1.1

Oracle Real Application Clusters (Oracle RAC)

RMAN channels and, 6.1.2

Oracle Secure Backup, 3.5.2, 5.2

Oracle VSS writer, 5.3.1

Oracle wallet, 6.2.6.1.1

orphaned backups, 14.3.2.3

OSB Cloud Module

See Also Oracle Database Backup and Restore Reference, Preface

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.5.5

performance tuning

short waits

definition of, 22.3.2.2

performance tuning, RMAN

backup performance, 22.4

LARGE_POOL_SIZE initialization parameter, 22.4.3

long waits, 22.3.2.2

physical backups, 1.1.1

physical block corruption, 16.1.2.2

pipe interface, RMAN, 4.6

point of recoverability

recovery window, 8.8.1

point-in-time recovery, 29.4

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, 28.7

UNIX backups, 28.7.1

Windows backups, 28.7.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, 28.3.2.4

RECOVER clause

ALTER DATABASE statement, 29.2.4.2, 29.3.1, 29.3.2

RECOVER command, 14.3

COPY option, 9.5.4

PARALLEL and NOPARALLEL options, 29.2.6

TEST option, 16.4

unrecoverable objects and standby databases, 30.5

UNTIL TIME option, 29.4.2

USING BACKUP CONTROLFILE clause, 30.2.4

recovery

ADD DATAFILE operation, 30.2.3

automatically applying archived logs, 29.2.2

cancel-based, 29.4.2

complete, 17.1, 29.3

closed database, 29.3.1

offline tablespaces, 29.3.2

corruption

intentionally allowing, 29.6.4

data files, 29.2.1

database

in NOARCHIVELOG mode, 20.1

database files

how RMAN applies changes, 14.3.1

overview, 14.3

database point-in-time, 18.5

disaster using RMAN, 20.4

dropped table, 30.8

errors, 29.6.1

failures requiring, 1.1.1

interrupting, 29.2.5

media, 29, 29.6, 30

multiple redo threads, 29.2.2.2

of lost or damaged recovery catalog, 13.6.2

online redo logs, 30.7

loss of group, 30.7.2

parallel, 29.2.6

preparing for, 17.2.1.2

problems, 29.6.1

fixing, 29.6.3

investigating, 29.6.2

stuck, 29.6.1

time-based, 29.4.2

transportable tablespaces, 30.6

trial, 29.6.6

explanation, 29.6.6.1

overview, 29.6.6

troubleshooting, 29.6.1

user errors, 30.8

user-managed, 29, 29.6, 30

using backup control file, 20.3.1

without recovery catalog, 20.3.2

using logs in a nondefault location, 29.2.4.1

using logs in default location, 29.2.3

using logs in nondefault location, 29.2.4.2

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.4

Recovery Manager

allocating tape buffers, 22.2.3.1.1

archived redo logs

backups, 9.4

authentication, 2.2

backups, 9.1.2

archived redo logs, 9.4

backing up, 8.5.2.1, 9.7.1

batch deletion of obsolete, 8.8.3

control files, 9.3.3

data file, 9.3.2, 9.7.2, 9.7.3

duplexed, 8.5.1

image copy, 8.4

incremental, 9.5, 10.4.1, 10.4.2

optimization, 5.5.1, 9.4.3

tablespace, 9.7.2, 9.7.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.3

database connections, 4.5.1

auxiliary database, 4.5.4

duplicate database, 4.5.4

hiding passwords, 4.5.5

SYSDBA required for target, 4.5.1.1

without a catalog, 4.5

DBMS_PIPE package, 4.6

definition, 2.1

disconnecting from, 2.2

duplicate databases, overview of, 24.1.2.3

error codes

message numbers, 23.1.3.1

errors, 23.1, 23.1.3

interpreting, 23.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, 22.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, 23.2

overview, 2.1, 3.2

performance

monitoring, 23.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

data files, 14.2

retention policies

configuring, 5.4

return codes, 23.1.5

setting time parameters, 4.3

snapshot control file location, 6.4

starting, 2.2

synchronous and asynchronous I/O, 22.2.1.2, 22.2.1.3, 22.2.3.1.3

terminating commands, 23.4

test disk API, 5.2.4

types of backups, 8.4

using RMAN commands, 3.2

recovery window, 5.4

point of recoverability, 8.8.1

RECOVERY WINDOW parameter

CONFIGURE command, 5.4.2

recovery windows

configuring for retention policy, 5.4.2

definition, 8.8.1

RECOVERY_CATALOG_OWNER role, 13.5.2

recycle bin, 18.1.2.2.2, 18.3.2

restoring objects from, 18.3.3

redo logs

incompatible format, 29.6.1

naming, 29.2.3

parallel redo, 29.6.1

redo records

problems when applying, 29.6.1

REPAIR FAILURE command, 15.5.1, 15.6

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

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, 29.5

restartable backups, 10.7.1

restarting

duplication after a failure, 24.7

RESTORE command, 14.2, 17.2.1.2

FORCE option, 14.2.4

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, 30.1.1

to nondefault location, 30.1.2

database

to default location, 29.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, 29.2.1

RESUME clause

ALTER SYSTEM statement, 28.6.2

resuming recovery after interruption, 29.2.5

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, 23.1.5

REVOKE command, 13.5.4

RMAN repository, 1.2, 2.1

RMAN sessions, 2.7.2, 3.3

S

SBT, 3.3.1, 5.2.5.2

sbtio.log

and RMAN, 23.1.1

sbttest program, 23.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.6.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, 25.1.1.1

SET statement

AUTORECOVERY option, 29.2.2

LOGSOURCE variable, 29.2.4.2, 29.3.1, 29.3.2

shadow copies, 9.5.3.1

shared server

configuring for use with RMAN, 6.5

configuring RMAN, 6.5

short waits

definition, 22.3.2.2

SHOW command, 2.3, 2.3, 5.1.1

SHUTDOWN statement

ABORT option, 29.5, 30.1.1, 30.1.2

size of backup sets, setting, 8.3.7

skipping files in RMAN backups, 10.3

snapshot control files, 6.4, 13.8.2.1

specifying location, 6.4

split mirrors

suspend/resume mode, 28.6.1

using as backups, 10.5

SPOOL command, 15.5.1

standby databases, 3.1

creating with DUPLICATE, 24.1.1

statements, SQL

ALTER DATABASE, 29.2.4.2, 29.3.1, 29.3.2

storage snapshots, 7.1.5.1

stored scripts, 3.4, 9.6.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, 29.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, 28.6.2, 28.6.2

suspending a database, 28.6.1

suspend/resume mode, 28.6.1

SWITCH command, 17.3.4

SYSDBA privileges, 2.2

system time

changing

effect on recovery, 29.4.2

T

tables, recovery of dropped, 30.8

tablespace point-in-time recovery, 18.1.2

configuring data file names, 6.3

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.7.2, 9.7.3, 28.3.2.2

offline, 28.3.1

online, 28.3.2.2

backups using RMAN, 9.3.2

excluding from backups, 6.2.4

excluding from RMAN backups, 6.2.4

read-only

backing up, 28.3.2.4

read/write

backing up, 28.3.2.1

recovering accessible

when database is open, 17.3.3

recovering offline in open database, 29.3.2

transporting with RMAN, 26

tape devices, 3.5.2

target database

connecting to, 2.2

definition, 2.1, 3.1

terminating RMAN commands, 23.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, 23.3

time format

RECOVER DATABASE UNTIL TIME statement, 29.4.2

time parameters

setting for Recovery Manager use, 4.3

time-based recovery, 29.4.2

trace files, RMAN, 23.1.1

transparent backup encryption, 6.2.6.1.1, 6.2.6.1.1

transparent-mode backup encryption, 10.6.2

transportable tablespaces

creating with RMAN, 26.1.1

and Data Pump Export, 26.5.2

and past points in time, 26.5.1

auxiliary destination, 26.1.2

auxiliary instance parameter file, 26.2, 26.2.2

file locations, 26.5.3

initialization parameters, 26.2.1

cross-platform, 27

recovery, 30.6

transporting tablespaces, 26

trial recovery, 16.4, 29.6.6, 29.6.6.1

tuning Recovery Manager

V$ views, 23.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.5.1, 8.3.4

unrecoverable objects

recovery, 30.5, 30.5

UNREGISTER DATABASE command, 13.8.4

unregistering databases, 13.8.4

UNTIL TIME option

RECOVER command, 29.4.2

upgrading the recovery catalog, 13.8.6.1

user errors

definition, 1.1.1.2

recovery from, 30.8

user-managed backups, 28, 28.2

backup mode, 28.3.2.1, 28.3.2.3

control files, 28.4, 28.4

definition, 8.4.2

determining data file status, 28.1.2

hot backups, 8.2, 28.3.2.3.1

listing files before, 28.1

offline tablespaces, 28.3.1, 28.3.1

read-only tablespaces, 28.3.2.4

tablespace, 28.3.2.2

verifying, 28.9

whole database, 28.2

user-managed recovery, 29.4

ADD DATAFILE operation, 30.2.3

complete, 29.3

incomplete, 29.4

interrupting, 29.2.5

scenarios, 30

user-managed restore operations, 29.2.1

V

V$ARCHIVED_LOG view, 5.3.2.3, 11.5.1.1, 18.5.2

listing all archived logs, 28.5

V$BACKUP view, 28.1.2

V$BACKUP_ASYNC_IO view, 22.3.2

V$BACKUP_DATAFILE view, 9.5.2, 12.4.3.3

V$BACKUP_FILES view, 5.4.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, 22.3.2

V$BLOCK_CHANGE_TRACKING view, 9.5.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, 28.1.1

listing files for backups, 28.1

V$DATAFILE_HEADER view, 11.1.2, 17.2.1.2.2, 17.2.1.2.2

V$DIAG_INFO view, 2.9.4, 19.3

V$EVENT_NAME view, 23.2.1

V$FLASHBACK_DATABASE_LOG view, 5.3.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, 29.3.1

V$LOGFILE view, 21.6.1.2, 30.7.1, 30.7.2

V$PARAMETER view, 18.2.2

V$PROCESS view, 11.1.2, 23.2, 23.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, 29.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, 29.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, 22.2.2

V$RMAN_OUTPUT view, 11.5.2

V$RMAN_STATUS view, 23.1.1

V$SESSION view, 6.5, 11.1.2, 23.2, 23.2.2

V$SESSION_LONGOPS view, 22.3.1

V$SESSION_WAIT view, 23.2, 23.2.1

V$SGASTAT view, 22.4.3

V$SYSSTAT view, 7.5.4

V$TABLESPACE view, 17.2.1.2.2, 28.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

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, recovery catalog, 11.1.2, 11.5

virtual private catalogs, 3.4

dropping, 13.5.5

Volume Shadow Copy Service (VSS), 5.3.1, 9.5.3.1

W

wallet, 6.2.6.1.1

whole database backups

ARCHIVELOG mode, 28.2

inconsistent, 28.2

NOARCHIVELOG mode, 28.2

preparing for, 28.2

using RMAN, 9.3.1, 9.3.1