Oracle9i Recovery Manager User's Guide -- Index

alert log

control file record messages, 16-30

monitoring overwriting of control file records, 16-31

useful for RMAN, 15-2

ALTER DATABASE statement

OPEN RESETLOGS clause, 16-10

RENAME DATABASE clause, 10-17

ALTER SYSTEM statement

KILL SESSION clause, 15-12

ALTER TABLESPACE statement

BEGIN BACKUP clause, 18-15

END BACKUP clause, 18-15

archived log failover, 5-16

archived redo logs

backing up, 9-38

using RMAN, 9-10, 9-11, 9-12

backups, 5-18

using RMAN, 9-9

cataloging, 16-6, 18-14

deletion after backup, 5-16

failover, 5-16

generated during backups, 5-17

restoring using RMAN, 10-19

RMAN fails to delete, 15-24

autobackups

control file, 5-46, 8-17, 9-7

automatic channel allocation, 5-3

automatic channels, 5-2

configuring, 8-11, 8-14

configuring for backups, 9-2

generic

configuring, 8-12

definition, 8-12

generic configurations, 5-8

naming conventions, 5-7

overriding, 8-11

parallelism, 8-11

specific configurations, 5-8

auxiliary databases

for RMAN TSPITR

converted filenames, 11-16

using datafile copies, 11-15

auxiliary sets

for RMAN TSPITR, 11-4

naming datafiles in tablespaces, 11-14

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-14, 9-46

BACKUPSET option, 5-24, 9-24

COPIES parameter, 5-21

CURRENT CONTROLFILE option, 9-7

DELETE ALL INPUT option, 5-16

DELETE INPUT option, 5-16, 7-13

FORMAT parameter, 5-27

KEEP option, 5-53

NOT BACKED UP SINCE clause, 9-25

NOT BACKUP UP SINCE clause, 5-60

PLUS ARCHIVELOG option, 5-18

PROXY ONLY option, 5-14

PROXY option, 5-14

SKIP OFFLINE option, 9-32

VALIDATE option, 5-65

BACKUP COPIES parameter

CONFIGURE command, 8-23

backup mode

definition, 5-61

backup optimization

configuring, 8-22

definition, 5-54, 9-25

disabling, 5-56, 8-23

enabling, 5-56, 8-23

recovery window and, 5-57

redundancy and, 5-58

retention policies and, 5-57

BACKUP OPTIMIZATION option

of CONFIGURE, 9-25

backup pieces

definition, 5-13

restricting size, 5-27

backup retention policy

definition, 5-47

backup sets

backing up, 9-24

backups of, 5-24

configuring maximum size, 8-21

creating by using BACKUP command, 5-32

crosschecking, 7-9

definition, 5-13

duplexing, 9-13

errors during creation, 5-45

failover during backups, 5-25

how RMAN generates, 5-28

multiplexing, 5-18

naming, 5-27

number, 5-28

organizing, 5-14

overview, 5-13

restricting piece size, 5-27

size, 5-28

specifying maximum size (in bytes), 5-27, 5-32

specifying number of, 5-28

testing restore of, 10-38

Backup Solutions Program (BSP), 4-17

BACKUP_TAPE_IO_SLAVES initialization parameter, 9-13

backups

archived redo logs, 9-38

backing up using RMAN, 9-12

using RMAN, 9-9, 9-10, 9-11

when needed, 5-18

automatic location using RMAN, 10-23

automatic log switch during, 5-17

availability, 18-12

altering with CHANGE command, 7-15

backup sets, 5-13, 9-24

backups of, 5-24

consistent

making using RMAN, 9-4

control file

automatic, 5-46, 8-17

using for recovery, 10-13

using RMAN, 9-7, 9-8

correlating RMAN channels with, 17-24

crosschecking, 18-2

cumulative incremental, 5-41, 5-42, 6-6, 6-12, 6-14, 9-40, 14-4, 14-6, 14-7, 14-8

datafile

using RMAN, 9-5, 9-6, 9-24, 9-25, 9-26

deleting, 7-12

duplexing, 8-23, 9-13

excluding tablespaces from backups, 8-24

exempt from retention policy, 18-13

expired

deleting, 18-6

failed RMAN, 15-24

failover during BACKUP BACKUPSET, 5-25

full, 5-36

generating reports for, 17-2

hung, 15-17

image copies, 5-13, 5-60

inconsistent

making using RMAN, 9-4

incremental, 5-37, 9-16, 9-40

differential, 5-39

using RMAN, 9-14, 9-15, 9-16

interrupted, 9-25

keeping, 9-44

limiting datafiles in a backup set, 5-19

limiting I/O rate, 5-34

limiting number of open files during, 5-19

long-term, 5-53

changing status, 7-16

methods for making, 1-2

multiple copies, 8-23

NOARCHIVELOG mode, in, 9-42

noncumulative incremental, 5-40, 5-50, 5-51

obsolete

batch deletes, 5-52

optimizing, 5-54

Oracle Real Application Clusters, 9-42

overview of RMAN, 9-3

recovering pre-RESETLOGS, 10-42

recovery catalog, 4-13, 16-19

reporting objects needing backups, 17-11

restartable, 5-59, 9-25

RMAN error handling, 9-46

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

split mirror, 5-61

using RMAN, 9-16

standby database

archived redo logs, 9-21

interpreting RC_ARCHIVED_LOG view, 9-20

overview of RMAN, 9-18

restrictions, 9-19

using RMAN, 9-18, 9-23

stored scripts, 16-16

tablespace

using RMAN, 9-5, 9-6, 9-24, 9-25, 9-26

tags, 5-62

testing RMAN, 5-65, 9-26

using media manager, 8-8

troubleshooting failed RMAN, 15-15, 15-19, 15-22

types, 5-13, 5-35

user-managed

cataloging, 18-15

validating, 9-26

whole database

using RMAN, 9-5

BEGIN BACKUP clause

ALTER TABLESPACE statement, 18-15

block media recovery, 10-35

guidelines, 6-10

overview, 6-9

BLOCKRECOVER command, 6-9, 10-35

BSP. See Backup Solutions Program (BSP)

canceling RMAN commands, 15-12

CATALOG command, 16-6, 18-14

cataloging

archived redo logs, 16-6

datafiles, 16-6

operating system copies, 9-43

catalog.sql script, 16-3

catproc.sql script, 16-3

CHANGE command, 7-8, 18-2

AVAILABLE option, 7-15, 18-12

KEEP option, 7-16

UNAVAILABLE option, 18-12

UNCATALOG option, 18-17

channels

allocating manually for backups, 9-2

allocating multiple, 7-14

configuring automatic, 8-11

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-25

setting for use with RMAN, 8-26

circular reuse records, 4-15

clearing RMAN configuration, 5-9, 8-16

command files

Recovery Manager, 4-9

command interface

RMAN, 4-5

commands, Recovery Manager

BACKUP, 5-14, 9-46

PROXY ONLY option, 5-14

PROXY option, 5-14

SKIP OFFLINE option, 9-32

BACKUP CURRENT CONTROLFILE, 9-7

batch execution, 4-9

CATALOG, 16-6, 18-14

CHANGE, 7-8, 18-2

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

COPY, 5-60

CROSSCHECK, 18-2

DELETE, 7-12, 18-16

DROP CATALOG, 16-28

DUPLICATE, 6-12, 13-2

EXECUTE SCRIPT, 16-16

how RMAN interprets, 4-5

interactive, 4-9

LIST, 7-2, 17-3

INCARNATION option, 16-10

piping, 4-10

PRINT SCRIPT, 7-7

RECOVER, 6-4

REGISTER, 16-7

REPLICATE, 10-18

REPORT, 17-10

NEED BACKUP option, 17-11

RESET DATABASE

INCARNATION option, 16-10

RESTORE, 10-5

RESYNC CATALOG, 4-13, 16-12

FROM CONTROLFILECOPY option, 16-22

SET

MAXCORRUPT option, 9-46

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

stand-alone, 4-7

terminating, 15-12

types, 4-7

UPGRADE CATALOG, 16-26

using, 3-2

compatibility

recovery catalog, 4-14

compilation

and execution of RMAN commands, 4-6

complete recovery

using RMAN, 10-7

CONFIGURE ... CLEAR command, 5-9

CONFIGURE command, 17-15

BACKUP COPIES parameter, 5-21

BACKUP OPTIMIZATION option, 8-23

CHANNEL option, 5-8

CLEAR option, 8-16

DEFAULT DEVICE TYPE clause, 5-6

DEVICE TYPE clause, 5-5

EXCLUDE option, 8-24

RETENTION POLICY clause, 5-47, 5-48

configuring

media manager

installing, 8-2

prerequisites, 8-2

media managers for use with RMAN, 8-6

Recovery Manager

automatic channels, 8-11, 8-12

backup optimization, 8-22

backup set size, 8-21

clearing, 5-9, 8-16

default device types, 5-6, 8-11

device types, 5-5

parallelism, 5-5

shared server, 8-28

SHOW command, 7-7

showing, 17-15

specific channels, 8-14

consistent backups

using RMAN, 9-4

control file autobackups

default format, 5-46

definition, 5-46, 8-17

restoring, 5-46

control file copies

backing up, 9-8

control file records

overwriting, 16-30

control files

automatic backups, 5-46, 8-17, 9-7

backing up

using RMAN, 9-7, 9-8

backup and recovery, 10-13

backups

including within database backup, 9-8

recovery using, 10-11

using RMAN, 9-7

copies

backing up, 9-8

duplicate database, 12-5

overwriting records, 16-30

restoring, 10-18

using dbid, 10-41

using RMAN, 10-18

snapshot

specifying location of, 8-26

types of records, 4-15

using instead of a recovery catalog, 4-14

CONTROL_FILE_RECORD_KEEP_TIME initialization parameter, 16-30

preventing overwrite of RMAN records, 16-30

CONTROL_FILES initialization parameter, 10-18, 11-8

copies

crosschecking, 18-2

long-term, 5-63

COPIES option

of BACKUP, 9-14

COPY command, 5-60

KEEP option, 5-63

corrupt datafile blocks, 5-64

detecting, 5-64

records in control file, 5-45

RMAN and, 5-45

setting maximum for backup, 9-46

corruption detection, 5-64

CREATE CATALOG command, 4-6

creating

duplicate databases

on a remote host, 12-13

recovery catalog, 8-30

test databases, 6-12

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, 18-2

cumulative incremental backups, 5-41, 9-40

database connections

Recovery Manager

auxiliary database, 2-7

hiding passwords, 2-8

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 incarnation

removing records from RMAN catalog, 16-11

database point-in-time recovery (DBPITR)

definition, 10-9

database schema

generating reports, 17-14

databases

backing up

using Recovery Manager, 5-14

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-6

datafile recovery

definition, 6-4

datafiles

backing up

using Recovery Manager, 5-14, 9-5, 9-6, 9-24, 9-25, 9-26

backups needed, listing, 17-32

cataloging, 16-6

duplicate database, 12-6

listing

unrecoverable, 17-11

recovery

basic steps, 6-5

determining when necessary, 17-27

restoring, 6-2, 10-4

using nondefault filenames, 10-16

db identifier

obtaining, 10-41

problems registering copied database, 16-7

DB_FILE_NAME_CONVERT initialization parameter, 11-8

using with RMAN DUPLICATE command, 12-8

DB_NAME initialization parameter, 11-8

DBMS_BACKUP_RESTORE package, 4-6

DBMS_PIPE package, 4-10

using with RMAN, 2-9

DBMS_RCVCAT package, 4-6

DBMS_RCVMAN package, 4-6

default device types

configuring, 8-11

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

EXPIRED option, 18-6

OBSOLETE option, 5-53

deleting

backups, 18-4, 18-5

on multiple channels, 18-8

copies, 18-4

expired backups, 7-13

files after backups, 7-13

obsolete backups, 7-12

on multiple device types, 7-14

using RMAN, 7-11

device types

RMAN

configuring, 8-11

differential incremental backups, 5-39

disaster recovery

using RMAN, 6-9

disconnecting

from Recovery Manager, 2-11

disk API, 8-5

disk channels

preconfigured, 8-11

dropping the recovery catalog, 16-28

dummy API, 8-5

duplexing

backups, 8-23

duplexing backup sets, 5-21, 9-13

DUPLICATE command, 6-12

duplicate databases

creating, 6-12

non-current, 12-20

on a remote host with same file system, 12-13

on local host, 12-18

on remote host with different file system, 12-14

using CONFIGURE AUXNAME, 12-17

using init.ora parameter and LOGFILE, 12-15

using SET NEWNAME, 12-16

datafiles, 12-6

DB_FILE_NAME_CONVERT initialization parameter, 12-6

failed creation, 15-27

generating control files, 12-5

generating filenames, 12-4

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-7

skipping read-only tablespaces, 12-7

duplicating a database, 6-12

troubleshooting, 15-27

END BACKUP clause

ALTER TABLESPACE statement, 18-15

environment variables

NLS_DATE_FORMAT, 8-26

NLS_LANG, 8-26

environment, Recovery Manager

definition, 4-2

error codes

media manager, 15-5

RMAN, 15-2, 15-4

message numbers, 15-4

error stacks

interpreting, 15-7

errors

during RMAN backups, 9-46

Recovery Manager, 15-3

EXCLUDE option

of CONFIGURE, 8-24

EXIT command, 2-11

exiting RMAN, 2-11

expired backups

deleting, 7-13, 18-6

EXPIRED option

of DELETE, 18-6

features, new, xxix to xli

FILESPERSET parameter

BACKUP command

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

fractured block detection, 5-65

fractured blocks

definition, 5-65

detection, 5-65

full backups, 5-36

generic channels

definition, 8-12

hardware multiplexing

definition, 5-12

hot backup mode. See backup mode

image copies, 5-60

testing restore of, 10-38

INCARNATION option

of LIST, 16-10

of RESET DATABASE, 16-10

INCLUDE CURRENT CONTROLFILE option

BACKUP command, 9-8

incomplete recovery

overview, 6-8

time-based, 10-10

using RMAN, 10-9

with current control file, 10-10

inconsistent backups

using RMAN, 9-4

incremental backups, 9-16, 9-40

differential, 5-39

how RMAN applies, 6-6

using RMAN, 9-14, 9-15, 9-16

initialization parameter file, 6-4

initialization parameters

BACKUP_TAPE_IO_SLAVES, 9-13

CONTROL_FILE_RECORD_KEEP_TIME, 16-30

CONTROL_FILES, 10-18

DB_FILE_NAME_CONVERT, 11-8, 12-6, 13-8

DB_NAME, 11-8

LARGE_POOL_SIZE, 14-13

LOCK_NAME_SPACE, 11-8

LOG_FILE_NAME_CONVERT, 11-8, 13-8

integrity checks, 5-63

interpreting RMAN error stacks, 15-7

I/O errors

effect on backups, 5-45

jobs

RMAN, 4-7

monitoring performance, 17-27

monitoring progress, 17-25

KEEP option

of BACKUP, 5-53, 18-13

of CHANGE, 7-16

LARGE_POOL_SIZE initialization parameter, 14-13

level 0 incremental backups, 5-38

LIST command, 7-2, 17-3

INCARNATION option, 16-10

lists

backups and copies, 17-10

backups and copies made before specified date, 17-32

scenarios, 17-31

LOCK_NAME_SPACE initialization parameter, 11-8

log switches

recovery catalog records, 16-19, 18-14

LOG_FILE_NAME_CONVERT initialization parameter, 11-8

long waits

definition of, 14-18

long-term backups

changing status, 7-16

definition, 5-53

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

MAXPIECESIZE parameter

SET command, 5-27, 8-6

MAXSETSIZE parameter

BACKUP command, 5-33, 8-21

CONFIGURE command, 8-21

mean time to recovery (MTTR)

definition, 6-10

media management

backing up files, 4-16

Backup Solutions Program, 4-17

crosschecking, 7-8

error codes, 15-5

linking to software, 8-3

proxy copy, 4-17

requirements, 8-2

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-5

using Recovery Manager, 6-4

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-16

mirroring

backups using, 9-16

monitoring RMAN, 17-23

multiplexing

datafiles with Recovery Manager, 5-18

naming backup sets, 5-27

new features, xxix to xli

NLS_DATE_FORMAT environment variable, 8-26

NLS_LANG environment variable, 8-26

NOARCHIVELOG mode

backing up, 9-42

noncircular reuse records, 4-15

noncumulative incremental backups, 5-40, 5-50, 5-51

NOT BACKED UP SINCE clause

BACKUP command, 9-25

objects owned by SYS

and TSPITR using RMAN, 11-7

obsolete backups

deleting, 5-52, 7-12

different from expired backups, 5-47

reporting, 7-4

online redo logs

duplicate database, 12-5

open database backups

fractured block detection during, 5-65

open database recovery

using RMAN, 10-8

OPEN RESETLOGS clause

ALTER DATABASE statement, 16-10

operating system copies

definition, 5-61

operating system utilities

copying files with, 9-43

Oracle Real Application Clusters

backups, 9-42

connecting using RMAN, 2-6

recovering using RMAN, 10-23

orphaned backups

reports, 7-5

overwriting control file records, 16-30

packages

DBMS_BACKUP_RESTORE, 4-6

DBMS_PIPE, 2-9, 4-10

DBMS_RCVCAT, 4-6

DBMS_RCVMAN, 4-6

used by RMAN, 4-6

parallelism

backups, 5-22

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-8

pipe interface, 4-10

pipes

using to run RMAN commands, 2-9

point of recoverability

recovery window, 5-48

point-in-time recovery

tablespace, 11-2 to 11-16

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-34

of CONFIGURE CHANNEL, 5-34

read-only tablespaces

backing up, 9-32

RECOVER command, 6-4

recovery

complete, 10-7

data block, 10-35

data blocks, 6-9

guidelines, 6-10

database

in NOARCHIVELOG mode, 10-44

database files

how RMAN applies changes, 6-6

in a disaster, 6-9

overview, 6-4

datafile without a backup, 10-45

determining files needing recovery, 17-27

differences among scenarios, 10-2

disaster using RMAN, 10-33

generic procedures, 10-2

generic RMAN, 10-4

incomplete, 10-9

of lost or damaged recovery catalog, 16-22

open database using RMAN, 10-8

Oracle Real Application Clusters, 10-23

preparing for, 10-5

tablespace, 10-8

time-based, 10-10

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

with recovery catalog, 10-13

without recovery catalog, 10-14

whole database

using backup control file, 10-13

without a recovery catalog, 4-15

recovery catalog, 4-11

availability, 16-25

backing up, 4-13, 16-19

cataloging

O/S backups, 18-14

compatibility, 4-14

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

consequences of using, 3-13

contents, 4-12

creating, 8-30

crosschecking, 7-9, 18-2

db identifier problems, 16-7

deleting backups, 18-4

deleting records, 18-5

displaying stored scripts, 17-21

dropping, 16-28

incomplete recovery using, 10-10

log switch record, 16-19, 18-14

managing size of, 16-18

moving to new database, 16-23

operating with, 1-8, 4-11

operating without, 4-14

overview, 4-11

querying, 17-2

recovery of lost or damaged, 16-22

refreshing, 16-12

registering databases, 16-6

registering target databases, 16-5

registration of target, 4-12

removing records, 18-18

database incarnation, 16-11

resynchronizing, 16-12

schema

setting up, 8-30

snapshot control file, 4-13

space requirements, 16-3

stored scripts

creating, 16-16

executing, 16-17

synchronization, 4-12

TSPITR without, 11-5

UNKNOWN database name, 15-29

unregistering databases, 16-8

updating

after operating system deletions, 18-18

after schema changes, 16-15

upgrading, 16-26

views

querying, 17-29

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-9

backup sets, 5-32

backing up, 9-24

overview, 5-13

backup types, 5-13

duplexed backup sets, 5-21

backups

archived redo logs, 9-9, 9-10, 9-11, 9-12

backing up, 5-24

batch deletion of obsolete, 5-52

control file, 9-7, 9-8

control file autobackups, 5-46, 8-17, 9-7

control file copies, 9-8

control files, 9-7

datafile, 9-5, 9-6, 9-24, 9-25, 9-26

fractured block detection, 5-65

image copy, 5-60

incremental, 9-14, 9-15, 9-16

long-term, 5-53

optimization, 5-54

overview, 9-3

restartable, 5-59

standby database, 9-23

tablespace, 9-5, 9-6, 9-24, 9-25, 9-26

testing, 5-65, 9-26

types, 5-35

using tags, 5-62

validating, 9-26

whole database, 9-5

channels, 5-2

generic configurations, 5-8

naming conventions, 5-7

specific configurations, 5-8

commands

BACKUP, 5-14, 9-46

CATALOG, 16-6, 18-14

CHANGE, 7-8, 18-2

DELETE, 18-16

DUPLICATE, 13-2

EXECUTE SCRIPT, 16-16

interactive use of, 4-9

job commands, 4-7

LIST, 16-10

REGISTER, 16-7

REPLICATE CONTROLFILE, 10-18

REPORT, 17-11

RESTORE, 10-5

RESYNC CATALOG, 16-22

stand-alone commands, 4-7

types, 4-7

using command files, 4-9

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-44

control files

automatic backups, 5-46, 8-17

corrupt datafile blocks, 5-64

handling I/O errors and, 5-45

crosschecking recovery catalog, 7-9, 18-2

database character set, 8-26

database connections, 2-2

auxiliary database, 2-7

duplicate database, 2-7

hiding passwords, 2-8

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-6

DBMS_PIPE package, 2-9

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, 15-4

interpreting, 15-7

executable

definition, 1-6

feature comparison with user-managed recovery, 1-4

file deletion

overview, 7-11

fractured block detection in, 5-65

hanging backups, 15-17

image copy backups, 5-60

incomplete recovery

with current control file, 10-10

incremental backups

cumulative, 5-41

differential, 5-39

level 0, 5-38

integrity checking, 5-63

interactive use of commands, 4-9

introduction, 4-2

jobs

monitoring progress, 17-25

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

requirements, 8-2

restoring files, 4-17

testing, 4-17

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

storing in control file, 4-14

monitoring, 17-23, 17-27

multiplexing

datafiles, 5-18

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

performance

monitoring, 17-23

performance tips, 14-11

pipe interface, 4-10

reasons for using, 1-2

recovery

after total media failure, 10-33

incomplete, 10-9

open database, 10-8

using backup control file, 10-13

recovery catalog, 4-11

availability, 16-25

backing up, 16-19

compatibility, 4-14

contents, 4-12

crosschecking, 7-9, 18-2

deciding whether to use, 3-13

managing the size of, 16-18

moving to new database, 16-23

operating with, 1-8, 4-11

operating without, 4-14

querying, 17-2

recovering lost or damaged, 16-22

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

removing records, 18-18

resynchronizing, 16-12

schema, 8-30

snapshot control file, 4-13

synchronization, 4-12

updating after schema changes, 16-15

upgrading, 16-26

registering databases, 16-7

reports, 7-2, 17-10

database schema, 17-14

objects needing a backup, 17-11

obsolete backups, 17-13, 17-14

overview, 7-3

repository

definition, 1-6

restoring, 10-4

archived redo logs, 10-19

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

datafiles, 6-2

to new host, 10-20

using nondefault filenames, 10-16

retention policies

configuring, 8-19

return codes, 15-9

RPC calls and, 15-18

sample scripts, 3-12

sbttest program, 4-17

setting time parameters, 8-26

snapshot control file location, 8-26

standby database

about creating, 13-2

backing up, 9-18

backing up archived logs, 9-21

backing up overview, 9-18

backing up the database, 9-23

backup restrictions, 9-19

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-20

LOG_FILE_NAME_CONVERT initialization parameter, 13-8

naming online redo logs, 13-8

naming standby datafiles, 13-6

preparing using RMAN, 13-2

starting RMAN and standby instance, 13-11

standby databases

creating, 6-14

starting, 2-4

stored scripts, 4-9

synchronous and asynchronous I/O, 14-6

tablespace point-in-time recovery, 6-8

tags for backups, 5-62

terminating commands, 15-12

test disk API, 8-5

types of backups, 5-60

using basic commands, 3-2

using incremental backups, 14-11

using RMAN commands, 4-5

using with a pipe, 2-9

recovery sets

containing whole tables, 11-6

for RMAN TSPITR, 11-4

recovery window

point of recoverability, 5-48

RECOVERY WINDOW parameter

CONFIGURE command, 8-19

recovery windows

backup optimization and, 5-57

configuring for retention policy, 8-19

definition, 5-48

REGISTER command, 16-6, 16-7

removing records from the recovery catalog, 18-18

RENAME DATABASE clause

ALTER DATABASE statement, 10-17

REPLICATE command, 10-18

REPORT command, 17-10

NEED BACKUP option, 17-11

REPORT OBSOLETE command, 5-52

reports, 7-2, 17-2, 17-10

database incarnations, 17-32

database schema, 17-14, 17-32

objects needing a backup, 17-11

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

obsolete backups and copies, 17-32

orphaned backups, 7-5

overview, 7-3

scenarios, 17-32

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-59, 9-25

restarting RMAN backups, 9-25

RESTORE command, 6-2, 10-5

FORCE option, 6-4

restore optimization, 6-4

restore validation, 10-38

restoring

backup control file

using dbid, 10-41

control files, 10-18

database

to new host, 10-20

database files, 6-2

how RMAN chooses, 6-3

mechanics, 6-2

restore optimization, 6-4

datafiles, 10-4

using nondefault filenames, 10-16

testing, 10-38

RESYNC CATALOG command, 4-13, 16-12

FROM CONTROLFILECOPY option, 16-22

resynchronizing the recovery catalog, 16-12

retention policies

affect on backup optimization, 5-57

configuring, 8-19

configuring for redundancy, 8-20

definition, 5-47

disabling, 5-48, 8-21

recovery windows, 8-19

redundancy, 5-51

retention policy

exempt backups, 5-53

making backups exempt, 18-13

recovery window, 5-48

redundancy, 5-48

return codes

RMAN, 15-9

RMAN. See Recovery Manager

rollback segments

and RMAN TSPITR, 11-6

sample scripts

RMAN, 3-12

sbtio.log

and RMAN, 15-3

sbttest program, 4-17, 15-9

scenarios, Recovery Manager

backing up archived redo logs, 9-38

cataloging operating system copies, 9-43

duplexing backup sets, 9-13

handling backup errors, 9-46

incremental backups, 9-40

incremental cumulative backups, 9-40

listing backups and copies, 17-31

listing obsolete backups and copies, 17-32

maintaining backups and copies, 9-44

NOARCHIVELOG backups, 9-42

Oracle Real Application Clusters backups, 9-42

recovering pre-resetlogs backup, 10-42, 10-44

recovery after total media failure, 10-33

reporting database schema, 17-32

reporting obsolete backups, 17-32

restoring when databases share name, 10-41

setting size of backup sets, 9-34

schemas

changes

updating recovery catalog, 16-15

server sessions

Recovery Manager, 4-4

session architecture

Recovery Manager, 4-4

SET command

AUTOLOCATE option

using in Oracle Real Application Clusters configuration, 10-23

BACKUP COPIES parameter, 5-21

MAXCORRUPT option, 9-46

shared server

configuring for use with RMAN, 8-28

short waits

definition of, 14-18

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

size of backup sets, setting, 5-27

SKIP OFFLINE option

of BACKUP, 9-32

SKIP READONLY option

of BACKUP, 9-32

snapshot control files, 4-13

specifying location, 8-26

split mirrors

using as backups, 9-16

stand-alone Recovery Manager commands, 4-7

standby databases

about creating using RMAN, 13-2

backing up using RMAN, 9-18, 9-23

guidelines for backing up logs, 9-21

interpreting the RC_ARCHIVED_LOG view, 9-20

overview, 9-18

restrictions, 9-19

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-14, 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

naming online redo logs using RMAN, 13-8

preparing using RMAN, 13-2

SET AUXNAME command, 13-9

SET NEWNAME command, 13-8, 13-9

starting RMAN and standby instance, 13-11

starting RMAN

without connecting to a database, 2-4

stored scripts

creating RMAN, 16-16

deleting, 16-18

displaying, 7-7

displaying RMAN, 17-21

executing, 16-17

executing RMAN, 16-17

managing, 16-16

printing, 17-21

Recovery Manager, 4-9

replacing, 16-17

SYSDBA option

implicitly assumed for RMAN connect to target, 2-3

tablespace backups

using RMAN, 9-5, 9-6, 9-24, 9-25, 9-26

tablespace point-in-time recovery

using RMAN, 6-8

basic steps, 11-2

introduction, 11-2

performing, 11-10

planning, 11-4

planning for, 11-4

preparing the auxiliary instance, 11-8

recovery sets containing whole tables, 11-6

resolving inconsistencies, 11-6

restrictions, 11-5

specifying filenames, 11-14

terminology, 11-3

why perform, 11-2

without recovery catalog, 11-5

tablespaces

backups using RMAN, 9-5

excluding from RMAN backups, 8-24

read-only

backing up, 9-32

recovering accessible

when database is open, 10-8

tags, 5-62

target database

definition, 1-6

terminating RMAN commands, 15-12

test databases, creating, 6-12

test disk API, 8-5

testing RMAN

backups, 5-65, 9-26

with media management API, 15-9

with media manager, 4-17

time parameters

setting for Recovery Manager use, 8-26

trace files

and RMAN, 15-3

TS_PITR_CHECK view, 11-7

TSPITR. See tablespace point-in-time recovery

tuning

Recovery Manager

V$ views, 17-23

UNAVAILABLE option

of CHANGE, 7-15, 18-12

UNCATALOG option

deleting repository records, 18-17

of CHANGE, 18-17

unregistering a database from the recovery catalog, 16-8

upgrading the recovery catalog, 16-26

user-managed backups

cataloging, 18-15

utilities

operating system, using to make copies, 9-43

V$ARCHIVED_LOG view, 6-7

V$BACKUP_CORRUPTION view, 5-45, 10-37

V$COPY_CORRUPTION view, 10-37

V$LONGOPS view, 5-45

V$PROCESS view, 17-23

V$PROXY_DATAFILE view, 5-14

V$SESSION view, 17-23

V$SESSION_LONGOPS view, 17-23

V$SESSION_WAIT view, 17-23

validating

backups, 9-26

validation of restore, 10-38

views

RC_ARCHIVED_LOG, 9-20

recovery catalog, 17-29

TS_PITR_CHECK, 11-7

whole database backups

using RMAN, 9-5

Index

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

T

U

V

W