Oracle RMAN 11g Backup and Recovery (188 page)

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

330–331

current online redo log group, 17, 294,

configuring RMAN backup on,

Database Configuration Assistant

296–297

179–183

(DBCA), 315

editing RMAN script, 184

Database Control, OEM

D

integration of Oracle and,

ar
chitecture, 313–314

174–179

cloning database, 343–344

daemons, Oracle Secure Backup, 119

media management

configuring backup settings,

data

synchronization and Oracle

318–319

changing database, 24–25

RMAN metadata, 187

defined, 310

checkpoints, 26

Oracle Integration agent,

vs. Grid Control, 311

committing change, 25

174–176

installing and configuring,

preserving lost tablespace, 358

restoring objects using GUI and

315–318

data block backups

RMAN, 185–187

Oracle testing process, 629

benefits of, 45–47

RMAN backup methods,

overview of, 313

checking for physical corruption

184–185

database control, vs. grid control, 311

during, 245

RMAN backup procedure, 185

database IDs.
See
DBIDs (database IDs)

flashback logs and, 393–394

Data Pump, 26

Database Utilities suite, 34–35

NULL data block compression,

Data Recovery Advisor.
See
DRA (Data
database writer processes (DBWn), 12

235–236

Recovery Advisor)

DATABASE_INCARNATION

only on changed database blocks. database

(V$DATABASE_INCARNATION)

See
incremental backups

changing data in, 24–25

view
, 220

overview of, 44–45

checkpoints, 26

datafile parameter, backup

potential problems with

clones.
See
cloned database;

command, 250

reading, 455

duplication, RMAN

datafileCopySpec parameter syntax

recovering corrupted, 351–353

configuring recovery catalog, 209

diagram, backup command, 570

RMAN process from start to

control file.
See
control file

datafiles

finish, 55

controlling software, 10–1
1

ARCHIVELOG recovery
, 29–30

RMAN vs. other backup

datafiles.
See
datafiles

backups based on last backup

utilities, 44

definition of, 8

time, 244–245

Data Block Integrity Check, OEM, 336

incremental backups of, 258–259

backups from standby

data dictionary views, 302, 441–442

online backups of, 247–249

database, 499

Data Guard and RMAN, 491–500

parameter files, 8, 30

backups in RAC, 503–504

creating standby database,

performance tuning of, 448–450

byte ordering in, 372–373

requirements, 493–494

physical components, 14–16

case study, online recovery from

creating standby database using

privileges, RMAN and, 35–36

loss of, 543

RMAN, 495–497

processes relationships, 23–24

case study, recovery in

datafile backups from standby

recovery catalog views for
, 220

ARCHIVELOG using FRA from

database, 499–500

restoring using Data Protector

lost, 550–551

duplicate...for standby command,

GUI, 185

case study, running production

494–495

shutdown of, 11, 23

datafile out of FRA, 552–553

640
Oracle RMAN 11
g
: Backup and Recovery

datafiles
(continued)

DBIDs (database IDs)

DB_UNIQUE_NAME initialization

checking during startup, 267

automated backups of SPFILE and

parameter
, 499

crosschecking backups, 401

control files, 92

DBWn (database writer processes), 12

in database open process, 22–23

generating with DBNEWID

DBWR_IO_SLAVES parameter,

duplicate for standby command,

utility
, 473

447–448

494–495

recording for recovery

debug, 205–206

forcing backup of read-only
, 244

operations, 208

using NetBackup, 170

incremental backups of, 258–259

recovering control file from

DEFAUL
T compression type, 237

listing backups by
, 426

autobackup, 273–274

delalConf parameter syntax diagram,

listing backups of specific,

recovering SPFILE from

configure command, 576

430–432

autobackup, 269–271

delete ar
chivelog command, 97

listing copies of, 436

recovering SPFILE from specific

delete command

online backups, 250

backup set, 272

changing data in database, 24

overview of, 14

recovery from complete database

purging recovery catalog

recovering, 292–293

loss (ARCHIVELOG), 538

records, 215

recovery catalog views for
, 218,

RMAN duplication and, 466–467,

RMAN maintenance, 416–417

220–221

472–473

syntax details, 581–582

recovery from previously

target-less duplication in 11g

delete input option, backup archivelog

restored, 340

and, 486

command, 251

recovery of read-only
, 350

unregistering database from

delete input option, backup set

reporting on, 438–440

recovery catalog, 212

backups, 252

restoring from datafile copy,

DBMS_BACKUP_RESTORE package,

delete obsolete command

350–351

SYS, 43–44

ar
chive log deletion policies, 97

restoring to different location,

dbms_backup_restore procedure, 278

default retention policies, 94

283–284

DBMS_RCVCA
T package, 50–51

removing obsolete archived redo

restoring using Data Protector

DBMS_RCVMAN package, 43, 50–51

logs, 242–243

GUI, 185

DB_NAME parameter, standby

retention policy

restoring using incremental

database, 494, 495

maintenance, 405

backups, 293

DBNEWID utility

delete parameter, change command,

restoring using OEM, 339–340

completing failed duplication

409–413

RMAN duplication, 471–472

manually
, 547

delete script command, 419, 421, 582

RMAN process from start to

defined, 473

DELETE status, cross-checking RMAN

finish, 54

incomplete duplication and,

backups, 401

skipping offline, inaccessible or

488–489

deleting database backups, TSM or

read-only
, 243–244

dbObject parameter syntax diagram

TDPO, 204

sync and split technology for,

listObjList subclause, 616

destination directories, configuring

521–522

recover command, 592

database in
ARCHIVELOG, 62–64

datafileSpec subclause, 614

db_recovery_file_dest keywords,

device agent, media management

DB Structure Integrity Check,

catalog command, 278

server
, 104

OEM, 337

DB_RECOVERY_FILE_DEST

device configuration

dba group membership, 35–36

parameter, FRA

OEM backup settings, 319

DBA_DATA_FILE view
, 363

configuring Flashback Database,

OEM limitations, 321

DBA_HIST_LOG view
, 65

394–395

RMAN backup settings, 321

DBA_OUTSTANDING_ALERTS view,

location defined by
, 64

device type parameter, backup

64, 67–68

setting initialization

command, 240

DBA_RECYCLEBIN view
, 390

parameters, 56

deviceConf parameter syntax diagram,

DB_BLOCK_SIZE parameter
, 8

setting up, 66–67

configure command, 577

dbca command-line tool, 315

DB_RECOVERY_FILE_DEST_SIZE

deviceSpecifier subclause, 615

DBCA (Database Configuration

parameter, FRA

DIAGNOSTIC_DEST parameter
, 74,

Assistant), 315

allocating space, 64–66

461–462

DB_CREATE_ONLINE_LOG_DEST_n

configuring Flashback Database,

Dictionary Integrity Check, OEM, 337

parameter
, 20

394–395

differential backups, 257–258

DB_FILE_NAME_CONVERT parameter,

setting initialization parameters, 56

directories, OSB, 119–120, 123–124

475, 515

setting up, 66–67

disaster recovery
, 263

Index
641

disk backups

duplication to same server using

Oracle Secure Backup, 115–1
16,

combining tape and, 329–330

disk backups, 484

120, 125

configuring backup sets in OEM,

file location considerations, 475

Oracle Secure Backup, using

319–320

syntax details, 583–586

Cloud Module for
, 138

duplication to remote server

testing RMAN configuration, 630

restore command and, 280

using, 476–478, 484–487

duplicate for standby command, 494

endian formats, 371–374

duplication to same server using,

duplication, RMAN

Enterprise Editions, RMAN included

481–484

ar
chitecture, 468–474

with, 34–35

output buffers in, 48

building password file, 479–481

Enterprise Manager.
See
EM (Enterprise

problems with write

case study, creating historical

Manager)

operations, 455

subset of target database,

environment, tuning backup and

disk channels, RMAN, 42

548–550

recovery
, 449

disk devices, memory buffers for
, 449

case study, manually completing

errors

disk groups,
ASM, 70

failed, 547–548

media management, 110–1
11

disk I/O slaves, RMAN, 43

incomplete, using DBNEWID

RMAN setup and

disk-only Oracle-suggested

utility
, 488–489

configuration, 35

backup, 328

location considerations,

surviving user.
See
Flashback

disk space, test environment and, 628

474–479

Technology

disks, TSM, 190–191

and network, 479

troubleshooting TSM backups,

DML (Data Manipulation Language),

overview of, 466

204–206

24–25

of RAC database on single-node

events, tracing RMAN sessions, 460–461

double at sign (@@) command, 564

database, 509–512

executable file, RMAN utility
, 35, 53

DRA (Data Recovery Advisor)

reasons for
, 466–467

execute command, 586

data dictionary views, 302

to remote server
, 484–487

execute script command, 420–421

defined, 297

to same server
, 481–484

exit command, 586–587

performing recovery
, 337–339

target-less in 1
1g, 487

expired backup images, managing,

understanding, 335

types of, 468

167–168

using Perform Recovery

dupOptionList parameter syntax

expired backups, listing, 430–431, 433

page, 339

diagram, duplicate command,

EXPIRED status, backups

using through RMAN, 297–302

584–585

crosschecking, 400–401

drop catalog command, 211–212,

duration parameter, backup command,

recovering older control files, 275

582–583

238–239, 453–454, 570

drop database command, 421, 583

F

dropped tablespaces, TSPITR unable to

E

recover
, 366

Other books

Speak Low by Melanie Harlow
Moribund Tales by Erik Hofstatter
Coming Clean by Sue Margolis
Hacia la luz by Andrej Djakow
Fool That I Am by Oakes, Paulette
Juliet's Moon by Ann Rinaldi