Oracle辅导：如何清理RMAN备份数据中的过期数据

会计考友

　好几天没开VM进修ORACLE
/ R6 L( l9 t$ k' C; X) A* f0 o　　今天启动呈现下面错误：
　　[root@web1 bdump]# pwd
　　/opt/oracle/admin/testdb2/bdump
　　[root@web1 bdump]# cat alert_oradb.log
( d& T: t  {. Z* _' P7 D4 V　　undo_tablespace = UNDOTBS1
　　remote_login_passwordfile= EXCLUSIVE
5 w; `4 ~; E* J8 l. t" s. K* s　　db_domain =
0 j. d! x7 h$ O! _" e3 w  i　　dispatchers = (PROTOCOL=TCP) (SERVICE=testdb2XDB)
　　job_queue_processes = 10
　　background_dump_dest = /opt/oracle/admin/testdb2/bdump
　　user_dump_dest = /opt/oracle/admin/testdb2/udump
　　core_dump_dest = /opt/oracle/admin/testdb2/cdump
/ w8 q2 m2 F( ?$ d: f, c　　audit_file_dest = /opt/oracle/admin/testdb2/adump
. ?9 c2 H7 W- M' V4 a: j9 k　　db_name = testdb2
$ }: I8 [6 S$ k; G  b' Z4 W　　open_cursors = 300
) s  @* r, P  Q) s" V5 t　　pga_aggregate_target = 16777216
　　MMAN started with pid=4, OS id=3760
　　PSP0 started with pid=3, OS id=3758
　　PMON started with pid=2, OS id=3756
) r8 ^" n/ t' z+ A  O) V　　LGWR started with pid=6, OS id=3764
　　DBW0 started with pid=5, OS id=3762
　　CKPT started with pid=7, OS id=3766
( n+ @: d# _9 o- z3 j　　SMON started with pid=8, OS id=3768
1 P/ @6 N) o: k9 n3 K" {. ?* D　　RECO started with pid=9, OS id=3770
, }8 o; k: c9 w( i# f　　CJQ0 started with pid=10, OS id=3772
　　MMON started with pid=11, OS id=3774
# A4 l) d9 @/ j9 O# P6 s　　Fri Aug 21 07:51:00 2009
4 b8 M0 s0 I/ e8 o$ D! ]$ y6 L　　starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
　　MMNL started with pid=12, OS id=3776
3 V) ~6 i8 o2 W: {! `  Z8 R# k　　Fri Aug 21 07:51:00 2009
　　starting up 1 shared server(s) ...
* q/ K8 A  v1 E- Z. k9 B; k: j　　Fri Aug 21 07:51:01 2009
, q% ~/ v. Q8 V, e* g! J2 U　　ALTER DATABASE MOUNT
- s  ^  V. L$ @' }　　Fri Aug 21 07:51:05 2009
" a( r0 s  s) X3 ^. Y　　Setting recovery target incarnation to 5
5 f% b9 c1 @" @% ]1 s8 E  a3 E　　Fri Aug 21 07:51:05 2009
　　Successful mount of redo thread 1, with mount id 1017141349
　　Fri Aug 21 07:51:05 2009
5 |# c& ]; b4 Z# H. N: ?' W　　Database mounted in Exclusive Mode
　　Completed: ALTER DATABASE MOUNT
　　Fri Aug 21 07:51:05 2009
　　ALTER DATABASE OPEN
8 A" G6 O; B% s1 i# S) M; G　　Fri Aug 21 07:51:06 2009
　　LGWR: STARTING ARCH PROCESSES
　　ARC0 started with pid=16, OS id=3784
　　Fri Aug 21 07:51:06 2009
( O0 V0 D# d% f, [8 f; F! ^　　ARC0: Archival started
8 r0 j4 X& D( X) Q) j: D　　ARC1: Archival started
8 z, t. |0 l; y/ [$ T' ]. M　　LGWR: STARTING ARCH PROCESSES COMPLETE
% q5 k" M, v, F4 B( T% P5 _; l　　ARC1 started with pid=17, OS id=3786
　　Fri Aug 21 07:51:06 2009
; I0 O; P4 n5 Y( [3 `5 |　　ARC0: STARTING ARCH PROCESSES
3 b3 F  h$ N* S8 M% ~1 |) b　　Fri Aug 21 07:51:06 2009
4 |- g! P3 T6 I. R$ H　　ARC1: Becoming the 'no FAL' ARCH
　　ARC1: Becoming the 'no SRL' ARCH
　　Fri Aug 21 07:51:06 2009
　　Thread 1 opened at log sequence 14
3 \8 {, V& U8 z4 J　　Current log# 1 seq# 14 mem# 0: /oradata/testdb2/redo01.log
　　Successful open of redo thread 1
　　Fri Aug 21 07:51:06 2009
/ w! T& A1 }) ^, w* n5 |　　MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
　　Fri Aug 21 07:51:06 2009
　　SMON: enabling cache recovery
% y9 r0 r+ r0 W9 p7 f　　Fri Aug 21 07:51:06 2009
　　ARC2: Archival started
5 v1 o$ S0 Z% ?4 B　　ARC0: STARTING ARCH PROCESSES COMPLETE
1 B) [, Y6 c" c/ s  s8 g) d　　ARC0: Becoming the heartbeat ARCH
　　ARC2 started with pid=18, OS id=3788
　　Fri Aug 21 07:51:08 2009
/ r9 k0 u) J4 ?  C" G　　Successfully onlined Undo Tablespace 1.
　　Fri Aug 21 07:51:08 2009
/ f0 G( h) m) R4 y0 l1 |　　SMON: enabling tx recovery
　　Fri Aug 21 07:51:08 2009
2 d& V' o( \" h* g　　Database Characterset is WE8ISO8859P1
　　replication_dependency_tracking turned off (no async multimaster replication found)
) M5 v  p( B- Y% D* d+ t　　Starting background process QMNC
: O0 Y. H  R) {2 ^　　QMNC started with pid=19, OS id=3790
　　Fri Aug 21 07:51:16 2009
. j) i' ~1 u- m8 G# F# O, s　　Completed: ALTER DATABASE OPEN
" d  x* S2 C* N1 L7 B: p　　Fri Aug 21 07:51:17 2009