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 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, 6-2
monitoring overwriting of control file records, 6-4
ALTER 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 using 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
DELETE INPUT option, 4-11
backup methods, 1-18
comparison, 1-18
feature comparison, 1-17
backup pieces
definition, 4-4
backup sets
testing restore of, 5-9
backups
after structural changes to database, 2-15
archived redo logs
using RMAN, 4-10, 4-12
automatic log switch 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
crosschecking, 6-5
cumulative incremental, 4-17
Data Pump Export utility, 2-16
datafile
using RMAN, 4-7, 4-8
Date 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 rule, 2-8
guidelines, 2-8 to 2-18
Data Pump Export utility, 2-16
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
definition, 1-2
methods
feature comparison, 1-17
noncumulative incremental, 4-16
offline, 2-14
online, 2-14
online redo logs, 2-17
physical
definition, 1-2
planning before database creation, 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 option, 6-16
UNCATALOG option, 6-21
channels
multiple
crosschecking and deleting, 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
configuring
Recovery Manager
autobackups, 3-9
backup retention policies, 3-18
consistent backups
using RMAN, 4-6
control file autobackups
after structural changes to database, 3-9
configuring, 3-9
control file copies
backing up, 4-10
control file records
overwriting, 6-2
control files
automatic backups
configuring, 3-9
backing up
using RMAN, 4-10
backups
including within database 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 initialization 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 failure, 1-11
instance failure, 1-11
overview, 1-11
read-only tablespaces, 1-15
CROSSCHECK command, 6-5
crosschecking, 6-5
backups and copies, 6-5
on multiple channels, 6-11
cumulative incremental backups, 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
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
backing up using RMAN, 4-8
datafiles
backing up
using Recovery Manager, 4-7, 4-8
listing
unrecoverable, 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 command, 3-2
exiting RMAN, 3-2
expired backups
deleting, 6-9
EXPIRED option
of DELETE, 6-9

F

failures
described, 1-2, 1-14
instance
recovery from, 1-11
media, 1-3, 1-14
safeguards provided, 1-5
See also recovery
FORCE option
DELETE 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
structural changes, 2-15
unrecoverable operations, 2-16

H

hardware configuration
keeping records of, 2-17

I

image copies
testing restore of, 5-9
INCLUDE CURRENT CONTROLFILE option
BACKUP command, 4-9
inconsistent backups
using RMAN, 4-6
incremental backups, 4-13
differential, 4-15
initialization parameters
CONTROL_FILE_RECORD_KEEP_TIME, 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 copies, 4-50
log switches
recovery catalog records, 6-17
logical backups, 1-2

M

managing RMAN metadata, 6-1
media failures
overview, 1-3, 1-14
media recovery
overview, 1-9
metadata
managing RMAN, 6-1
RMAN
querying, 4-43
modes
archive log, 2-10
multiplexing
recovery and, 1-14

N

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

O

offline backups, 2-14
online backups, 2-14
online redo logs
backing up, 2-17
media failure, 1-14
multiplexed, 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 recoverability
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 tablespaces, 1-15
data structures used in, 1-5
failures requiring, 1-2, 1-14
generic procedures, 5-4
instance, 1-11
instance recovery, 1-11
instance failure, 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 backups, 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
tablespace, 4-7, 4-8
testing, 4-42
validating, 4-42
whole database, 4-6
commands
CATALOG, 6-17
CHANGE, 6-5
DELETE, 6-19
REPORT, 4-51
RESTORE, 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 needing a backup, 4-52
obsolete backups, 4-53
restoring
archived redo logs, 5-23
retention policies
configuring, 3-18
setting time parameters, 3-3
RECOVERY 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
objects needing a backup, 4-52
obsolete backups, 4-53
unrecoverable backups, 4-53
repository
RMAN
querying, 4-43
RESTORE command, 5-6
restore 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
software 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
recovering 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 records, 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