Oracle RMAN 11g Backup and Recovery (194 page)

229–232

skip parameter
, backup command, 243

operational database online,

overview of, 22

skip readonly parameter, backup

272–273

restoring database in

command, 244

split mirror backups, 209

NOARCHIVELOG mode, 282

skipSpec parameter syntax diagram

spool command, 606

startup nomount command, 10–12, 22

backup command, 571

SQL

startup, of database, 21–22

convert command, 579

applying to logical standby

startup read only command, 11

validate command, 612

database, 492

startup restrict command, 10, 23

SMON (system monitor) process, 12

creating standby control file, 493

status codes

SMR (server
-managed recovery), 34

enabling tracing of RMAN

assigning to database datafiles, 14

snapshot control file

sessions, 461

crosschecking backups, 400–403

654
Oracle RMAN 11
g
: Backup and Recovery

status codes
(continued)

SYS.DBMS_BACKUP_RESTORE

tablespace parameter, backup

modifying archived redo log

package

command, 250

backups, 409

auxiliary database and, 52

tablespace point-in-time recovery.

of online redo log groups, 17–18

overview of, 43–44

See
TSPITR (tablespace point-in-time

storage clouds, OSB, 116, 138

RMAN packages in kernel, 44

recovery)

storage pool volumes, 202–203

RMAN process and, 54, 56

tags

subclause syntax.
See
RMAN

SYS.DBMS_RCVMAN package

backup command options, 238

subclause syntax details

auxiliary database and, 52

incrementally updated backups

substitution variables, set newname

overview of, 43

using, 259–260

command, 285

RMAN process and, 54

tape backups

sudo set up, 35

System Change Number.
See
SCN

combined disk and, 329–330

support matrix, Oracle and Data

(System Change Number)

in disk backup world,

Protector integration, 174

System Global Area.
See
SGA (System

102–103

switch clone tempfile all

Global Area)

duplication to different server

command, 364

system monitor (SMON) process, 12

using, 478–479

switch command, 283–284, 607–608

system Oracle-related files, backing

duplication to same server

switchFile parameter syntax

up, 30

using, 484

diagram, 608

system oratab file, backing up, 30

impact of multiplexing on, 453

sync and split technology

SYSTEM tablespace, recovery from loss

output buffers and, 48

as broken mirror backups,

of, 542

performing, 108–109

518–520

performing restore from, 109

RAID and, 518

T

problems with write

RMAN and, 524–526

operations, 455

sync and split technology, with Oracle

tables, Flashback T
able, 384–387

remote server duplication

database

tablespace.
See also
TSPITR

using, 486

ar
chive logs, 522–523

(tablespace point-in-time recovery)

same server duplication

benefits of, 523–524, 528–529

ARCHIVELOG recovery
, 29

using, 486

control files, 522

case study, online recovery from

using sbttest for
, 109–1
10

datafiles, 521–522

loss of, 543

tape buffer size, 447

getting from Oracle software, 527

case study, recovery from loss of

tape channels, RMAN

overview of, 520–521

SYSTEM tablespace, 542

defined, 42

redo log files, 522

configuring exclusion policy,

testing with Oracle default SBT

using standby database,

84, 320

interface, 105–106

Flashback Database and

configuring recovery catalog

understanding in OEM, 331

incremental apply
, 527–528

database, 209

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

using VSS for W
indows, 529

creating recovery catalog user

tape management system, retention

synchronization

account, 210

policy
, 95

manual recovery catalog, 216

cross-platform transportable,

tape-only Oracle-suggested backup,

RMAN metadata and Data

372–374

328–329

Protector
, 187

crosschecking backups, 401

target database

synchronous backup I/O, 457–458

definition of, 9

case study, using RMAN

syntax.
See
RMAN syntax

incremental backups of, 258–259

duplication to create historical

reference guide

listing backups by name of, 430

subset of, 548–550

SYS packages, used by RMAN, 43–44

making image copies of, 254

connecting to for RMAN

sysdba privileges, RMAN

online backup of, 249–251

duplication, 468

always connecting to database

overview of, 15

creating RMAN backup account,

with, 77

recoveries, 291–292

80–81

auxiliary database requiring, 52

recovering, 291–292

defined, 34

making changes on OEM

recovery catalog views for
, 222

Grid Control monitoring, 311

Recovery Settings page

restoring using Data Protector

privileges, 35–36

with, 324

GUI, 185

recovery catalog and, 50

managing restore points in

specifically excluding during

RMAN compatibility and, 53, 79

OEM, 342

automated backup, 88

RMAN process, connecting to, 54

tar
get database and, 35–36

tuning backup and recovery
, 450

Index
655

running crosscheck command

time-based recovery
, 348

TSPITR (tablespace point-in-time

from, 401

Tivoli Data Protection for Oracle.
See

recovery)

running RMAN locally from,

TDPO (Tivoli Data Protection for

automated, 357–359

37–39

Oracle)

auxiliary database and, 51–52

running RMAN remotely to,

Tivoli Storage Manager.
See
TSM

customizing automated, 360

36–37

(Tivoli Storage Manager)

manually
, 360–366

target-less duplication in 11g

tnsnames.ora file

media recovery for user error

and, 487

creating for remote RMAN

with, 378

using RMAN to create standby

backups, 37

overview of, 356–357

database, 496–497

creating single-node standby

restrictions, 366

where backups come from,

database from RAC, 514

TS_PITR_CHECK view
, 357–358

493–494

duplicating RAC database on

TS_PITR_OBJECTS_TO_BE_DROPPED

tar
get instance, TSPITR, 357

single-node database, 511

view
, 358

target-less duplication, in 1
1g, 486

duplication to remote server using

TCP/IP, installing and configuring

disk backups, 486

U

OSB, 122

preparing network for RMAN

TDPO (Tivoli Data Protection for

duplication, 479–481

Undo Segment Integrity Check,

Oracle)

running RMAN locally from target

OEM, 336

backing up database objects to

database and, 38

undo segments

TSM, 193–194

UR=A parameter
, 498

Flashback and, 379–380

configuring for Oracle, 194–198

using RMAN to create standby

Flashback T
able, 384

defined, 190

database, 497

generating and storing undo in,

deleting database backups, 204

to restore point clause, recover/restore

24–25

performing RMAN backup using,

commands, 349

UNDO tablespaces, 235

199–203

toDestSpec subclause, 619

UNIX, RMAN scripts for
, 622–623

real world example, 193

trace files, 9, 460–462

unregister database command, 212,

troubleshooting TSM backups,

Transaction Integrity Check,

215, 609

205–206

OEM, 336

Unregister Database link, Recovery

tdpoconf utility
, 197

transparent mode encryption, 95

Catalog Settings page, 327

TDPO_NODE, 196, 203, 206

transport tablespace command,

until clause

tempfiles, recovery catalog views

608–609

recover copy of database

for
, 222

transportOptionList parameter syntax

command, 260

tempfileSpec subclause, 618

diagram, convert command, 579

setting in duplication, 481

templates

Transp_tbs_optlist parameter syntax

until sequence parameter
, 545,

adding to backup selection list,

diagram, transport tablespace

548–550

165–166

command, 609

until time parameter, backup

configuring RMAN backup on

troubleshooting

command, 240, 251, 275

Data Protector
, 179–180

NetBackup, 169

untilClause subclause, RMAN, 619

terminology
, Oracle, 7–9

RMAN recovery
, 334–336

unused block compression, block-level

test environment setup, 625–631

truncate table operation, 384

backups, 45–46

getting started, 263

TSM (Tivoli Storage Manager),

unused online redo log group, 18

go cheap, 627–628

189–206

update command, 24

matching your production

Administration Center and Web

upgrade catalog command,

environment, 627

client, 194

214–215, 610

Oracle configuration,

client, 193–194

UR=A parameter, tnsnames.ora

628–629

configuring TDPO for Oracle,

file, 498

overview of, 626

194–198

USE_DB_RECOVERY_FILE_DEST

RMAN configuration, 630–631

deleting database backups, 204

parameter
, 323

test box, 627

overview of, 190

user accounts, creating

tiers

performing RMAN backup using

database, 80–81

NetBackup, 156–157

TDPO, 199–204

Oracle Secure Backup, 120–122

tape channels with Oracle default

real world example, 193

recovery catalog, 209

SBT interface, 105–106

server system objects, 190–193

user class, OSB user rights, 122

TSM, 190–191

troubleshooting, 204–206

656
Oracle RMAN 11
g
: Backup and Recovery

User Directed Recovery, OEM,

V$DATABASE view
, 220, 372

V$RMAN_BACKUP_JOB_DETAILS

339–342

V$DATABASE_BLOCK_CORRUPTION

view
, 455

user errors.
See
Flashback Technology

view
, 220, 351–352, 404

V$RMAN_CONFIGURATION

user processes, 12

V$DATAFILE view
, 220

view
, 221

USER_RECYCLEBIN view
, 390

V$DATAFILE_COPY view
, 219, 220

V$RMAN_ENCRYPTION_

using backup controlfile

V$DIAG_INFO view
, 75

ALGORITHMS view
, 96–97

command, 522

verdeleted attribute, TSM copy

V$RMAN_OUTPUT view
, 227–228

groups, 197

V$SESSION view
, 42, 456

V

verification, of database restorability,

V$SESSION_LONGOPS view

366–371

RMAN performance tuning, 456

V$ views, for reporting, 441–442

VERITAS NetBackup for Oracle.
See