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