Oracle RMAN 11g Backup and Recovery (191 page)

online redo log groups, 17–19

duplicating RAC database on

database cloning from, 343–344

online redo logs

single-node database, 511

Database Control, 313–318

ARCHIVELOG mode physical

noncir
cular reuse records, 40

functionality of, 308

backups, 27–28

nonredo parameter, recover

Grid Control, 311–313

case study, recovery from loss of

command, 281

Oracle database/file system

unar
chived, 544–545

noprompt parameter

backup, 138

checks occurring during

change command,

overview of, 308–310

startup, 267

301–302

performing Flashback Table,

commit command and, 25

delete command, 416

385–387

as database physical component,

drop database command, 421

performing Flashback Versions

14–15

not backed up option, backup

Query
, 380–384

definition of, 9

command, 244, 251

performing recovery
, 334–341

management of, 19–20

notBackedUpSpec parameter syntax

recovery catalog views, 222–223

multiplexing, 18

diagram, backup command, 571

testing, 629

overview of, 17

nslookup command, 629

using Cloud Module for OSB

recovering from loss of,

NULL
data block compression, 45,

backups, 140

293–297

235–236

utilizing Flashback Transaction

ONLINE status, database datafiles, 14

from, 387–389

opening database, 267

O

offline (cold) backups

operating systems

consistent vs. inconsistent state

OSB accounts, 120–121

OAS (Oracle Application Server), and

during, 23

RMAN test environment, 627

Grid Control, 311

defined, 5

troubleshooting TSM backups,

ob2rman.pl, 185, 186

limitations of, 144

204–206

objects

performing with Data

operator class, OSB user rights, 122

creating recovery catalog schema,

Protector
, 175

optimization, backup

210–21
1

testing RMAN configuration, 630

enabling, 88

Index
647

forcing backup of read-only

installing and configuring Grid

limitations of conventional

datafiles, 244

Control, 313

backups, 144

using OSB Cloud Module,

RMAN process, 54

performing backups, 148–152

150–152

running RMAN locally from target

understanding cloud computing,

ORA-19511 errors, media

database, 37–39

144–145

management, 111

testing Oracle installation/

OSB (Oracle Secure Backup)

ORA-27206 errors, media

configuration, 628–629

Express, 115

management, 111

ORACLE_SID, 269

output buffers, tape backups, 108

Oracle

orapwd utility
, 81–82

output memory buffers, 47–48

architecture.
See
backup and

OSB (Oracle Secure Backup)

overriding, configure exclude

recovery architecture

administrative data, 119–120

command, 243

database physical components,

backup encryption, 115–1
16

14–16

command-line interface

P

establishing account with, 147

(obtool), 117

support for recovery
, 533

components, 117–1
18

packages

sync and split.
See
sync and split

daemons, 119

recovery catalog, 50–51

technology

downloading and installing,

SYS, 43–44

testing installation/configuration,

147–148

parameter files, online backups,

628–629

fast database backup

251–252

Oracle 10g RMAN Backup &

compression, 116

Parameters tab, RMAN Script job, 333

Recovery
, 493

features of, 114–1
15

password file

Oracle 9i RMAN Backup &

host access modes, 119

building for RMAN duplication,

Recovery
, 626

installing and configuring,

479–480, 483, 486

Oracle
Advanced Compression, 46

122–132

configuring database for
, 81–82

Oracle Application Server (OAS), and

interfaces, 116–1
17

configuring TDPO for Oracle,

Grid Control, 311

media management solution, 102

197–198

oracle class, OSB user rights, 122

NDMP
hosts, 121

creating, 81–82

Oracle Client CD, 311

operating system accounts,

creating single-node standby

Oracle Cluster File System

120–121

database from RAC, 514

(OCFS), 502

Oracle database/file system

creating standby database with

Oracle Database 10g High Availability

backup, 133–137

RMAN, 497

with RAC, Flashback, & Data Guard

OSB Express vs., 115

and database privileges, 36

(Hart), 5, 628

rights and classes, 121–122

duplicating RAC database on

Oracle Database Configuration

and RMAN, 115

single-node database, 511

Assistant (ODBCA), 71–72

users and classes, 120

running RMAN locally from target

Oracle Enterprise Manager.
See
OEM

W
eb tool, 117

database, 38

(Oracle Enterprise Manager)

OSB (Oracle Secure Backup) Cloud

password mode encryption, 95, 120

Oracle Enterprise Manager Grid

Module

performance gains, block-level

Control 10g Handbook (Oracle

defined, 116

backup, 46–47

Press), 310, 313

installing and using for OSB

performance tuning, RMAN, 445–462

Oracle Home, backing up, 30

backups, 138–140

before beginning, 446

Oracle Inventory
, backing up, 30

OSB (Oracle Secure Backup) Cloud

database, 448–450

Oracle Management Service (OMS),

Module, backups to Amazon Web

database-RMAN related issues,

312–313

Services, 143–152

454–456

Oracle Secure Backup.
See
OSB

advantages of, 146

hardware, 447–448

(Oracle Secure Backup)

Amazon cloud and Oracle, 145

MML layer
, 454

Oracle Standby Database, 492

Amazon EC2 and EBS, 145

RMAN settings, 451–454

Oracle T
otal Recall, 397–398

Amazon S3, 145

tracing RMAN sessions,

ORACLE_HOME

Amazon S3 backup over Internet

460–462

Database Control

or from
Amazon EC2, 145–146

what can be achieved, 446–447

ar
chitecture, 314

deploying RMAN backups to

performance tuning, RMAN views

duplication to same server, with

Amazon S3, 145–148

V$ACTIVE_SESSION_HISTORY

different, 475

licensing considerations, 152

view
, 457

648
Oracle RMAN 11
g
: Backup and Recovery

performance tuning, RMAN views

point-of-failure database recoveries,

creating single-node standby

(continued)

287–291

database from, 512–515

V$BACKUP_ASYNC_IO view,

policies

datafile backups, 503–504

457–460

OEM backup settings, 320–321

duplicating RAC database to

V$BACKUP_SYNC_IO view,

RMAN backup settings, 321

single-node system, 509–512

457–460

policies, NetBackup

overview of, 502

V$RMAN_BACKUP_JOB_DETAILS

defining NetBackup schedules,

restore and recovery challenges,

view
, 456

163–165

507–509

V$SESSION view
, 456

managing expired backup

storing block change tracking file

V$SESSION_LONGOPS

images, 167–168

in ASM for
, 256

view
, 456

NetBackup configuration,

unique backup challenges,

PGA (Private Global Area)

160–163

502–503

caution about, 13

policy domain, TSM, 192

RAID, 518–520

datablock backup in, 44

portability
, tape backups, 103

rate parameter

RMAN memory utilization,

A Practical Guide to Performance

channels, 86

49–50

T
uning & Diagnostics (Shee), 446

tuning RMAN down using, 453

physical backup and recovery

primary access mode, OSB, 119

raw partitions, archive log backups in

ARCHIVELOG mode full

primary database, 494, 498–500

RAC, 504

recovery
, 29

primary key
, backup set, 404–405

RC_ views, 217–222, 442

ARCHIVELOG mode physical

print script command, 420, 590–591

RC_ARCHIVED_LOG (V$ARCHIVED_

backups, 27–28

Private Global Area.
See
PGA (Private

LOG) view
, 217

ARCHIVELOG mode

Global Area)

RC_BACKUP_CONTROLFILE

recoveries, 29

privileges, RMAN and database, 35–36

(V$BACKUP_DATAFILE) view
, 218

ARCHIVELOG point-in-time

process monitor (PMON), 12

RC_BACKUP_CORRUPTION

recoveries, 30–31

processes

(V$BACKUP_CORRUPTION)

ARCHIVELOG tablespace and

changing data in database, 24–25

view
, 218

datafile recovery
, 29–30

database relationships and, 23–24

RC_BACKUP_DATAFILE (V$BACKUP_

flashback functionality
, 31

definition of, 9

DATAFILE) view
, 218

NOARCHIVELOG mode physical

five required Oracle, 11–12

RC_BACKUP_FILES (V$BACKUP_

backups, 27

optional, 12–13

FILES) view
, 218–219

NOARCHIVELOG mode

RMAN channel, 42

RC_BACKUP_PIECE (V$BACKUP_

recoveries, 28–29

RMAN server
, 42

PIECE) view
, 219

overview of, 26

user and server
, 12

RC_BACKUP_REDOLOG

physical components, Oracle

processor speed, test environment

(V$BACKUP_REDOLOG) view
, 219

database, 14–16

and, 627

RC_BACKUP_SET (V$BACKUP_SET)

physical corruption, checking

progress logs, NetBackup, 169–170

view
, 219

only
, 404

proxy backup daemon, OSB, 119

RC_BACKUP_SPFILE (V$BACKUP_

physical standby database, 492, 498

pur
ge command, Recycle Bin, 390

SPFILE) view
, 219

PITR (point-in-time recovery)

RC_CONTROLFILE_COPY

ARCHIVELOG mode, 30–31

Q

(V$DATAFILE_COPY) view
, 219

for auxiliary databases and

RC_COPY_CORRUPTION (V$COPY_

tablespaces, 51–52

quit command, 591

CORRUPTION) view
, 219

benefits of split mirror

RC_DATABASE (V$DATABASE)

backup, 523

R

view
, 220

with recover command, 281

RC_DATABASE_BLOCK_

tablespace.
See
TSPITR

RAC (Real Application Clusters),

CORRUPTION (V$DATABASE_

(tablespace point-in-time

501–516

BLOC_CORRUPTION) view
, 220

recovery)

ar
chive log backups, 504–507

RC_DATAFILE (V$DATAFILE)

user directed in OEM, 339

backing up multinode RAC

view
, 220

using restore points to define, 349

database, 515

RC_DATAFILE_COPY (V$DATAFILE_

plan, backup and recovery
, 7

checks occurring during

COPY) view
, 220

PMON (process monitor), 12

startup, 267

Index
649

RC_LOGFILE (V$LOG_HISTORY)

recover database noredo command,