Oracle RMAN 11g Backup and Recovery- P15

Chia sẻ: Thanh Cong | Ngày: | Loại File: PDF | Số trang:5

Thêm vào BST

Báo xấu

99
lượt xem 23
download

Download Vui lòng tải xuống để xem tài liệu đầy đủ

Oracle RMAN 11g Backup and Recovery- P15: Oracle, yet another edition of our RMAN backup and recovery book has hit the shelves! Oracle Database 11g has proven to be quite the release to be sure. RMAN has new functionality and whizbang new features that improve an already awesome product. RMAN has certainly evolved over the years, as anyone who started working with it in Oracle version 8 can attest to.

Chủ đề:

Bình luận(0) Đăng nhập để gửi bình luận!

Lưu

Nội dung Text: Oracle RMAN 11g Backup and Recovery- P15

652 Oracle RMAN 11g: 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 completedTimeSpec, 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–110 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 Windows, 623 sessions, tracing RMAN, 460–462 RMAN syntax reference guide schema objects, 9, 210–211, 440 set backup copies parameter, backup command list, 562–563 schtasks utility, Windows, 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 target, 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–11 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 large 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–11 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 force 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 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 11g: 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 Table, 384–387 remote server duplication database tablespace. See also TSPITR using, 486 archive 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–110 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 Windows, 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 target 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 target instance, TSPITR, 357 single-node database, 511 view, 358 target-less duplication, in 11g, 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 Table, 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 11g: 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 RMAN process from start to V$ACTIVE_SESSION_HISTORY NetBackup for Oracle finish, 55 view, 457 V$FLASHBACK_DATABASE_LOG tracking SYS.DBMS_BACKUP_ validate backupset command, view, 395 RESTORE package, 44 370–371 V$FLASHBACK_DATABASE_STAT viewing RMAN channel validate command view, 395–396 processes, 42 check logical option, 404 V$FLASH_RECOVERY_AREA_USAGE viewing RMAN server syntax details, 610–612 view, 69 processes, 42 validating RMAN backups, views VSS (Volume Shadow Copy Service) 404–405 DRA data dictionary, 302 for Windows, 237 validate parameter, backup command, Flashback Database, 395–396 V$TABLESPACE view, 222 243, 369 managing FRA, 67–69 V$TEMPFILE view, 222 validateObject parameter syntax recovery catalog, 217–222 V$THREAD view, 221 diagram, validate command, 611 RMAN performance tuning, V$TRANSPORTABLE_PLATFORM validateOperand parameter syntax 454–460 view, 372–373 diagram, validate command, 612 V$, for reporting, 441–442 V$UNDOSTAT view, 379 validation, of RMAN backups, V$IR_FAILURE view, Data Recovery 404–405 Advisor, 302 W V$ARCHIVED_LOG view, 217, V$IR_FAILURE_SET view, Data 499–500 Recovery Advisor, 302 Web tool, OSB, 117, 126–127 V$BACKUP_ASYNC_IO view, V$IR_MANUAL_CHECKLIST view, Whole Database Recovery, OEM 457–460 Data Recovery Advisor, 302 defined, 339 V$BACKUP_CORRUPTION view, V$IR_REPAIR view, Data Recovery performing, 340–341 218, 351–352 Advisor, 302 recover to current or previous V$BACKUP_DATAFILE view, 218 V$LOG view point in time, 339 V$BACKUP_FILES view, 218–219 log sequence number of online recovery from previously restored V$BACKUP_PIECE view, 219 redo logs, 9 datafiles, 340 V$BACKUP_REDOLOG view, 219 recovery catalog, 221 recovery scope less than entire V$BACKUP_SET view, 219 status of online redo log group, database, 342 V$BACKUP_SPFILE view, 219 17–18 restore all datafiles, 339–340 V$BACKUP_SYNC_IO view, 457–460 V$LOGFILE view, 221 Windows OS V$BLOCK_CHANGE_TRACKING V$LOG_HISTORY view, 221 RMAN scripts for, 621–622 view, 256 V$OFFLINE_RANGE view, 221 scheduled backups on, 623 V$COPY_CORRUPTION view, VPC (virtual private catalog), Volume Shadow Copy Service 219, 352 creating, 213 for, 237 VCTF (block change tracking file), V$RECOVERY_FILE_DEST view, write operations, performance issues, 255–256, 320 68, 405 455–456