Oracle RMAN 11g Backup and Recovery (187 page)

overview of, 533–534

channel allocation

taking from split mirror
, 525–526

from running production datafile

interfacing with MML, 107–109

verifying restorability of database,

out of FRA, 552–553

recovery from complete database

366–371

through resetlogs, 545–546

loss (ARCHIVELOG), 538–539,

backupSpec parameter syntax

using Flashback Database/media

541–542

diagram, backup command, 568

recovery to open database with

recovery from complete database

backupSpecOperand parameter syntax

resetlogs, 553–555

loss (NOARCHIVELOG), 535

diagram, backup command, 569

Index
637

RMAN backup with

clustered file systems, 502

replace script command, 595

automatic, 204

cmdfile parameter, RMAN stored

report command, 595–596

to tape, using SBT interface,

scripts, 418

reset database command,

106–107

cold backup mode.
See
offline (cold)

596–597

channels

backups

restore command, 597–599

configuring RMAN default

command-line interface (obtool),

resync catalog command, 599

settings, 84–87

OSB, 117

revoke command, 599–600

database backups and, 261

command line, RMAN configuration

RMAN subclauses.
See
RMAN

datablock backups and, 44–45

client compatibility
, 79

subclause syntax details

offline RMAN backups and,

connect command, 79

run command, 600–601

233–235

connecting via, 76–78

send command, 601–602

RMAN process and, 42–43, 55

exiting RMAN client, 80

set command, 602–604

tuning backup and recovery

running RMAN backup of Data

show command, 604–605

hardware, 447

Protector-integrated

shutdown command, 606

tuning with parallelized, 451

database, 185

spool command, 606

check logical option, backup

command list syntax details

SQL
command, 606–607

command, 243, 245

@ command, 563

startup command, 607

check logical option, validate

@@ command, 564

switch command, 607–608

command, 404

advise failure command, 564

transport tablespace command,

check logical parameter, restore

allocate channel command,

608–609

command, 369–370

564–565

unregister database command, 609

check readonly parameter, restore

allocate channel for maintenance

upgrade catalog command, 610

command, 350

command, 565

validate command, 610–612

checkers, OEM, 335–337

alter database command, 566

comments, storing script-related, 419

checkpoints

backup command, 566–571

commit command, 25

database open process, 22

catalog command, 572

commit vector
, 25

defined, 8

change command, 573–574

compatibility issues, RMAN

overview of, 26

configure command, 574–578

auxiliary databases, 53

as required process, 12

connect command, 578

catalog databases and schema, 53

storing in control file, 15

convert command, 578–579

client, 79

checksyntax parameter
, RMAN CLI, 78

create catalog command, 580

cross-platform transportable

cir
cular reuse records, 40

create script command, 580

tablespaces, 372

classes, OSB, 121–122

crosscheck command, 580–581

planning backups, 227–228

client

delete command, 581–582

tar
get and RMAN executable, 53

defined, 117

delete script command, 582

completedT
imeSpec subclause, 614

exiting RMAN, 80

drop catalog command, 582–583

components

RMAN compatibility

drop database command, 583

configuring RMAN backups on

guidelines, 79

duplicate command, 583–586

Data Protector
, 181–182

TSM, 190, 192–194

execute command, 586

NetBackup, 155

client (database) servers, NetBackup,

exit command, 586–587

Oracle and Data Protector

156–157, 166–167

flashback database

configuration, 176–177

cloned database.
See also
duplication,

command, 587

Oracle and Data Protector

RMAN

grant command, 587–588

integration, 174–176

from OEM, 311

host command, 588

Oracle Secure Backup,

performing manual TSPITR,

import catalog command, 588

117–1
18, 125

363–365

list command, 589–590

compression

testing RMAN configuration, 630

print script command, 590–591

as backup command option,

cloud computing, 144–145

quit command, 591

236–237

Cloud Module.
See
OSB (Oracle

recover command, 591–594

configuring backup sets for disk

Secure Backup) Cloud Module

register database command, 594

backups, 319–320

Cluster Ready Services (CRS), RAC

release channel command, 594

fast database backups with, 116

integration, 504

repair failure command, 594

RMAN, 86

638
Oracle RMAN 11
g
: Backup and Recovery

configure auxname command, 360

using RMAN commands, 76–78

CONTROL FILE_RECORD_KEEP_TIME

configure channel device type clear

connectStringSpec subclause, 614

parameter
, 40, 82–83

command, 85

consistent vs. inconsistent state

controlfilecopy parameter, backup

configure channel device type

backups and, 23

command, 251–252

command, 84

definition of, 8

CONTROL_FILE_RECORD_KEEP_

configure command

restore, recovery and, 266–267

TIME parameter
, 82–83

archive log deletion policies,

control file

convert command, 578–579

242–243

capturing during backup, 246

convert database command, 372–373

backup redundancy backup

crosschecking backup, 401

convert datafile command, 371–374

retention policy
, 405

danger of re-creating, 41

convert tablespace command,

compression, 237

database recovery after restoring,

371–372

datafile location for

276–278

convertOptionList parameter syntax

duplication, 475

definition of, 8

diagram, convert command, 579

getting started, 261

disk-only Oracle-suggested

copies, image.
See
image copies

limiting size of backup set, 240

backups, 328

copies parameter, backup

RMAN script for calling

getting started, 261

command, 245

NetBackup, 169

listing backups of, 434–435

copy command, 255

syntax details, 574–578

listing copies of, 437–438

copy groups, 192, 197

configure command, RMAN default

making image copies of, 254

copyOfSpec parameter syntax diagram

settings

online backups, 251–252

backup command, 570

ar
chive log deletion policies, 97

Oracle database backup with

validate command, 611

backup set-related settings, 87–88

Cloud Module, 138–140

corruption

channel default settings, 85–87

problems with read/write

checking database blocks for

default automated backups of

operations, 455

physical, 245

control file and SPFILE, 91–92

record reuse, 39–40

recovery catalog views for,

default levels of encryption,

recovering from autobackup,

218–220

95–97

273–279

validate command checking, 404

default retention policies, 92–95

recovering from backup set, 276

viewing all database, 351–353

overview of, 83–84

recovering from recovery

corruption list restore parameter,

snapshot control file settings, 88

catalog, 276

blockrecover command, 352–353

summary of tasks, 97

recovery catalog views for,

cost

using format string, 88–90

218, 219

justifying VERITAS NetBackup for

using Shared Servers, 97

recovery from complete database

Oracle, 171

various settings, 83–85

loss (ARCHIVELOG mode),

Oracle Cloud Backup

configure controlfile autobackup

539, 541

advantages, 146

command, 91

recovery from complete database

tape vs. disk backups, 103

configure exclude command,

loss (NOARCHIVELOG mode),

using cheap test environment,

overriding, 243

281, 535–537

627–628

Configure Oracle window
, 181

restoring online, 278

crash

configure retention policy clear

restoring using Data Protector

during database open process, 23

command, 95

GUI, 185–186

shutdown abort command

configure retention policy command,

restoring with restore

simulating, 23

92–95

command, 280

create catalog command, 210–21
1,

configure retention policy command,

RMAN automated backups of,

325, 580

FRA, 64

91–92

create control file command,

configure retention policy to none

RMAN backup or recovery

277, 281

command, 95

role, 39

create restore point command, 238

configure snapshot controlfile

RMAN duplication, 472

create script command, 263,

command, 41

RMAN process from start to

419, 580

connect command, RMAN, 79, 578

finish, 54

Credentials tab, RMAN Script job, 333

connections

snapshot.
See
snapshot control file

cross-checking RMAN backups,

RMAN, RAC and Net, 505

standby
, 493, 495–496

400–403

testing Tivoli Data Protection for

sync and split technology
, 522

cross-platform database movement,

Oracle, 198

views, 442

and RMAN, 371–374

Index
639

crosscheck command

overview of, 492

startup of, 10, 21–22

allocating space in FRA, 66

recovery catalog and, 209

using recover command, 281

crosschecking backups, 400–402

standby database and, 492–493

Database Backup Storage Selectors

deleting expired backups, 168

taking backups from standby

link, OSB, 128

getting started, 262

database, 498–499

database backups, from OEM,

syntax details, 580–581

using Flashback Database for

327–334

troubleshooting recovery/restore,

standby database

creating RMAN script job,

374–375

reinstantiation, 500

332–334

using, 402–403

data loss

Oracle-suggested backup strategy,

CRS (Cluster Ready Services), RAC

active online redo log, 18

327–330

integration, 504

quantifying cost of, 6

RMAN script job vs. scheduled

cumulative backups, 258

Data Manipulation Language (DML),

backup wizard, 331

current controlfile parameter, backup

24–25

scheduling customized backup,

command, 251

Data Protector
, 173–187