Oracle RMAN 11g Backup and Recovery (192 page)

backing up multinode RAC

view
, 221

282–283, 287

database, 515

RC_OFFLINE_RANGE (V$OFFLINE_

RECOVER status, database

case studies, 534–542

RANGE) view
, 221

datafiles, 14

coding backup scripts to perform

RC_REDO_LOG (V$LOG,

recover tablespace command, 29, 359

backup without, 209

V$LOGFILE) view
, 221

recoverableClause parameter syntax

configuring in OEM, 325–327

RC_REDO_THREAD (V$LOG,

diagram, list command, 590

creating, 209–21
1

V$THREAD) view
, 221

recover
.bsq file, 35

creating virtual private

RC_RESYNC view
, 221

recoverObject parameter syntax

catalog, 213

RC_RMAN_CONFIGURATION

diagram, recover command, 592

definition of, 37

(V$RMAN_CONFIGURATION)

recoverOptionList parameter syntax

dropping, 211–212

view
, 221

diagram, recover command, 593

enabling tracing of RMAN

RC_TABLESPACE (V$TABLESPACE)

recoverSpec parameter syntax

sessions, 461

view
, 222

diagram, recover command, 591

getting started with your database

RC_TEMPFILE (V$TEMPFILE)

recovery

backup, 262

view
, 222

ARCHIVELOG mode, 29–30

importance of in recovery,

RCVER view
, 227

block media, 47

268–269

read consistent images (read

configuring settings in OEM,

maintenance, 214–216

consistency), 24–25, 40–41

322–325

mer
ging multiple, 214

READ ONLY
mode, tablespaces, 15

considering cost of, 6

offline RMAN backups

read-only tablespace, recovery

getting started, 262

connecting to, 232

considerations, 350

housing files in FRA.
See
FRA

Oracle testing process, 628

read operations, performance

(flash recovery area)

overview of, 208

problems, 455

listing backups eligible for
, 429

problems with read/write

reader class, OSB user rights, 122

maximum length of time allowed

operations, 455

readrate parameter, turning RMAN

for
, 6

querying for stored script

down with, 453

NOARCHIVELOG mode, 28–29

information, 419

Real Application Clusters.
See
RAC

Oracle Cloud Backup

recovering control file from, 276

(Real Application Clusters)

advantages, 146

recovering SPFILE when

RECID (record ID), 525–526

RMAN duplication, 472

using, 272

record reuse, in control file, 39–40

recovery, advanced RMAN

recovering to previous

recordSpec subclause, 618

ar
chived redo log restores, 350

incarnation with, 353–354

recover command

cross-platform database

recovering to previous

datafile copy restores, 350–351

movement, 371–374

incarnation without, 354–356

overview of, 281

datafile copy restores, 350–351

registering database in, 211

parallel channel operations, 451

incomplete recoveries, 346–349

restoring control file online, 278

recovering to previous

read-only tablespace

RMAN backups, 50–51

incarnation, 354

recovery
, 350

RMAN compatibility issues, 53

to restore point clause of, 349

recovering corrupted data blocks,

understanding, 208–209

restoring datafiles with

351–353

unregistering database from, 212

incremental backups, 293

recovery to previous incarnation,

utilizing virtual private

syntax details, 591–594

353–356

catalog, 213

troubleshooting in RMAN, 375

tablespace point-in-time recovery.

views, 217–222

recover copy of database

See
TSPITR (tablespace point-

views intended for OEM,

command, 259

in-time recovery)

222–223

recover database command

troubleshooting, 334–336

recovery catalog databases, 185, 209

completing repair failure

verifying backups are

Recovery Catalogs link, Recovery

command with, 297

recoverable, 366–371

Catalog Settings page, 327

point-of-failure database

recovery area keywords, catalog

Recovery Manager (RMAN).

recoveries, 290

command, 278

See
RMAN

troubleshooting recovery in

recovery catalog, 207–223

recovery
, performing in OEM, 334–341

RMAN, 375–376

adding RMAN backups to, 212

checkers, 335–337

650
Oracle RMAN 11
g
: Backup and Recovery

recovery, performing in OEM

remotely
, running RMAN, 36–37

resize, logfile groups, 20

(continued)

repair failure command, 297, 301, 594

resources

configuring recovery catalogs,

replace script command, 419, 595

ARCHIVELOG parameters, 63

325–327

report commands, RMAN

distribution of I/O on Oracle

configuring recovery settings,

overview of, 438

database, 448

322–325

performing RMAN database

downloading OSB, 122

Data Recovery Advisor
, 337–339

backup, 262

high availability solutions, 5

overview of, 334–335

report need backup, 438

OEM, 310

setting scope less than entire

report need backup

Oracle database performance

database, 341

redundancy
, 439

tuning, 446

user directed, 339–340

report need backup redundancy

RMAN performance

workshop, 340–341

window days, 439

achievements, 446–447

recovery set, TSPITR, 357

report obsolete, 92–95, 405,

Restore
All Datafiles, OEM, 339–340

Recovery Settings page, OEM,

440–441

restore and recovery

322–325

report schema, 440

approach to, 267

recovery target, incomplete recoveries,

report unrecoverable, 439–440

basics, 266–267

347–348

syntax details, 595–596

Data Recovery Advisor
, 297–302

recovery to previous incarnation,

reporting on RMAN, 423–443

of database in ARCHIVELOG

353–356

data dictionary views, 441–442

mode, 287–291

recovery window backup retention

list commands.
See
list

of database in NOARCHIVELOG

policy
, 92–94, 404–405

commands, RMAN

mode, 281–287

Recycle Bin, and Flashback Drop,

managing OEM backup, 343

datafile recoveries, 292–293

389–393

report commands.
See
report

preparing RMAN for
, 267–268

Redo Integrity Check, OEM, 336

commands, RMAN

in RAC environment, 507–509

redo log files

reportObject parameter syntax

recover command, 281

archived.
See
archived redo logs

diagram, report command, 596

recovering control file from

changing location of for

repository database, Grid Control, 313

autobackup, 274–279

duplication, 475

reset catalog command, 215

recovering from online redo log

online.
See
online redo logs

reset database command, 215,

loss, 293–297

overview of, 16–18

596–597

recovery catalog, MML layer and,

sequence number
, 18–19

reset database to incarnation

268–269

sync and split technology for
, 522

command, 354, 355

restore command, 280–281

testing RMAN configuration, 630

reset logs operation, recovery based

restore vs. recovery
, 266

redo (records), 9, 17

on, 19

restoring control file, 273–274

redundancy-based retention policies,

resetDbUniqueNameOption parameter

restoring SPFILE, 269–273

94–95

syntax diagram, change

tablespace recoveries, 291–292

register database command, 211, 594

command, 574

using incremental backups, 293

registration

resetlogs command

restore ar
chivelog command, 350–351

database, with recovery

case study, recovery through,

restore clonefile command, 363

catalog, 211

545–546

restore command

recovery catalog, with OEM,

case study, using Flashback

check logical parameter
, 369–370

326–327

Database/media recovery to

check readonly parameter
, 350

split mirror copies with RMAN,

open database with, 553–555

modifying how far back RMAN

524–525

incomplete recovery through, 347

looks for control file

unregistering database from

recovering older control file

autobackup, 270–271

recovery catalog, 212, 215

backups, 275

overview of, 280–281

relationships, processes and database,

recovering to previous

recovering control file from

23–24

incarnation before issuing,

backup set, 276

release channel command, 594

353–354

recovering SPFILE from specific

reliability
, Oracle Cloud Backups, 146

recovering to previous

backup set, 271–272

remote server, RMAN duplication to,

incarnation without recovery

restore from tape, 109

475–476, 484–487

catalog, 355

to restore point clause, 349

REMOTE_LOGIN_PASSWORDFILE

resetting database incarnation in

restoring datafiles with

parameter
, 82

recovery catalog, 215

incremental backups, 293

Index
651

syntax details, 597–599

disabling, 95

scripts for Windows,

troubleshooting in RMAN,

for files in FRA, 64

621–622

374–375

incrementally updated

stored scripts, 418–421

restore control file from autobackup

backups, 260

tracing sessions, 460–462

command, 273, 274–275, 468

maintenance, 405–408

RMAN architecture

restore controlfile command, 354

managing expired backup

auxiliary database, 51–52

restore database command

images, 166–167

backing up data block, 44–47

point-of-failure database

modifying for backup sets,

compatibility issues, 53–54

recoveries, 290

240–242

database control file, 39–41

recovering to previous

OEM backup settings, 321

database privileges and, 35–36

incarnation with recovery

recovery window backup,

flash recovery area, 56–57

catalog, 354

404–405

memory
, 47–50

restoring database in

RMAN default settings

network topology of

NOARCHIVELOG mode,

configuration, 92–95

backups, 36–39

282–283

reuse keyword, 254

process from start to finish,

tuning backup and recovery

revoke command, 599–600

54–56

strategy
, 450

rights, OSB, 121–122

recovery catalog, 50–51

restore database validate check logical

RMAN

RMAN utility
, 34–35

command, 263

adding previous backups to

server-managed recovery
, 34

restore datafile command, 292

recovery catalog, 212

server processes, 42–43

restore from datafile copy command,

backing up recovery catalog

SYS packages, 43–44