Oracle RMAN 11g Backup and Recovery (189 page)

BOOK: Oracle RMAN 11g Backup and Recovery
5.98Mb size Format: txt, pdf, ePub

failover features

dsm.opt file, TDPO for Oracle, 197

EBS (Elastic Block Store), A
WS, 145

restore command, 281

dsm.sys file, TDPO for Oracle,

EC2 (Elastic Compute Cloud), AWS,

RMAN, RAC and Net

196–197

145–146

connections, 505

dual mode encryption, 95

elasticity, of Oracle Cloud

fast database backup compression, 116

duplicate command, RMAN

Backup, 146

FAST_START_MTTR_TARGET, instance

creating clones, 466

EM (Enterprise Manager)

recovery
, 322–323

creating clones in OEM vs., 343

defined, 308

Fault Diagnosability Infrastructure,

creating single-node standby

RMAN compatibility issues, 53

73–75

database from RAC

running RMAN backup of Data

file location considerations

database, 515

Protector-integrated

restore operations in RAC, 507

creating standby database,

database, 185

RMAN duplication to remote

493–495

emca command-line tool, 315–318

server
, 476

creating standby database using

EMCA (Enterprise Manager

RMAN duplication to same

RMAN, 497

Configuration Assistant), 316–318

server
, 475

duplicating RAC database on

emctl command, 313

file restore command, duplication, 476

single-node database, 512

encryption

file system

duplication ar
chitecture, 469

configuring RMAN default

case study, recovery from

duplication to remote server using

settings, 95–97

complete database loss

disk backups, 486

Oracle Enterprise Manager
, 321

(ARCHIVELOG), 538, 540

642
Oracle RMAN 11
g
: Backup and Recovery

file system
(continued)

Flashback Transaction

recovering SPFILE using, 271

clustered, 502

exploring Flashback Versions

recovery from complete database

using Oracle Secure Backup,

Query
, 383–384

loss (ARCHIVELOG), 538

133–137

overview of, 387–388

recovery from complete database

file types, FRA, 65

utilizing from OEM, 388–389

loss (NOARCHIVELOG),

fileNameConversionSpec

Flashback Versions Query
, 380–384

536–537

subclause, 615

flashback window
, 379

restore operations in RAC,

fileperset parameter
, 449, 452–453

for standby clause, current controlfile

507–508

flash recovery area.
See
FRA (flash

parameter of backup command, 251

retention policy maintenance for,

recovery area)

force parameter
, 545

405–408

Flash Recovery, OEM Recovery

forDbUniqueNameOption parameter

setting up, 66–67

Settings, 323–324

syntax diagram

storing backup copies in, 253

Flashback Data Ar
chive, 397–398

change command, 573

views, 67

Flashback Database

configure command, 577

from backup clause, restore command,

benefits of Oracle sync and split,

delete command, 582

271, 276

236–237

forDBUniqueNameOption

full database recoveries, 287–291

case study, opening database with

subclause, 615

resetlogs and, 553–555

foreignlogRecordSpecifier

G

configuring, 394–395

subclause, 615

defined, 31

forever option, keep parameter of

General tab, RMAN Script job, 332

implementing flashback logs,

backup command, 240

getting started, RMAN backups,

393–394

format command, offline RMAN

261–263

overview of, 393

backups, 234

grant command, 587–588

performing, 396–397

format string specification, 88–90

granules, 8

point-in-time recovery in

formatSpec subclause, 616

grid computing, 308–310

OEM, 339

forRecoverOfSpec parameter syntax

Grid Control, OEM

for standby database

diagram, backup command, 571

cloning database with, 343–344

reinstantiation, 500

FRA (flash recovery area)

Database Control vs., 311

for sync and split, 526

allocating space in, 64–66

defined, 310

tuning and tweaking,

archive log backups in RAC with

Oracle testing process with, 629

395–396

ASM and, 506–507

overview of, 311–313

flashback database command,

ASM and, 70

RMAN duplication with, 468

393–394, 397, 587

avoiding ar
chival backups, 240

Flashback Drop, 389–393

benefits of, 71

flashback logs, 16, 393–394

case study, recovery from lost

H

Flashback Query

datafile using image copy in,

implementing Flashback Versions

550–551

HA
(high availability) solutions, 5

Query
, 380–384

case study, running production

hardware

overview of, 379

datafile out of, 552–553

configuring RMAN backup on

performing, 380

configuring in OEM Recovery

Data Protector
, 181–182

undo segments and, 379–380

Settings page, 323–324

time required to replace

flashback retention target, Flashback

defined, 16

damaged, 6

Database, 394

definition of, 8

tuning backup and recovery,

Flashback T
able, 379–380, 384–387

disk-only Oracle-suggested

447–448

Flashback Technology

backups, 328

health checkers, OEM.
See

Flashback Data Archive (Oracle

flashback logs stored in, 16,

checkers, OEM

T
otal Recall), 397–398

393–394

HIGH compression type, 237

Flashback Database, 393–397

managing online redo logs, 20

home clusters, and test

Flashback Drop, 389–393

manually removing files from, 69

environment, 628

Flashback Query
, 378–384

online backups, 253

host access modes, OSB, 119

Flashback T
able, 384–387

other features, 70

host command, 588

Flashback Transaction,

overview of, 56–57

host security, running RMAN

387–389

putting database in ARCHIVELOG

locally
, 38

surviving user errors with, 378

mode, 72–73

host_sid name, Database Control, 314

Index
643

hot backup mode.
See
online (hot)

disk-only Oracle-suggested

L

backups

backups as, 328

HP Data Protector.
See
Data Protector

incrementally updated backups,

large pool

hybrid Oracle-suggested backup,

259–260

defined, 13

329–330

options, 258–259

overview of, 50

performing, 260–261

tuning backup and recovery

I

recover command determining

hardware, 447–448

image for
, 281

LARGE_POOL_SIZE parameter
, 50

I/O slaves, RMAN, 43, 49–50

restoring datafiles with, 293

LGWR (log writer) process

I/O tuning, 448

using for sync and split, 236–237,

committing data change, 25

IDB (Internal Database), Data

526–527

as required process, 12

Protector
, 176

using in restore and recovery
, 293

writing to online redo logs, 15,

image copies

incremental parameter, backup

17–19

case study, recovery from lost

command, 256–257

libobk files, 157–159, 178–179

datafile using, 550–551

incrementally updated backups,

library
, NetBackup, 170

case study, recovery from running

259–260

licensing

production datafile out of FRA,

index backup daemon, OSB, 119

NetBackup, 156

552–553

init.ora file

OSB Cloud Module, 146, 152

creating, 253–255

creating single-node standby

links

crosschecking backups, 400–403

database from RAC, 513

configuring TDPO for

listing, 435–438

duplicating RAC database on

Oracle, 198

images, managing expired backup,

single-node database, 510

Oracle to NetBackup media

167–168

duplication ar
chitecture, 468

manager
, 157–159

import catalog command, 214, 588

duplication to remote server using list backup command, RMAN

inaccessible parameter, backup

disk backups, 485–486

overview of, 426–429

command, 243–244

duplication to same server using

recovery catalog view
, 218–219

inactive online redo log group, 18,

disk backups, 482–483

before starting RMAN, 630

295–296

using RMAN to create standby

using change command with, 414

include current controlfile option,

database, 496–497

viewing backup IDs for removal,

backup command, 246

input memory buffers, 47–48, 108

409–412

including backups parameter, drop

insert command, 24–25

list commands, RMAN, 424–438

database command, 421

instance

list archive all command,

incomplete duplication, DBNEWID

defined, 9

432–433

utility
, 488–489

recovery
, 23, 322–323

list backup by file

incomplete recoveries

startup (startup nomount),

command, 426

cancel-based recovery
, 349

11–12, 22

list backup of controlfile

establishing point for
, 347–348

interfaces, OSB, 116–1
17

command, 275, 434–435

log sequence-based, 349

Internal Database (IDB), Data

list backup of datafile command,

overview of, 346

Protector
, 176

430–432

SCN-based, 348–349

ISC (Integrated Solutions Console),

list backup of spfile command,

time-based, 348

IBM, 194

434–435

using resetlogs command, 347

list backup of tablespace

using restore points, 349

J

command, 430–432

inconsistent state vs. consistent

list backup of tablespace users

backups and, 23

Jamaican processes, 12

command, 416

restore and recovery and,

list backup summary
, 425

266–267

K

list copy command, 218–219,

incremental backups, 255–261

409, 435–436

base backup, 256–257

keep forever option, change

list copy of archive all command,

benefits of, 255

command, 407–408

436–437

block change tracking file,

keep parameter, backup command,

list copy of controlfile command,

255–256

238, 240–242

437–438

differential vs. cumulative,

keepOption subclause, 616

list copy of database

257–258

kernel, RMAN packages in, 44

command, 436

644
Oracle RMAN 11
g
: Backup and Recovery

list commands, RMAN
(continued)

log sequence-based recovery
, 349

cross-checking RMAN backups,

list copy of datafile

overview of, 18–19

400–403

command, 436

recovery from complete database

delete command, 416–417

list copy of tablespace

loss (ARCHIVELOG) with

drop database command, 421

command, 436

recovery catalog, 541

overview of, 400

Other books

The Hunter’s Tale by Margaret Frazer
A Shade of Kiev 2 by Bella Forrest
Brute Force by Marc Cameron
AnchorandStorm by Kate Poole
Murder at Ford's Theatre by Margaret Truman