Skip Headers
Oracle® Database Backup and Recovery Basics
10g Release 2 (10.2)

Part Number B14192-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
View PDF

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