Index
A B C D E F G H I J K L M N O P R S T U V W
A
- ABORT option
-
- SHUTDOWN statement, 18.5.1.1, 18.5.1.2, 18.8.1, 18.10.1, 18.10.2
- active online redo log
-
- loss of group, 19.8.2.2, 19.8.2.2
- alert log, 19.11.1
-
- checking after RESETLOGS, 18.9.3
- useful for RMAN, 12.1.1
- ALLOW ... CORRUPTION clause
-
- RECOVER command, 21.5
- ALTER DATABASE statement
-
- BACKUP CONTROLFILE clause, 17.5.2
-
- TO, 17.5.2
- CLEAR LOGFILE clause, 19.8.2.1.3
- END BACKUP clause, 17.4.3.1
- NORESETLOGS option, 18.9.2
- OPEN RESETLOGS clause, 10.2.3
- RECOVER clause, 18.4.2, 18.6.6
- RESETLOGS option, 18.9.2, 18.9.2, 18.10.1, 18.10.2
- ALTER SYSTEM statement
-
- KILL SESSION clause, 12.3.1
- RESUME clause, 17.7.2
- SUSPEND clause, 17.7.2, 17.7.2
- ALTER TABLESPACE statement
-
- BEGIN BACKUP clause, 17.4.1, 17.4.2.2
- END BACKUP option, 17.4.2.2
- archived redo logs
-
- applying during media recovery, 18.6
- automating application, 18.6.2.1, 18.6.2.2
- backing up, 6.9.6
- cataloging, 10.2.1.2
- changing default location, 18.6.5
- corrupted, 21.1
- deleting after recovery, 18.4.2
- deletion after backup, 2.2.4.1, 9.3.2.4
- deletion after restore, 3.2.2.1
- errors during recovery, 18.6.7
- incompatible format, 21.1
- location during recovery, 18.6
- loss of, 19.9
- restoring, 18.4.2
- RMAN fails to delete, 12.4.6
- using for recovery
-
- in default location, 18.6.3
- in nondefault location, 18.6.6
- ARCHIVELOG mode
-
- datafile loss in, 19.1.2, 19.1.2
- AS SELECT clause
-
- CREATE TABLE statement, 19.5
- autobackups
-
- control file, 2.6, 2.6.2.1
- server parameter file, 2.6
- automatic channels, 2.1
-
- allocation, 2.1
- configuring, 5.3, 5.3.1, 5.3.4, 6.1
- generic
-
- configuring, 2.1.5, 5.3.2
- definition, 5.3.2
- naming conventions, 2.1.4
- overriding, 5.3
- parallelism, 5.3.1
- specific configurations, 2.1.6, 2.1.6
- AUTORECOVERY option
-
- SET statement, 18.6.2
- auxiliary instance parameter file
-
- with TRANSPORT TABLESPACE, 14.3.4
B
- BACKUP
-
- and corrupt datafile blocks and MAXCORRUPT, 2.11.2
- AS COPY
-
- and DB_FILE_NAME_CONVERT, 2.4.2
- and output filenames, 2.4.2
- FORMAT, 2.4.2
- image copy
-
- and output filenames, 2.4.2
- INCREMENTAL
-
- FROM SCN, 13.8
- INCREMENTAL FROM SCN, 13.8.1
- output filenames
-
- image copies, 2.4.2
- BACKUP command, 6.9.13
-
- BACKUPSET option, 2.3.2, 6.4
- DELETE INPUT option, 9.3.3
- FORMAT parameter, 2.4.1
- KEEP option, 2.7.4
- NOT BACKED UP SINCE clause, 2.9, 6.7
- PROXY ONLY option, 2.2.2
- PROXY option, 2.2.2
- SKIP OFFLINE option, 6.9.1, 6.9.1
- VALIDATE option, 2.12.4
- BACKUP CONTROLFILE clause
-
- of ALTER DATABASE, 17.1.1
- BACKUP CONTROLFILE TO TRACE clause
-
- of ALTER DATABASE, 17.1.1
- BACKUP COPIES parameter
-
- CONFIGURE command, 5.6
- backup encryption, 6.6.1
-
- dual-mode, 6.6.1.3
- overview, 6.6
- password, 6.6.1.2
- transparent, 6.6.1.1
- backup mode
-
- ending with ALTER DATABASE END BACKUP, 17.4.3.1
- for online user-managed backups, 17.4.1
- instance failure, 17.4.3
- backup optimization
-
- configuring, 5.5
- definition, 2.8, 6.7
- disabling, 2.8.3, 5.5
- enabling, 2.8.3, 5.5
- recovery window and, 2.8.5.1
- redundancy and, 2.8.5.2
- retention policies and, 2.8.5
- BACKUP OPTIMIZATION option
-
- of CONFIGURE, 6.7
- backup retention policy
-
- definition, 2.7
- backup sets
-
- backing up, 2.3.2, 6.4
- configuring maximum size, 5.4
- crosschecking, 9.2
- duplexing, 6.2
- errors during creation, 2.11
- failover during backups, 2.3.2.3
- how RMAN generates, 2.4.5
- limiting size, 2.4.5
- multiplexing, 2.2.5
- naming, 2.4.1
- specifying maximum size (in bytes), 2.4.4
- specifying number of, 2.4.5
- Backup Solutions Program (BSP), 1.4.2
- backups
-
- archived redo logs, 6.9.6
-
- deletion after backing up, 9.3.2.4
- availability
-
- altering with CHANGE command, 9.4
- backup sets, 6.4
- backups of, 2.3.2
- closed, 17.2.1
- consistent, 17.2
- control files, 17.5, 17.5
-
- binary, 17.5.1
- trace files, 17.5.2
- correlating RMAN channels with, 9.6.1.2.1, 9.6.1.2.2
- cumulative incremental, 2.5.1.4, 3.4
- datafile
-
- using RMAN, 6.4, 6.7.1, 6.7.2
- DBVERIFY utility, 17.9
- deleting, 9.3.2
- determining datafile status, 17.1.2
- duplexing, 5.6, 6.2
- excluding tablespaces from backups, 5.7
- failed RMAN, 12.4.7
- failover during BACKUP BACKUPSET, 2.3.2.3
- hung, 12.4.2
- image copies, 2.2.1
- inconsistent, 17.2
- incremental, 2.5.1
-
- differential, 2.5.1.3
- using RMAN, 6.2.1, 6.2.2
- interrupted, 6.7
- keeping, 6.9.11
- keeping records, 17.12
- limiting I/O rate, 2.4.6
- listing files needed, 17.1
- logical, 17.10
- long-term, 2.7.4, 2.7.4
-
- changing status, 9.5
- multiple copies, 5.6
- NOARCHIVELOG mode, in, 6.9.10
- obsolete
-
- batch deletes, 2.7.3
- offline datafiles, 17.3
- offline tablespaces, 17.3, 17.3
- optimizing, 2.8
- read-only tablespaces, 17.4.4
- recovery catalog, 1.3.2.4, 10.6.1
- restartable, 2.9, 6.7
- restoring user-managed, 18.2
- RMAN error handling, 6.9.13
- specifying number of files in a backup set, 2.4.5.1
- split mirror, 2.2.1.2
-
- using RMAN, 6.3
- stored scripts, 10.5
- tablespace, 17.4.2
-
- using RMAN, 6.4, 6.7.1, 6.7.2
- tags, 2.4.3
- testing RMAN, 2.12.4, 6.8
-
- using media manager, 5.2.3.4
- troubleshooting failed RMAN, 12.4.1, 12.4.4, 12.4.5
- types, 2.5
- Updating standby databases with incrementals, 13.8.1
- user-managed, 17
-
- restoring, 18.4.1
- validating, 6.8
- verifying, 17.9
- whole database
-
- preparing for, 17.2.1
- BEGIN BACKUP clause
-
- ALTER TABLESPACE statement, 17.4.1
- block corruptions
-
- stored in V$DATABASE_BLOCK_CORRUPTION, 6.8
- block media recovery, 7.5
-
- guidelines, 3.3.1
- overview, 3.3
- BLOCKRECOVER command, 3.3, 7.5
- BSP. See Backup Solutions Program (BSP)
C
- cancel-based media recovery
-
- procedures, 18.7.2, 18.8.4
- canceling RMAN commands, 12.3
- CATALOG command, 10.2.1.2
- cataloging
-
- archived redo logs, 10.2.1.2
- datafiles, 10.2.1.2
- catalog.sql script, 10.1.2
- catproc.sql script, 10.1.2
- CHANGE command, 9.2
-
- AVAILABLE option, 9.4
- KEEP option, 9.5
- change-based media recovery
-
- coordinated in dis, 19.11.1
- channels
-
- allocating manually for backups, 6.1
- configuring automatic, 5.3
- configuring for backups, 6.1
- control options, 2.1.9
- definition, 2.1
- difference between manual and automatic, 2.1.1
- generic configurations, 2.1.5
- overriding automatic, 5.3
- parallelism for manual channels, 2.1.8
- preconfigured disk, 5.3
- Recovery Manager, 2.1
- RMAN naming conventions, 2.1.4
- specific configurations, 2.1.6
- circular reuse records, 1.3.1.1
- CLEAR LOGFILE clause
-
- of ALTER DATABASE, 19.8.2.1.3
- clearing RMAN configuration, 2.1.7, 5.3.5
- clone databases
-
- preparing for TSPITR, 20.3.1, 20.3.2
- cold failover cluster
-
- definition, 17.4.3
- command files
-
- Recovery Manager, 1.2.2.2
- command interface
-
- RMAN, 1.2
- commands, Recovery Manager
-
- BACKUP, 6.9.13
-
- PROXY ONLY option, 2.2.2
- PROXY option, 2.2.2
- SKIP OFFLINE option, 6.9.1
- batch execution, 1.2.2.2
- CATALOG, 10.2.1.2
- CHANGE, 9.2
- CONFIGURE, 2.1.5, 2.1.7
- DELETE, 9.3.2
- DROP CATALOG, 10.12
- DUPLICATE, 3.4
- EXECUTE SCRIPT, 10.5
- how RMAN interprets, 1.2
- interactive, 1.2.2.1
- LIST, 9.1.1
-
- INCARNATION option, 10.2.3
- piping, 4.7
- RECOVER, 3.2
- RESET DATABASE
-
- INCARNATION option, 10.2.3
- RESYNC CATALOG, 10.3
-
- FROM CONTROLFILECOPY option, 10.6.3
- SET
-
- MAXCORRUPT option, 6.9.13
- SHOW, 2.1.2
- standalone, 1.2.2.5
- terminating, 12.3, 12.3
- UPGRADE CATALOG, 10.11
- commands, SQL
-
- ALTER DATABASE, 18.4.2, 18.6.6
- commands, SQL*Plus
-
- RECOVER
-
- UNTIL TIME option, 18.8.4
- SET, 18.4.2, 18.6.2, 18.6.6
- compatibility
-
- recovery catalog, 1.3.2.5
- compilation
-
- and execution of RMAN commands, 1.2.1
- complete recovery
-
- procedures, 18.7
- CONFIGURE command
-
- BACKUP OPTIMIZATION option, 5.5
- CHANNEL option, 2.1.5
- CLEAR option, 2.1.7, 5.3.5
- DEFAULT DEVICE TYPE clause, 2.1.3
- DEVICE TYPE clause, 2.1.2
- EXCLUDE option, 5.7
- RETENTION POLICY clause, 2.7, 2.7
- configuring
-
- media manager
-
- installing, 5.2.1
- prerequisites, 5.2.1
- media managers for use with RMAN, 5.2.3.1
- Recovery Manager
-
- autobackups, 2.6
- automatic channels, 5.3, 5.3.2
- backup optimization, 5.5
- backup set size, 5.4
- clearing, 2.1.7, 5.3.5
- default device types, 2.1.3
- device types, 2.1.2
- parallelism, 2.1.2
- shared server, 5.10
- snapshot control file location, 5.9
- specific channels, 5.3.4
- tablespace exclusion for backups, 5.7
- consistent backups
-
- whole database, 17.2
- control file autobackups
-
- after structural changes to database, 2.6
- configuring, 2.6
- default format, 2.6.1
- restoring, 2.6
- control files
-
- automatic backups, 2.6.2.1
-
- configuring, 2.6
- backing up to trace file, 17.5.2.1
- backups, 17.1.1, 17.5
-
- binary, 17.5.1
- recovery using, 7.3
- trace files, 17.5.2
- creating after loss of all copies, 18.5.3
- duplicate database, 13.2.1
- finding filenames, 17.1.1
- multiplexed
-
- loss of, 18.5.1
- recreated, 18.5.3
- restoring
-
- to default location, 18.5.1.1
- to nondefault location, 18.5.1.2
- using SET DBID, 7.6.2
- snapshot
-
- specifying location of, 5.9
- time-based recovery, 18.8.2
- types of records, 1.3.1.1
- user-managed restore after loss of all copies, 18.5.3
- using instead of a recovery catalog, 1.3.1
- CONTROL_FILES initialization parameter, 8.5.1.2, 18.5.1.2
- CONVERT command
-
- and DB_FILE_NAME_CONVERT, 15.1.1
- moving data to/from ASM, 15.4
- with databases, 15.2
- with tablespaces and datafiles, 15
- CONVERT DATABASE, 15.2
- CONVERT DATAFILE
-
- moving to/from ASM, 15.4
- CONVERT DATAFILE or TABLESPACE, 15.1
- CONVERT TABLESPACE
-
- moving to/from ASM, 15.4
- coordinated time-based recovery
-
- distributed databases, 19.11.1
- COPIES option
-
- of BACKUP, 6.2.2
- corrupt datafile blocks, 2.12.1
-
- detecting, 2.12.1, 2.12.2
- records in control file, 2.11.2
- recovering, 7.5.3
- RMAN and, 2.11.1
- setting maximum for backup, 6.9.13
- corrupt datafile blocks during backup, 2.11.2
- corruption detection, 2.12.2
- CREATE DATAFILE clause
-
- of ALTER DATABASE, 19.3
- CREATE TABLE statement
-
- AS SELECT clause, 19.5
- CREATE TABLESPACE statement, 19.2
- creating
-
- test databases, 3.4
- crosschecking
-
- definition, 9.2
- recovery catalog with the media manager, 9.2
- cross-platform transportable database, 15.2
-
- transport script, 15.3.2.1
- cross-platform transportable tablespace, 15
- cumulative incremental backups, 2.5.1.4
D
- data blocks
-
- corrupted, 21.1
- data dictionary views, 17.3, 17.4.1, 17.4.4
- Data Pump Export utility, 17.10
-
- backups, 17.10
- Data Pump Import utility, 17.10
- database connections
-
- Recovery Manager
-
- auxiliary database, 4.3
- hiding passwords, 4.5
- database incarnation, 18.9
- database point-in-time recovery (DBPITR)
-
- user-managed, 18.8
- databases
-
- listing for backups, 17.1
- media recovery procedures, user-managed, 18
- media recovery scenarios, 19
- recovery
-
- after control file damage, 18.5.1.1, 18.5.1.2
- registering in recovery catalog, 10.2.1, 10.2.1
- suspending, 17.7.1
- unregistering in recovery catalog, 10.2.2
- datafile recovery
-
- definition, 3.2
- datafiles
-
- backing up
-
- offline, 17.3
- using Recovery Manager, 6.4, 6.7.1, 6.7.2
- cataloging, 10.2.1.2
- determining status, 17.1.2
- duplicate database, 13.2.3
- listing
-
- for backup, 17.1
- losing, 19.1
-
- in ARCHIVELOG mode, 19.1.2
- in NOARCHIVELOG mode, 19.1.1
- recovery
-
- basic steps, 3.2.1
- without backup, 19.3
- re-creating, 19.3
- renaming
-
- after recovery, 19.2
- restoring, 3.1, 18.4.1
-
- to default location, 18.4.1
- db identifier
-
- problems registering copied database, 10.2.1.2
- setting during disaster recovery, 7.3.1
- setting with DBNEWID, 10.2.1.2
- DB_FILE_NAME_CONVERT
-
- and CONVERT command, 15.1.1
- DB_FILE_NAME_CONVERT initialization parameter, 8.5.1.2, 20.2.6
-
- using with RMAN DUPLICATE command, 13.2.3, 13.2.4, 13.2.4
- DB_NAME initialization parameter, 8.5.1.2
- DBA_DATA_FILES view, 17.3, 17.4.1, 17.4.4
- DBMS_PIPE package, 4.7
-
- using with RMAN, 4.7
- DBNEWID utility, 10.2.1.2
- DBVERIFY utility, 17.9
- DELETE command, 9.3.2
-
- OBSOLETE option, 2.7.3
- deleting
-
- expired backups, 9.3.2.3
- files after backups, 9.3.3
- obsolete backups, 9.3.2.2
- using RMAN, 9.3.1
- device types
-
- configuring in RMAN, 5.3.1
- differential incremental backups, 2.5.1.3
- disk API, 5.2.3
- disk channels
-
- preconfigured, 5.3
- distributed databases
-
- change-based recovery, 19.11.1
- coordinated time-based recovery, 19.11.1
- recovery, 19.11, 19.11
- dropping the recovery catalog, 10.12
- dual mode backup encryption, 6.6.1.3
- dummy API, 5.2.3
- duplexing
-
- backup sets, 2.3.1, 5.6, 6.2
- DUPLICATE command, 3.4
- duplicate database
-
- synchronizing
-
- using DUPLICATE DATABASE, 13.7
- using incremental backups, 13.8
- duplicate databases
-
- creating, 3.4
-
- on local host, 13.5.3
- on remote host with different file system, 13.5.2
- on remote host with same file system, 13.5.1
- past point-in-time, 13.6.4
- using CONFIGURE AUXNAME, 13.5.2.4
- using init.ora parameter and LOGFILE, 13.5.2.2
- using SET NEWNAME, 13.5.2.3
- datafiles, 13.2.3
- excluding tablespaces, 3.4, 13.1.2
- failed creation, 12.4.10
- generating control files, 13.2.1
- generating filenames, 13.2
- how RMAN creates, 13.1.1
- NOFILENAMECHECK option, 13.2.3.1
- preparing for duplication, 13.4
- skipping offline normal tablespaces, 13.3.2
- skipping read-only tablespaces, 13.3.1
- duplicating a database, 3.4
-
- troubleshooting, 12.4.10
E
- endian formats
-
- and CONVERT DATAFILE/TABLESPACE, 15.1
- environment, Recovery Manager
-
- definition, 1.1
- error codes
-
- media manager, 12.1.3.2
- RMAN, 12.1, 12.1.3
-
- message numbers, 12.1.3.1
- error messages
-
- Recovery Manager
-
- interpreting, 12.1.4
- error stacks
-
- interpreting, 12.1.4
- errors
-
- during RMAN backups, 6.9.13
- EXCLUDE option
-
- of CONFIGURE, 5.7
- expired backups
-
- deleting, 9.3.2.3
F
- FAST_START_MTTR_TARGET
-
- and tuning instance recovery, 11.4.4
- Fast-Start checkpointing architecture, 11.4.3
- Fast-Start Fault Recovery, 11.4, 11.4.3
- features, new, Preface
- fileNameConversionSpec
-
- and CONVERT command, 15.1.1
- filenames
-
- listing for backup, 17.1
- FORCE option
-
- DELETE command, 9.3.5
- fractured blocks
-
- definition, 2.12.3
- detection, 2.12.3
G
- generic channels
-
- definition, 5.3.2
- groups
-
- archived redo log, 19.8.1, 19.8.2
- online redo log, 19.8.1, 19.8.2
H
- hot backup mode
-
- for online user-managed backups, 17.4.1
- hot backups
-
- failed, 17.4.3
-
- ending with ALTER DATABASE END BACKUP, 17.4.3.1
I
- image copies, 2.2.1
-
- and SWITCH commands, 2.2.1.1
- inactive online redo log
-
- loss of, 19.8.2.1
- INCARNATION option
-
- of LIST, 10.2.3
- of RESET DATABASE, 10.2.3
- incomplete media recovery, 18.8
-
- in Oracle Real Application Clusters configuration, 18.6.2.2
- time-based, 18.8.4
- with backup control file, 18.6.2.2
- incomplete recovery
-
- overview, 3.2.3
- incremental backups
-
- differential, 2.5.1.3
- how RMAN applies, 3.2.2
- using RMAN, 6.2.1, 6.2.2
- Incremental Roll Forward of Database Copy, 13.8
- initialization parameter file, 3.2
- initialization parameters
-
- CONTROL_FILES, 18.5.1.2
- DB_FILE_NAME_CONVERT, 8.5.1.2
- DB_NAME, 8.5.1.2
- LARGE_POOL_SIZE, 11.3.3
- LOCK_NAME_SPACE, 8.5.1.2
- LOG_ARCHIVE_DEST_n, 18.6.3
- LOG_ARCHIVE_FORMAT, 18.6.3
- LOG_FILE_NAME_CONVERT, 8.5.1.2
- RECOVERY_PARALLELISM, 18.11
- instance failures
-
- in backup mode, 17.4.3
- instance recovery
-
- Fast-Start Fault Recovery, 11.4.3
- performance tuning, 11.4
- integrity checks, 2.12
- interpreting RMAN error stacks, 12.1.4
- interrupting media recovery, 18.6.8
- I/O errors
-
- effect on backups, 2.11.1
- ignoring during deletions, 9.3.5
J
- jobs
-
- RMAN
-
- monitoring performance, 9.6.4
- monitoring progress, 9.6.2
K
- KEEP option
-
- of BACKUP, 2.7.4
- of CHANGE, 9.5
L
- level 0 incremental backups, 2.5.1.2
- LIST command, 9.1.1
-
- INCARNATION option, 10.2.3
- LOCK_NAME_SPACE initialization parameter, 8.5.1.2
- log sequence numbers
-
- requested durin, 18.6
- LOG_ARCHIVE_DEST_n initialization parameter, 18.6.3, 20.2.6
- LOG_ARCHIVE_FORMAT initialization parameter, 18.6.3, 20.2.6
- LOG_FILE_NAME_CONVERT initialization parameter, 8.5.1.2, 20.2.6
- logical backups, 17.10
- LOGSOURCE variable
-
- SET statement, 18.4.2, 18.6.6
- long waits
-
- defined, 11.3.5.2
- long-term backups
-
- changing status, 9.5
- definition, 2.7.4, 2.7.4
- loss of
-
- inactive log group, 19.8.2.1
M
- managing RMAN metadata, 10, 13
- MAXCORRUPT setting, 2.11.2
- MAXPIECESIZE parameter
-
- SET command, 5.2.3.2.2
- MAXSETSIZE parameter
-
- BACKUP command, 5.4
- CONFIGURE command, 5.4
- MAXSIZE parameter
-
- RECOVER command, 3.2.2.1
- mean time to recovery (MTTR)
-
- definition, 3.3
- media failures
-
- archived redo log file loss, 19.9
- complete recovery, 18.7
- complete recovery, user-managed, 18.7
- control file loss, 18.5.3
- datafile loss, 19.1
- NOARCHIVELOG mode, 18.10
- online redo log group loss, 19.8.2
- online redo log loss, 19.8.1
- online redo log member loss, 19.8.1
- recovery, 18.7
-
- distributed databases, 19.11
- recovery procedures
-
- examples, 19.1
- media management
-
- backing up files, 1.4.1
- Backup Solutions Program, 1.4.2
- crosschecking, 9.2
- error codes, 12.1.3.2
- linking to software, 5.2.2
- sbttest program, 12.2.1
- testing the API, 12.2
- media managers
-
- configuring for use with RMAN, 5.2.3.1
- installing, 5.2.1
- linking
-
- testing, 5.2.3
- prerequisites for configuring, 5.2.1
- testing, 5.2.3
- testing backups, 5.2.3.4
- troubleshooting, 5.2.3.4
- media recovery
-
- ADD DATAFILE operation, 19.2
- after control file damage, 18.5.1.1, 18.5.1.2
- applying archived redo logs, 18.6
- cancel-based, 18.7.2, 18.8, 18.8.4
- ch, 18.8
- complete, 18.7
-
- closed database, 18.7.1
- complete, user-managed, 18.7
- corruption
-
- allowing to occur, 21.4
- datafiles
-
- basic steps, 3.2.1
- without backup, 19.3
- distributed databases, 19.11
- errors, 18.6.7, 18.6.7, 21.1
- incomplete, 18.8
- interrupting, 18.6.8
- lost files
-
- lost archived redo log files, 19.9
- lost datafiles, 19.1
- lost mirrored control files, 18.5.1
- NOARCHIVELOG mode, 18.10, 18.10
- offline tablespaces in open database, 18.7.2
- online redo log files, 19.8
- opening database after, 18.9, 18.9.2
- parallel, 18.11
- problems, 21.1, 21.1
-
- fixing, 21.3
- investigating, 21.2
- restarting, 18.6.8
- restoring
-
- archived redo log files, 18.4.2
- whole database backups, 18.10
- resuming after interruption, 18.6.8
- roll forward phase, 18.6
- scenarios, 19
- time-based, 18.8
- transportable tablespaces, 19.7
- trial, 21.6
-
- explanation, 21.6.1
- overview, 21.6
- troubleshooting, 21.1
-
- basic methodology, 21.1
- types
-
- distributed databases, 19.11
- undamaged tablespaces online, 18.7.2
- unsuccessfully applied redo logs, 18.6.7
- using Recovery Manager, 3.2
- media recovery, user-managed, 18
- metadata
-
- managing RMAN, 1.3, 10, 13
- querying RMAN, 9.1
- storing in control file, 1.3.1
- mirrored files
-
- online redo log
-
- loss of, 19.8.1
- splitting, 17.7.1
-
- suspend/resume mode, 17.7.1
- using RMAN, 6.3
- mirroring
-
- backups using, 6.3
- modes
-
- NOARCHIVELOG
-
- recovery from failure, 18.10
- monitoring RMAN, 9.6
- MOUNT option
-
- STARTUP statement, 18.8.2, 18.8.3
- multiplexed files
-
- control files
-
- loss of, 18.5.1
- multiplexing
-
- datafiles with Recovery Manager, 2.2.5
N
- naming backup sets, 2.4.1
- new features, Preface
- NOARCHIVELOG mode
-
- backing up, 6.9.10
- datafile loss in, 19.1.1
- disadvantages, 18.10
- recovery, 18.10
- noncircular reuse records, 1.3.1.1
- NOT BACKED UP SINCE clause
-
- BACKUP command, 6.7
- not feasible to test 1 oct 04 nocheck, 5.2.3.1
O
- obsolete backups
-
- deleting, 2.7.3, 9.3.2.2
- different from expired backups, 2.7
- reporting, 9.1.2.1
- online redo logs, 19.8.2.1
-
- active group, 19.8.1, 19.8.2
- applying during media recovery, 18.6
- archived group, 19.8.1, 19.8.2
- clearing
-
- failure, 19.8.2.1.3
- clearing inactive logs
-
- archived, 19.8.2.1.1
- unarchived, 19.8.2.1.2
- current group, 19.8.1, 19.8.2
- determining active logs, 19.8.2
- inactive group, 19.8.1, 19.8.2
- listing log files for backup, 17.1.1
- loss of
-
- active group, 19.8.2.2, 19.8.2.2
- all members, 19.8.2
- group, 19.8.2
- mirrored members, 19.8.1
- recovery, 19.8
- multiple group loss, 19.8.2.3
- replacing damaged member, 19.8.1
- status of members, 19.8.1, 19.8.2
- online tablespace transport, 14
- OPEN RESETLOGS clause
-
- ALTER DATABASE statement, 10.2.3
- operating system copies
-
- definition, 2.2.1.2
- ORA-01578 error message, 19.5
- Oracle Encryption Wallet
-
- and backups, 6.6.1.1
P
- packages
-
- DBMS_PIPE, 4.7, 4.7
- parallel recovery, 18.11
- parallelism
-
- backups, 2.2.7
- configuring RMAN, 2.1.2, 5.3.1
- manually allocated RMAN channels, 2.1.8
- partitioned tables
-
- dropped partitions, 20.6
- performing partial TSPITR, 20.5
- split partitions, 20.7
- password backup encryption, 6.6.1.2
- password files
-
- connecting to Recovery Manager with, 4.2
- passwords
-
- connecting to RMAN, 4.5
- performance tuning
-
- backup performance, 11.3
- disk bandwidth and RATE channel parameter, 11.2.1
- Fast-Start Fault Recovery, 11.4
- instance recovery, 11.4
-
- FAST_START_MTTR_TARGET, 11.4.3
- setting FAST_START_MTTR_TARGET, 11.4.4
- using V$INSTANCE_RECOVERY, 11.4.3.3
- LARGE_POOL_SIZE initialization parameter, 11.3.3
- long waits
-
- defined, 11.3.5.2
- short waits
-
- definition of, 11.3.5.2
- pipe interface, 4.7
- point of recoverability
-
- recovery window, 2.7.1
- point-in-time recovery, 18.8
-
- tablespace, 8, 8.1.2, 8.1.2.1, 20.4.2
-
- user-managed, 20
- PROXY ONLY option
-
- of BACKUP, 2.2.2
- PROXY option
-
- of BACKUP, 2.2.2
R
- RATE option
-
- of ALLOCATE CHANNEL, 2.4.6
- of CONFIGURE CHANNEL, 2.4.6
- raw devices
-
- backing up to, 17.8
- restoring to, 18.4.1
- UNIX backups, 17.8.1
- Windows backups, 17.8.2
- read-only tablespaces
-
- backing up, 6.9.1
- backups, 17.4.4
- Recov, 10.2.3
- RECOVER clause
-
- of ALTER DATABASE, 18.4.2, 18.6.6
- RECOVER command, 3.2, 3.2.2.1
-
- unrecoverable objects and standby databases, 19.5
- UNTIL TIME option, 18.8.4
- USING BACKUP CONTROLFILE clause, 19.6
- RECOVER SQL*Plus statement
-
- PARALLEL and NOPARALLEL options, 18.11
- recovery
-
- ADD DATAFILE operation, 19.2
- automatically applying archived logs, 18.6.2
- cancel-based, 18.7.2, 18.8.4
- complete, 18.7
-
- closed database, 18.7.1
- offline tablespaces, 18.7.2
- corruption
-
- intentionally allowing, 21.4
- data blocks, 3.3, 7.5
-
- guidelines, 3.3.1
- database
-
- in NOARCHIVELOG mode, 7.1.1
- database files
-
- how RMAN applies changes, 3.2.2
- overview, 3.2
- datafile without a backup, 7.6.3
- datafiles, 19.1
-
- ARCHIVELOG mode, 19.1.2
- NOARCHIVELOG mode, 19.1.1
- determining files needing recovery, 18.3
- disaster using RMAN, 7.4
- dropped table, 19.10
- errors, 21.1
- interrupting, 18.6.8
- media, 18, 19, 21
- multiple redo threads, 18.6.2.2
- of lost or damaged recovery catalog, 10.6.3
- online redo logs, 19.8
-
- losing member, 19.8.1
- loss of group, 19.8.2
- opening database after, 18.9
- parallel, 18.11
- parallel processes for, 18.11
- problems, 21.1
-
- fixing, 21.3
- investigating, 21.2
- responding to unsuccessful, 18.6.7
- setting number of processes to use, 18.11
- stuck, 21.1
- time-based, 18.8.4
- transportable tablespaces, 19.7
- trial, 21.6
-
- explanation, 21.6.1
- overview, 21.6
- troubleshooting, 21.1
- user errors, 19.10
- user-managed, 18, 19, 21
- using backup control file, 7.3
-
- without recovery catalog, 7.3.1
- using logs in a nondefault location, 18.6.5
- using logs in default location, 18.6.3
- using logs in nondefault location, 18.6.6
- without a recovery catalog, 1.3.1.2
- recovery catalog, 1.3.2
-
- availability, 10.8
- backing up, 1.3.2.4, 10.6.1
- compatibility, 1.3.2.5
- contents, 1.3.2.2
- crosschecking, 9.2
- db identifier problems, 10.2.1.2
- dropping, 10.12
- managing size of, 10.4
- moving to new database, 10.7
- operating with, 1.3
- operating without, 1.3.1
- recovery of, 10.6.3
- refreshing, 10.3
- registering target databases, 1.3.2.1, 10.2.1, 10.2.1
- resynchronizing, 10.3
- snapshot control file, 1.3.2.3.1
- space requirements, 10.1.1.2
- stored scripts
-
- creating, 10.5.1
- synchronization, 1.3.2.3
- UNKNOWN database name, 12.4.12
- unregistering databases, 10.2.2
- updating
-
- after schema changes, 10.3.3.3
- upgrading, 10.11
- views
-
- querying, 10.9
- Recovery Manager
-
- allocating disk buffers, 11.1.1
- allocating tape buffers, 11.1.1.2
- backup sets
-
- backing up, 6.4
- backup types
-
- duplexed backup sets, 2.3.1
- backups
-
- backing up, 2.3.2
- batch deletion of obsolete, 2.7.3
- control file autobackups, 2.6.2.1
- datafile, 6.4, 6.7.1, 6.7.2
- image copy, 2.2.1
- incremental, 6.2.1, 6.2.2
- long-term, 2.7.4
- optimization, 2.8
- restartable, 2.9
- tablespace, 6.4, 6.7.1, 6.7.2
- testing, 2.12.4, 6.8
- types, 2.5
- using tags, 2.4.3
- validating, 6.8
- channels, 2.1
-
- generic configurations, 2.1.5
- naming conventions, 2.1.4
- specific configurations, 2.1.6
- commands
-
- BACKUP, 2.2.2, 6.9.13
- CATALOG, 10.2.1.2
- CHANGE, 9.2
- EXECUTE SCRIPT, 10.5
- interactive use of, 1.2.2.1
- RESYNC CATALOG, 10.6.3
- standalone commands, 1.2.2.5
- using command files, 1.2.2.2
- compilation and execution of commands, 1.2.1
- configuring
-
- default device types, 2.1.3
- device types, 2.1.2
- corrupt datafile blocks, 2.12.1, 2.12.2
-
- handling I/O errors and, 2.11.1
- crosschecking recovery catalog, 9.2
- database connections
-
- auxiliary database, 4.3
- duplicate database, 4.3
- hiding passwords, 4.5
- with password files, 4.2
- DBMS_PIPE package, 4.7
- duplicate databases
-
- how created, 13.1.1
- environment
-
- definition, 1.1
- error codes
-
- message numbers, 12.1.3.1
- errors, 12.1, 12.1.3
-
- interpreting, 12.1.4
- file deletion
-
- overview, 9.3.1
- fractured block detection in, 2.12.3
- hanging backups, 12.4.2
- image copy backups, 2.2.1
- incremental backups
-
- cumulative, 2.5.1.4
- differential, 2.5.1.3
- level 0, 2.5.1.2
- integrity checking, 2.12
- interactive use of commands, 1.2.2.1
- jobs
-
- monitoring progress, 9.6.2
- media management
-
- backing up files, 1.4.1
- Backup Solutions Program (BSP), 1.4.2
- crosschecking, 9.2
- media manager, linking with a, 5.2.2
- metadata, 1.3, 10, 13
-
- storing in control file, 1.3.1
- monitoring, 9.6, 9.6.4
- multiplexing
-
- datafiles, 2.2.5
- overview, 1.2
- performance
-
- monitoring, 9.6
- pipe interface, 4.7
- recovery
-
- after total media failure, 7.4
- recovery catalog, 1.3.2
-
- availability, 10.8
- backing up, 10.6.1
- compatibility, 1.3.2.5
- contents, 1.3.2.2
- crosschecking, 9.2
- managing the size of, 10.4
- moving to new database, 10.7
- operating with, 1.3
- operating without, 1.3.1
- recovering, 10.6.3
- registration of target databases, 1.3.2.1, 10.2.1
- resynchronizing, 10.3
- snapshot control file, 1.3.2.3.1
- synchronization, 1.3.2.3
- updating after schema changes, 10.3.3.3
- upgrading, 10.11
- reports, 9.1
-
- overview, 9.1.2
- restoring
-
- datafiles, 3.1
- to new host, 7.2
- return codes, 12.1.5
- RPC calls and, 12.4.3
- snapshot control file location, 5.9
- standby databases
-
- creating, 3.5
- starting, 4.1
- stored scripts, 1.2.2.3
- synchronous and asynchronous I/O, 11.1.2
- tablespace point-in-time recovery, 3.2.4
- tags for backups, 2.4.3
- terminating commands, 12.3
- test disk API, 5.2.3
- types of backups, 2.2.1
- using RMAN commands, 1.2
- recovery window
-
- point of recoverability, 2.7.1
- recovery windows
-
- backup optimization and, 2.8.5.1
- definition, 2.7.1
- RECOVERY_PARALLELISM initialization parameter, 18.11
- redo logs
-
- incompatible format, 21.1
- listing files for backup, 17.1.1
- naming, 18.6.3
- parallel redo, 21.1
- redo records
-
- problems when applying, 21.1
- REGISTER command, 10.2.1
- REPORT OBSOLETE command, 2.7.3
- reports, 9.1
-
- obsolete backups, 9.1.2.1
- overview, 9.1.2
- repository
-
- RMAN, 1.3
- RESET DATABASE command
-
- INCARNATION option, 10.2.3
- RESETLOGS operation
-
- when necessary, 18.9.1
- RESETLOGS option
-
- of ALTER DATABASE, 18.9, 18.9.2, 18.9.2, 18.10.1, 18.10.2
- restartable backups
-
- definition, 2.9, 6.7
- restarting RMAN backups, 6.7
- RESTORE command, 3.1
-
- FORCE option, 3.1.4
- restore optimization, 3.1.4
- restoring
-
- archived redo logs, 18.4.2
- backup control file
-
- using SET DBID, 7.6.2
- control files
-
- to default location, 18.5.1.1
- to nondefault location, 18.5.1.2
- database
-
- to default location, 18.10.1
- to new host, 7.2
- to new location, 18.10.2
- database files, 3.1
-
- how RMAN chooses, 3.1.2
- mechanics, 3.1.1
- restore optimization, 3.1.4
- datafiles
-
- to default location, 18.4.1
- to raw devices, 18.4.1
- user-managed backups, 18.2
-
- keeping records, 17.12
- RESUME clause
-
- ALTER SYSTEM statement, 17.7.2
- resuming recovery after interruption, 18.6.8
- RESYNC CATALOG command, 10.3
-
- FROM CONTROLFILECOPY option, 10.6.3
- resynchronizing the recovery catalog, 10.3
- retention policies
-
- affect on backup optimization, 2.8.5
- definition, 2.7
- disabling, 2.7
- exempt backups, 2.7.4
- recovery window, 2.7
- redundancy, 2.7, 2.7.2
- return codes
-
- RMAN, 12.1.5
- RMAN. See Recovery Manager
S
- sbtio.log
-
- and RMAN, 12.1.1
- sbttest program, 12.2.1
- scenarios, Recovery Manager
-
- backing up archived redo logs, 6.9.6
- duplexing backup sets, 6.2
- handling backup errors, 6.9.13
- maintaining backups and copies, 6.9.11
- NOARCHIVELOG backups, 6.9.10
- recovering pre-resetlogs backup, 7.1.1
- recovery after total media failure, 7.4
- setting size of backup sets, 6.9.4
- schemas
-
- changes
-
- updating recovery catalog, 10.3.3.3
- SCN (system change number)
-
- use in distributed recovery, 19.11.1
- server parameter files
-
- autobackups, 2.6
- configuring autobackups, 2.6
- server sessions
-
- Recovery Manager, 1.1.1
- session architecture
-
- Recovery Manager, 1.1.1
- SET command
-
- MAXCORRUPT option, 6.9.13
- SET statement
-
- AUTORECOVERY option, 18.6.2
- LOGSOURCE variable, 18.4.2, 18.6.6
- shared server
-
- configuring for use with RMAN, 5.10
- short waits
-
- definition of, 11.3.5.2
- SHOW command, 2.1.2
- SHUTDOWN statement
-
- ABORT option, 18.5.1.1, 18.5.1.2, 18.8.1, 18.10.1, 18.10.2
- size of backup sets
-
- setting, 2.4.4
- SKIP OFFLINE option
-
- of BACKUP, 6.9.1
- SKIP READONLY option
-
- of BACKUP, 6.9.1
- snapshot control files, 1.3.2.3.1
-
- specifying location, 5.9
- split mirrors
-
- using as backups, 6.3
- splitting mirrors
-
- suspend/resume mode, 17.7.1
- standalone Recovery Manager commands, 1.2.2.5
- standby databases
-
- creating using RMAN, 3.5
- updating with incrementals, 13.8.1
- starting RMAN
-
- without connecting to a database, 4.1
- STARTUP statement
-
- MOUNT option, 18.8.2, 18.8.3
- stored scripts
-
- creating RMAN, 10.5.1
- deleting, 10.5.6, 10.5.6, 10.5.6
- managing, 10.5
- Recovery Manager, 1.2.2.3
- stuck recovery
-
- definition, 21.1
- SUSPEND clause
-
- ALTER SYSTEM statement, 17.7.2, 17.7.2
- suspending a database, 17.7.1
- suspend/resume mode, 17.7.1
- SWITCH command, 2.2.1.1
- synchronizing duplicate database
-
- uising DUPLICATE DATABASE, 13.7
- uising incremental backups, 13.8
- system time
-
- changing
-
- effect on recovery, 18.8
T
- tables
-
- recovery of dropped, 19.10
- tablespace backups
-
- using RMAN, 6.4, 6.7.1, 6.7.2
- tablespace point-in-time recovery, 8.1.2
-
- clone database, 20.1.1
- introduction, 20.1
- methods, 20.1.2
- performing
-
- user-managed, 20
- planning for, 20.2
- procedures for using transportable tablespace feature, 20.4.1, 20.4.2
- requirements, 20.2.1
- terminology, 20.1.1
- transportable tablespace method, 20.1.2
- user-managed, 20.1.2
- using RMAN, 3.2.4
-
- basic steps, 8.1.2
- introduction, 8.1
- planning, 8.2
- preparing the auxiliary instance, 8.5.1
- restrictions, 8.1.2.1.1
- why perform, 8.1.2
- tablespace transport
-
- online, 14
- tablespaces
-
- backups, 17.4.2
-
- offline, 17.3
- online, 17.4.2
- excluding from RMAN backups, 5.7
- read-only
-
- backing up, 6.9.1, 17.4.4
- read/write
-
- backing up, 17.4.1
- recovering offline in open database, 18.7.2
- tags, 2.4.3
- terminating RMAN commands, 12.3
- test databases, creating, 3.4
- test disk API, 5.2.3
- testing RMAN
-
- backups, 2.12.4, 6.8
- with media management API, 12.2
- time format
-
- RECOVER DATABASE UNTIL TIME statement, 18.8.4
- time-based recovery, 18.8.4
-
- coordinated in distributed databases, 19.11.1
- trace files
-
- and RMAN, 12.1.1
- backing up control file, 17.5.2.1
- control file backups to, 17.5.2
- transparent backup encryption, 6.6.1.1
- transportable tablespace
-
- cross-platform, 15
- online, 14
- transportable tablespaces
-
- and CONVERT DATAFILE/TABLESPACE, 15.1
- creating with RMAN, 14.1
-
- and Data Pump Export, 14.3.3
- and past points in time, 14.3.2
- auxiliary destination, 14.2.2, 14.3.1
- auxiliary instance parameter file, 14.3.4, 14.3.4.2
- Concepts, 14.2
- file locations, 14.3.7
- initialization parameters, 14.3.4.1
- limitations, 14.2.3
- Shared Pool Size, 14.3.5, 14.4.1
- when to use, 14.2.1
- cross-platform, 15.1
- recovery, 19.7
- TSPITR and, 20.1.2
- transporting databases across platforms, 15.2
- trial recovery
-
- explanation, 21.6.1
- overview, 21.6
- TSPITR, 8.1.2
- TSPITR. See tablespace point-in-time recovery
- tuning
-
- Recovery Manager
-
- V$ views, 9.6
U
- UNAVAILABLE option
-
- of CHANGE, 9.4
- unrecoverable objects
-
- and RECOVER operation, 19.5
- recovery
-
- unrecoverable objects and, 19.5
- unregistering a database from the recovery catalog, 10.2.2
- UNTIL TIME option
-
- RECOVER command, 18.8.4
- upgrading the recovery catalog, 10.11
- user errors
-
- recovery from, 19.10
- user-managed backups, 17, 17.2
-
- backup mode, 17.4.3
- control files, 17.5, 17.5
-
- binary, 17.5.1
- trace files, 17.5.2
- determining datafile status, 17.1.2
- hot backups, 17.4.3.1
- listing files before, 17.1
- offline dataf, 17.3
- offline tablespaces, 17.3, 17.3
- read-only tablespaces, 17.4.4
- restoring, 18.4.1, 18.4.1
- tablespace, 17.4.2
- verifying, 17.9
- whole database, 17.2.1
- user-managed recovery, 18.8
-
- ADD DATAFILE operation, 19.2
- complete, 18.7
- incomplete, 18.8
- interrupting, 18.6.8
- opening database after, 18.9
- scenarios, 19
- user-managed restore operations, 18.2
- USING BACKUP CONTROLFILE option
-
- RECOVER command, 18.8.3
V
- V$ARCHIVED_LOG view, 3.2.2.1
-
- listing all archived logs, 17.6
- V$BACKUP view, 17.1.2
- V$BACKUP_ASYNC_IO, 9.6
- V$BACKUP_CORRUPTION view, 2.11.2
- V$BACKUP_SYNC_IO, 9.6
- V$COPY_CORRUPTION view, 2.11.2
- V$DATABASE_BLOCK_CORRUPTION view, 6.8, 7.5.3
- V$DATAFILE view, 17.1.1
-
- listing files for backups, 17.1
- V$LOG_HISTORY view
-
- listing all archived logs, 18.4.2
- V$LOGFILE view, 19.8.1, 19.8.2
-
- listing files for backups, 17.1.1
- listing online redo logs, 17.1.1
- V$PROCESS view, 9.6
- V$RECOVER_FILE view, 18.3
- V$RECOVERY_LOG view
-
- listing logs needed for recovery, 18.4.2
- V$SESSION view, 9.6
- V$SESSION_LONGOPS view, 9.6
- V$SESSION_WAIT view, 9.6
- V$TABLESPACE view, 17.1.1
- validating
-
- backups, 6.8
- views
-
- recovery catalog, 10.9
W
- wallet, 6.6.1.1
- whole database backups
-
- ARCHIVELOG mode, 17.2
- inconsistent, 17.2
- NOARCHIVELOG mode, 17.2
- preparing for, 17.2.1