Oracle9i User-Managed Backup and Recovery Guide -- Index

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-7

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-24, 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

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

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

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 tablespace, 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

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, 2-2, 2-19

backing up to trace file, 2-20

backups

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

data blocks

corrupted, 5-2

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

Export utility, 2-28

backups, 2-28

read consistency, 2-28

exports

modes, 2-29

features, new

LOG_ARCHIVE_DEST_n parameter, xix, xx

suspend/resume database operations, xx

transportable tablespaces, xx

filenames

listing for backup, 2-2

groups

archived redo log, 6-6, 6-8

online redo log, 6-6, 6-8

hot backup mode

for online user-managed backups, 2-9

hot backups

failed, 2-11

ending with ALTER DATABASE END BACKUP, 2-12

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

using 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

log sequence numbers

requested during recovery, 4-2

LOG_ARCHIVE_DEST_n initialization parameter, 4-6

LOG_ARCHIVE_FORMAT initialization parameter, 4-6

LOG_FILE_NAME_CONVERT initialization parameter, 7-8, 7-9

logical backups, 2-28

LOGSOURCE variable

SET statement, 3-16, 4-8

loss of

inactive log group, 6-8

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 logs, 4-2

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-6

datafiles

without backup, 3-7

distributed databases, 6-13

coordinated time-based, 6-14

error messages, 4-8

errors, 5-3

errors with redo log files, 4-8

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-4

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-8

explanation, 5-8

overview, 5-8

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

multithreaded recovery, 4-5

new features

LOG_ARCHIVE_DEST_n parameter, xix, xx

suspend/resume database operations, xx

transportable tablespaces, xx

NOARCHIVELOG mode

datafile loss in, 6-2

disadvantages, 4-22

recovery, 4-22

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

parallel block recovery

definition, 4-25

parallel recovery, 4-26

partitioned tables

and dropped partitions, 7-19

and split partitions, 7-21

performing partial TSPITR, 7-16

point-in-time recovery, 4-16

tablespace, 7-1 to 7-15

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-26

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-6

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

multithreaded, 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-4

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-8

explanation, 5-8

overview, 5-8

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

listing files for backup, 2-2

naming, 4-6

redo records

problems when applying, 5-2

RESETLOGS operation

backup after, 4-30

following up, 4-30

when necessary, 4-27

RESETLOGS option

of ALTER DATABASE, 4-24, 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, 1-6

user-managed backups, 3-2

keeping records, 3-3

whole database backups, 4-23

RESUME clause

ALTER SYSTEM statement, 2-18

resuming recovery after interruption, 4-33

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

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

backing up, 2-9

online, 2-9

backups

offline, 2-6

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-8

overview, 5-8

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, 4-16

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

ADD DATAFILE operation, 6-3

applying archived 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$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

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