Oracle RMAN 11g Backup and Recovery (186 page)

restoring records to control file,

command, 255

architectures

277–278

archivelogRecordSpecifier subclause,

backup challenges of RAC,

restoring specific, 350

613–614

502–503

restoring with recover

archiving tables, Flashback Data

Database Control, 313–314

command, 281

Ar
chive, 397–398

duplication, 468–470

restoring with restore

archlogRange parameter syntax

Grid Control, 312–313

command, 280

diagram, 614

NetBackup, 159

RMAN duplication process, 472

as backupset parameter, backup

Oracle and Data Protector

sync and split technology for,

command, 237

integration, 175

522–523

as compressed backupset

Oracle backup and recovery.

archivelog destination to parameter, set

parameter
, 237

See
backup and recovery

command, 350

ASH (Active Session History),

architecture

ARCHIVELOG mode

V$ACTIVE_SESSION_HISTORY

RMAN.
See
RMAN architecture

ar
chived redo logs in, 7–8

view
, 457

ar
chival backups, 240–241

case studies in recovery
, 537–

ASM (Automatic Storage Management)

ar
chive copy group, TSM, 192

542, 550–551

archive log backups in RAC,

archive log deletion policies

committing data change, 25

506–507

configuring RMAN default

creating image copy of archived

FRA
and, 56, 70

settings, 97

redo log, 255

overview of, 16

OEM limitations, 321

database recoveries in, 287–291

restore operations in RAC,

overview of, 242–243

database recovery after restoring

507–508

archived redo logs

control file, 277

sharing files across multiple

backup sets, modifying retention

disk-only Oracle-suggested

computers, 502

policy for
, 240

backups in, 328

storing block change tracking file

backups from standby database,

full recovery in, 29

in, 256

499–500

incremental backups in, 255

testing Oracle installation/

backups in ARCHIVELOG mode,

NOARCHIVELOG mode vs.,

configuration, 629

27–28

20–21

asynchronous backup I/O, 447,

backups in RAC, 504–507

online backups in, 247

457–459

Index
635

at sign (@) command, 563

B

checking database for errors, 243

atClause parameter syntax diagram, 596

compression, 236–237

attributes, NetBackup policy
, 161–163

BACKGROUND_DUMP_DEST

creating restore points, 238

auditing tables, Flashback Data

database parameter, alert log

forcing backup of read-only

Ar
chive, 397–398

directory
, 7

datafiles, 244

autobackup command

backup and recovery architecture

limiting backup impacts,

configure controlfile from, 91

ARCHIVELOG vs.

238–239

restore control file from, 273–276

NOARCHIVELOG modes,

limiting size of backup set,

restore spfile from, 269–271

20–21

239–240

autoBackupOptList parameter syntax

controlling database software,

making copies of backups, 245

diagram, restore command, 598

10–1
1

modifying retention policy for

autolocate feature, RMAN, 505

database physical components,

backup set, 240–242

Automatic Backup Schedule,

14–16

multisection backups, 236

NetBackup, 164–165

high availability
, 5

offline RMAN backups without

automatic checkpoint tuning, 323

logical backup and recovery
, 26

using configured defaults, 235

Automatic Diagnostic Destination

Oracle database, 14–16

overriding configure exclude

directory
, 461

Oracle logical structures, 21

command, 243

Automatic Storage Management.

Oracle memory and RMAN,

with set command, 246–247

See
ASM (Automatic Storage

13–14

skipping offline, inaccessible or

Management)

Oracle processes, 11–12

read-only datafiles, 243–244

auxiliary channel configuration,

Oracle redo logs, 16–20

using standby database, 498–499

RMAN duplication, 469–470

Oracle terminology
, 7–9

validate parameter
, 369

auxiliary command, 79, 363

other Oracle components, 31–32

backup command, syntax details,

auxiliary database

overview of, 5

566–571

as clone database, 493–494

physical backup and recovery,

backup control file command, 254

configuring parameter file for

26–31

backup control file, defined, 8

manual TSPITR, 361–362

planning, 7

backup copy group, TSM, 192

duplicating RAC database on

requirements gathering, 6–7

backup current controlfile for standby

single-node database, 510

shutdown of database, 23

command, 493

duplicating to remote server using

startup of database, 21–22

backup database commands

disk backups, 485

using database and internals,

backing up datafiles based on last

duplicating to same server using

23–26

backup time, 245

disk backups, 482

using OEM.
See
OEM (Oracle

datafile backups in RAC,

overview of, 51–52

Enterprise Manager)

503–504

RMAN compatibility and, 54, 79

backup and recovery strategy,

getting started, 262

auxiliary destination, TSPITR, 357, 359

tuning, 450

offline RMAN backups,

auxiliary instance, TSPITR, 357,

backup archivelog all command,

229–230, 235

359–363

248, 250

optimization, 88

auxiliary set, TSPITR, 357

backup ar
chivelog command, 88,

backup datafile command, 250, 450

AVAILABLE status, crosschecking

244, 250–251

backup pieces, 233

backups, 400

backup as compressed backupset

backup recovery area command, 66,

AWS (Amazon Web Services)

database command, 231

253, 508

EC2 and EBS, 145

backup as copy command, 253–254

backup redundancy backup retention

establishing account with, 147

backup backupset command, 252, 481

policy
, 405

Oracle and
Amazon cloud, 145

backup command options, 236–247

backup retention policies, 405–408

OSB Cloud Module and, 144

archive log deletion policies,

Backup Scheduling W
izard, 330–331

RMAN backup to S3, deploying,

242–243

backup selection list, NetBackup,

145–148

assigning tags to backups, 238

165–166

Simple Storage Service, 138, 145

backing up datafiles based on last backup sets

storing S3 as default SBT

backup time, 244–245

configuring backup in

channel, 149

backing up to specific device

RMAN, 321

understanding cloud computing,

type, 240

crosschecking backups, 400–403

144–145

capturing elusive control file, 246

defined, 233

636
Oracle RMAN 11
g
: Backup and Recovery

backup sets
(continued)

BACKUP_TAPE_IO_SLAVES parameter,

using RMAN duplication to create

limiting size of, 239–240

447, 449

historical subset of target

modifying retention policy,

backupTypeSpec parameter syntax

database, 548–550

240–242

diagram, backup command, 570

catalog backupset command, 481

OEM settings, 319–320

base backup, incremental, 256–257

catalog command

online backups, 252

begin backup command, 522

adding RMAN backups to

recovering control file from, 276

binary compression, block-level

recovery catalog, 212

recovering SPFILE from specific,

backups, 46

cataloging other backups in

271–272

blank errors, media management, 111

RMAN, 417–418

recovery catalog views for
, 219

block change tracking file (BCTF),

defined, 209

restoring control file from

255–256, 320

recovering deleted backup, 416

RMAN, 186

block-level backups, RMAN,

registering split mirror copies with

RMAN default settings

44–47, 55

RMAN, 524–525

configuration, 87–88

block media recovery
, 47

restoring RMAN-related records

viewing corruption, 352

block media recovery (BMR), 351–353

to control file, 277–278

Backup Settings page, OEM, 319

blockObject parameter syntax diagram

syntax details, 572

backup spfile command, 251

recover command, 592

catalog database, testing RMAN, 630

backup tablespace command,

validate command, 612

catalog datafilecopy command, 481

250, 450

blockrecover command, 351–353

catalog, media manager
, 103–104

backup throttling, and OEM, 321

blocks, 8

catalog start with command, 212, 278

backup, using media manager for tape,
BMR (block media recovery), 351–353

catproc.sql script, 44

103–104

broken mirror backups, 518–520

Cell Manager, Data Protector,

backup validate command, 340, 404

byte ordering, 372–373

176–177, 179–180

backup validate database command,

central agent, Grid Control

351–352

C

ar
chitecture, 312

backupCommands parameter syntax

CF Block Integrity Check, OEM, 336

diagram, run command, 600

cancel-based recovery
, 30–31, 349

cfauConf parameter syntax diagram,

backupConf parameter syntax

case studies, RMAN recovery

configure command, 576

diagram, configure command, 576

from complete database loss

change backuppiece uncatalog

backupOperand parameter syntax

(ARCHIVELOG), 537–542

command, 413, 415

diagram, backup command, 567

from complete database loss

change command

backups, RMAN, 225–238

(NOARCHIVELOG), 534–537

overview of, 408–413

backup command.
See
backup

completing failed duplication

recovering older control file

command options

manually
, 547–548

backups, 275

compatibility issues, 227–228

considerations, 532–533

retention policy maintenance

configuring settings in OEM,

from loss of SYSTEM

using FRA, 407–408

318–322

tablespace, 542

syntax details, 573–574

copies, 253–255

loss of unarchived online redo

using, 413–416

getting started, 261–263

log, 544–545

change directory command, 123

incremental, 255–261

from lost datafile (ARCHIVELOG)

change failure command, 297,

managing in OEM, 341–343

using image copy in FRA,

301–302

monitoring status of, 228–229

550–551

change vectors, within redo logs, 15

offline, 229–235

online from loss of datafile or

changeFailure parameter syntax

online, 247–253

tablespace, 543

diagram, change command, 574

scripted backups vs., 226–227