Skip Headers

Oracle® Database Backup and Recovery Basics
10g Release 1 (10.1)

Part Number B10735-01
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
Feedback

Go to pr
evious page
Previous
View PDF

Index

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


A

alert log
control file record messages, 6-2
monitoring overwriting of control file records, 6-4
ALTE R DATABASE statement
RENAME FILE clause, 5-20
archived redo logs
backing up
using RMAN, 4-10, 4-12
cataloging, 6-17
generated during backups, 4-11
restoring us ing RMAN, 5-23
archiving modes, 2-10
autobackups
generating, 4-9
availability
of RMAN backups, 6-16
AVAILABLE option
of CHANGE, 6-16
avoiding dangerous backup techniques, 2-17

B

backup and recovery
definition, 1-2
BACKUP command, 4-2
CURRENT CONTROLFILE option, 4-9
DELETE ALL INPUT option, 4-11
DEL ETE INPUT option, 4-11
backup methods, 1-1 8
comparison, 1-18
feature comparison, 1-17
backup pieces
definition, 4-4
backup sets
testing restore of, 5-9
backups
after structural chan ges to database, 2-15
archived redo logs
using RMAN, 4-10, 4-12
automatic log s witch during, 4-11
availability, 6-16
consistent
making using RMAN, 4-6
control file
using RMAN, 4-9, 4-10
control file autobackups, 4-9
crossc hecking, 6-5
cumulative incremental, 4-17
< dd class="L2IX">Data Pump Export utility, 2-16
datafile
< dd class="L3IX">using RMAN, 4-7, 4-8
Da te Pump Export utility, 2-16
definition, 1-2
exempt from retention policy, 6-17
expired
deleting, 6-9
frequency, 2-14
generating reports for, 4-44
golden rul e, 2-8
guidelines, 2-8 to 2-18
Data Pump Export utility, 2-16< /a>
frequency, 2-14
often-used tablespaces, 2-15
storing old backups, 2-14
structural changes, 2-15
unrecoverable objects, 2-16
inconsistent
making using RMAN, 4-6
incremental, 4-13
differential, 4-15
logical
definit ion, 1-2
methods
feature comparis on, 1-17
noncumulative incremental, 4-16
offline, 2-14
online, 2-14
online redo logs, 2-17
physical
definition, 1-2
planning before database cre ation, 2-8
records of, 2-17
Recovery Manager, 4-2
reporting objects needing backups, 4-52
server parameter files, 4-10
storing , 2-14
tablespace, 2-15
using RMAN, 4-7, 4-8
techniques to avoid, 2-17
testing RMAN, 4-42
validating, 4-42
whole database
using RMAN, 4-6
block corruptions
stored in V$DATABASE_BLOCK_CORRUPTION, 4-42

C

CATALOG command, 6-17
CHANGE command, 6 -5
AVAILABLE option, 6-16
UNAVAILABLE o ption, 6-16
UNCATALOG option, 6-21
channels
multiple
crosschecking and delet ing, 6-11
character sets
setting for use with RMAN, 3-3
commands, Recovery Manager
BACKUP CURRENT CONTROLFILE, 4-9
CATALOG, 6-17
CHANGE, 6-5
CROSSCHECK, 6-5
DELETE, 6-19
LIST, 4-44
REPORT, 4-51
NEED BACKUP option, 4-51
RESTORE, 5-6
< /dl>
configuring
Recovery Manager
autob ackups, 3-9
backup retention policies, 3-18
consistent backups
using RMAN, 4-6
control file autobackups
after structural changes to data base, 3-9
configuring, 3-9
control file copies
backing up, 4-10
control file records
overwriting, 6-2
control files
automatic backups
configuri ng, 3-9
backing up
using RMAN, 4-10
backups
including within databa se backup, 4-9
using RMAN, 4-9
copies
backing up, 4-10
overview, 1-6
overwriting records, 6-2
restoring, 5-16
CONTROL_FILE_RECORD_KEEP_TIME initi alization parameter, 6-2
preventing overwrite of RMAN records, 6-2
CONTROL_FILES initialization parameter, 5-16
copies
crosschecking, 6-5
crash recovery, 1-11
after instance fail ure, 1-11
instance failure, 1-11
overview, 1-11
read-only tablespaces, 1-15< /a>
CROSSCHECK command, 6-5
crosschecking, 6-5
backups and copies, 6-5
on multiple channels, 6-11
cumulative incremental backup s, 4-17

D

Data Pump Export utility
backups, 2-16
data structures
involved in recovery, 1-5
database connections
Recovery Manager
without a catalog, 3-4
< /dl>
SYSDBA required for RMAN, 3-3
types in RMAN, 3-2
database schema
generating reports, 4-55
database writer process (DBWn)
media failure, 1-15
databases
modes of archiving, 2-10
datafile copies < dl class="L2IX">
backing up using RMAN, 4-8
datafiles
backing up
using Recovery Manager, 4-7, 4-8
listing
unrecoverab le, 4-51
read-only
recovery, 1-15
DELETE command, 6-8, 6-19
EXPIRED option, 6-9
deleting
backups, 6-7, 6-8
on multiple channels, 6-11
copies, 6-7
differential incremental backups, 4-15
disconnecting
from Recovery Manager, 3-2
disk failures, 1-3, 1-14

E

environment variables
NLS_DATE_FORMAT, 3-3
NLS_LANG, 3-3
EXIT comman d, 3-2
exiting RMAN, 3-2
expired backups
deleting, 6-9
EXP IRED option
of DELETE, 6-9

F

failures
described, 1-2, 1 -14
instance
recovery from, 1-11
media, 1-3, 1-14
safe guards provided, 1-5
See also recovery
FORCE option
DELE TE command, 6-10

G

golden rule
of backup and recovery, 2-8
guidelines
backups
Data Pump Export utility, 2-16
frequency, 2-14
often-used tablespaces, 2-15
storing old backups, 2-14
str uctural changes, 2-15
unrecoverable operations, 2-16

H

hardware configuration
kee ping records of, 2-17

I

image copies
testing restore of, 5-9
INCLUDE CURRENT CONTROL FILE option
BACKUP command, 4-9
in consistent backups
using RMAN, 4-6
incremental backups, 4-13
differential, 4-15
initialization parameters
CONTROL_FILE_RECORD_KEEP_TIM E, 6-2
CONTROL_FILES, 5-16
instance recovery, 1-11
definition, 1-11
instance failure, 1-11
overview, 1-11
read-only tablespaces, 1-15
instances
recovery of, 1-11
I/O errors
ignoring during deletions, 6-10

K

KEEP option
of BACKUP, 6-17

L

level 0 incremental backups, 4-15
LIST command, 4-44
lists
backups and copie s, 4-50
log switches
recovery cata log records, 6-17
logical backups, 1-2

M

managing RMAN metadata, 6-1
media fail ures
overview, 1-3, 1-14
media recovery
overview, 1-9
metadata
managing RMAN, 6-1
RMAN
querying, 4-43
modes
archive log, 2-10
multi plexing
recovery and, 1-14

N

NLS_DATE_FORMAT environment variable, 3-3
NLS_LANG environment varia ble, 3-3
noncumulative incremental backups, 4-16

O< /h2>
offline backups, 2-14
online backups , 2-14
online redo logs
backing up, 2-17
media failure, 1-14
m ultiplexed, 1-14
open database recovery
using RMAN, 5-13
overwriting control file records, 6-2

P

performing backups after unrecoverable operations, 2-16
physical backups, 1-2
point of reco verability
recovery window, Glossary-17

Q

querying
recovery catalog, 4-44
QUIT command, 3-2
quitting RMAN, 3-2

R

recovery
crash, 1-11
crash recovery, 1-11
read-only tab lespaces, 1-15
data structures used in, 1 -5
failures requiring, 1-2, 1-14
generic procedures, 5-4
instance, 1-11< /a>
instance recovery, 1-11
instance failur e, 1-11
read-only tablespaces, 1-15
media, 1-9
media recovery
enabled or disabled, 2-10
open database using RMAN, 5-13
preparing for, 5-6
tablespace, 5-13
recovery catalog
cataloging
O/S backups, 6-17
deleting backu ps, 6-7
deleting records, 6-8
log switch record, 6-17
querying, 4-44
updating
after operating system deletions, 6-21
Recovery Manager
archived redo logs
backups, 4-10
backups, 4- 2
archived redo logs, 4-10, 4-12
control file, 4-10
control file copies, 4-10
control files, 4-9
datafile, 4-7, 4-8
incremental, 4-13< /dd>
tablespace, 4-7, 4-8
testin g, 4-42
validating, 4-42
wh ole database, 4-6
commands
CATALOG , 6-17
CHANGE, 6-5
DELETE , 6-19
REPORT, 4-51
RESTOR E, 5-6
database character set, 3-3
database connections, 3-2
SYSDBA required for target, 3-3
without a catalog, 3-4
datafile copies
backing up, 4-8
disconnecting from, 3-2
incremental backups
cumulative, 4-17
differential, 4- 15
level 0, 4-15
lists, 4-44
metadata, 6-1
recovery
open database, 5-13
recovery catalog
querying, 4-44
reports, 4-51
database schema, 4-55
objects ne eding a backup, 4-52
obsolete backups, 4-53
< /dl>
restoring
archived redo logs, 5-23
retention policies
configuring, 3-18
setting time parameters, 3-3
RECOVER Y WINDOW parameter
CONFIGURE command, 3-18
recovery windows
configuring for retention policy, 3-18
redo logs
archiving modes, 2-10
RENAME DATABASE clause
ALTER DATABASE statement, 5-20
REPORT command, 4-51
NEED BACKUP option, 4-51
reports, 4-44, 4-51
database schema, 4-55< /a>
objects needing a backup, 4-52
obsolete backups, 4-53
unrecoverable backups, 4-53
repository
RMAN
querying, 4-43
RESTORE command, 5-6
rest ore validation, 5-9
restoring
control files , 5-16
server parameter files, 5-17
testing, 5-9
retention policies
configuring, 3-18
configuring for redundancy, 3-19
disabling, 3-19
making backups exempt, 6-17
recovery windows, 3-18
rollback segments, 1-7

S

server parameter files
backups, 4-10
configuring autobackups, 3-9
restoring, 5-17
softwar e configuration
keeping records of, 2-17
SYSDBA option
implicitly assumed for RMAN connect to target, 3-3

T

tablespace backups
using RMAN, 4-7, 4-8
tablespaces
backing up, 2-15
frequency, 2-15
backups using RMAN, 4-7
recove ring accessible
when database is open, 5-13
testing RMAN
backups, 4-42
time parameters
setting for Recovery Manager use, 3-3

U

UNAVAILABLE option
of CHANGE, 6-16
UNCATALOG option
deleting repository record s, 6-21
of CHANGE, 6-21
undo blocks, 1-7
undo tablespaces, 1-7
unrecoverable operations
performing backups after, 2-16
user errors, 1-16

V

V$DATABASE_BLOCK_CORRUPTION view, 4-42
validating
backups, 4-42
validation of restore, 5-9

W

whole database backups
using RMAN, 4-6