Oracle RMAN 11g Backup and Recovery (193 page)

350–351

database, 216

rman command, 76

restore operations

case studies.
See
case studies,

RMAN command line, 117, 297

memory buffers on, 49

RMAN recovery

RMAN configuration

using Data Protector GUI,

controlling overall impact of

in ARCHIVELOG mode.

185–187

operations, 453–454

See
ARCHIVELOG mode,

restore points

Data Guard and.
See
Data Guard

configuring database in

backup command options, 238

and RMAN

database security
, 81–82

managing backups in OEM, 342

Data Protector, configuring

database user
, 80–81

recovery using, 349

backup, 179–183

Fault Diagnosability

restore preview command, 280,

Data Protector, integrating with

Infrastructure, 73–75

367–369

Oracle, 174–176

other considerations, 99

restore spfile command, 271

Data Protector, running backup of

RMAN command line,

restore spfile from autobackup

integrated Oracle database,

76–80

command, 269

184–185

setting CONTROL_FILE_

restoreCommands parameter syntax

deleting expired backups,

RECORD_KEEP_TIME

diagram, run command, 601

167–168

parameter
, 82–83

restoreObject parameter syntax

deploying backup to AWS S3,

summary of tasks, 98

diagram, restore command, 598

145–148

testing process, 630–631

restoreSpecOperand parameter syntax

enhancing with VERITAS

RMAN configuration, default settings,

diagram, restore command, 598

NetBackup.
See
NetBackup for

83–97

resync catalog command

Oracle

ar
chive log deletion policies, 97

manual resynchronizing recovery

and memory
, 13–14

automated backups of control file

catalog, 216

metadata, and Data Protector

and SPFILE, 91–92

recovery catalog views, 217

synchronization, 187

backup sets, 87–88

syntax details, 599

Oracle Secure Backup and, 115

channels, 85–87

resyncing, recovery catalog, 50,

performing backups using OSB

encryption, 95–97

216–217, 327

Cloud Module, 148–152

overview of, 83–84

retention policies

physical backup and recovery.

retention policies, 92–95

archive log deletion policies,

See
physical backup and

snapshot control file, 88

242–243

recovery

summary of tasks, 97

backup, 405–408

repository
, 208

using format string, 88–90

backup redundancy backup, 405

Script job, 331–334

using Shared Servers, 97

backup settings in RMAN, 321

scripts for UNIX, 622–623

various settings, 84–85

652
Oracle RMAN 11
g
: Backup and Recovery

RMAN subclause syntax details

specifying OSB Cloud Module

security

allocOperandList, 612–613

each time you allocate

configuring database in

archivelogRecordSpecifier,

channel, 148–152

ARCHIVELOG mode, 81–82

613–614

storing S3 as default SBT

NetBackup and, 170

completedT
imeSpec, 614

channel, 149

send command, 601–602

connectStringSpec, 614

tape backups, 108

server

datafileSpec, 614

SBT devices, 449

mounting split mirror volume on

deviceSpecifier
, 615

sbttest, 109–1
10

other
, 523–524

fileNameConversionSpec, 615

schedule backup daemon, OSB, 119

NetBackup software

forDBUniqueNameOption, 615

scheduled backups

installation, 156

foreignlogRecordSpecifier
, 615

creating RMAN script job,

processes, 12, 42

formatSpec, 616

333–334

RMAN duplication to remote,

keepOption, 616

customizing, 330–331

475–476, 484–487

listObjList, 616

getting started, 262

RMAN duplication to same,

maintQualifier
, 617

NetBackup, 163–165

474–475, 481–484

maintSpec, 617

RMAN backup on Data

server
-managed recovery (SMR), 34

obsOperandList, 617

Protector
, 183

SERVER=dedicated syntax, Shared

recordSpec, 618

RMAN backup on Data Protector-

Servers option, 97

tempfileSpec, 618

integrated Oracle database,

service backup daemon, OSB, 119

toDestSpec, 619

184–185

Session Manager, Data Protector
, 176

untilClause, 619

W
indows, 623

sessions, tracing RMAN, 460–462

RMAN syntax reference guide

schema objects, 9, 210–21
1, 440

set backup copies parameter, backup

command list, 562–563

schtasks utility, W
indows, 623

command, 245

command list syntax.
See

SCN (System Change Number)

set command

command list syntax details

database open process, 22–23

archivelog destination to

reserved words, 560–562

definition of, 9

parameter
, 350

specifier and operands list, 563

incomplete recoveries and,

backup options, 246–247

robot backup daemon, OSB, 119

346–348

during backups, 96

robotic interface, media management

information stored in control

establishing recovery tar
get, 347

server
, 104

file, 15

syntax details, 602–604

rollback segments, Flashback and,

performing Flashback Database,

set dbid command

379–380

396–397

recovering control file from

round-robin style of writing, log

recover database using, 30,

autobackup, 273–274

sequence numbers, 18–19

348–349

SPFILE recovery from autobackup

row history
, 380–384

recovering to previous

using RMAN, 269–271

run block, 233, 475

incarnation with recovery

unregistering database from

run command, 600–601

catalog, 354

recovery catalog, 212

scripts

set encryption on command, 96

S

adding to backup selection list,

set encryption on identified by

165–166

password command, 95

S3 (Simple Storage Service), Amazon

disk-only Oracle-suggested

set encryption on identified by

account signup, 147

backups, 328–329

password only command, 95

backup over Internet or from

editing RMAN, 184

set newname command, 280, 360

Amazon ECS, 145–146

getting started, 262–263

set newname for clone command, 364

backups using OSB Cloud

RMAN backups vs. backups,

set newname for database command,

Module, 148–152

226–227

283–285

defined, 144

RMAN for NetBackup, 168–169

set time command, 282

overview of, 145

RMAN Script job, 331–334

set until restore point

persistently storing as default SBT

RMAN scripts for UNIX,

command, 349

channel, 149

622–623

setParameter parameter syntax

RMAN backup to, 145–148

RMAN scripts for Windows,

diagram, duplicate command, 584

SBT API

621–622

setRmanOption parameter syntax

media management and, 107–108

RMAN stored, 418–421

diagram, set command, 603

Index
653

setRmanorRunOption parameter

capturing during backup, 246

performing Flashback Table from,

syntax diagram, set command, 604

configuring RMAN default

384–385

setRunOption parameter syntax

settings, 88

tuning backup and recovery
, 449

diagram, set command, 603

OEM limitations, 321

sql clone command, 363

SG (SCSI Generic) driver
, OSB, 122

RAC and, 503

sql command

SGA (System Global Area)

RMAN process, 54

creating restore points, 238

datablock backup in, 44

software, controlling database, 10–1
1

datafile recoveries, 292

defining memory allocations

source host credentials, database

syntax details, 606–607

in, 13

cloning in OEM, 343–344

tablespace recoveries, 292

definition of, 9

speed, split mirror backups and, 523

Standard Editions, RMAN included

granules, 8

SPFILE

with, 34–35

lar
ge pool in, 49

crosschecking backups, 401

standard policy domain, TSM, 192

overview of, 13

disk-only Oracle-suggested

standby database.
See also
Data Guard

RMAN memory utilization,

backups, 328

and RMAN

49–50

duplicating RAC database on

archive logs backups from,

testing Oracle installation/

single-node database, 510

499–500

configuration, 628

duplication to remote server using

backing up multinode RAC

shared pool, SGA, 13

disk backups, 485

database, 515

Shared Servers, 37, 97

duplication to same server using

creating single-node, 512–515

show all command, 204, 221–222

disk backups, 482

datafile backups from, 499

show command, 604–605

getting started with your database

Oracle sync and split and,

show parameter command, 72–73

backup, 261

236–237, 526–527

shutdown abort command, 11, 23

listing backups of, 434–435

overview of, 492

shutdown command

recovery catalog views for
, 219

primary database vs., 494

offline RMAN backups, 23, 229,

RMAN automated backups of,

taking backups from, 498–499

231–232

91–92

using Flashback Database for

overview of, 11

RMAN process from start to

reinstantiation, 500

shut down database, 23

finish, 55

using RMAN to create, 492–497

syntax details, 606

SPFILE, restoring, 269–273

start with option, catalog

shutdown immediate command, 11,

overview of, 269

command, 418

23, 278

recovery from autobackup using

startup command

shutdown normal command, 294–295

RMAN, 269–271

derivatives of, 10–1
1

shutdown, of database, 23

recovery from complete database

start database, 21–22

shutdown transactional command, 11

loss (ARCHIVELOG),

syntax details, 607

SID, automated TSPITR, 359

538–539, 541

startup for
ce command, 11

Simple Storage Service.
See
S3 (Simple

recovery from complete database

startup mount command

Storage Service), Amazon

loss (NOARCHIVELOG), 535

ARCHIVELOG mode full

since time option, backup command,

recovery from specific backup

recovery
, 29

244–245

set, 271–272

defined, 10

sizeSpec parameter syntax diagram

recovery when using recovery

loss of current online redo log

backup command, 571

catalog, 272

group, 296

duplicate command, 586

with restore command, 280

offline RMAN backups,

recover command, 593

restoring backed up SPFILE with