Oracle RMAN 11g Backup and Recovery (190 page)

list expired backup

recovery from complete database

recovery catalog, 214–216

command, 430

loss (ARCHIVELOG) without

RMAN stored scripts, 418–421

list failure command, 297–299

recovery file, 539

validation of RMAN backups,

list incarnation command,

recovery from loss of unarchived

404–405

353–354, 355, 424–425

online redo log, 545

maintenanceCommands parameter

list incarnation of database

log switch operation, 9, 15, 17

syntax diagram, run command, 600

command, 354–356

log writer process.
See
LGWR (log

maintQualifier parameter syntax

list recoverable command, 429

writer) process

diagram, list command, 590

syntax details, 589–590

LOG_ARCHIVE_DEST_ parameter,

maintQualifier subclause, 617

listBackupOption parameter syntax

7–8, 323

maintSpec parameter syntax diagram

diagram, list command, 590

LOG_ARCHIVE_DEST_n parameter,

change command, 573

listener.ora file

62–63, 67, 72, 505

crosscheck command, 580–581

creating single-node standby

LOG_ARCHIVE_FORMAT parameter,

delete command, 582

database, 514–515

63–64, 323, 547

maintSpec subclause, 617

creating standby database using

LOG_ARCHIVE_MAX_PROCESSES

MANAGED RECOVERY
mode, 500

RMAN, 497

parameter
, 63

management

duplication of RAC database,

LOG_ARCHIVE_START parameter
, 63

media.
See
media management

511–512

LOG_ARCHIVE_STATE_n

OEM backup, 341–343

duplication to remote server
, 486

parameter
, 63

management class, TSM, 192, 193

duplication to same server
, 483

logfile clause, 494–495

manual backup location, retention

preparing for RMAN duplication,

logical backup and recovery
, 26

policy maintenance, 405

479–481

logical corruption, checking, 404

master server, NetBackup installation

listObjectSpec parameter syntax

logical errors, 378.
See also
Flashback

on, 156

diagram, list command, 590

Technology

maxcorrupt parameter, backup

listObjList subclause, RMAN

logical standby databases, 492

command, 245, 369–370

syntax, 616

logical structures, 21

maxdays parameter, restore command,

load balancing, 505

login trigger, tracing RMAN

270–271, 273–275

loadsbt.exe, 110

sessions, 461

maxnummp=2, TDPO for Oracle, 195

location

LogMiner utility
, 255, 323

maxopenfiles parameter
, 86,

changing backup, 481

logs

452–453

OEM unable to modify snapshot

backup set retention policy

maxpiecesize parameter
, 86–87, 240

control file, 321

options, 240

maxseq parameter, restore command,

restoring archived redo logs to

flashback, 16, 393–394

270–271, 273–275

other
, 350

NetBackup, 169–170

maxsetsize parameter
, 87, 239

restoring database files to other,

logSpec parameter syntax diagram,

Media Agent, Data Protector

283–284

duplicate command, 585

General, 176

restoring files in OEM to

LONG_WAITS/IO_COUNTS

media management, 101–1
11

other
, 339

view
, 460

backup to tape, 108–109

RMAN duplication

LOW compression type, 237

errors, 110–1
11

considerations, 474–479

Media Management Library
, 107

log file considerations

M

media manager catalog, 103–104

duplicate for standby

Oracle testing process, 629

command, 494

maintenance, RMAN

other software components, 104

RMAN duplication, 473–474

backup retention policies, 405–

overview of, 102

log sequence number

408

restore from tape, 109

completing failed duplication

cataloging other backups in

RMAN and media manager
, 103

manually
, 547

RMAN, 417–418

SBT API, 107–108

definition of, 9

change command, 408–416

tape backups, 102–103

Index
645

testing tape channels with Oracle

migration, recovery catalog, 215

needBackupOption parameter syntax

default SBT interface, 105–106

minimize load parameter, backup

diagram, report command, 595

using sbttest and loadsbt.exe,

command, 453–454

Net connections, RMAN, RAC

109–1
10

minimize time parameter, backup

and, 505

Media Management Library.
See
MML

command, 239

Net Service Name W
izard, 481

(Media Management Library)

miscellaneousCommands parameter

NetBackup Administrator’
s Guide, 168

media management server

syntax diagram, run command, 601

NetBackup for Oracle, 153–171

defined, 103

MML (Media Management Library)

ar
chitecture, 159

duplication to different server

backup with Data Protector
, 185

cost justification, 171

using tape backups, 478

Data Protector Oracle Integration

defining backup selection,

restore operations in RAC

and, 176, 178

165–166

environment, 508

defined, 103

defining policy clients, 166–167

media manager

duplication to different server

installation, 155–157

catalog, 103–104

using tape backups, 478

key features, 154

other software components, 104

interfacing with, 107

linking Oracle to NetBackup

RMAN and, 103–104

not testing for production

Media Manager
, 157–159

media recovery

backups, 106

managing expired backup

during database open process,

OSB Cloud Module as.
See
OSB

images, 167–168

23, 553–555

(Oracle Secure Backup) Cloud

necessary components, 155

duplicate for standby command

Module

Netbackup logs, 169–170

and, 495

overview of, 105–107

policy configuration, 160–163

OEM Recovery Settings page, 323

recovery, recovery catalog and,

RMAN sample scripts, 168–169

overview of, 267

268–269, 537, 540

schedule configuration, 163–165

in physical standby database, 492

tuning, 454

security best practices, 170

in RAC environment, 508–509

monitor class, OSB user rights, 122

storage/media device

RMAN block, 47

monitoring and reporting on RMAN,

configuration, 155

media servers, 117, 156

423–443

troubleshooting, 169

MEDIUM compression type, 237

data dictionary views, 441–442

network

memory

list command.
See
list

backing up parameter files, 30

building memory buffers, 47–49

commands, RMAN

RMAN duplication and, 479–481

duplicate for standby command

report command, 438–441

Network Data Management Protocol

and, 494

RMAN backup status, 227–228

(NDMP), 119, 121

OEM requirements, 629

MTS (Multi-Threaded Server).
See

network topology, RMAN backups

PGA
vs. SGA, 49–50

Shared Servers

with auxiliary database, 52

recovery from complete database

MTTR (mean time to recover),

overview of, 36

loss (ARCHIVELOG) and,

322–323

running locally from target

538, 540

multiplexing

database, 37–39

RMAN duplication to remote

input memory buffers and, 48

running remotely
, 36–37

server and, 476

performance tuning RMAN,

using recovery catalog, 50–51

RMAN duplication to same server

452–453

NFS (network file system)-mounted

and, 474

redo log, 9, 18

directory

test environment and, 628

multisection backups, 49, 236

archive log backups in RAC,

tuning usage of, 448–449

505–506

memory buffers

N

not installing NetBackup software

problems with read/write

on, 156

operations, 455

namespaces, OSB users, 120

RMAN duplication to remote

RMAN process and, 47–49, 55

naming conventions

server
, 477–478

memory-to-memory writes, datablock

block change tracking file,

NLS_DATE_FORMAT environment

backups, 44–45

255–256

variable, testing RMAN

mer
ged incremental backups, 259–260

recovery catalog views, 217

configuration, 630

merged multiple recovery

TDPO_NODE, 203

NOARCHIVELOG mode

catalogs, 214

NDMP (Network Data Management

ARCHIVELOG mode, switching

metadata, 39, 208

Protocol), 119, 121

between, 71

646
Oracle RMAN 11
g
: Backup and Recovery

NOARCHIVELOG mode
(continued)

preserving lost, in tablespace

offline (cold) backups, RMAN

ARCHIVELOG mode vs., 20–21

recovery
, 358

using default settings, 229–230

case studies, recovery from

restoring Oracle database, 186

without using configured defaults,

complete database loss,

TSM server system, 190–192

232–235

534–537

obsolete backups, reports, 440–441

OFFLINE status, database datafiles, 14

committing data change, 25

obsOperandList subclause, 617

OMS (Oracle Management Service),

getting started, 262

obtool, OSB, 117

312–313

incremental backups in, 255

OCFS (Oracle Cluster File

online (hot) backups, 246–247

offline dropping of datafile in, 14

System), 502

ar
chived redo log, 250–251

performing physical backup

ODBCA (Oracle Database

backup set, 252

in, 27

Configuration Assistant), 71–72

consistent vs. inconsistent state

recoveries, 28–29

OEM client install, Oracle Client

and, 23

recovery after restoring control

CD, 311

control and parameter files,

file, 277

OEM (Oracle Enterprise Manager)

251–252

restore and recovery of database

accessing OSB with, 116

database, 247–249

in, 281–287

backup management and

datafile, 250

tablespace or datafile backups

reporting, 341–343

defined, 5

in, 250

configuring backup settings,

flash recovery area and, 253

nocatalog command, 209

318–322

limitations of, 144

node affinity
, RAC datafiles, 504

configuring for OSB usage,

overview of, 247

node utilization, CRS, 504

129–132

performing with Data

noexclude parameter, backup

configuring recovery catalogs,

Protector
, 175

command, 243

325–327

restoring backed up SPFILE, 272

nologs, backup set retention

configuring recovery settings,

sync and split technology and,

policy
, 240

322–325

522–523

NOMOUNT mode

database backups from.
See

tablespace, 27, 249–250

creating standby database, 493

database backups, from OEM