Oracle9i Recovery Manager User's Guide -- Index

alert log

control file record messages, 16-32

monitoring overwriting of control file records, 16-33

useful for RMAN, 15-2

ALTER DATABASE statement

OPEN RESETLOGS clause, 16-10

RENAME FILE clause, 10-19

ALTER SYSTEM statement

KILL SESSION clause, 15-12

ALTER TABLESPACE statement

BEGIN BACKUP clause, 18-15

END BACKUP clause, 18-15

archived redo logs

backing up, 5-17, 9-40

using RMAN, 9-11, 9-12, 9-13, 9-15

cataloging, 16-7, 18-15

deletion after backup, 5-16, 7-13

deletion after restore, 6-9

generated during backups, 5-17

restoring using RMAN, 10-21

RMAN fails to delete, 15-34

autobackups

control file, 5-47, 8-17, 9-8

generating, 9-8

server parameter file, 5-47

autolocation

restoring in Oracle Real Application Clusters, 6-5

automatic channels, 5-2

allocation, 5-3

configuring, 8-10, 8-11, 8-14, 9-2

generic

configuring, 5-8, 8-12

definition, 8-12

naming conventions, 5-7

overriding, 8-11

parallelism, 8-11

specific configurations, 5-8

auxiliary databases

for RMAN TSPITR

converted filenames, 11-12

auxiliary sets

for RMAN TSPITR, 11-4

naming datafiles in tablespaces, 11-10

availability

of RMAN backups, 18-12

AVAILABLE option

of CHANGE, 18-12

backup and recovery

methods comparison between RMAN and user-managed, 1-4

BACKUP command, 5-13, 9-49

BACKUPSET option, 5-24, 9-26

COPIES parameter, 5-21

CURRENT CONTROLFILE option, 9-10

DELETE ALL INPUT option, 5-16

DELETE INPUT option, 5-16, 7-14

FORMAT parameter, 5-27

KEEP option, 5-55

NOT BACKED UP SINCE clause, 5-62, 9-27

PLUS ARCHIVELOG option, 5-17

PROXY ONLY option, 5-14

PROXY option, 5-14

SKIP OFFLINE option, 9-34

VALIDATE option, 5-68

BACKUP COPIES parameter

CONFIGURE command, 8-24

backup mode

definition, 5-63

backup optimization

configuring, 8-23

definition, 5-56, 9-27

disabling, 5-58, 8-23

enabling, 5-58, 8-23

recovery window and, 5-59

redundancy and, 5-60

retention policies and, 5-59

BACKUP OPTIMIZATION option

of CONFIGURE, 9-27

backup pieces

definition, 5-13

restricting size, 5-28

backup retention policy

definition, 5-50

backup sets

backing up, 5-24, 9-26

configuring maximum size, 8-22

creating by using BACKUP command, 5-33

crosschecking, 7-9

definition, 5-13

duplexing, 9-15

errors during creation, 5-46

failover during backups, 5-26

how RMAN generates, 5-29, 5-34

limiting size, 5-29

multiplexing, 5-18

naming, 5-27

number, 5-34

organizing, 5-13

overview, 5-13

restricting piece size, 5-28

size, 5-34

specifying maximum size (in bytes), 5-28, 5-33

specifying number of, 5-29

testing restore of, 10-41

Backup Solutions Program (BSP), 4-17

BACKUP_TAPE_IO_SLAVES initialization parameter, 8-24, 9-16

backups

archived redo logs, 9-40

backing up using RMAN, 9-15

deletion after backing up, 7-13

using RMAN, 9-11, 9-12, 9-13

when needed, 5-17

automatic log switch during, 5-17

availability, 18-12

altering with CHANGE command, 7-16

backup sets, 5-12, 9-26

backups of, 5-24

consistent

making using RMAN, 9-5

control file

using for recovery, 10-15

using RMAN, 9-10, 9-11

control file autobackups, 9-8

correlating RMAN channels with, 15-17, 15-18

crosschecking, 18-2

cumulative incremental, 5-42, 5-43, 6-7, 6-13, 6-15, 9-43, 14-4, 14-5, 14-7, 14-8

datafile

using RMAN, 9-7, 9-8, 9-26, 9-27, 9-28

deleting, 7-12

duplexing, 8-24, 9-15

excluding tablespaces from backups, 8-25

exempt from retention policy, 18-14

expired

deleting, 18-6

failed RMAN, 15-35

failover during BACKUP BACKUPSET, 5-26

full, 5-37

generating reports for, 17-2

hung, 15-27

image copies, 5-12, 5-62

inconsistent

making using RMAN, 9-5

incremental, 5-38, 9-17, 9-42

differential, 5-40

using RMAN, 9-16, 9-17

interrupted, 9-27

keeping, 9-46

limiting datafiles in a backup set, 5-19

limiting I/O rate, 5-35

limiting number of open files during, 5-19

long-term, 5-55

changing status, 7-17

methods for making, 1-2

multiple copies, 8-24

NOARCHIVELOG mode, in, 9-44

noncumulative incremental, 5-41, 5-52, 5-53

obsolete

batch deletes, 5-54

optimizing, 5-56

Oracle Real Application Clusters, 9-44

overview of RMAN, 9-3

recovering pre-RESETLOGS, 10-45

recovery catalog, 4-14, 16-20

reporting objects needing backups, 17-12

restartable, 5-61, 9-27

RMAN error handling, 9-49

server parameter files, 9-11

specifying number of files in a backup set, 5-29

split mirror, 5-63

using RMAN, 9-18

standby database

archived redo logs, 9-22

interpreting RC_ARCHIVED_LOG view, 9-22

overview of RMAN, 9-20

restrictions, 9-21

using RMAN, 9-20, 9-24, 9-25

stored scripts, 16-16

tablespace

using RMAN, 9-7, 9-8, 9-26, 9-27, 9-28

tags, 5-64

testing RMAN, 5-68, 9-28

using media manager, 8-8

troubleshooting failed RMAN, 15-25, 15-29, 15-33

types, 5-12, 5-36

user-managed

cataloging, 18-15

validating, 9-28

whole database

using RMAN, 9-6

BEGIN BACKUP clause

ALTER TABLESPACE statement, 18-15

block corruptions

stored in V$DATABASE_BLOCK_CORRUPTION, 9-28

block media recovery, 10-38

guidelines, 6-12

overview, 6-11

BLOCKRECOVER command, 6-11, 10-38

BSP. See Backup Solutions Program (BSP)

canceling RMAN commands, 15-11

CATALOG command, 16-7, 18-15

cataloging

archived redo logs, 16-7

datafiles, 16-7

operating system copies, 9-45

catalog.sql script, 16-4

catproc.sql script, 16-4

CHANGE command, 7-8, 18-2

AVAILABLE option, 7-16, 18-12

KEEP option, 7-17

UNAVAILABLE option, 18-12

UNCATALOG option, 18-18

channels

allocating manually for backups, 9-2

allocating multiple, 7-15

configuring automatic, 8-10

configuring for backups, 9-2

control options, 5-11

definition, 5-2

difference between manual and automatic, 5-4

generic configurations, 5-8

multiple

crosschecking and deleting, 18-8

overriding automatic, 8-11

parallelism for manual channels, 5-10

preconfigured disk, 8-11

Recovery Manager, 5-2

RMAN naming conventions, 5-7

specific configurations, 5-8

character sets

RMAN errors, 15-36

setting for use with RMAN, 8-27

circular reuse records, 4-15

clearing RMAN configuration, 5-9, 8-16

command files

Recovery Manager, 4-8

command interface

RMAN, 4-5

commands, Recovery Manager

BACKUP, 5-13, 9-49

PROXY ONLY option, 5-14

PROXY option, 5-14

SKIP OFFLINE option, 9-34

BACKUP CURRENT CONTROLFILE, 9-10

batch execution, 4-8

CATALOG, 16-7, 18-15

CHANGE, 7-8, 18-2

CONFIGURE, 5-8, 5-9, 17-15

COPY, 5-62

CROSSCHECK, 18-2

DELETE, 7-12, 18-16

DROP CATALOG, 16-30

DUPLICATE, 6-14, 13-2

EXECUTE SCRIPT, 16-16

how RMAN interprets, 4-5

interactive, 4-8

LIST, 7-2, 17-3

INCARNATION option, 16-10

piping, 4-10

PRINT SCRIPT, 7-7

RECOVER, 6-5

REGISTER, 16-7

REPORT, 17-11

NEED BACKUP option, 17-11

RESET DATABASE

INCARNATION option, 16-10

RESTORE, 10-6

RESYNC CATALOG, 4-13, 16-11

FROM CONTROLFILECOPY option, 16-23

SET

MAXCORRUPT option, 9-49

SHOW, 5-5, 7-7, 17-15

standalone, 4-7

terminating, 15-11

types, 4-6

UPGRADE CATALOG, 16-28

using, 3-3

compatibility

recovery catalog, 4-14

compilation

and execution of RMAN commands, 4-6

complete recovery

using RMAN, 10-8

CONFIGURE command, 17-15

BACKUP COPIES parameter, 5-21

BACKUP OPTIMIZATION option, 8-23

CHANNEL option, 5-8

CLEAR option, 5-9, 8-16

DEFAULT DEVICE TYPE clause, 5-6

DEVICE TYPE clause, 5-5

EXCLUDE option, 8-25

RETENTION POLICY clause, 5-50, 5-51

configuring

media manager

installing, 8-2

prerequisites, 8-2

media managers for use with RMAN, 8-6

Recovery Manager

autobackups, 8-17

automatic channels, 8-10, 8-12

backup optimization, 8-23

backup retention policies, 8-20

backup set size, 8-22

clearing, 5-9, 8-16

default device types, 5-6, 8-11

device types, 5-5

parallelism, 5-5

shared server, 8-29

SHOW command, 7-7

showing, 17-15

snapshot control file location, 8-28

specific channels, 8-14

tablespace exclusion for backups, 8-25

consistent backups

using RMAN, 9-5

control file autobackups

after structural changes to database, 8-17

configuring, 8-17

default format, 5-49

restoring, 5-48

control file copies

backing up, 9-11

control file records

overwriting, 16-32

control files

automatic backups, 5-47, 8-17, 9-8

configuring, 8-17

backing up

using RMAN, 9-11

backup and recovery, 10-15

backups

including within database backup, 9-10

recovery using, 10-13

using RMAN, 9-8, 9-10

copies

backing up, 9-11

duplicate database, 12-5

overwriting records, 16-32

restoring, 10-20

using RMAN, 10-20

using SET DBID, 10-43

snapshot

specifying location of, 8-28

types of records, 4-15

using instead of a recovery catalog, 4-14

CONTROL_FILE_RECORD_KEEP_TIME initialization parameter, 16-32

preventing overwrite of RMAN records, 16-32

CONTROL_FILES initialization parameter, 10-20, 11-15

copies

crosschecking, 18-2

long-term, 5-65

COPIES option

of BACKUP, 9-17

COPY command, 5-62

KEEP option, 5-65

corrupt datafile blocks, 5-66

detecting, 5-66, 5-67

records in control file, 5-46

recovering, 10-40

RMAN and, 5-46

setting maximum for backup, 9-49

corruption detection, 5-67

creating

duplicate databases

on a remote host, 12-13

recovery catalog, 8-31

test databases, 6-14

CROSSCHECK command, 18-2

crosschecking, 18-2

backups and copies, 18-2

definition, 7-8

on multiple channels, 18-8

recovery catalog with the media manager, 7-9

cumulative incremental backups, 5-42, 9-43

database connections

Recovery Manager

auxiliary database, 2-7

hiding passwords, 2-9

Oracle Real Application Clusters configuration, 2-6

with a catalog, 2-5

without a catalog, 2-4

SYSDBA required for RMAN, 2-2

types in RMAN, 2-2

database point-in-time recovery (DBPITR)

definition, 10-10

database schema

generating reports, 17-14

databases

backing up

using Recovery Manager, 5-13

creating duplicate

on a remote host, 12-13

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

unregistering in recovery catalog, 16-8

datafile copies

backing up using RMAN, 9-8

datafile recovery

definition, 6-5

datafiles

backing up

using Recovery Manager, 5-13, 9-7, 9-8, 9-26, 9-27, 9-28

backups needed, listing, 17-27

cataloging, 16-7

duplicate database, 12-6

listing

unrecoverable, 17-11

recovery

basic steps, 6-6

determining when necessary, 15-23

restoring, 6-2, 10-5

using nondefault filenames, 10-19

db identifier

changing with DBNEWID, 4-12

problems registering copied database, 16-7

setting during disaster recovery, 10-17

setting with DBNEWID, 16-6, 16-8

DB_FILE_NAME_CONVERT initialization parameter, 11-14

using with RMAN DUPLICATE command, 12-9

DB_NAME initialization parameter, 11-14

DBMS_PIPE package, 4-10

using with RMAN, 2-10

DBNEWID utility, 4-12, 16-6, 16-8

default device types

configuring, 8-11

DELETE command, 7-12, 18-5, 18-16

EXPIRED option, 18-6

OBSOLETE option, 5-55

deleting

backups, 18-4, 18-5

on multiple channels, 18-8

copies, 18-4

expired backups, 7-13

files after backups, 7-14

obsolete backups, 7-12

on multiple device types, 7-15

using RMAN, 7-11

device types

configuring in RMAN, 8-11

differential incremental backups, 5-40

disaster recovery

using RMAN, 6-10

disconnecting

from Recovery Manager, 2-11

disk API, 8-5

disk channels

preconfigured, 8-11

dropping the recovery catalog, 16-30

dummy API, 8-5

duplexing

backup sets, 5-21, 8-24, 9-15

DUPLICATE command, 6-14

duplicate databases

creating, 6-14

noncurrent, 12-22

on local host, 12-19

on remote host with different file system, 12-14

on remote host with same file system, 12-13

using CONFIGURE AUXNAME, 12-18

using init.ora parameter and LOGFILE, 12-16

using SET NEWNAME, 12-17

datafiles, 12-6

DB_FILE_NAME_CONVERT initialization parameter, 12-7

excluding tablespaces, 6-14, 12-4

failed creation, 15-38

generating control files, 12-5

generating filenames, 12-5

how RMAN creates, 12-3

NOFILENAMECHECK option, 12-8

online redo logs, 12-5

preparing for duplication, 12-9

SET NEWNAME command, 12-6

skipping offline normal tablespaces, 12-8

skipping read-only tablespaces, 12-7

duplicating a database, 6-14

troubleshooting, 15-38

END BACKUP clause

ALTER TABLESPACE statement, 18-15

environment variables

NLS_DATE_FORMAT, 8-27

NLS_LANG, 8-27

environment, Recovery Manager

definition, 4-2

error codes

media manager, 15-4

RMAN, 15-2, 15-3

message numbers, 15-4

error messages

Recovery Manager

interpreting, 15-6

error stacks

interpreting, 15-6

errors

during RMAN backups, 9-49

Recovery Manager, 15-3

EXCLUDE option

of CONFIGURE, 8-25

EXIT command, 2-11

exiting RMAN, 2-11

expired backups

deleting, 7-13, 18-6

EXPIRED option

of DELETE, 18-6

features, new, xxxiii to xlix

FILESPERSET parameter

BACKUP command

specifying number of files in a backup set, 5-29

FORCE option

DELETE command, 7-14, 18-8

fractured blocks

definition, 5-67

detection, 5-67

full backups, 5-37

generic channels

definition, 8-12

hardware multiplexing

definition, 5-12

hot backup mode. See backup mode

image copies, 5-62

testing restore of, 10-41

INCARNATION option

of LIST, 16-10

of RESET DATABASE, 16-10

INCLUDE CURRENT CONTROLFILE option

BACKUP command, 9-10

incomplete recovery

overview, 6-9

time-based, 10-11

using RMAN, 10-10

with current control file, 10-10

inconsistent backups

using RMAN, 9-5

incremental backups, 9-17, 9-42

differential, 5-40

how RMAN applies, 6-7

using RMAN, 9-16, 9-17

initialization parameter file, 6-5

initialization parameters

BACKUP_TAPE_IO_SLAVES, 9-16

CONTROL_FILE_RECORD_KEEP_TIME, 16-32

CONTROL_FILES, 10-20

DB_FILE_NAME_CONVERT, 11-14, 12-7, 13-8

DB_NAME, 11-14

LARGE_POOL_SIZE, 14-13

LOCK_NAME_SPACE, 11-14

LOG_FILE_NAME_CONVERT, 11-14, 13-8

integrity checks, 5-65

interpreting RMAN error stacks, 15-6

I/O errors

effect on backups, 5-46

ignoring during deletions, 7-14, 18-8

jobs

RMAN, 4-7

monitoring performance, 15-23

monitoring progress, 15-19

KEEP option

of BACKUP, 5-55, 18-14

of CHANGE, 7-17

LARGE_POOL_SIZE initialization parameter, 14-13

level 0 incremental backups, 5-39

LIST command, 7-2, 17-3

INCARNATION option, 16-10

lists

backups and copies, 17-10

backups and copies made before specified date, 17-27

scenarios, 17-26

LOCK_NAME_SPACE initialization parameter, 11-14

log switches

recovery catalog records, 16-20, 18-15

LOG_FILE_NAME_CONVERT initialization parameter, 11-14

long waits

definition of, 14-17

long-term backups

changing status, 7-17

definition, 5-55

managing RMAN metadata, 12-1, 16-1, 18-1

MAXPIECESIZE parameter

SET command, 5-28, 8-6

MAXSETSIZE parameter

BACKUP command, 5-33, 8-22

CONFIGURE command, 8-22

MAXSIZE parameter

RECOVER command, 6-9

mean time to recovery (MTTR)

definition, 6-11

media management

backing up files, 4-16

Backup Solutions Program, 4-17

crosschecking, 7-8

error codes, 15-4

linking to software, 8-3

proxy copy, 4-17

restoring files, 4-17

sbttest program, 4-17, 15-9

testing the API, 15-9

media management library (MML), 1-9

media managers

configuring for use with RMAN, 8-6

definition, 1-9

installing, 8-2

linking

testing, 8-5

prerequisites for configuring, 8-2

testing, 8-5

testing backups, 8-8

troubleshooting, 8-8

media recovery

datafiles

basic steps, 6-6

using Recovery Manager, 6-5

message stack

RMAN, 15-3

metadata

managing RMAN, 4-11, 12-1, 16-1, 18-1

querying RMAN, 7-2

RMAN

querying, 17-2

storage of RMAN, 4-5

storing in control file, 4-14

mirrored files

splitting

using RMAN, 9-18

mirroring

backups using, 9-18

monitoring RMAN, 15-15

multiplexing

datafiles with Recovery Manager, 5-18

naming backup sets, 5-27

new features, xxxiii to xlix

NLS_DATE_FORMAT environment variable, 8-27

NLS_LANG environment variable, 8-27

NOARCHIVELOG mode

backing up, 9-44

noncircular reuse records, 4-15

noncumulative incremental backups, 5-41, 5-52, 5-53

NOT BACKED UP SINCE clause

BACKUP command, 9-27

obsolete backups

deleting, 5-54, 7-12

different from expired backups, 5-50

reporting, 7-4

online redo logs

duplicate database, 12-5

open database recovery

using RMAN, 10-9

OPEN RESETLOGS clause

ALTER DATABASE statement, 16-10

operating system copies

definition, 5-63

operating system utilities

copying files with, 9-45

Oracle Enterprise Manager

Backup wizard, 9-4

job scripts, 4-10

Recovery wizard, 10-2

Oracle Real Application Clusters

autolocation of backups, 10-25

backups, 9-44

connecting using RMAN, 2-6

recovering using RMAN, 10-25

orphaned backups

reports, 7-5

overwriting control file records, 16-32

packages

DBMS_PIPE, 2-10, 4-10

parallelism

backups, 5-23

configuring RMAN, 5-5, 8-11

manually allocated RMAN channels, 5-10

password files

connecting to Recovery Manager with, 2-5

passwords

connecting to RMAN, 2-9

pipe interface, 4-10

pipes

using to run RMAN commands, 2-9

point of recoverability

recovery window, 5-51

point-in-time recovery

tablespace, 11-2 to 11-12

PRINT SCRIPT command, 7-7

proxy copy

overview, 4-17

PROXY ONLY option

of BACKUP, 5-14

PROXY option

of BACKUP, 5-14

querying

recovery catalog, 17-2

QUIT command, 2-11

quitting RMAN, 2-11

RATE option

of ALLOCATE CHANNEL, 5-35

of CONFIGURE CHANNEL, 5-35

read-only tablespaces

backing up, 9-34

RECOVER command, 6-5, 6-9

recovery

complete, 10-8

data blocks, 6-11, 10-38

guidelines, 6-12

database

in NOARCHIVELOG mode, 10-46

database files

how RMAN applies changes, 6-7

in a disaster, 6-10

overview, 6-5

datafile without a backup, 10-47

determining files needing recovery, 15-23

differences among scenarios, 10-3

disaster using RMAN, 10-35

generic procedures, 10-2

generic RMAN, 10-5

incomplete, 10-10

of lost or damaged recovery catalog, 16-23

open database using RMAN, 10-9

Oracle Real Application Clusters, 10-25

preparing for, 10-6

tablespace, 10-9

time-based, 10-11

using backup control file, 10-13, 10-15

with recovery catalog, 10-15

without recovery catalog, 10-16

whole database

using backup control file, 10-15

without a recovery catalog, 4-15

recovery catalog, 4-11

availability, 16-26

backing up, 4-14, 16-20

cataloging

O/S backups, 18-15

compatibility, 4-14

connecting to Recovery Manager with, 2-5, 2-7

consequences of using, 3-13

contents, 4-12

creating, 8-31

crosschecking, 7-9

db identifier problems, 16-7

deleting backups, 18-4

deleting records, 18-5

displaying stored scripts, 17-21

dropping, 16-30

incomplete recovery using, 10-10

log switch record, 16-20, 18-15

managing size of, 16-19

moving to new database, 16-24

operating with, 1-8, 4-11

operating without, 4-14

overview, 4-11

querying, 17-2

recovery of, 16-23

refreshing, 16-11

registering target databases, 4-11, 16-5, 16-6

removing records, 18-18

resynchronizing, 16-11

schema

setting up, 8-31

snapshot control file, 4-13

space requirements, 16-3

stored scripts

creating, 16-17

executing, 16-17

synchronization, 4-12

TSPITR without, 11-5

UNKNOWN database name, 15-39

unregistering databases, 16-8

updating

after operating system deletions, 18-19

after schema changes, 16-14

upgrading, 16-28

views

querying, 17-23

Recovery Manager, 14-2

allocating channels, 14-9

allocating disk buffers, 14-2

allocating input files, 14-10

allocating tape buffers, 14-5

archived redo logs

backups, 9-11

backup sets, 5-33

backing up, 9-26

overview, 5-13

backup types, 5-12

duplexed backup sets, 5-21

backups

archived redo logs, 9-11, 9-12, 9-13, 9-15

backing up, 5-24

batch deletion of obsolete, 5-54

control file, 9-11

control file autobackups, 5-47, 8-17, 9-8

control file copies, 9-11

control files, 9-8, 9-10

datafile, 9-7, 9-8, 9-26, 9-27, 9-28

image copy, 5-62

incremental, 9-16, 9-17

long-term, 5-55

optimization, 5-56

overview, 9-3

restartable, 5-61

standby database, 9-25

tablespace, 9-7, 9-8, 9-26, 9-27, 9-28

testing, 5-68, 9-28

types, 5-36

using tags, 5-64

validating, 9-28

whole database, 9-6

channels, 5-2

generic configurations, 5-8

naming conventions, 5-7

specific configurations, 5-8

commands

BACKUP, 5-13, 5-14, 9-49

CATALOG, 16-7, 18-15

CHANGE, 7-8, 18-2

DELETE, 18-16

DUPLICATE, 13-2

EXECUTE SCRIPT, 16-16

interactive use of, 4-8

job commands, 4-7

LIST, 16-10

REGISTER, 16-7

REPORT, 17-11

RESTORE, 10-6

RESYNC CATALOG, 16-23

standalone commands, 4-7

types, 4-6

using command files, 4-8

compilation and execution of commands, 4-6

configuring

default device types, 5-6

device types, 5-5

showing, 7-7, 17-15

connecting

command line options, 2-3

constraints

backup, 5-45

corrupt datafile blocks, 5-66, 5-67

handling I/O errors and, 5-46

crosschecking recovery catalog, 7-9

database character set, 8-27

database connections, 2-2

auxiliary database, 2-7

duplicate database, 2-8

hiding passwords, 2-9

Oracle Real Application Clusters configuration, 2-6

SYSDBA required for target, 2-2

with a catalog, 2-5

with password files, 2-5

with recovery catalog, 2-5, 2-7

without a catalog, 2-4

datafile copies

backing up, 9-8

DBMS_PIPE package, 2-10

definition, 1-2

disconnecting from, 2-11

duplicate databases

how created, 12-3

environment

definition, 4-2

error codes

message numbers, 15-4

errors, 15-2, 15-3

interpreting, 15-6

executable

definition, 1-6

feature comparison with user-managed recovery, 1-4

file deletion

overview, 7-11

fractured block detection in, 5-67

hanging backups, 15-27

image copy backups, 5-62

incomplete recovery

with current control file, 10-10

incremental backups

cumulative, 5-42

differential, 5-40

level 0, 5-39

integrity checking, 5-65

interactive use of commands, 4-8

introduction, 4-2

jobs

monitoring progress, 15-19

lists, 17-3

media management

backing up files, 4-16

Backup Solutions Program (BSP), 4-17

crosschecking, 7-8

media manager, linking with a, 8-3

proxy copy, 4-17

restoring files, 4-17

testing, 4-17

metadata, 4-11, 12-1, 16-1, 18-1

storing in control file, 4-14

monitoring, 15-15, 15-23

multiplexing

datafiles, 5-18

overview, 1-5, 4-2, 4-5

performance, 14-11

monitoring, 15-15

pipe interface, 4-10

reasons for using, 1-2

recovery

after total media failure, 10-35

incomplete, 10-10

open database, 10-9

using backup control file, 10-15

recovery catalog, 4-11

availability, 16-26

backing up, 16-20

compatibility, 4-14

contents, 4-12

crosschecking, 7-9

deciding whether to use, 3-13

managing the size of, 16-19

moving to new database, 16-24

operating with, 1-8, 4-11

operating without, 4-14

querying, 17-2

recovering, 16-23

registration of target databases, 4-11, 16-6

removing records, 18-18

resynchronizing, 16-11

schema, 8-31

snapshot control file, 4-13

synchronization, 4-12

updating after schema changes, 16-14

upgrading, 16-28

registering databases, 16-7

reports, 7-2, 17-11

database schema, 17-14

objects needing a backup, 17-12

obsolete backups, 17-13, 17-14

overview, 7-3

repository

definition, 1-6

restoring, 10-5

archived redo logs, 10-21

control files to new location without recovery catalog, 10-20

datafiles, 6-2

to new host, 10-23

using nondefault filenames, 10-19

retention policies

configuring, 8-20

return codes, 15-9

RPC calls and, 15-28

sample scripts, 3-2

sbttest program, 4-17

setting time parameters, 8-27

snapshot control file location, 8-28

standby database

about creating, 13-2

backing up, 9-20, 9-24

backing up archived logs, 9-22

backing up overview, 9-20

backup restrictions, 9-21

copying standby control file, 13-6

creating, 13-9

creating standby control file, 13-3

creating standby control file using RMAN BACKUP command, 13-4

creating standby control file using RMAN COPY command, 13-5

creating standby control file using SQL, 13-5

creating using image copies, 13-21

creation overview, 13-9

DB_FILE_NAME_CONVERT initialization parameter, 13-8

interpreting the RC_ARCHIVED_LOG view, 9-22

LOG_FILE_NAME_CONVERT initialization parameter, 13-8

naming standby datafiles, 13-6

preparing using RMAN, 13-2

starting RMAN and standby instance, 13-11

standby databases

creating, 6-15

starting, 2-4

stored scripts, 4-9

synchronous and asynchronous I/O, 14-5

tablespace point-in-time recovery, 6-9

tags for backups, 5-64

terminating commands, 15-11

test disk API, 8-5

types of backups, 5-62

using basic commands, 3-3

using incremental backups, 14-11

using RMAN commands, 4-5

using with a pipe, 2-9

recovery sets

for RMAN TSPITR, 11-4

recovery window

point of recoverability, 5-51

RECOVERY WINDOW parameter

CONFIGURE command, 8-20

recovery windows

backup optimization and, 5-59

configuring for retention policy, 8-20

definition, 5-51

REGISTER command, 16-6, 16-7

removing records from the recovery catalog, 18-18

RENAME DATABASE clause

ALTER DATABASE statement, 10-19

REPORT command, 17-11

NEED BACKUP option, 17-11

REPORT OBSOLETE command, 5-54

reports, 7-2, 17-2, 17-11

database incarnations, 17-27

database schema, 17-14, 17-27

objects needing a backup, 17-12

obsolete backups, 7-4, 17-13, 17-14, 17-27

orphaned backups, 7-5

overview, 7-3

scenarios, 17-27

unrecoverable backups, 17-13, 17-14

repository

RMAN, 4-5, 4-11

querying, 17-2

RESET DATABASE command

INCARNATION option, 16-10

restartable backups

definition, 5-61, 9-27

restarting RMAN backups, 9-27

RESTORE command, 6-2, 10-6

FORCE option, 6-4

restore optimization, 6-4

restore validation, 10-41

restoring

backup control file

using SET DBID, 10-43

control files, 10-20

database

to new host, 10-23

database files, 6-2

how RMAN chooses, 6-4

mechanics, 6-3

restore optimization, 6-4

datafiles, 10-5

using nondefault filenames, 10-19

server parameter files, 10-12

testing, 10-41

RESYNC CATALOG command, 4-13, 16-11

FROM CONTROLFILECOPY option, 16-23

resynchronizing the recovery catalog, 16-11

retention policies

affect on backup optimization, 5-59

configuring, 8-20

configuring for redundancy, 8-21

definition, 5-50

disabling, 5-51, 8-22

exempt backups, 5-55

making backups exempt, 18-14

recovery window, 5-51

recovery windows, 8-20

redundancy, 5-51, 5-53

return codes

RMAN, 15-9

RMAN. See Recovery Manager

sample scripts

RMAN, 3-2

sbtio.log

and RMAN, 15-3

sbttest program, 4-17, 15-9

scenarios, Recovery Manager

backing up archived redo logs, 9-40

cataloging operating system copies, 9-45

duplexing backup sets, 9-15

handling backup errors, 9-49

incremental backups, 9-42

incremental cumulative backups, 9-43

listing backups and copies, 17-26

listing obsolete backups and copies, 17-27

maintaining backups and copies, 9-46

NOARCHIVELOG backups, 9-44

Oracle Real Application Clusters backups, 9-44

recovering pre-resetlogs backup, 10-45, 10-46

recovery after total media failure, 10-35

reporting database schema, 17-27

reporting obsolete backups, 17-27

setting size of backup sets, 9-36

schemas

changes

updating recovery catalog, 16-14

server parameter files

autobackups, 5-47

backups, 9-11

configuring autobackups, 8-17

restoring, 10-12

server sessions

Recovery Manager, 4-4

session architecture

Recovery Manager, 4-4

SET command

BACKUP COPIES parameter, 5-21

MAXCORRUPT option, 9-49

shared server

configuring for use with RMAN, 8-29

short waits

definition of, 14-17

SHOW command, 5-5, 7-7, 17-15

size of backup sets

setting, 5-28

SKIP OFFLINE option

of BACKUP, 9-34

SKIP READONLY option

of BACKUP, 9-34

snapshot control files, 4-13

specifying location, 8-28

split mirrors

using as backups, 9-18

standalone Recovery Manager commands, 4-7

standby databases

about creating using RMAN, 13-2

backing up using RMAN, 9-20, 9-24, 9-25

guidelines for backing up logs, 9-22

interpreting the RC_ARCHIVED_LOG view, 9-22

overview, 9-20

restrictions, 9-21

copying control file using RMAN, 13-6

copying standby control file, 13-6

creating

on local host, 13-20

on remote host with different directory structure, 13-15

on remote host with same directory structure, 13-13

creating control file

using RMAN, 13-3, 13-4, 13-5

using SQL, 13-5

creating using RMAN, 6-15, 13-9

overview, 13-9

using image copies, 13-21

DB_FILE_NAME_CONVERT initialization parameter, 13-8

LOG_FILE_NAME_CONVERT initialization parameter, 13-8

naming datafiles using RMAN, 13-6

preparing using RMAN, 13-2

SET AUXNAME command, 13-8

SET NEWNAME command, 13-8

starting RMAN and standby instance, 13-11

starting RMAN

without connecting to a database, 2-4

stored scripts

creating RMAN, 16-17

deleting, 16-18

displaying, 7-7, 17-21

executing, 16-17

executing RMAN, 16-17

managing, 16-16

printing, 17-22

Recovery Manager, 4-9

replacing, 16-18

SYSDBA option

implicitly assumed for RMAN connect to target, 2-3

tablespace backups

using RMAN, 9-7, 9-8, 9-26, 9-27, 9-28

tablespace point-in-time recovery

using RMAN, 6-9

basic steps, 11-2

introduction, 11-2

performing, 11-17

planning, 11-4

planning for, 11-4

preparing the auxiliary instance, 11-13

restrictions, 11-5

terminology, 11-3

why perform, 11-2

without recovery catalog, 11-5

tablespaces

backups using RMAN, 9-7

excluding from RMAN backups, 8-25

read-only

backing up, 9-34

recovering accessible

when database is open, 10-9

transporting RMAN backups, 10-48

tags, 5-64

target database

definition, 1-6

terminating RMAN commands, 15-11

test databases, creating, 6-14

test disk API, 8-5

testing RMAN

backups, 5-68, 9-28

with media management API, 15-9

with media manager, 4-17

time parameters

setting for Recovery Manager use, 8-27

trace files

and RMAN, 15-3

transportable tablespaces, 10-48

transporting tablespaces between databases, 10-48

TSPITR. See tablespace point-in-time recovery

tuning

Recovery Manager

V$ views, 15-15

UNAVAILABLE option

of CHANGE, 7-16, 18-12

UNCATALOG option

deleting repository records, 18-18

of CHANGE, 18-18

unregistering a database from the recovery catalog, 16-8

upgrading the recovery catalog, 16-28

user-managed backups

cataloging, 18-15

utilities

operating system, using to make copies, 9-45

V$ARCHIVED_LOG view, 6-8

V$BACKUP_ASYNC_IO, 15-15

V$BACKUP_CORRUPTION view, 5-46

V$BACKUP_SYNC_IO, 15-15

V$COPY_CORRUPTION view, 5-46

V$DATABASE_BLOCK_CORRUPTION view, 9-28, 10-40

V$PROCESS view, 15-15

V$PROXY_DATAFILE view, 5-14

V$SESSION view, 15-15

V$SESSION_LONGOPS view, 15-15

V$SESSION_WAIT view, 15-15

validating

backups, 9-28

validation of restore, 10-41

views

RC_ARCHIVED_LOG, 9-22

recovery catalog, 17-23

whole database backups

using RMAN, 9-6

Index

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

T

U

V

W