Oracle8i Backup and Recovery Guide -- Index

ABORT option

SHUTDOWN command, 3-3, 14-17, 14-18, 14-26, 15-12

active online redo log

loss of group, 15-9, 15-10

ALERT files, 15-16

checking after RESETLOGS, 14-34

allocate channel command (RMAN), 11-9

for delete option, 8-26, 11-13

for maintenance option, 11-13

ALTER DATABASE command

alter database command (RMAN), 11-15

ALTER SYSTEM command

ARCHIVE ALL option

using to archive online redo logs, 3-5

ARCHIVE LOG CURRENT option, 16-4, 16-21

RESUME option, 13-10

SUSPEND option, 13-9

ALTER TABLESPACE command

BEGIN BACKUP option, 13-6, 13-9

BEGIN/END BACKUP option, 6-28

END BACKUP option, 13-9

application error

definition, 1-12

applying log files

SQL*Plus, 14-12

ARCHIVE LOG CURRENT option

ALTER SYSTEM command, 16-4, 16-21

archived redo logs, 2-14, 2-18, 2-21

archivelog backups

using RMAN, 8-8

ARCHIVELOG mode, 2-16

advantages, 2-17

archiving, 2-15

backup options, 3-20

backup strategies when using, 3-16

datafile loss in, 15-3

definition of, 2-16

distributed databases, 3-22

overview, 1-10

running in, 2-16

strategies for backups in, 3-16

archivelogRecoverSpecifier clause (RMAN), 11-17

archiving

advantages, 2-15

after inconsistent closed backups, 3-5

after open backups, 3-5

ALTER SYSTEM ARCHIVE ALL, 3-5

destination states, 16-11

disadvantages, 2-15

to failed destinations, 16-11

viewing information on, 2-4, 2-18

AS SELECT option

CREATE TABLE command, 14-4

AUTORECOVERY option

SET command, 14-12

auxiliary databases

for RMAN TSPITR

converted filenames, A-15

using datafile copies, A-14

auxiliary sets

for RMAN TSPTIR, A-4

naming datafiles in tablespaces, A-13

available option (RMAN)

change command, 6-8

avoiding dangerous backup techniques, 3-23

backup command (RMAN), 4-29, 8-2, 8-26, 11-21

format parameter, 4-31

proxy only option, 4-19

proxy option, 4-19

skip offline option, 8-15

backup control files

recovery using, 9-20

BACKUP CONTROLFILE option

ALTER DATABASE command, 3-6, 13-3

BACKUP CONTROLFILE TO TRACE option

ALTER DATABASE command, 13-3, 13-12

backup files

user-created, cataloging, 6-28

backup formats, 3-12 to 3-14

backup sets, 3-12

logical backups, 3-14

backup methods, 3-8 to 3-11

comparison of, 3-11

Enterprise Backup Utility, 3-11

Export utility, 3-10

operating system, 3-10

Recovery Manager, 3-9

backup options

ARCHIVELOG mode, 3-20

NOARCHIVELOG mode, 3-20

backup pieces

naming, 4-31

backup sets

creating using backup command, 4-31

testing restore of, 6-18

type of backup format, 3-12

Backup Solutions Program (BSP), 4-20

Legato Storage Manager (LSM), 4-20

backup strategy

overview, 1-11 to 1-17

BACKUP_TAPE_IO_SLAVES initialization parameter, 8-23

backups

after OPEN RESETLOGS option, 3-19

after structural changes to database, 3-18

after UNRECOVERABLE operations, 16-28

archived redo logs, 8-19

using RMAN, 8-8

ARCHIVELOG mode in, 3-16

backup command (RMAN), 8-2

backup sets, 4-28

choosing a strategy, 3-15 to 3-24

consistent, 1-16

consistent whole database, 3-2

control file, 2-7, 2-9, 3-8, 13-11

using RMAN, 8-6, 8-7

cumulative incremental, 4-42, 4-50, 4-53, 8-22, 16-7, 16-30

datafile, 3-8

using RMAN, 8-4, 8-5, 8-6

DBVERIFY utility, 13-5

definition, 1-2

distributed databases, 3-22

ARCHIVELOG mode, 3-22

NOARCHIVELOG mode, 3-22

duplexing, 8-22

effects of archiving on, 2-16

Enterprise Backup Utility, 3-10

Export utility, 3-10, 3-14, 3-22

frequency, 3-18

full, 4-37

generating reports for, 7-2

guidelines, 3-14 to 3-24

distributed database constraints, 3-22

Export utility, 3-22

frequency, 3-18

multiplexing files, 3-17

often-used tablespaces, 3-19

storing old backups, 3-21

structural changes, 3-18

testing strategies, 3-24

unrecoverable operations, 3-19

whole database backups after OPEN RESETLOGS, 3-19

image copies, 4-28, 4-45

importance, 1-11

inconsistent, 1-16

closed database, 3-4

in NOARCHIVELOG mode, 3-4

listing files needed, 13-2

logical, definition, 1-2

NOARCHIVELOG mode, in, 3-16, 8-23

noncumulative incremental, 4-40

offline, 3-18

online, 3-18

online redo logs, 3-23

options

ARCHIVELOG mode, 3-20

NOARCHIVELOG mode, 3-20

Parallel Server Environment, 8-25

parallelization, 4-34, 8-23

physical, definition, 1-2

planning before database creation, 3-14

procedures, 13-3 to 13-17

offline tablespaces, 13-10

procedures for

offline datafiles, 13-10

recovery catalog, 4-14

Recovery Manager types, 4-28

Recovery Manager, user tags for, 4-46

reporting objects needing backups, 7-5

restoring whole database backup, 14-17

RMAN error handling, 8-26

status

checking backup, 13-7

stored scripts, 6-20

storing, 3-21

tablespace, 3-19, 13-8

using RMAN, 8-4, 8-5, 8-6

techniques to avoid, 3-23

test strategies, 3-24

to disk, 3-10

types, 3-2, 13-3 to 13-17

whole database, 3-2, 13-3 to 13-5

backup control files and, 3-3

preparing to take, 13-4

using RMAN, 8-3

backups, using RMAN, 8-2

BEGIN BACKUP option

ALTER TABLESPACE command, 13-6

BEGIN/END option

ALTER TABLESPACE command, 6-28

BSP

See Backup Solutions Program

cancel-based media recovery

definition, 3-29

procedures, 14-20, 14-23, 14-26, 14-29

CASE1.RCV sample script

setting size limits for backup pieces, 5-20

catalog command (RMAN), 6-5, 6-27, 11-32

cataloging O/S copies, 8-25

CATALOG.SQL script, 6-2

CATPROC.SQL script, 6-2

CATRMAN.SQL script, 6-5

change command (RMAN), 6-10, 11-35

available option, 6-8

delete option, 6-28

unavailable option, 6-8

change-based recovery, 14-32 to 14-35

coordinated in distributed databases, 15-16

definition, 3-29

channel control

overview of RMAN, 4-24

channels

allocating, 4-24

parellelization of, 4-26

character set

setting for use with RMAN, 5-3

CLEAR LOGFILE GROUP option

ALTER DATABASE command, 16-17

CLEAR UNARCHIVED LOGFILE option

ALTER DATABASE command, 16-25

clearing redo log files, 2-14

clone databases

exporting, B-13

opening, B-13

preparing for TSPITR, B-11

preparing parameter files for, B-10

code examples

whole database backups, 13-3

command files

Recovery Manager, 4-10

command line

arguments for RMAN, 4-9

command line parameters (RMAN), 11-39

commands, Recovery Manager

allocate, 11-9

allocate channel for delete, 8-26

allocate channel for maintenance/delete, 11-13

alter database, 11-15

archivelogRecoverSpecifier clause (RMAN), 11-17

backup, 4-29, 8-2, 8-26, 11-21

proxy only option, 4-19

proxy option, 4-19

skip offline option, 8-15

catalog, 6-5, 6-27

change, 6-10, 11-35

delete option, 6-28

connect, 11-44, 11-46

copy, 11-48

create catalog, 11-52

create script, 11-54

crosscheck, 11-57

debug, 11-62

delete expired backupset, 11-63

delete script, 11-65, 11-66

drop catalog, 6-35, 11-68

duplicate, 4-52, 11-69

execute script, 6-20

host, 11-74

list, 4-20, 11-76

incarnation of database option, 6-7

listObjList clause, 11-84

overview, 4-5

print script, 11-86

recover, 4-49, 9-15, 11-88

register, 6-6, 11-93

release channel, 11-95

release channel (of type maintenance), 11-96

replace script, 11-97

replicate, 9-11, 11-100

replicate controlfile, 9-11

report, 4-22, 11-102

need backup option, 7-5

reset database, 6-7, 11-110

incarnation option, 6-7

restore, 9-17, 11-112

resync catalog, 4-14, 6-23, 11-118

from controlfilecopy option, 6-33

duplex parameter, 8-22

maxcorrupt for datafile option, 8-26

newname for datafile option, 9-9

set (within run command), 11-133

shutdown command, 11-137

upgrade catalog, 6-34, 11-148

validate, 11-150

commands, Recovery manager

catalog, 11-32

commands, SQL

ALTER DATABASE, 14-8, 14-12, 14-14, 16-17, 16-25

CREATE CONTROLFILE, 16-25

commands, SQL*Plus

RECOVER, 14-9

UNTIL TIME option, 14-31

RECOVER DATAFILE, 14-10

RECOVER TABLESPACE, 14-9

SET, 14-8, 14-12

COMPATIBLE parameter, 16-26

standby database, 16-5

compilation and execution of RMAN commands, 4-6

complete export, 13-17

complete recovery

definition, 1-19, 3-28

procedures, 14-20

using RMAN, 9-18

connect command (RMAN), 11-44, 11-46

connection options

Recovery Manager, 5-8

consistent backups

definition, 1-16

consistent whole database backups, 3-2, 13-3

constraints

restore, 4-48

control file backups

definition, 3-8

using RMAN, 8-6, 8-7

control files, 2-3 to 2-7

CONTROL_FILES initialization parameter, 2-9, 9-11, 15-13, 16-25

coordinated time-based recovery

distributed databases, 15-16

copy command (RMAN), 11-48

corrupt datafile blocks

records in control file, 4-36

RMAN and, 4-36

setting maximum for backup, 8-26

corruption detection, 4-54, 4-55

crash recovery

definition, 1-19

create catalog command (RMAN), 11-52

CREATE CONTROLFILE command

and recovery, 9-16

standby database, effect on, 16-25

CREATE DATAFILE option

ALTER DATABASE command, 14-7

create script command (RMAN), 11-54

CREATE TABLE command

AS SELECT option, 14-4

CREATE TABLESPACE command, 15-3

creating

standby databases, 16-3

creating duplicate databases, 10-2

on a remote host, 10-10

creating test databases, 4-52

creating the recovery catalog, 6-2

crosscheck command (RMAN), 11-57

crosschecking

definition, 4-18

recovery catalog with the media manager, 6-9

cumulative export, 13-17

cumulative incremental backups, 4-42, 8-22

data dictionary

views, 13-6, 13-10

database schema

generating reports, 7-8

database structures

datafiles, 1-6

online redo log, 1-8

overview, 1-6 to 1-11

physical, 1-6 to 1-11

redo log files, 1-8

rollback segment, 1-8

databases

altering physical structure

standby databases, impact on, 16-22

backing up

using Recovery Manager, 4-29

creating duplicate

on a remote host, 10-10

creating duplicate using RMAN, 10-2

creating test, 10-2

db identifier, 6-5

disaster recovery planning, 16-1 to 16-29

listing for backups, 13-2

media recovery procedures, 14-1 to 14-32

media recovery scenarios, 15-1 to 15-15

name stored in control file, 2-3

physical structure, 1-6 to 1-11

recovery

after control file damage, 15-12

recovery after OPEN RESETLOGS option, 14-35

registering in recovery catalog, 6-4, 6-5

standby, 16-2 to 16-29

advantages, 16-2

control files, 16-25, 16-29

creating, 16-2

creating, procedures for, 16-3

datafiles, taking offline, 16-27

definition, 16-2

direct path operations, 16-27

initialization parameters, 16-25

maintaining, 16-6

manual recovery mode, 16-5, 16-6

modes, 16-5

read-only mode, 16-5, 16-19

redo log files, altering, 16-24

renaming datafiles, 16-24

sustained recovery mode, 16-5

transmitting archived redo logs, 16-7

suspending, 13-9

unregistering in recovery catalog, 6-6

whole database backups, 13-3 to 13-5

datafile backups

using RMAN, 8-4, 8-5, 8-6

DATAFILE ONLINE option

ALTER DATABASE command, 14-31

datafiles, 1-6

dates

specifying in RMAN commands, 5-2

db identifier, 6-5

DB_FILE_NAME_CONVERT initialization parameter, 4-53

using with RMAN duplicate command, 10-7

DB_FILE_STANDBY_NAME_CONVERT initialization parameter, 16-26

for primary and standby databases, 16-25

DB_FILES initialization parameter, 16-26

DBA_DATA_FILES view, 13-6, 13-10

DBVERIFY utility, 13-5

debug command (RMAN), 11-62

delete expired backupset command (RMAN), 11-63

delete script command (RMAN), 11-65, 11-66

destination states for archived redo logs, 16-11

differential incremental backups, 4-40

direct path operations

standby databases, 16-27

disaster recovery

using a standby database for, 16-1 to 16-29

disconnecting

from Recovery Manager, 5-12

disk failures, 1-13

distributed databases

backups, 3-22

change-based recovery, 15-16

coordinated time-based recovery, 15-16

media recovery and snapshots, 15-17

recovery, 15-15

taking backups, 3-22

drop catalog command (RMAN), 11-68

dropped tables

recovery, 15-15

dropping the recovery catalog, 6-35

duplex parameter (RMAN)

set command, 8-22

duplexing backup sets, 4-33, 8-22

duplicate command (RMAN), 4-52, 11-69

duplicate databases

creating, 4-52, 10-2

creating non-current, 10-19

creating on a remote host with same filesystem, 10-10

creating on local host, 10-17

creating on remote host with different filesystem, 10-12

DB_FILE_NAME_CONVERT parameter, 10-5

generating filenames, 10-3

nofilenamecheck option, 10-6

preparing for duplication, 10-7

restrictions, 10-3

set auxname command (RMAN), 10-5

set newname command (RMAN), 10-5

skipping tablespaces, 10-5

duplicating a database, 4-52

ENABLE THREAD option

ALTER DATABASE command, 16-24

Enterprise Backup Utility, 3-11

environment variables

NLS_DATE_FORMAT, 5-2

NLS_LANG, 5-2

errors

during RMAN backups, 8-26

Recovery Manager, 4-12

Export utility, 3-10, 3-14

backups, 3-14, 3-22, 13-16

backups and, 3-22

export types, 13-17

read consistency, 13-16

exports

failures

disk, 1-13

hardware, 1-12

instance, 1-12

media, 1-13

multiplexed online redo logs, 2-12

file, 6-3

filenames

listing for backup, 13-2

format parameter (RMAN)

backup command, 4-31

fractured block detection, 4-55

full backups, 4-37

generating lists using RMAN, 4-20

generating reports, 4-20, 7-5

groups

archived redo log, 15-6, 15-7

online redo log, 15-6, 15-7

guidelines

backups

distributed database constraints, 3-22

Export utility, 3-22

frequency, 3-18

multiplexing files, 3-17

often-used tablespaces, 3-19

storing old backups, 3-21

structural changes, 3-18

testing strategies, 3-24

unrecoverable operations, 3-19

whole database backups after OPEN RESETLOGS, 3-19

hardware failures, 1-12

host command (RMAN), 11-74

hot backup mode

necessary for online O/S backups, 13-7

hot backups

inconsistent whole database backups, 3-4

image copies, 4-45

crosschecking, 6-12

testing restore of, 6-18

Import utility, 13-16

database recovery, 13-18

procedure for using, 13-18

inactive online redo log

loss of, 15-7

incarnation of database option (RMAN)

list command, 6-7

incarnation option (RMAN)

reset database command, 6-7

incomplete media recovery

change-based, 14-32 to 14-35

definition, 1-20, 3-28

in OPS configuration, 14-13

procedures for, 14-26 to 14-35

time-based, 14-29 to 14-31

using backup control file, 14-13

incomplete recovery

change-based (RMAN), 9-25

log sequence-based (RMAN), 9-26

time-based (RMAN), 9-24

using RMAN, 9-23

with a recovery catalog, 9-24

without a recovery catalog, 9-27

inconsistent backups

definition, 1-16

inconsistent whole database backups

definition, 3-4

incremental backups, 8-21

differential, 4-40

using RMAN, 8-9

incremental export, 13-17

initialization parameters

INIT.ORA files, 4-49, 9-15

instance

failure, 1-12

recovery, 1-19

integrity checking, 4-54

interrupting media recovery, 14-16

I/O errors

effect on backups, 4-36

job, 4-8

keywords

in syntax diagrams, 11-3

level 0 incremental backups, 4-39

list command (RMAN), 4-20, 11-76

incarnation of database option, 6-7

listing backups and copies, 7-3

listObjList clause (RMAN), 11-84

lists, generating, 7-2 to 7-4

listing backups and copies, 7-3

scenarios, 7-10

log sequence number

requested during recovery, 14-10

log sequence recovery, 3-29

log switches

multiplexed redo log files and, 2-14

recovery catalog records, 6-27

waiting for archiving to complete, 2-14

log writer process (LGWR)

multiplexed redo log files and, 2-13

trace files and, 2-13

LOG_ARCHIVE_DEST initialization parameter, 14-8, 14-10, 14-28, 14-31

specifying destinations using, 2-19, 16-10

LOG_ARCHIVE_DEST parameter, 16-7

LOG_ARCHIVE_DEST_n initialization parameter, 2-19, 14-8, 14-10, 16-6, 16-10

REOPEN option, 16-11

LOG_ARCHIVE_DUPLEX_DEST initialization parameter

specifying destinations using, 2-19, 16-10

LOG_ARCHIVE_FORMAT initialization parameter, 14-7, 14-10

logical backups

definition, 3-14

LOGSOURCE variable

SET command, 14-8, 14-12

loss of

inactive log group, 15-7

managing RMAN metadata, 6-1

manual recovery mode, 16-5

media failure

archived redo log file loss, 15-10

complete recovery, 14-20 to 14-25

control file loss, 15-11, 15-13

datafile loss, 15-2

definition, 1-13

description, 15-2

disk controller, 15-2

NOARCHIVELOG mode, 14-17

online redo log group loss, 15-6

online redo log loss, 15-5

permanent, 15-2

recovery, 14-20 to 14-32

distributed databases, 15-15

recovery procedures

examples, 15-2 to 15-15

understanding types, 15-2

media management

backing up files, 4-17

Backup Solutions Program, 4-20

Legato Storage Manager (LSM), 4-20

crosschecking, 4-18

linking to software, 5-19

maximum file size, 5-20

proxy copy, 4-19

requirements, 5-19

restoring files, 4-18

sbttest program, 4-19

sending device-specific strings, 5-20

troubleshooting, 5-21

unique filenames, generating, 5-19

Media Management Library (MML), 4-17

media recovery, 14-1 to 14-36

ADD DATAFILE operation, 15-3

after control file damage, 15-12

after OPEN RESETLOGS operation, 14-35

applying archived redo logs, 14-10

applying redo logs during, 14-10

cancel-based, 3-29, 14-20, 14-23, 14-26, 14-29

change-based, 3-29, 14-26, 14-32 to 14-35

commands, 14-2 to 14-10

complete, 1-19, 3-28, 14-20 to 14-25

completion of, 14-23, 14-25

datafiles

guidelines for, 4-49, 9-16

without backup, 14-6

deciding which files need recovery, 14-3

definition, 14-2

distributed databases, 15-15

coordinated time-based, 15-16

dropped table, 15-15

effects of archiving on, 2-16

error messages, 14-16

errors with redo log files, 14-16

incomplete, 3-28, 14-26 to 14-35

incomplete, definition, 1-20

interrupting, 14-16

log sequence recovery, 3-29

lost control file, 15-11

lost files

lost archived redo log files, 15-10

lost control files, 15-11

lost datafiles, 15-2

lost mirrored control files, 15-12

methods

choosing, 3-31

NOARCHIVELOG mode, 14-17

offline tablespaces in open database, 14-23

online redo log files, 15-5

open database-offline tablespace, 14-23

opening database after, 14-33

overview, 1-19 to 1-23

restarting, 14-16

restoring

archived redo log files, 14-7

damaged files, 14-6

whole database backups, 14-17

resuming after interruption, 14-16

roll forward phase, 14-10

rolling back, 14-2

rolling forward, 14-2

See Also recovery

snapshots, 15-17

successfully applied redo logs, 14-15

SYSTEM tablespace, 14-23

time-based, 14-26

transportable tablespaces, 15-4

types

distributed databases, 15-15

undamaged tablespaces online, 14-23

using Import utility, 13-18

using Recovery Manager, 4-49, 9-15

metadata

managing, 6-1

Recovery Manager, 4-13

storing in control file, 4-15

mirrored disk storage, 2-9

mirrored files

control files, 2-9

loss of, 15-12

online redo log, 2-13

loss of, 15-5

loss of member, 15-5

splitting, 13-9

suspend/resume mode, 13-9

mirroring

compared to multiplexing, 2-7

mode

ARCHIVELOG, 1-10

NOARCHIVELOG, 1-10

recovery from failure, 14-17

MOUNT option

STARTUP command, 14-28, 14-30

MOUNT STANDBY DATABASE option

ALTER DATABASE command, 16-6, 16-29

multiplexing

archived redo logs, 2-19, 16-10

compared to mirroring, 2-7

control files, 2-7, 2-8, 2-9

datafiles with Recovery Manager, 4-32

redo log files, 2-12

groups, 2-13

multi-threaded recovery, 14-13

name translation for RMAN commands, 4-6

naming backup sets, 4-31

newname for datafile option (RMAN)

set command, 9-9

NLS_DATE_FORMAT environment variable, 5-2, 8-19, 9-24

NLS_LANG environment variable, 5-2, 8-19, 9-24

NOARCHIVELOG mode

archiving, 2-15

backing up, 8-23

backup options, 3-20

datafile loss in, 15-2

definition, 2-15

disadvantages, 14-17

distributed database backups, 3-22

inconsistent closed backups in, 3-4

overview, 1-10

recovery, 14-17

running in, 2-15

strategies for backups in, 3-16

noncumulative incremental backups, 4-40

NORESETLOGS option

ALTER DATABASE command

backing up control file, 13-14

objects owned by SYS

and TSPITR using RMAN, A-6

offline

backups, 3-18

taking standby database datafiles, 16-27

online

backups, 3-18

online redo log, 1-8, 15-7

online redo logs

listing log files for backup, 13-2

open database backup

fractured block detection during, 4-55

open database recovery

using RMAN, 9-22

OPEN READ ONLY clause

ALTER DATABASE command, 16-19, 16-20, 16-21

OPEN RESETLOGS option

ALTER DATABASE command, 6-7

ORA-01578 error message, 14-5

Oracle Enterprise Manager, 3-10

Oracle8i utilities

Recovery Manager, 4-2

O/S backups, 13-3 to 13-18

O/S utilities

copying files with, 8-25

PARALLEL clause

RECOVER command, 14-20

parallel recovery, 14-19

Parallel Server

backups and, 8-25

PARALLEL_MAX_SERVERS initialization parameter, 14-20

parallelization

channels, 4-26

factors affecting degree of, 4-27

of backups using RMAN, 4-34, 8-23

RMAN backups, 4-34, 8-23

parameters

in syntax diagrams, 11-3

partitioned tables

and dropped partitions, B-18

and split partitions, B-22

performing partial TSPITR, B-15

password files

and Recovery Manager, 5-2

connecting to Recovery Manager with, 5-9, 5-11

connecting to Recovery Manager without, 5-10

performing backups after unrecoverable operations, 3-19

physical database structures, 1-6 to 1-11

point-in-time recovery

tablespace, A-2 to A-15, B-1 to B-26

primary databases

preparing for use, B-14

print script command (RMAN), 11-86

process failures, 1-12

definition, 1-12

proxy copy

overview, 4-19

proxy only option (RMAN)

backup command, 4-19

proxy option (RMAN)

backup command, 4-19

querying

recovery catalog, 7-2

read consistency

Export utility, 13-16

read-only mode

standby databases, 16-5, 16-19

read-only tablespaces

backing up, 8-15

effect on recovery, 14-5

recovering, 14-5

RECOVER ... FROM option

ALTER DATABASE command, 14-8, 14-12

RECOVER AUTOMATIC LOGFILE option

ALTER DATABASE command, 14-15

RECOVER command, 14-9

FROM 'location' option, 16-29

MANAGED STANDBY DATABASE option, 16-8, 16-18

PARALLEL clause, 14-20

unrecoverable objects and standby databases, 14-5

UNTIL TIME option, 14-31

recover command (RMAN), 4-49, 9-15, 11-88

RECOVER DATAFILE command, 14-10

RECOVER TABLESPACE command, 14-9

recovered tablespaces

backing up, B-14

recovery

cancel-based, 14-20, 14-23, 14-26, 14-29

change-based, 14-32 to 14-35

commands, 14-2 to 14-10

complete using RMAN, 9-18

crash, 1-19

disaster using RMAN, 9-35

distributed databases

with snapshots, 15-17

Import utility, 13-18

incomplete using RMAN, 9-23

multi-threaded, 14-13

of lost or damaged recovery catalog, 6-33

open database using RMAN, 9-22

parallel processes for, 14-19

PARALLEL_MAX_SERVERS initialization parameter, 14-20

read-only tablespaces, 14-5

See Also media recovery

setting number of processes to use, 14-19

strategies

deciding what to recovery, 3-28

determining when media recovery is necessary, 3-30

time-based, 3-28, 14-29 to 14-31

using backup control file (RMAN), 9-20

using RMAN, 9-15

recovery catalog, 4-13, 5-4 to 6-33

and incomplete recovery, 9-24

backing up, 4-14

cataloging

O/S backups, 6-27

changing availability of backup, 6-8

changing status of backups to deleted, 6-13

connecting to Recovery Manager with, 5-10, 5-11

connecting to Recovery Manager without, 5-9, 5-10

consequences of using, 5-4

creating, 6-2

in separate database, 5-5

crosschecking, 6-9

dropping, 6-35

log switch record, 6-27

managing size of, 6-26

operating with, 4-13

operating without, 4-15

overview, 4-13

querying, 4-20, 7-2

recovery of lost or damaged, 6-33

refreshing, 6-23

registering databases, 6-4, 6-5

removing records, 6-16

resynchronizing, 4-14, 6-23

schema, 5-5

setting up, 6-2

snapshot control file, 4-14

unregistering databases, 6-6

updating

after schema changes, 6-25

upgrading, 6-34

views, 12-1

Recovery Manager

advantages to using, 4-4

allocate channel for maintenance, 11-13

duplexed backup sets, 4-33

backups, 8-2

archived redo logs, 8-8

control file, 8-6, 8-7

datafile, 8-4, 8-5, 8-6

fractured block detection, 4-55

image copy, 4-45

incremental, 8-9

tablespace, 8-4, 8-5, 8-6

using tags, 4-46

whole database, 8-3

channel control

overview, 4-24

command line arguments, 4-9

commands

allocate channel, 11-9

allocate channel for delete, 8-26

alter database, 11-15

backup, 4-19, 4-29, 8-2, 8-26

create catalog, 11-52

create script, 11-54

crosscheck, 11-57

debug, 11-62

delete expired backup, 11-63

interactive use of, 4-10

job, 4-9

list, 6-7

release channel, 11-95

replace script, 11-97

replicate controlfile, 9-11

send, 5-20

stand-alone commands, 4-8

startup, 11-142

switch, 11-144

upgrade catalog, 11-148

using command files, 4-10

validate, 11-150

compilation and execution of commands, 4-6

connecting

duplicate database, 5-11

with password files, 5-9, 5-11

with recovery catalog, 5-10, 5-11

without password files, 5-10

without recovery catalog, 5-9, 5-10

connection options, 5-8

constraints

backup, 4-44

restore, 4-48

corrupt datafile blocks, 4-54, 4-55

handling I/O errors and, 4-36

creating duplicate databases, 10-2

crosschecking recovery catalog, 6-9

database character set, 5-3

dates in commands, 5-2

disconnecting from, 5-12

errors, 4-12

fractured block detection in, 4-55

image copy backups, 4-45

incomplete recovery

with a recovery catalog, 9-24

without a recovery catalog, 9-27

incremental backups

cumulative, 4-42

differential, 4-40

level 0, 4-39

integrity checking, 4-54

interactive use of commands, 4-10

introduction, 4-2

lists, 7-2

media management

backing up files, 4-17

Backup Solutions Program (BSP), 4-20

crosschecking, 4-18

maximum file size, 5-20

media manager, linking with a, 5-19

proxy copy, 4-19

requirements, 5-19

restoring files, 4-18

testing, 4-19

unique filenames, 5-19

metadata, 4-13, 6-1

storing in control file, 4-15

multiplexing

datafiles, 4-32

name translation, 4-6

overview, 4-4

parallelization of backups, 4-34

password files, 5-2

PL/SQL job steps, 4-6

recovery, 9-15

after total media failure, 9-35

complete, 9-18

incomplete, 9-23

open database, 9-22

using backup control file, 9-20

recovery catalog, 4-13

backing up, 6-30

changing availability of backups and copies, 6-8

creating a separate database, 5-5

crosschecking, 6-9

deciding whether to use, 5-4

losing control files when not using a, 4-16

managing the size of, 6-26

operating with, 4-13

operating without, 4-15

querying, 4-20, 7-2

recovering lost or damaged, 6-33

registering databases, 6-5

removing records, 6-16

resynchronizing, 6-23

schema, 6-2

snapshot control file, 4-14

updating after schema changes, 6-25

upgrading, 6-34

registering databases, 6-6

reports, 7-5

database schema, 7-8

objects needing a backup, 7-5

obsolete backups, 7-6, 7-8

resetting database information, 6-7

restoring, 9-2

archived redo logs, 9-13

control files to new location, 9-11, 9-12

database to default location, 9-3

restoring datafiles using, 4-47

sample scripts, 5-21

sbttest program, 4-19, 5-21

setting time parameters, 5-2

snapshot control file location, 5-3

stored scripts, 4-10

syntax conventions, 11-2

tablespace point-in-time recovery, 4-51

types of backups, 4-45

user tags for backups, 4-46

using RMAN commands, 4-5

recovery sets

containing whole tables, A-6

copying to primary database, B-13

for RMAN TSPITR, A-4

importing into primary database, B-13

recovery strategy

overview, 1-17 to 1-25

RECOVERY_PARALLELISM initialization parameter, 14-19

redo log files, 1-8

"fuzzy" data in backups and, 3-17

files named in control file, 2-3

groups, 2-13

members, 2-13

listing files for backup, 13-2

members, 2-13

mirrored

log switches and, 2-14

multiplexed, 2-12

diagrammed, 2-13

groups, 2-13

if all inaccessible, 2-14

if some members inaccessible, 2-14

purpose of, 1-9

naming, 14-10

overview, 1-8

register command (RMAN), 6-5, 6-6, 11-93

registering

archived redo logs, 6-5

datafiles, 6-5

release channel command (RMAN), 11-95

releasing a maintenance channel, 11-96

remote file server (RFS) process, 16-9

removing records from the recovery catalog, 6-16

RENAME DATABASE clause

ALTER DATABASE command, 9-9

REOPEN option

LOG_ARCHIVE_DEST_n initialization parameter, 16-11

replace script command (RMAN), 11-97

replicate command (RMAN), 9-11, 11-100

report command (RMAN), 4-22, 11-102

need backup option, 7-5

reports, generating, 7-2, 7-5

database schema, 7-8

objects needing a backup, 7-5

obsolete backups, 7-6, 7-8

scenarios, 7-10, 7-11, 7-12

unrecoverable backups, 7-6, 7-8

reset database command (RMAN), 6-7, 11-110

incarnation option, 6-7

RESETLOGS option

ALTER DATABASE command, 14-17, 14-18, 14-33

backing up control file, 13-14

database backups after using, 3-19

multiple timelines for redo logs, 3-23

recovery of database after using, 14-35

restore command (RMAN), 9-17, 11-112

restore constraints, 4-48

restore validation, 6-18

restoring

archived redo logs using RMAN, 9-13

backup file selection, 4-48

backups of online redo logs, 3-23

database using RMAN, 9-3

datafiles, 4-47

datafiles using RMAN, 9-2

testing, 6-18

whole database backups, 14-17

RESUME option

ALTER SYSTEM command, 13-10

resuming recovery after interruption, 14-16

resync catalog command (RMAN), 4-14, 6-23, 11-118

from controlfilecopy option, 6-33

resynchronizing the recovery catalog, 4-14, 6-23

RFS

See remote file server

RMAN

See Recovery Manager

rman command (RMAN), 11-121

rollback segments, 1-8

and RMAN TSPITR, A-6

rolling back, 14-2

rolling forward, 14-2

run command (RMAN), 11-121, 11-124

sample scripts

RMAN, 5-21

sbttest program, 4-19, 5-21

scenarios, Recovery Manager

schema changes

updating recovery catalog, 6-25

SCN

See system change number

SCN (system change number)

definition, 1-9

scripts

CATRMAN.SQL, 6-5

send command (RMAN), 5-20, 11-127

SET command

AUTORECOVERY option, 14-12

LOGSOURCE variable, 14-8, 14-12

set command (RMAN), 11-129

duplex parameter, 8-22

executed within run, 11-133

maxcorrupt for datafile option, 8-26

newname parameter, 4-53, 9-9

SHUTDOWN command

ABORT option, 13-7, 14-17, 14-18, 14-26, 15-12

consistent whole database backups, 3-3

shutdown command (RMAN), 11-137

size of backup sets, setting, 4-31

skip offline option (RMAN)

backup command, 8-15

skip readonly option (RMAN)

backup command, 8-15

snapshot control files, 4-14

specifying location, 5-3

snapshots

distributed database recovery, 15-17

media recovery and, 15-17

specifying destinations

for archived redo logs, 2-19

splitting mirrors

suspend/resume mode, 13-9

sql command (RMAN), 11-140

SQL commands

applying log files, 14-14

for recovering tablespace, 14-14

SQL*Plus

applying log files, 14-12

stand-alone Recovery Manager commands, 4-8

standby databases, 16-2 to 16-29

advantages, 16-2

altering control files, 16-25

archived redo logs

control files

datafiles

taking offline, 16-27

definition, 16-2

direct path operations, 16-27

effect of altering primary database, 16-22

initialization parameters, 16-25

maintaining, 16-6

manual recovery mode

procedures, 16-6

standby database, 16-5

modes, 16-5

read-only mode, 16-5, 16-19

redo log files

altering, 16-24

sustained recovery mode, 16-5

transmitting archived redo logs, 16-7

STANDBY_ARCHIVE_DEST initialization parameter, 16-26

STARTUP command

MOUNT option, 14-28, 14-30

startup command (RMAN), 11-142

statement failures, 1-12

stored scripts

Recovery Manager, 4-10

replacing, 6-21

strategies

backup, 3-15 to 3-24

backups

ARCHIVELOG mode, 3-16

NOARCHIVELOG mode, 3-16

recovery

deciding what to recovery, 3-28

determining when media recovery is necessary, 3-30

SUSPEND option

ALTER SYSTEM command, 13-9

suspending a database, 13-9

suspend/resume mode, 13-9

sustained recovery mode, 16-5

switch command (RMAN), 11-144

syntax conventions

Recovery Manager, 11-2

syntax diagrams

explanation of, 11-2

keywords, 11-3

parameters, 11-3

system change number (SCN)

definition, 1-9

use in distributed recovery, 15-17

system failures, 1-12

SYSTEM tablespace

recovery of, 14-23

system time, changing

effect on recovery, 14-26

tablespace backups

using RMAN, 8-4, 8-5, 8-6

tablespace point-in-time recovery, B-25

tablespaces

read-only

effect on recovery, 14-5

recovering offline in open database, 14-23

test databases, creating, 4-52

testing

backup strategies, 3-24

media manager, 4-19

time format

RECOVER DATABASE UNTIL TIME statement, 14-31

time parameters

setting for Recovery Manager use, 5-2

time-based recovery, 14-29 to 14-31

coordinated in distributed databases, 15-16

definition, 3-28

TNSNAMES.ORA file, 16-10

trace files

control file backups to, 13-12

log writer process and, 2-13

transactions

rollback, 1-8

uncommitted, 1-8

transmitting archived redo logs, 2-21, 16-7

in normal transmission mode, 2-21

transportable tablespaces

recovery, 15-4

TSPITR and, B-3

troubleshooting the media manager, 5-21

TS_PITR_CHECK view, A-6

TSPITR. See tablespace point-in-time recovery.

unavailable option (RMAN)

change command, 6-8

unrecoverable objects

and RECOVER operation, 14-5

UNRECOVERABLE operations

backups after, 16-28

performing backups after, 3-19

unregistering a database from the recovery catalog, 6-6

until clause (RMAN), 11-42, 11-146

UNTIL TIME option

RECOVER command, 14-31

updating records in recovery catalog, 6-13

upgrade catalog command (RMAN), 11-148

upgrading the recovery catalog, 6-34

user errors

database failures, 1-12

definition, 1-12

recovery from, 15-14

user tags, 4-46

user-created backup files

cataloging, 6-28

USING BACKUP CONTROLFILE option

RECOVER command, 14-28

utilities

O/S, using to make copies, 8-25

Recovery Manager, 4-2

V$ARCHIVE view, 2-4, 2-12, 2-18

V$BACKUP view, 13-7

V$BACKUP_CORRUPTION view, 4-36

V$DATABASE view, 2-4, 2-18

V$DATAFILE view, 14-31, 16-28

listing files for backups, 13-2

V$LOG view, 2-4, 2-12, 2-18

displaying archiving status, 2-4, 2-12, 2-18

V$LOG_HISTORY view, 14-7

V$LOGFILE view, 15-6, 15-7

listing files for backups, 13-2

V$LONGOPS view, 4-36

V$PROXY_ARCHIVEDLOG view, 4-19

V$PROXY_DATAFILE view, 4-19

V$RECOVER_FILE view, 1-24, 14-3

determining which files to recover, 3-27

V$RECOVERY_LOG view, 14-7

validate command (RMAN), 11-150

validation of restore, 6-18

views

warning

archiving mode for first backup, 3-16

consistency and Export backups, 13-16

whole database backups, 13-3 to 13-5

ARCHIVELOG mode, 13-3

consistent, 3-2

backup control files and, 3-3

using SHUTDOWN ABORT command, 3-3

definition, 3-2

inconsistent, 3-4

NOARCHIVELOG mode, 13-3

preparing to take, 13-4

restoring from, 14-17

using RMAN, 8-3

Index

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

T

U

V

W