Skip Headers

Oracle9i User-Managed Backup and Recovery Guide
Release 2 (9.2)

Part Number A96572-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents

Master Index

Feedback

Go to previous page

Index

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


A

ABORT option
SHUTDOWN statement, 3-9, 4-16, 4-23, 4-24
active online redo log
loss of group, 6-10, 6-11
alert log, 6-14
checking after RESETLOGS, 4-30
ALLOW ... CORRUPTION clause
RECOVER command, 5-8
ALTER DATABASE statement
BACKUP CONTROLFILE clause, 2-19
TO TRACE option, 2-19
CLEAR LOGFILE clause, 6-10
END BACKUP clause, 2-12
NORESETLOGS option, 4-29
RECOVER clause, 3-16, 4-8
RESETLOGS option, 4-23, 4-25, 4-29
ALTER SYSTEM statement
RESUME clause, 2-18
SUSPEND clause, 2-18
ALTER TABLESPACE statement
BEGIN BACKUP clause, 2-8, 2-10
END BACKUP option, 2-10
archived redo logs
applying during media recovery, 4-2
automating application, 4-3, 4-4
changing default location, 4-7
corrupted, 5-2
deleting after recovery, 3-16
errors during recovery, 4-8
incompatible format, 5-3
location during recovery, 4-2
loss of, 6-12
restoring, 3-15
using for recovery
in default location, 4-5
in nondefault location, 4-7
ARCHIVELOG mode
datafile loss in, 6-2
AS SELECT clause
CREATE TABLE statement, 4-34
automatic undo management
tablespace backups, 2-15
AUTORECOVERY option
SET statement, 4-3

B

BACKUP CONTROLFILE clause
of ALTER DATABASE, 2-2
BACKUP CONTROLFILE TO TRACE clause
of ALTER DATABASE, 2-2, 2-19
backup mode
ending with ALTER DATABASE END BACKUP, 2-12
for online user-managed backups, 2-9
instance failure, 2-11
backups
after RESETLOGS, 4-30
closed, 2-4
consistent, 2-4
control files, 2-19
binary, 2-19
trace files, 2-19
DBVERIFY utility, 2-27
determining datafile status, 2-3
inconsistent, 2-4
keeping records, 3-3
listing files needed, 2-2
logical, 2-28
offline datafiles, 2-6
offline tablespaces, 2-6
read-only tablespaces, 2-14
restoring user-managed, 3-2
restoring whole database, 4-23
tablespace, 2-9
user-managed
overview, 1-3
restoring, 3-6
verifying, 2-27
whole database
preparing for, 2-4
BEGIN BACKUP clause
ALTER TABLESPACE statement, 2-8

C

cancel-based media recovery
procedures, 4-13, 4-20
change-based media recovery, 4-21
coordinated in distributed databases, 6-14
CLEAR LOGFILE clause
of ALTER DATABASE, 6-10
clone databases
preparing for TSPITR, 7-10, 7-12
preparing parameter files for, 7-7
cold failover cluster
definition, 2-12
commands, SQL
ALTER DATABASE, 3-16, 4-8
commands, SQL*Plus
RECOVER
UNTIL TIME option, 4-21
SET, 3-16, 4-3, 4-8
complete recovery
procedures, 4-9
consistent backups
whole database, 2-4
control files
backing up to trace file, 2-20
backups, 2-2, 2-19
binary, 2-19
trace files, 2-19
creating, 3-14
finding filenames, 2-2
loss of, 3-8
all copies, 3-13
multiplexed
loss of, 3-9
restoring
to default location, 3-9
to nondefault location, 3-9
time-based recovery, 4-16
CONTROL_FILES initialization parameter, 3-10
coordinated time-based recovery
distributed databases, 6-14
CREATE DATAFILE clause
of ALTER DATABASE, 3-7
CREATE TABLE statement
AS SELECT clause, 4-34
CREATE TABLESPACE statement, 6-3

D

data blocks
corrupted, 5-3
data dictionary views, 2-6, 2-8, 2-14
database incarnation, 4-26
database point-in-time recovery (DBPITR)
user-managed, 4-16
databases
listing for backups, 2-2
media recovery procedures, 4-1 to  4-22
media recovery scenarios, 6-1
recovery
after control file damage, 3-9
after OPEN RESETLOGS option, 4-31
suspending, 1-5, 2-16
datafiles
backing up
offline, 2-6
determining status, 2-3
listing
for backup, 2-2
losing, 6-2
in ARCHIVELOG mode, 6-2
in NOARCHIVELOG mode, 6-2
recovery
without backup, 3-7
re-creating, 3-7
renaming
after recovery, 6-4
restoring, 3-6
to default location, 3-7
DB_FILE_NAME_CONVERT initialization parameter, 7-8
DBA_DATA_FILES view, 2-6, 2-8, 2-14
DBVERIFY utility, 2-27
distributed databases
change-based recovery, 6-14
coordinated time-based recovery, 6-14
recovery, 6-13

E

Export utility, 2-28
backups, 2-28
read consistency, 2-28
exports
modes, 2-29

F

features, new, xxi to  xxv
filenames
listing for backup, 2-2

G

groups
archived redo log, 6-6, 6-8
online redo log, 6-6, 6-8

H

hot backup mode
for online user-managed backups, 2-9
hot backups
failed, 2-11
ending with ALTER DATABASE END BACKUP, 2-12

I

Import utility, 2-28
database recovery, 2-29
procedure for using, 2-29
inactive online redo log
loss of, 6-8
incomplete media recovery, 4-16
change-based, 4-21
in Oracle Real Application Clusters configuration, 4-5
time-based, 4-20 to  4-21
with backup control file, 4-5
initialization parameters
CONTROL_FILES, 3-10
LOG_ARCHIVE_DEST_n, 4-6
LOG_ARCHIVE_FORMAT, 4-6
RECOVERY_PARALLELISM, 4-26
instance failures
in backup mode, 2-11
interrupting media recovery, 4-33

L

log sequence numbers
requested during recovery, 4-2
LOG_ARCHIVE_DEST_n initialization parameter, 4-6, 7-9
LOG_ARCHIVE_FORMAT initialization parameter, 4-6, 7-9
LOG_FILE_NAME_CONVERT initialization parameter, 7-8
logical backups, 2-28
LOGSOURCE variable
SET statement, 3-16, 4-8
loss of
inactive log group, 6-8

M

media failures
archived redo log file loss, 6-12
complete recovery, 4-9 to  4-15, 4-15
control file loss, 3-8, 3-13
datafile loss, 6-2
NOARCHIVELOG mode, 4-22
online redo log group loss, 6-7
online redo log loss, 6-6
online redo log member loss, 6-6
recovery, 4-9 to  4-22
distributed databases, 6-13
recovery procedures
examples, 6-2
media recovery, 4-1 to  4-33
ADD DATAFILE operation, 6-3
after control file damage, 3-9
after OPEN RESETLOGS operation, 4-31
applying archived redo logs, 4-2
cancel-based, 4-13, 4-16, 4-20
change-based, 4-16, 4-21
complete, 4-9 to  4-15, 4-15
closed database, 4-9
completion of, 4-12, 4-15
corruption
allowing to occur, 5-7
datafiles
without backup, 3-7
distributed databases, 6-13
coordinated time-based, 6-14
errors, 4-8, 5-3
incomplete, 4-16
interrupting, 4-33
lost files
lost archived redo log files, 6-12
lost control files, 3-8
lost datafiles, 6-2
lost mirrored control files, 3-9
NOARCHIVELOG mode, 4-22
offline tablespaces in open database, 4-12
online redo log files, 6-5
opening database after, 4-26, 4-29
parallel, 4-25
preconditions, 4-34
problems, 5-2, 5-3
fixing, 5-5
investigating, 5-4
restarting, 4-33
restoring
archived redo log files, 3-15
whole database backups, 4-22
restrictions, 4-34
resuming after interruption, 4-33
roll forward phase, 4-2
scenarios, 6-1
time-based, 4-16
transportable tablespaces, 6-4
trial, 5-9
explanation, 5-9
overview, 5-9
troubleshooting, 5-2
basic methodology, 5-3
types
distributed databases, 6-13
undamaged tablespaces online, 4-12
unsuccessfully applied redo logs, 4-8
using Import utility, 2-29
mirrored files
online redo log
loss of, 6-6
splitting, 1-5, 2-16
suspend/resume mode, 1-5, 2-16
modes
NOARCHIVELOG
recovery from failure, 4-22
MOUNT option
STARTUP statement, 4-18, 4-19
multiplexed files
control files
loss of, 3-9

N

new features, xxi to  xxv
NOARCHIVELOG mode
datafile loss in, 6-2
disadvantages, 4-22
recovery, 4-22

O

online redo logs, 6-8
active group, 6-6, 6-8
applying during media recovery, 4-2
archived group, 6-6, 6-8
clearing
failure, 6-10
clearing inactive logs
archived, 6-9
unarchived, 6-9
current group, 6-6, 6-8
determining active logs, 6-8
inactive group, 6-6, 6-8
listing log files for backup, 2-2
loss of
active group, 6-10, 6-11
all members, 6-7
group, 6-7
mirrored members, 6-6
recovery, 6-5
multiple group loss, 6-12
replacing damaged member, 6-6
status of members, 6-6, 6-8
ORA-01578 error message, 4-35
Oracle Managed Files, 1-3

P

parallel block recovery
definition, 4-25
parallel recovery, 4-26
partitioned tables
dropped partitions, 7-19
performing partial TSPITR, 7-16
split partitions, 7-21
point-in-time recovery, 4-16
tablespace, 7-1 to  7-15

R

raw devices
backing up to, 2-22
restoring to, 3-6
UNIX backups, 2-22
Windows backups, 2-25
read consistency
Export utility, 2-28
read-only tablespaces
backups, 2-14
RECOVER clause
of ALTER DATABASE, 3-16, 4-8
RECOVER command
PARALLEL option, 4-25
unrecoverable objects and standby databases, 4-35
UNTIL TIME option, 4-21
USING BACKUP CONTROLFILE clause, 4-35
recovery
ADD DATAFILE operation, 6-3
automatically applying archived logs, 4-3
cancel-based, 4-13, 4-20
change-based, 4-21
complete, 4-9 to  4-15
closed database, 4-9
offline tablespaces, 4-12
control files, 3-8
corruption
intentionally allowing, 5-7
datafiles, 6-2
ARCHIVELOG mode, 6-2
NOARCHIVELOG mode, 6-2
determining files needing recovery, 3-5
dropped table, 6-13
errors, 5-3
Import utility, 2-29
interrupting, 4-33
media, 3-1, 4-1, 5-1, 6-1
multiple redo threads, 4-5
online redo logs, 6-5
losing member, 6-6
loss of group, 6-7
opening database after, 4-26
parallel, 4-25
parallel processes for, 4-26
preconditions, 4-34
problems, 5-2
fixing, 5-5
investigating, 5-4
responding to unsuccessful, 4-8
restrictions, 4-34
setting number of processes to use, 4-26
stuck, 5-2
time-based, 4-20 to  4-21
transportable tablespaces, 6-4
trial, 5-9
explanation, 5-9
overview, 5-9
troubleshooting, 5-2
user errors, 6-13
user-managed, 1-6, 3-1, 4-1, 5-1, 6-1
using logs in a nondefault location, 4-7
using logs in default location, 4-5
using logs in nondefault location, 4-7
RECOVERY_PARALLELISM initialization parameter, 4-26
redo logs
incompatible format, 5-3
listing files for backup, 2-2
naming, 4-6
parallel redo, 5-3
redo records
problems when applying, 5-2
RESETLOGS operation
backup after, 4-30
following up, 4-30
when necessary, 4-26
RESETLOGS option
of ALTER DATABASE, 4-23, 4-25, 4-26, 4-29
recovery of database after using, 4-31
restoring
archived redo logs, 3-15
control files, 3-8
to default location, 3-9
to nondefault location, 3-9
database
to default location, 4-23
to new location, 4-24
datafiles
to default location, 3-7
to raw devices, 3-6
user-managed backups, 1-6, 3-2
keeping records, 3-3
whole database backups, 4-23
RESUME clause
ALTER SYSTEM statement, 2-18
resuming recovery after interruption, 4-33

S

SCN (system change number)
use in distributed recovery, 6-15
SET statement
AUTORECOVERY option, 4-3
LOGSOURCE variable, 3-16, 4-8
SHUTDOWN statement
ABORT option, 3-9, 4-16, 4-23, 4-24
splitting mirrors
suspend/resume mode, 1-5, 2-16
STARTUP statement
MOUNT option, 4-18, 4-19
stuck recovery
definition, 5-2
SUSPEND clause
ALTER SYSTEM statement, 2-18
suspending a database, 1-5, 2-16
suspend/resume mode, 1-5, 2-16
system time
changing
effect on recovery, 4-16

T

tables
recovery of dropped, 6-13
tablespace point-in-time recovery
clone database, 7-2
introduction, 1-7, 7-2
methods, 7-3
performing, 7-1 to  7-15
planning for, 7-4
procedures for using transportable tablespace feature, 7-14, 7-15
requirements, 7-5
terminology, 7-2
transportable tablespace method, 7-3
user-managed, 7-3
tablespaces
backups, 2-9
offline, 2-6
online, 2-9
read-only
backing up, 2-14
read/write
backing up, 2-8
recovering offline in open database, 4-12
time format
RECOVER DATABASE UNTIL TIME statement, 4-21
time-based recovery, 4-20 to  4-21
coordinated in distributed databases, 6-14
trace files
backing up control file, 2-20
control file backups to, 2-19
transportable tablespaces
recovery, 6-4
TSPITR and, 7-3
trial recovery
explanation, 5-9
overview, 5-9

U

undo tablespaces
backups, 2-15
unrecoverable objects
and RECOVER operation, 4-35
recovery
unrecoverable objects and, 4-34
UNTIL TIME option
RECOVER command, 4-21
user errors
recovery from, 6-13
user-managed backup and recovery
definition, 1-2
reasons, 1-2
user-managed backups, 2-4
backup mode, 2-11
basic methodology, 1-4
control files, 2-19
binary, 2-19
trace files, 2-19
definition, 1-3
determining datafile status, 2-3
hot backups, 2-12
listing files before, 2-2
offline datafiles, 2-6
offline tablespaces, 2-6
read-only tablespaces, 2-14
restoring, 3-6
restoring whole database, 4-23
tablespace, 2-9
verifying, 2-27
whole database, 2-4
user-managed recovery, 4-16
ADD DATAFILE operation, 6-3
applying archived redo logs, 4-2
complete, 4-9
incomplete, 4-16
interrupting, 4-33
opening database after, 4-26
scenarios, 6-1
user-managed restore and recovery
overview, 1-6
user-managed restore operations, 3-2
USING BACKUP CONTROLFILE option
RECOVER command, 4-19

V

V$ARCHIVED_LOG view
listing all archived logs, 2-22
V$BACKUP view, 2-3
V$DATAFILE view, 2-2
listing files for backups, 2-2
V$LOG_HISTORY view
listing all archived logs, 3-15
V$LOGFILE view, 6-6, 6-8
listing files for backups, 2-2
listing online redo logs, 2-2
V$RECOVER_FILE view, 3-5
V$RECOVERY_LOG view
listing logs needed for recovery, 3-15
V$TABLESPACE view, 2-2

W

warning
consistency and Export backups, 2-29
whole database backups
ARCHIVELOG mode, 2-4
inconsistent, 2-4
NOARCHIVELOG mode, 2-4
preparing for, 2-4
restoring from, 4-23

Go to previous page
Oracle
Copyright © 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents

Master Index

Feedback