采用RESTORE ARCHIVELOG恢复归档

简介:
 ### BEGIN LOG - DATE: 120723, TIME: 101037 ###

=============================================================================================
1、想“瞎猫碰耗子”,采用from to 和between and均不成功
=============================================================================================


RMAN> RUN
  SET ARCHIVELOG DESTINATION TO '/u01/archive/';
  RESTORE ARCHIVELOG SEQUENCE from 18556 to 15624;
}
2> 3> 4> 
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "from": expecting one of: "between, equal, integer"
RMAN-01007: at line 4 column 29 file: standard input

RMAN> 
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "}": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, convert, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, flashback, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade, unregister, validate"
RMAN-01007: at line 1 column 1 file: standard input

RMAN> RUN
  SET ARCHIVELOG DESTINATION TO '/u01/archive/';
  RESTORE ARCHIVELOG SEQUENCE between 18556 and 15624;
}2> 3> 4> 5> 

executing command: SET ARCHIVELOG DESTINATION

Starting restore at 2012-07-23 10:19:51
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/23/2012 10:19:51
RMAN-20242: specification does not match any archive log in the recovery catalog


=============================================================================================
2、采用日期限定取归档成功
=============================================================================================
RMAN> RUN
  SET ARCHIVELOG DESTINATION TO '/u01/archive/';
  restore archivelog from time 'sysdate-4';
}2> 3> 4> 5> 

executing command: SET ARCHIVELOG DESTINATION

Starting restore at 2012-07-23 10:28:41
using channel ORA_DISK_1

archive log thread 1 sequence 18556 is already on disk as file /u01/archive/1_18556_697238176.dbf
archive log thread 1 sequence 18557 is already on disk as file /u01/archive/1_18557_697238176.dbf
archive log thread 1 sequence 18603 is already on disk as file +DATA/archivelog/1_18603_697238176.dbf
archive log thread 1 sequence 18604 is already on disk as file +DATA/archivelog/1_18604_697238176.dbf
archive log thread 1 sequence 18605 is already on disk as file +DATA/archivelog/1_18605_697238176.dbf
archive log thread 1 sequence 18606 is already on disk as file +DATA/archivelog/1_18606_697238176.dbf
archive log thread 1 sequence 18607 is already on disk as file +DATA/archivelog/1_18607_697238176.dbf
archive log thread 2 sequence 15625 is already on disk as file +DATA/archivelog/2_15625_697238176.dbf
archive log thread 2 sequence 15626 is already on disk as file +DATA/archivelog/2_15626_697238176.dbf
archive log thread 2 sequence 15627 is already on disk as file +DATA/archivelog/2_15627_697238176.dbf
archive log thread 2 sequence 15628 is already on disk as file +DATA/archivelog/2_15628_697238176.dbf
channel ORA_DISK_1: starting archive log restore to user-specified destination
archive log destination=/u01/archive/
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18519
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18520
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18521
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18522
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18523
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18524
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18525
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18526
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18527
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18528
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18529
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18530
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18531
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18532
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18533
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18534
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18535
channel ORA_DISK_1: reading from backup piece /u01/rmanbak/arch_PORT_31ngh9h2_1_1
channel ORA_DISK_1: restored backup piece 1
piece handle=/u01/rmanbak/arch_PORT_31ngh9h2_1_1 tag=BKARCH
channel ORA_DISK_1: restore complete, elapsed time: 00:03:56
channel ORA_DISK_1: starting archive log restore to user-specified destination
archive log destination=/u01/archive/
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15537
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15538
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15539
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15540
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15541
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15542
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15543
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15544
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15545
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15546
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15547
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15548
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15549
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15550
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15551
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15552
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15553
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15554
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15555
channel ORA_DISK_1: reading from backup piece /u01/rmanbak/arch_PORT_32ngh9nj_1_1
channel ORA_DISK_1: restored backup piece 1
piece handle=/u01/rmanbak/arch_PORT_32ngh9nj_1_1 tag=BKARCH
channel ORA_DISK_1: restore complete, elapsed time: 00:04:44
channel ORA_DISK_1: starting archive log restore to user-specified destination
archive log destination=/u01/archive/
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18536
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15556
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15557
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18537
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15558
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18538
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15559
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15560
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15561
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18539
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15562
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15563
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15564
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18540
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15565
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18541
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18542
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15566
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15567
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18543
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15568
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18544
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15569
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18545
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15570
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18546
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15571
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18547
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15572
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18548
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15573
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18549
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15574
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18550
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15575
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18551
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15576
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18552
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15577
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15578
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18553
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18554
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15579
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15580
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18555
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15581
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15582
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15583
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18558
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15584
channel ORA_DISK_1: reading from backup piece /u01/rmanbak/arch_PORT_38ngjtue_1_1
channel ORA_DISK_1: restored backup piece 1
piece handle=/u01/rmanbak/arch_PORT_38ngjtue_1_1 tag=BKARCH
channel ORA_DISK_1: restore complete, elapsed time: 00:05:37
channel ORA_DISK_1: starting archive log restore to user-specified destination
archive log destination=/u01/archive/
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18559
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18560
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18561
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18562
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18563
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18564
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18565
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18566
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18567
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18568
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18569
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18570
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18571
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18572
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18573
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18574
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18575
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18576
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18577
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18578
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18579
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18580
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18581
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18582
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18583
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18584
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18585
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18586
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18587
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18588
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18589
channel ORA_DISK_1: reading from backup piece /u01/rmanbak/arch_PORT_3engmmm7_1_1
channel ORA_DISK_1: restored backup piece 1
piece handle=/u01/rmanbak/arch_PORT_3engmmm7_1_1 tag=BKARCH
channel ORA_DISK_1: restore complete, elapsed time: 00:03:34
channel ORA_DISK_1: starting archive log restore to user-specified destination
archive log destination=/u01/archive/
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15585
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15586
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15587
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15588
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15589
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15590
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15591
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15592
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15593
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15594
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15595
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15596
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15597
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15598
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15599
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15600
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15601
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15602
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15603
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15604
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15605
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15606
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15607
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15608
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15609
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18590
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18591
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15610
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18592
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18593
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18594
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15611
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15612
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15613
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18595
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15614
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15615
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15616
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18596
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18597
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15617
channel ORA_DISK_1: reading from backup piece /u01/rmanbak/arch_PORT_3fngmmq7_1_1
channel ORA_DISK_1: restored backup piece 1
piece handle=/u01/rmanbak/arch_PORT_3fngmmq7_1_1 tag=BKARCH
channel ORA_DISK_1: restore complete, elapsed time: 00:03:27
channel ORA_DISK_1: starting archive log restore to user-specified destination
archive log destination=/u01/archive/
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18598
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15618
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15619
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15620
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18599
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15621
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18600
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15622
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15623
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18601
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=18602
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=15624
channel ORA_DISK_1: reading from backup piece /u01/rmanbak/arch_PORT_3lngp6iv_1_1
channel ORA_DISK_1: restored backup piece 1
piece handle=/u01/rmanbak/arch_PORT_3lngp6iv_1_1 tag=BKARCH
channel ORA_DISK_1: restore complete, elapsed time: 00:01:05
Finished restore at 2012-07-23 10:51:08

RMAN> exit


Recovery Manager complete.

[oradba@oracle1 archive]$ ls -lt
total 14391064
-rw-r----- 1 oradba oinstall  27292672 Jul 23 10:51 1_18598_697238176.dbf
-rw-r----- 1 oradba oinstall   3275264 Jul 23 10:51 1_18601_697238176.dbf
-rw-r----- 1 oradba oinstall     45056 Jul 23 10:51 1_18602_697238176.dbf
-rw-r----- 1 oradba oinstall  99333632 Jul 23 10:51 2_15619_697238176.dbf
-rw-r----- 1 oradba oinstall  97739776 Jul 23 10:51 1_18599_697238176.dbf
-rw-r----- 1 oradba oinstall  97740800 Jul 23 10:51 2_15618_697238176.dbf
-rw-r----- 1 oradba oinstall  97740800 Jul 23 10:51 2_15620_697238176.dbf
-rw-r----- 1 oradba oinstall  97740800 Jul 23 10:51 2_15621_697238176.dbf
-rw-r----- 1 oradba oinstall  97740800 Jul 23 10:51 2_15622_697238176.dbf
-rw-r----- 1 oradba oinstall     83968 Jul 23 10:51 2_15624_697238176.dbf
-rw-r----- 1 oradba oinstall  97740800 Jul 23 10:51 1_18600_697238176.dbf
-rw-r----- 1 oradba oinstall  79453696 Jul 23 10:50 2_15623_697238176.dbf
-rw-r----- 1 oradba oinstall  97733632 Jul 23 10:50 2_15604_697238176.dbf
-rw-r----- 1 oradba oinstall  97733120 Jul 23 10:50 2_15608_697238176.dbf
-rw-r----- 1 oradba oinstall  97738240 Jul 23 10:50 1_18592_697238176.dbf
-rw-r----- 1 oradba oinstall  85894144 Jul 23 10:49 2_15596_697238176.dbf
-rw-r----- 1 oradba oinstall  72805376 Jul 23 10:49 1_18594_697238176.dbf
-rw-r----- 1 oradba oinstall  45745152 Jul 23 10:49 2_15610_697238176.dbf
-rw-r----- 1 oradba oinstall  28088832 Jul 23 10:49 2_15616_697238176.dbf
-rw-r----- 1 oradba oinstall     51200 Jul 23 10:49 1_18597_697238176.dbf
-rw-r----- 1 oradba oinstall     40960 Jul 23 10:49 2_15598_697238176.dbf
-rw-r----- 1 oradba oinstall    274432 Jul 23 10:49 2_15597_697238176.dbf
-rw-r----- 1 oradba oinstall    285696 Jul 23 10:49 2_15617_697238176.dbf
-rw-r----- 1 oradba oinstall    353792 Jul 23 10:49 2_15599_697238176.dbf
-rw-r----- 1 oradba oinstall    779264 Jul 23 10:49 2_15600_697238176.dbf
-rw-r----- 1 oradba oinstall   1589248 Jul 23 10:49 2_15601_697238176.dbf
-rw-r----- 1 oradba oinstall   2342400 Jul 23 10:49 1_18596_697238176.dbf
-rw-r----- 1 oradba oinstall   2344448 Jul 23 10:49 1_18595_697238176.dbf
-rw-r----- 1 oradba oinstall   4477440 Jul 23 10:49 2_15602_697238176.dbf
-rw-r----- 1 oradba oinstall  97739264 Jul 23 10:49 2_15595_697238176.dbf
-rw-r----- 1 oradba oinstall  97739264 Jul 23 10:49 1_18593_697238176.dbf
-rw-r----- 1 oradba oinstall  97739776 Jul 23 10:49 2_15605_697238176.dbf
-rw-r----- 1 oradba oinstall  97740288 Jul 23 10:49 1_18590_697238176.dbf
-rw-r----- 1 oradba oinstall  97739776 Jul 23 10:49 2_15603_697238176.dbf
-rw-r----- 1 oradba oinstall  97740800 Jul 23 10:49 2_15592_697238176.dbf
-rw-r----- 1 oradba oinstall  97740800 Jul 23 10:49 2_15611_697238176.dbf
-rw-r----- 1 oradba oinstall  97740800 Jul 23 10:49 2_15589_697238176.dbf
-rw-r----- 1 oradba oinstall  97740800 Jul 23 10:48 2_15588_697238176.dbf
-rw-r----- 1 oradba oinstall  97741824 Jul 23 10:48 2_15591_697238176.dbf
-rw-r----- 1 oradba oinstall  97741312 Jul 23 10:48 2_15593_697238176.dbf
-rw-r----- 1 oradba oinstall  97743872 Jul 23 10:48 1_18591_697238176.dbf
-rw-r----- 1 oradba oinstall  97743872 Jul 23 10:48 2_15585_697238176.dbf
-rw-r----- 1 oradba oinstall  97747456 Jul 23 10:48 2_15594_697238176.dbf
-rw-r----- 1 oradba oinstall  97744384 Jul 23 10:48 2_15607_697238176.dbf
-rw-r----- 1 oradba oinstall  97748480 Jul 23 10:48 2_15590_697238176.dbf
-rw-r----- 1 oradba oinstall 101799936 Jul 23 10:47 2_15612_697238176.dbf
-rw-r----- 1 oradba oinstall  99848704 Jul 23 10:47 2_15586_697238176.dbf
-rw-r----- 1 oradba oinstall  98941440 Jul 23 10:47 2_15613_697238176.dbf
-rw-r----- 1 oradba oinstall 100137472 Jul 23 10:47 2_15615_697238176.dbf
-rw-r----- 1 oradba oinstall  97766912 Jul 23 10:47 2_15606_697238176.dbf
-rw-r----- 1 oradba oinstall  97780224 Jul 23 10:47 2_15609_697238176.dbf
-rw-r----- 1 oradba oinstall  98243072 Jul 23 10:47 2_15614_697238176.dbf
-rw-r----- 1 oradba oinstall  97829376 Jul 23 10:47 2_15587_697238176.dbf
-rw-r----- 1 oradba oinstall  97735168 Jul 23 10:46 1_18572_697238176.dbf
-rw-r----- 1 oradba oinstall  97734144 Jul 23 10:46 1_18575_697238176.dbf
-rw-r----- 1 oradba oinstall  97734656 Jul 23 10:46 1_18576_697238176.dbf
-rw-r----- 1 oradba oinstall  97735168 Jul 23 10:46 1_18562_697238176.dbf
-rw-r----- 1 oradba oinstall  78765056 Jul 23 10:46 1_18560_697238176.dbf
-rw-r----- 1 oradba oinstall  76834304 Jul 23 10:46 1_18588_697238176.dbf
-rw-r----- 1 oradba oinstall  30535680 Jul 23 10:46 1_18559_697238176.dbf
-rw-r----- 1 oradba oinstall  97735680 Jul 23 10:45 1_18586_697238176.dbf
-rw-r----- 1 oradba oinstall  97736704 Jul 23 10:45 1_18589_697238176.dbf
-rw-r----- 1 oradba oinstall  97738240 Jul 23 10:45 1_18568_697238176.dbf
-rw-r----- 1 oradba oinstall  97738752 Jul 23 10:45 1_18580_697238176.dbf
-rw-r----- 1 oradba oinstall  97739776 Jul 23 10:45 1_18584_697238176.dbf
-rw-r----- 1 oradba oinstall  97739776 Jul 23 10:45 1_18585_697238176.dbf
-rw-r----- 1 oradba oinstall  97739264 Jul 23 10:45 1_18587_697238176.dbf
-rw-r----- 1 oradba oinstall  97740800 Jul 23 10:45 1_18583_697238176.dbf
-rw-r----- 1 oradba oinstall  97740800 Jul 23 10:45 1_18582_697238176.dbf
-rw-r----- 1 oradba oinstall  97740800 Jul 23 10:45 1_18581_697238176.dbf
-rw-r----- 1 oradba oinstall  97740800 Jul 23 10:45 1_18570_697238176.dbf
-rw-r----- 1 oradba oinstall  97740800 Jul 23 10:45 1_18573_697238176.dbf
-rw-r----- 1 oradba oinstall  97740800 Jul 23 10:45 1_18574_697238176.dbf
-rw-r----- 1 oradba oinstall  97740800 Jul 23 10:45 1_18565_697238176.dbf
-rw-r----- 1 oradba oinstall  97740800 Jul 23 10:45 1_18569_697238176.dbf
-rw-r----- 1 oradba oinstall  97740800 Jul 23 10:45 1_18564_697238176.dbf
-rw-r----- 1 oradba oinstall 104846336 Jul 23 10:44 1_18567_697238176.dbf
-rw-r----- 1 oradba oinstall 102509056 Jul 23 10:44 1_18566_697238176.dbf
-rw-r----- 1 oradba oinstall  97740800 Jul 23 10:44 1_18561_697238176.dbf
-rw-r----- 1 oradba oinstall  97741312 Jul 23 10:44 1_18563_697238176.dbf
-rw-r----- 1 oradba oinstall  97744384 Jul 23 10:44 1_18571_697238176.dbf
-rw-r----- 1 oradba oinstall  99038720 Jul 23 10:44 1_18579_697238176.dbf
-rw-r----- 1 oradba oinstall  97745408 Jul 23 10:44 1_18578_697238176.dbf
-rw-r----- 1 oradba oinstall  97749504 Jul 23 10:44 1_18577_697238176.dbf
-rw-r----- 1 oradba oinstall  81596928 Jul 23 10:42 1_18538_697238176.dbf
-rw-r----- 1 oradba oinstall  66624000 Jul 23 10:42 1_18554_697238176.dbf
-rw-r----- 1 oradba oinstall  55920640 Jul 23 10:42 1_18539_697238176.dbf
-rw-r----- 1 oradba oinstall  50135040 Jul 23 10:42 2_15579_697238176.dbf
-rw-r----- 1 oradba oinstall  27434496 Jul 23 10:42 2_15583_697238176.dbf
-rw-r----- 1 oradba oinstall      8704 Jul 23 10:42 1_18536_697238176.dbf
-rw-r----- 1 oradba oinstall   6733312 Jul 23 10:42 1_18555_697238176.dbf
-rw-r----- 1 oradba oinstall     77824 Jul 23 10:42 1_18558_697238176.dbf
-rw-r----- 1 oradba oinstall    111104 Jul 23 10:42 2_15584_697238176.dbf
-rw-r----- 1 oradba oinstall    316416 Jul 23 10:42 2_15556_697238176.dbf
-rw-r----- 1 oradba oinstall  97733120 Jul 23 10:42 1_18542_697238176.dbf
-rw-r----- 1 oradba oinstall  97735168 Jul 23 10:42 1_18548_697238176.dbf
-rw-r----- 1 oradba oinstall  97734144 Jul 23 10:42 2_15567_697238176.dbf
-rw-r----- 1 oradba oinstall  97739776 Jul 23 10:42 1_18545_697238176.dbf
-rw-r----- 1 oradba oinstall  97739776 Jul 23 10:42 2_15560_697238176.dbf
-rw-r----- 1 oradba oinstall  97737216 Jul 23 10:42 2_15568_697238176.dbf
-rw-r----- 1 oradba oinstall  97739776 Jul 23 10:42 2_15571_697238176.dbf
-rw-r----- 1 oradba oinstall  97740288 Jul 23 10:42 2_15564_697238176.dbf
-rw-r----- 1 oradba oinstall  97740288 Jul 23 10:41 2_15561_697238176.dbf
-rw-r----- 1 oradba oinstall  97740800 Jul 23 10:41 2_15582_697238176.dbf
-rw-r----- 1 oradba oinstall  97740800 Jul 23 10:41 2_15576_697238176.dbf
-rw-r----- 1 oradba oinstall  97740800 Jul 23 10:41 2_15572_697238176.dbf
-rw-r----- 1 oradba oinstall  97740800 Jul 23 10:41 2_15570_697238176.dbf
-rw-r----- 1 oradba oinstall  97740800 Jul 23 10:41 2_15566_697238176.dbf
-rw-r----- 1 oradba oinstall  97740800 Jul 23 10:41 2_15558_697238176.dbf
-rw-r----- 1 oradba oinstall  97740800 Jul 23 10:41 1_18552_697238176.dbf
-rw-r----- 1 oradba oinstall  97740800 Jul 23 10:40 1_18543_697238176.dbf
-rw-r----- 1 oradba oinstall  97740800 Jul 23 10:40 1_18551_697238176.dbf
-rw-r----- 1 oradba oinstall  97740800 Jul 23 10:40 1_18540_697238176.dbf
-rw-r----- 1 oradba oinstall  97740800 Jul 23 10:40 1_18537_697238176.dbf
-rw-r----- 1 oradba oinstall  97741312 Jul 23 10:40 2_15578_697238176.dbf
-rw-r----- 1 oradba oinstall  97741824 Jul 23 10:40 1_18550_697238176.dbf
-rw-r----- 1 oradba oinstall  97741824 Jul 23 10:40 2_15565_697238176.dbf
-rw-r----- 1 oradba oinstall  97742336 Jul 23 10:40 2_15574_697238176.dbf
-rw-r----- 1 oradba oinstall  97742848 Jul 23 10:39 1_18547_697238176.dbf
-rw-r----- 1 oradba oinstall  97744896 Jul 23 10:39 2_15580_697238176.dbf
-rw-r----- 1 oradba oinstall  97749504 Jul 23 10:39 1_18541_697238176.dbf
-rw-r----- 1 oradba oinstall  97752064 Jul 23 10:39 1_18553_697238176.dbf
-rw-r----- 1 oradba oinstall  97755136 Jul 23 10:39 2_15577_697238176.dbf
-rw-r----- 1 oradba oinstall  97758720 Jul 23 10:39 1_18546_697238176.dbf
-rw-r----- 1 oradba oinstall  97776640 Jul 23 10:39 1_18549_697238176.dbf
-rw-r----- 1 oradba oinstall  97792000 Jul 23 10:39 1_18544_697238176.dbf
-rw-r----- 1 oradba oinstall 102693888 Jul 23 10:38 2_15557_697238176.dbf
-rw-r----- 1 oradba oinstall 101197312 Jul 23 10:38 2_15559_697238176.dbf
-rw-r----- 1 oradba oinstall 101091328 Jul 23 10:38 2_15562_697238176.dbf
-rw-r----- 1 oradba oinstall  97792512 Jul 23 10:38 2_15563_697238176.dbf
-rw-r----- 1 oradba oinstall  97810432 Jul 23 10:38 2_15569_697238176.dbf
-rw-r----- 1 oradba oinstall  97890304 Jul 23 10:38 2_15573_697238176.dbf
-rw-r----- 1 oradba oinstall  97861120 Jul 23 10:38 2_15581_697238176.dbf
-rw-r----- 1 oradba oinstall  97959936 Jul 23 10:38 2_15575_697238176.dbf
-rw-r----- 1 oradba oinstall  97733120 Jul 23 10:37 2_15538_697238176.dbf
-rw-r----- 1 oradba oinstall  97734656 Jul 23 10:37 2_15541_697238176.dbf
-rw-r----- 1 oradba oinstall  16794112 Jul 23 10:36 2_15555_697238176.dbf
-rw-r----- 1 oradba oinstall  97740800 Jul 23 10:36 2_15544_697238176.dbf
-rw-r----- 1 oradba oinstall  97740800 Jul 23 10:36 2_15552_697238176.dbf
-rw-r----- 1 oradba oinstall  97740800 Jul 23 10:36 2_15553_697238176.dbf
-rw-r----- 1 oradba oinstall  97740800 Jul 23 10:36 2_15539_697238176.dbf
-rw-r----- 1 oradba oinstall  97741312 Jul 23 10:36 2_15551_697238176.dbf
-rw-r----- 1 oradba oinstall  97741312 Jul 23 10:35 2_15542_697238176.dbf
-rw-r----- 1 oradba oinstall  97741312 Jul 23 10:35 2_15546_697238176.dbf
-rw-r----- 1 oradba oinstall  97741312 Jul 23 10:35 2_15550_697238176.dbf
-rw-r----- 1 oradba oinstall  97741824 Jul 23 10:35 2_15545_697238176.dbf
-rw-r----- 1 oradba oinstall  97742336 Jul 23 10:35 2_15540_697238176.dbf
-rw-r----- 1 oradba oinstall  97742848 Jul 23 10:35 2_15548_697238176.dbf
-rw-r----- 1 oradba oinstall  97744896 Jul 23 10:35 2_15554_697238176.dbf
-rw-r----- 1 oradba oinstall  97745920 Jul 23 10:35 2_15537_697238176.dbf
-rw-r----- 1 oradba oinstall  97784320 Jul 23 10:33 2_15549_697238176.dbf
-rw-r----- 1 oradba oinstall  97812992 Jul 23 10:33 2_15543_697238176.dbf
-rw-r----- 1 oradba oinstall  97948672 Jul 23 10:33 2_15547_697238176.dbf
-rw-r----- 1 oradba oinstall  10761728 Jul 23 10:32 1_18535_697238176.dbf
-rw-r----- 1 oradba oinstall  53237760 Jul 23 10:32 1_18534_697238176.dbf
-rw-r----- 1 oradba oinstall  97740800 Jul 23 10:32 1_18532_697238176.dbf
-rw-r----- 1 oradba oinstall  97740800 Jul 23 10:32 1_18524_697238176.dbf
-rw-r----- 1 oradba oinstall  97740800 Jul 23 10:32 1_18525_697238176.dbf
-rw-r----- 1 oradba oinstall  97740800 Jul 23 10:31 1_18521_697238176.dbf
-rw-r----- 1 oradba oinstall  97741312 Jul 23 10:31 1_18530_697238176.dbf
-rw-r----- 1 oradba oinstall  97741312 Jul 23 10:30 1_18528_697238176.dbf
-rw-r----- 1 oradba oinstall  97741824 Jul 23 10:30 1_18531_697238176.dbf
-rw-r----- 1 oradba oinstall  97743360 Jul 23 10:30 1_18533_697238176.dbf
-rw-r----- 1 oradba oinstall  97745408 Jul 23 10:30 1_18527_697238176.dbf
-rw-r----- 1 oradba oinstall  97755648 Jul 23 10:30 1_18529_697238176.dbf
-rw-r----- 1 oradba oinstall  97783808 Jul 23 10:30 1_18520_697238176.dbf
-rw-r----- 1 oradba oinstall  97808384 Jul 23 10:30 1_18526_697238176.dbf
-rw-r----- 1 oradba oinstall  97817600 Jul 23 10:30 1_18523_697238176.dbf
-rw-r----- 1 oradba oinstall  98060288 Jul 23 10:29 1_18519_697238176.dbf
-rw-r----- 1 oradba oinstall  97869824 Jul 23 10:29 1_18522_697238176.dbf
-rw-r----- 1 oradba oinstall  97761280 Jul 23 10:27 1_18461_697238176.dbf
-rw-r----- 1 oradba oinstall  97768960 Jul 23 10:27 2_15473_697238176.dbf
-rw-r----- 1 oradba oinstall  98203136 Jul 23 10:27 2_15478_697238176.dbf
-rw-r----- 1 oradba oinstall  97779200 Jul 23 10:27 2_15472_697238176.dbf
-rw-r----- 1 oradba oinstall  97811968 Jul 23 10:27 1_18462_697238176.dbf
-rw-r----- 1 oradba oinstall   4445184 Jul 23 10:23 1_18557_697238176.dbf
-rw-r----- 1 oradba oinstall  82082304 Jul 23 10:11 1_18556_697238176.dbf
 


本文转自zylhsy 51CTO博客,原文链接:http://blog.51cto.com/yunlongzheng/940104,如需转载请自行联系原作者
相关文章
RMAN备份及恢复归档日志的语法
RMAN备份及恢复归档日志的语法
788 0
|
网络协议 Unix
dg rman 增量备份恢复
dg rman 增量备份恢复
110 0
|
数据库
rman 异机恢复
rman 异机恢复
102 0
|
监控
rman 恢复部分归档日志
rac 数据库在恢复部分归档日志的时候,需要指定数据库的线程编号。
1862 0
|
SQL otter 关系型数据库
|
Oracle 关系型数据库 数据库
|
Oracle 关系型数据库 Shell
|
Oracle 关系型数据库 数据库
[20160524]rman备份与检查点4.txt
[20160524]rman备份与检查点4.txt --链接: http://blog.itpub.net/267265/viewspace-2105221/ http://blog.
872 0
|
Oracle 关系型数据库 数据库
[20160523]rman备份与检查点3.txt
[20160523]rman备份与检查点3.txt --从前面的测试可以发现: --1.通过以上信息可以确定备份文件会写检查点. --2.而且备份文件是先写检查点,再做备份.
724 0
|
Oracle 关系型数据库 Linux
[20160523]rman备份与检查点2.txt
[20160523]rman备份与检查点2.txt --写过几篇关于检查点的文章,测试看看如果rman做备份时是否写检查点. 1.环境: SCOTT@book> @ &r/ver1 PORT_STRING         VERSION        B...
671 0

相关实验场景

更多