Restore Archivelog
RMAN> run{
2> allocate channel c1 type 'sbt_tape';
3> set archivelog destination to '/mnt/southdb/arch';
4> restore archivelog from logseq 18427 until logseq 18527;
5> release channel c1;
6> }
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: c1
RMAN-08500: channel c1: sid=122 devtype=SBT_TAPE
RMAN-08526: channel c1: VERITAS NetBackup for Oracle - Release 4.5GA (00000000)
RMAN-03022: compiling command: set
RMAN-03022: compiling command: restore
RMAN-03022: compiling command: IRESTORE
RMAN-06050: archivelog thread 1 sequence 18479 is already on disk as file /u01/app/oracle/admin/southdb/arch/arch_0001_0000018479.arc
RMAN-06050: archivelog thread 1 sequence 18480 is already on disk as file /mnt/southdb/arch/arch_0001_0000018480.arc
RMAN-06050: archivelog thread 1 sequence 18481 is already on disk as file /mnt/southdb/arch/arch_0001_0000018481.arc
RMAN-06050: archivelog thread 1 sequence 18482 is already on disk as file /mnt/southdb/arch/arch_0001_0000018482.arc
RMAN-06050: archivelog thread 1 sequence 18483 is already on disk as file /u01/app/oracle/admin/southdb/arch/arch_0001_0000018483.arc
RMAN-06050: archivelog thread 1 sequence 18484 is already on disk as file /mnt/southdb/arch/arch_0001_0000018484.arc
RMAN-06050: archivelog thread 1 sequence 18485 is already on disk as file /mnt/southdb/arch/arch_0001_0000018485.arc
RMAN-06050: archivelog thread 1 sequence 18486 is already on disk as file /u01/app/oracle/admin/southdb/arch/arch_0001_0000018486.arc
RMAN-06050: archivelog thread 1 sequence 18487 is already on disk as file /mnt/southdb/arch/arch_0001_0000018487.arc
RMAN-06050: archivelog thread 1 sequence 18488 is already on disk as file /mnt/southdb/arch/arch_0001_0000018488.arc
RMAN-06050: archivelog thread 1 sequence 18489 is already on disk as file /mnt/southdb/arch/arch_0001_0000018489.arc
RMAN-06050: archivelog thread 1 sequence 18490 is already on disk as file /mnt/southdb/arch/arch_0001_0000018490.arc
RMAN-06050: archivelog thread 1 sequence 18491 is already on disk as file /mnt/southdb/arch/arch_0001_0000018491.arc
RMAN-06050: archivelog thread 1 sequence 18492 is already on disk as file /mnt/southdb/arch/arch_0001_0000018492.arc
RMAN-06050: archivelog thread 1 sequence 18493 is already on disk as file /mnt/southdb/arch/arch_0001_0000018493.arc
RMAN-06050: archivelog thread 1 sequence 18494 is already on disk as file /mnt/southdb/arch/arch_0001_0000018494.arc
RMAN-06050: archivelog thread 1 sequence 18495 is already on disk as file /mnt/southdb/arch/arch_0001_0000018495.arc
RMAN-06050: archivelog thread 1 sequence 18496 is already on disk as file /mnt/southdb/arch/arch_0001_0000018496.arc
RMAN-06050: archivelog thread 1 sequence 18497 is already on disk as file /mnt/southdb/arch/arch_0001_0000018497.arc
RMAN-06050: archivelog thread 1 sequence 18498 is already on disk as file /mnt/southdb/arch/arch_0001_0000018498.arc
RMAN-06050: archivelog thread 1 sequence 18499 is already on disk as file /mnt/southdb/arch/arch_0001_0000018499.arc
RMAN-06050: archivelog thread 1 sequence 18500 is already on disk as file /mnt/southdb/arch/arch_0001_0000018500.arc
RMAN-06050: archivelog thread 1 sequence 18501 is already on disk as file /mnt/southdb/arch/arch_0001_0000018501.arc
RMAN-06050: archivelog thread 1 sequence 18502 is already on disk as file /mnt/southdb/arch/arch_0001_0000018502.arc
RMAN-06050: archivelog thread 1 sequence 18503 is already on disk as file /mnt/southdb/arch/arch_0001_0000018503.arc
RMAN-06050: archivelog thread 1 sequence 18504 is already on disk as file /mnt/southdb/arch/arch_0001_0000018504.arc
RMAN-06050: archivelog thread 1 sequence 18505 is already on disk as file /mnt/southdb/arch/arch_0001_0000018505.arc
RMAN-06050: archivelog thread 1 sequence 18506 is already on disk as file /mnt/southdb/arch/arch_0001_0000018506.arc
RMAN-06050: archivelog thread 1 sequence 18507 is already on disk as file /mnt/southdb/arch/arch_0001_0000018507.arc
RMAN-06050: archivelog thread 1 sequence 18508 is already on disk as file /mnt/southdb/arch/arch_0001_0000018508.arc
RMAN-06050: archivelog thread 1 sequence 18509 is already on disk as file /mnt/southdb/arch/arch_0001_0000018509.arc
RMAN-06050: archivelog thread 1 sequence 18510 is already on disk as file /u01/app/oracle/admin/southdb/arch/arch_0001_0000018510.arc
RMAN-06050: archivelog thread 1 sequence 18511 is already on disk as file /mnt/southdb/arch/arch_0001_0000018511.arc
RMAN-06050: archivelog thread 1 sequence 18512 is already on disk as file /mnt/southdb/arch/arch_0001_0000018512.arc
RMAN-06050: archivelog thread 1 sequence 18513 is already on disk as file /mnt/southdb/arch/arch_0001_0000018513.arc
RMAN-06050: archivelog thread 1 sequence 18514 is already on disk as file /mnt/southdb/arch/arch_0001_0000018514.arc
RMAN-06050: archivelog thread 1 sequence 18515 is already on disk as file /mnt/southdb/arch/arch_0001_0000018515.arc
RMAN-06050: archivelog thread 1 sequence 18516 is already on disk as file /mnt/southdb/arch/arch_0001_0000018516.arc
RMAN-06050: archivelog thread 1 sequence 18517 is already on disk as file /mnt/southdb/arch/arch_0001_0000018517.arc
RMAN-06050: archivelog thread 1 sequence 18518 is already on disk as file /mnt/southdb/arch/arch_0001_0000018518.arc
RMAN-06050: archivelog thread 1 sequence 18519 is already on disk as file /mnt/southdb/arch/arch_0001_0000018519.arc
RMAN-06050: archivelog thread 1 sequence 18520 is already on disk as file /mnt/southdb/arch/arch_0001_0000018520.arc
RMAN-06050: archivelog thread 1 sequence 18521 is already on disk as file /u01/app/oracle/admin/southdb/arch/arch_0001_0000018521.arc
RMAN-06050: archivelog thread 1 sequence 18522 is already on disk as file /u01/app/oracle/admin/southdb/arch/arch_0001_0000018522.arc
RMAN-06050: archivelog thread 1 sequence 18523 is already on disk as file /mnt/southdb/arch/arch_0001_0000018523.arc
RMAN-06050: archivelog thread 1 sequence 18524 is already on disk as file /mnt/southdb/arch/arch_0001_0000018524.arc
RMAN-06050: archivelog thread 1 sequence 18525 is already on disk as file /mnt/southdb/arch/arch_0001_0000018525.arc
RMAN-06050: archivelog thread 1 sequence 18526 is already on disk as file /mnt/southdb/arch/arch_0001_0000018526.arc
RMAN-06050: archivelog thread 1 sequence 18527 is already on disk as file /mnt/southdb/arch/arch_0001_0000018527.arc
RMAN-03023: executing command: IRESTORE
RMAN-08018: channel c1: starting archivelog restore to user-specified destination
RMAN-08508: archivelog destination=/mnt/southdb/arch
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18427
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18428
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18429
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18430
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18431
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18432
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18433
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18434
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18435
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18436
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18437
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18438
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18439
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18440
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18441
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18442
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18443
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18444
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18445
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18446
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18447
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18448
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18449
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18450
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18451
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18452
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18453
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18454
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18455
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18456
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18457
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18458
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18459
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18460
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18461
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18462
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18463
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18464
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18465
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18466
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18467
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18468
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18469
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18470
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18471
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18472
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18473
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18474
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18475
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18476
RMAN-08023: channel c1: restored backup piece 1
RMAN-08511: piece handle=arch-s924-p1-t635580578 tag=null params=NULL
RMAN-08024: channel c1: restore complete
RMAN-08018: channel c1: starting archivelog restore to user-specified destination
RMAN-08508: archivelog destination=/mnt/southdb/arch
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18477
RMAN-08022: channel c1: restoring archivelog
RMAN-08510: archivelog thread=1 sequence=18478
RMAN-08023: channel c1: restored backup piece 1
RMAN-08511: piece handle=arch-s925-p1-t635581914 tag=null params=NULL
RMAN-08024: channel c1: restore complete
RMAN-03022: compiling command: release
RMAN-03023: executing command: release
RMAN-08031: released channel: c1
RMAN>
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/9925929/viewspace-975590/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- rman restore archivelog logRESTHive
- restore archivelog 的各種用法RESTHive
- restore archivelog 的各種用法RESTHive
- rman 還原歸檔日誌(restore archivelogRESTHive
- rman 還原歸檔日誌(restore archivelog)RESTHive
- 用restore archivelog從備份集中恢復歸檔日誌RESTHive
- archivelog模式和flashback db以及guarantee restore point之間的相互制約關係!Hive模式REST
- netbackup rman restore archivelog 報ora-19511錯誤處理過程RESTHive
- RMAN RAC Archivelog Restore Fails with RMAN-20242 (Doc ID 180169.1)HiveRESTAI
- guarantee restore points-Flashback after RMAN restoreREST
- canvas restore()CanvasREST
- RESTORE POINTREST
- Delete Dataguard ArchivelogdeleteHive
- 配置ARCHIVELOG 模式Hive模式
- RMAN - backup archivelog all 與 backup database plus archivelog 區別HiveDatabase
- [zt] crosscheck archivelog allROSHive
- 轉至archivelog模式Hive模式
- DOCKER特性 - LIVE RESTOREDockerREST
- canvas save()和restore()CanvasREST
- SQL Server Backup & RestoreSQLServerREST
- How restore CBO statisticsREST
- TFS Express backup and restoreExpressREST
- backup and restore tipsREST
- TMS request queue restoreREST
- Oracle OCP(58):ARCHIVELOG 管理OracleHive
- Archivelog & Noarchivelog mode in RMANHive
- Restore Points 制定回退方案REST
- restore和recover 區別REST
- restore database check readonlyRESTDatabase
- restore,recover的區別REST
- Cold backup and restore the entire databaseRESTDatabase
- How to restore ASM based OCRRESTASM
- DBMS_BACKUP_RESTORE.DBMS_BACKUP_RESTORE用於特殊情況下的恢復REST
- git操作之二:git restoreGitREST
- restore、recover到指定時間REST
- oracle 8i的restoreOracleREST
- restore controlfile from autobackREST
- read only tablespace backup restoreREST