Index

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

---

A

alert log

control file record messages, 8.1.2

monitoring overwriting of control file records, 8.1.2.1

ALTER DATABASE statement

RENAME FILE clause, 6.4.3.1

archived log files

backing up, 4.3.7.1

deleting after backup, 4.3.7.1.2

with other backups, 4.3.7.2

archived redo logs

backing up

using RMAN, 4.3.7, 4.3.7.2

cataloging, 8.7

generated during backups, 4.3.7.1.1

restoring using RMAN, 6.4.4

archiving modes, 2.3.3

autobackups

generating, 4.3.5

availability

of RMAN backups, 8.6.1

AVAILABLE option

of CHANGE, 8.6.1

avoiding dangerous backup techniques, 2.3.12

---

B

BACKUP

ARCHIVELOG, 4.3.7.1

DELETE ALL, 4.3.7.1.2

DELETE INPUT, 4.3.7.1.2

FOR RECOVER OF COPY WITH TAG, 4.4.3

PLUS ARCHIVELOG, 4.3.7.2

backup and recovery

definition, 1.1

BACKUP command, 4.1

CURRENT CONTROLFILE option, 4.3.5.2

DELETE ALL INPUT option, 4.3.7.1.2

DELETE INPUT option, 4.3.7.1.2

backup methods, 1.10

comparison, 1.10

feature comparison, 1.9

backup pieces

definition, 4.1.2.2

backup scenarios

disk-and-tape, A.2

disk-only, A.1

backup sets

testing restore of, 6.3.5

unused space compression, 4.1.2.2

backups

after structural changes to database, 2.3.8

archived redo logs

using RMAN, 4.3.7, 4.3.7.2

automatic log switch during, 4.3.7.1.1

availability, 8.6.1

consistent

making using RMAN, 4.3.1

control file

using RMAN, 4.3.5.2, 4.3.5.3

control file autobackups, 4.3.5

crosschecking, 8.2, 8.2.1

cumulative incremental, 4.4.1.3

Data Pump Export utility, 2.3.11

datafile

using RMAN, 4.3.3, 4.3.4.1, 4.3.4.2

Date Pump Export utility, 2.3.11

definition, 1.1

exempt from retention policy, 8.6.2

expired

deleting, 8.3.2

frequency, 2.3.7

generating reports for, 4.6, 4.8.1

guidelines, 2.3

Data Pump Export utility, 2.3.11

frequency, 2.3.7

often-used tablespaces, 2.3.9

storing old backups, 2.3.6

structural changes, 2.3.8

unrecoverable objects, 2.3.10

inconsistent

making using RMAN, 4.3.1

incremental, 4.4

differential, 4.4.1.2

logical

definition, 1.1.1

methods

feature comparison, 1.9

noncumulative incremental, 4.4.1.2

offline, 2.3.7

online, 2.3.7

online redo logs, 2.3.12

physical

definition, 1.1.1

planning before database creation, 2.3

records of, 2.3.13

recovering pre-RESETLOGS, 7.6.6

Recovery Manager, 4.1

reporting objects needing backups, 4.8.2

server parameter files, 4.3.6

storing, 2.3.6

tablespace, 2.3.9

using RMAN, 4.3.3, 4.3.3, 4.3.4.1, 4.3.4.2

techniques to avoid, 2.3.12

testing RMAN, 4.5

validating, 4.5

whole database

using RMAN, 4.3.2, 4.3.2

backupsets

compressed, 4.2.5

block change tracking, 4.4.4

enabling and disabling, 4.4.4.1

block corruptions

stored in V$DATABASE_BLOCK_CORRUPTION, 4.5

---

C

CATALOG command, 8.7

CHANGE command, 8.2

AVAILABLE option, 8.6.1

UNAVAILABLE option, 8.6.1

UNCATALOG option, 8.8.1

CHANGE... KEEP

with DELETE OBSOLETE, 8.3.4.1, 8.6.2

change tracking, 4.4.4

disk space used for, 4.4.4.4

enabling and disabling, 4.4.4.1

moving the change tracking file, 4.4.4.3

channels

multiple

crosschecking and deleting, 8.4

character sets

setting for use with RMAN, 3.1.2

commands, Recovery Manager

BACKUP CURRENT CONTROLFILE, 4.3.5.2

CATALOG, 8.7

CHANGE, 8.2

CROSSCHECK, 8.2

DELETE, 8.7.1

LIST, 4.7

REPORT, 4.8.1

NEED BACKUP option, 4.8.2

RESTORE, 6.3.2.2

compressed backupsets, 4.2.5

configuring

Recovery Manager

autobackups, 3.4.7

backup retention policies, 3.5.5

consistent backups

using RMAN, 4.3.1

control file autobackups

after structural changes to database, 3.4.7

configuring, 3.4.7

control file copies

backing up, 4.3.5.3

control file records

overwriting, 8.1.2

control files

automatic backups

configuring, 3.4.7

backing up

using RMAN, 4.3.5.3

backups

including within database backup, 4.3.5.1

using RMAN, 4.3.5, 4.3.5.2

copies

backing up, 4.3.5.3

overview, 1.2.1.3

overwriting records, 8.1.2

restoring, 6.4.1.6

CONTROL_FILE_RECORD_KEEP_TIME initialization parameter, 8.1.2

preventing overwrite of RMAN records, 8.1.2

CONTROL_FILES initialization parameter, 6.4.1.6

copies

crosschecking, 8.2

crash recovery, 1.4.3

after instance failure, 1.4.3

instance failure, 1.4.3

overview, 1.4.3

read-only tablespaces, 6.3.2.3

CROSSCHECK command, 8.2

crosschecking, 8.2

backups and copies, 8.2

on multiple channels, 8.4

cumulative incremental backups, 4.4.1.3

---

D

Data Pump Export utility

backups, 2.3.11, 2.3.11

data structures

involved in recovery, 1.2.1

database connections

Recovery Manager

without a catalog, 3.3

SYSDBA required for RMAN, 3.3.2

types in RMAN, 3.3.1

database point-in-time recovery, 7.6

time-based recovery, 7.6

database point-in-time recovery (DBPITR)

definition, 7.1.1

database schema

generating reports, 4.8.5

database writer process (DBWn)

media failure, 1.8.1

databases

modes of archiving, 2.3.3

datafile copies

backing up using RMAN, 4.3.4.2

datafiles

backing up

using Recovery Manager, 4.3.3, 4.3.4, 4.3.4.1, 4.3.4.2

read-only

recovery, 6.3.2.3

DBPITR, 7.6

DELETE command, 8.3.1, 8.7.1

EXPIRED option, 8.3.2

DELETE OBSOLETE

with CHANGE... KEEP, 8.3.4.1, 8.6.2

deleting

backups, 8.3, 8.3.1

on multiple channels, 8.4

copies, 8.3

differential incremental backups, 4.4.1.2

disconnecting

from Recovery Manager, 3.1.1

disk failures, 1.1.2.2, 1.8.1

disk usage

monitoring, 3.5.4.6

---

E

environment variables

NLS_DATE_FORMAT, 3.1.2

NLS_LANG, 3.1.2

EXIT command, 3.1.1

exiting RMAN, 3.1.1

expired backups

deleting, 8.3.2

EXPIRED option

of DELETE, 8.3.2

---

F

failures

described, 1.1.2, 1.8

instance

recovery from, 1.4.3

media, 1.1.2.2, 1.8.1

safeguards provided, 1.2.1

See also recovery

flash recovery area

backup scenarios using, A.1

backup scenarios using with tape, A.2

monitoring disk usage with V$RECOVERY_FILE_DEST and V$FLASH_RECOVERY_AREA_USAGE, 3.5.4.6

Flashback Database

and flashback logs, 1.7

overview, 1.7

flashback database

determining the flashback database window, 5.3.6

enabling, 5.3.3

logs

rules for retention and deletion, 5.3.5.1

performance tuning, 5.3.7

requirements, 5.3.2

space management, 5.3.5

estimating disk space requirement, 5.3.4.1

Flashback Drop, 7.4

and recycle bin, 1.7

overview, 1.7

recycle bin, 7.4.1

flashback drop

enabling and disabling, 7.4.4

flashback features

overview, 1.7

Flashback Query

overview, 1.7

Flashback Table

overview, 1.7

flashback table

using, 7.3.1, 7.3.2

FLASHBACK TABLE statement, 7.3.1, 7.3.2

Flashback Technology

overview, 1.7

Flashback Transaction Query

overview, 1.7

flashback transaction query, 7.2

flashback undrop

object names when in recycle bin, 7.4.3

querying recycle bin, 7.4.5

restoring objects, 7.4.7

Flashback Version Query

overview, 1.7

FORCE option

DELETE command, 8.3.3

---

G

guaranteed restore point, 5.1.3

compared to storage snapshots, 5.1.3.1

requirements, 5.2.1

guaranteed restore points

space usage in flash recovery area, 5.2.3

guidelines

backups

Data Pump Export utility, 2.3.11

frequency, 2.3.7

often-used tablespaces, 2.3.9

storing old backups, 2.3.6

structural changes, 2.3.8

unrecoverable operations, 2.3.10

---

H

hardware configuration

keeping records of, 2.3.13

---

I

image copies

testing restore of, 6.3.5

INCLUDE CURRENT CONTROLFILE option

BACKUP command, 4.3.5.1

incomplete recovery

defined, 7.6

inconsistent backups

using RMAN, 4.3.1

incremental backups, 4.4

and block change tracking, 4.4.4

differential, 4.4.1.2

incrementally updated, 4.4.3

incrementally updated backups, 4.4.3

initialization parameters

CONTROL_FILE_RECORD_KEEP_TIME, 8.1.2

CONTROL_FILES, 6.4.1.6

instance recovery, 1.4.3

definition, 1.4.3

instance failure, 1.4.3

overview, 1.4.3

read-only tablespaces, 6.3.2.3

instances

recovery of, 1.4.3

I/O errors

ignoring during deletions, 8.3.3

---

K

KEEP option

of BACKUP, 8.6.2

---

L

level 0 incremental backups, 4.4.1.1

LIST command, 4.6, 4.7

lists

backups and copies, 4.7.5

log switches

recovery catalog records, 8.7

logical backups, 1.1.1

---

M

managing RMAN metadata, 8

media failures

overview, 1.1.2.2, 1.8.1

media recovery

overview, 1.4.1, 1.4.1

metadata

managing RMAN, 8

modes

archive log, 2.3.3

multiplexing

recovery and, 1.8.1

---

N

NLS_DATE_FORMAT environment variable, 3.1.2

NLS_LANG environment variable, 3.1.2

noncumulative incremental backups, 4.4.1.2

---

O

offline backups, 2.3.7

online backups, 2.3.7

online redo logs

backing up, 2.3.12

media failure, 1.8.1

multiplexed, 1.8.1

Oracle Flashback Database

overview, 1.7

Oracle Flashback Drop

overview, 1.7

Oracle Flashback Query

overview, 1.7

Oracle Flashback Table

overview, 1.7

Oracle Flashback Transaction Query

overview, 1.7

Oracle Flashback Version Query

overview, 1.7

overwriting control file records, 8.1.2

---

P

performing backups after unrecoverable operations, 2.3.10

physical backups, 1.1.1

point-in-time recovery

performing

with current control file, 7.6.4

---

Q

QUIT command, 3.1.1

quitting RMAN, 3.1.1

---

R

recovery

crash, 1.4.3

crash recovery, 1.4.3

read-only tablespaces, 6.3.2.3

data structures used in, 1.2.1

database point-in-time, 7.6

failures requiring, 1.1.2, 1.8

generic procedures, 6.3.1

instance, 1.4.3

instance recovery, 1.4.3

instance failure, 1.4.3

read-only tablespaces, 6.3.2.3

media, 1.4.1, 1.4.1

media recovery

enabled or disabled, 2.3.3

point-in-time

time-based, 7.6

preparing for, 6.3.2.2

tablespace, 6.2.2

recovery catalog

cataloging

O/S backups, 8.7

deleting backups, 8.3

deleting records, 8.3.1

log switch record, 8.7

updating

after operating system deletions, 8.8.2

Recovery Manager

archived redo logs

backups, 4.3.7

backups, 4.1

archived redo logs, 4.3.7, 4.3.7.2

control file, 4.3.5.3

control file copies, 4.3.5.3

control files, 4.3.5, 4.3.5.2

datafile, 4.3.3, 4.3.4, 4.3.4.1, 4.3.4.2

incremental, 4.4

tablespace, 4.3.3, 4.3.4.1, 4.3.4.2

testing, 4.5

validating, 4.5

whole database, 4.3.2, 4.3.2

commands

CATALOG, 8.7

CHANGE, 8.2

DELETE, 8.7.1

REPORT, 4.8.2

RESTORE, 6.3.2.2

database character set, 3.1.2

database connections, 3.3.1

SYSDBA required for target, 3.3.2

without a catalog, 3.3

datafile copies

backing up, 4.3.4.2

disconnecting from, 3.1.1

incremental backups

cumulative, 4.4.1.3

differential, 4.4.1.2

level 0, 4.4.1.1

lists, 4.7

metadata, 8

reports, 4.8.1

database schema, 4.8.5

objects needing a backup, 4.8.2

obsolete backups, 4.8.4

restoring

archived redo logs, 6.4.4

retention policies

configuring, 3.5.5

setting time parameters, 3.1.2

RECOVERY WINDOW parameter

CONFIGURE command, 3.5.5.1

recovery windows

configuring for retention policy, 3.5.5.1

Recycle Bin

and Flashback Drop, 1.7, 7.4.1

recycle bin

enabling and disabling, 7.4.4

renamed objects, 7.4.3

restoring objects from, 7.4.7

viewing, 7.4.5

redo logs

archiving modes, 2.3.3

RENAME DATABASE clause

ALTER DATABASE statement, 6.4.3.1

REPORT command, 4.6, 4.8.1

NEED BACKUP option, 4.8.2

reports, 4.6, 4.8.1, 4.8.1

database schema, 4.8.5

objects needing a backup, 4.8.2

obsolete backups, 4.8.4

unrecoverable backups, 4.8.4

RESTORE command, 6.3.2.2

restore point

guaranteed, 5.1.3

compared to storage snapshots, 5.1.3.1

normal, 5.1.2

requirements, 5.2.1

restore points

using, 5.2

restore validation, 6.3.5

restoring

control files, 6.4.1.6

server parameter files, 6.4.2, 6.4.2

testing, 6.3.5

retention policies

configuring, 3.5.5

configuring for redundancy, 3.5.5.2

disabling, 3.5.5.4

making backups exempt, 8.6.2

recovery windows, 3.5.5.1

rollback segments, 1.2.1.4

---

S

scenarios, Recovery Manager

recovering pre-resetlogs backup, 7.6.6

server parameter files

backups, 4.3.6

configuring autobackups, 3.4.7

restoring, 6.4.2, 6.4.2

software configuration

keeping records of, 2.3.13

SQLRF20001, 5.2.2

SYSDBA option

implicitly assumed for RMAN connect to target, 3.3.2

---

T

tables

FLASHBACK TABLE statement, 7.3.1

flashback transaction query, 7.2

tablespace backups

using RMAN, 4.3.3, 4.3.4.1, 4.3.4.2

tablespaces

backing up, 2.3.9

frequency, 2.3.9

backups using RMAN, 4.3.3

recovering accessible

when database is open, 6.2.2

testing RMAN

backups, 4.5

time parameters

setting for Recovery Manager use, 3.1.2

time-based recovery, 7.6

---

U

UNAVAILABLE option

of CHANGE, 8.6.1

UNCATALOG option

deleting repository records, 8.8.1

of CHANGE, 8.8.1

undo blocks, 1.2.1.4

undo tablespaces, 1.2.1.4

unrecoverable operations

performing backups after, 2.3.10

unused block compression, 4.1.2.2

unused space compression, 4.1.2.2

user errors, 1.8.2

---

V

V$DATABASE_BLOCK_CORRUPTION view, 4.5

V$FLASH_RECOVERY_AREA_USAGE, 3.5.4.6

V$RECOVERY_FILE_DEST, 3.5.4.6

validating

backups, 4.5

validation of restore, 6.3.5

---

W

whole database backups

using RMAN, 4.3.2