无RMAN备份集情况下的坏块恢复(2)


BS Key  Type LV Size      Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
303    Full    164.91M    DISK        00:01:52    2014-11-21   
        BP Key: 303  Status: AVAILABLE  Compressed: YES  Tag: DB_BAK
        Piece Name: /u01/orabackup/backupsets/ora10g-4175411955_20141121_864227354_352.db
  List of Datafiles in backup set 303
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- ---------- ----
  1      Full 1260226    2014-11-21 /u01/app/oracle/oradata/ora10g/system01.dbf
  2      Full 1260226    2014-11-21 /u01/app/oracle/oradata/ora10g/undotbs01.dbf
  3      Full 1260226    2014-11-21 /u01/app/oracle/oradata/ora10g/sysaux01.dbf
  4      Full 1260226    2014-11-21 /u01/app/oracle/oradata/ora10g/users01.dbf
  5      Full 1260226    2014-11-21 /u01/app/oracle/oradata/ora10g/example01.dbf
  6      Full 1260226    2014-11-21 /u01/app/oracle/oradata/ora10g/zlm01.dbf


BS Key  Size      Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
304    19.50K    DISK        00:00:01    2014-11-21   
        BP Key: 304  Status: AVAILABLE  Compressed: YES  Tag: ARC_BAK
        Piece Name: /u01/orabackup/backupsets/ora10g-4175411955_20141121_864227471_353.arc


  List of Archived Logs in backup set 304
  Thrd Seq    Low SCN    Low Time  Next SCN  Next Time
  ---- ------- ---------- ---------- ---------- ---------
  1    44      1260208    2014-11-21 1260277    2014-11-21


BS Key  Type LV Size      Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
305    Full    7.23M      DISK        00:00:01    2014-11-21   
        BP Key: 305  Status: AVAILABLE  Compressed: NO  Tag: TAG20141121T151114
        Piece Name: /u01/orabackup/backupsets/ora10g-c-4175411955-20141121-04.ctl
  Control File Included: Ckp SCN: 1260283      Ckp time: 2014-11-21
  SPFILE Included: Modification time: 2014-11-21


RMAN> exit


Recovery Manager complete.
[oracle@ora10g ~]$ cd /u01/orabackup/backupsets/
[oracle@ora10g backupsets]$ ll -lrth
total 215M
-rw-r----- 1 oracle oinstall  43M Nov 21 15:09 ora10g-4175411955_20141121_864227317_351.arc
-rw-r----- 1 oracle oinstall 165M Nov 21 15:11 ora10g-4175411955_20141121_864227354_352.db
-rw-r----- 1 oracle oinstall  20K Nov 21 15:11 ora10g-4175411955_20141121_864227471_353.arc
-rw-r----- 1 oracle oinstall 7.3M Nov 21 15:11 ora10g-c-4175411955-20141121-04.ctl


--删除RMAN备份集
[oracle@ora10g backupsets]$ rm -f *
[oracle@ora10g backupsets]$ rman target /


Recovery Manager: Release 10.2.0.1.0 - Production on 16 16:07:59 2014


Copyright (c) 1982, 2005, Oracle.  All rights reserved.


connected to target database: ORA10G (DBID=4175411955)


RMAN> crosscheck backup;

using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=154 devtype=DISK
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/flash_recovery_area/ORA10G/backupset/2014_11_12/o1_mf_nnndf_TAG20141112T141548_b65yrnkg_.bkp recid=286 stamp=863446548
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/orabackup/backupsets/ora10g-4175411955_20141121_864227317_351.arc recid=302 stamp=864227318
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/orabackup/backupsets/ora10g-4175411955_20141121_864227354_352.db recid=303 stamp=864227356
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/orabackup/backupsets/ora10g-4175411955_20141121_864227471_353.arc recid=304 stamp=864227472
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/orabackup/backupsets/ora10g-c-4175411955-20141121-04.ctl recid=305 stamp=864227475
Crosschecked 5 objects


RMAN> delete noprompt expired backupset;


using channel ORA_DISK_1

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/6d29b0b5cd7132448789a378b02e4a73.html