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