rman maintains

来源：互联网发布：mysql有哪些内置的表编辑：程序博客网时间：2024/04/28 20:26

RMAN> list backup;

List of Backup Sets
===================

BS Key Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
9       62.61M     DISK        00:00:03     06-JUN-09
        BP Key: 9   Status: AVAILABLE Compressed: NO Tag: TAG20090606T215250
        Piece Name: /u01/logbk_20090606_09kguadi_1_1.bak

List of Archived Logs in backup set 9
Thrd Seq     Low SCN    Low Time Next SCN   Next Time
---- ------- ---------- --------- ---------- ---------
1    14      585130     05-JUN-09 590397     05-JUN-09
1    15      590397     05-JUN-09 591388     05-JUN-09
1    16      591388     05-JUN-09 592971     05-JUN-09
1    17      592971     05-JUN-09 599670     06-JUN-09
1    18      599670     06-JUN-09 607984     06-JUN-09
1    19      607984     06-JUN-09 611270     06-JUN-09
1    20      611270     06-JUN-09 611948     06-JUN-09
1    21      611948     06-JUN-09 612948     06-JUN-09
1    22      612948     06-JUN-09 618237     06-JUN-09
1    23      618237     06-JUN-09 626505     06-JUN-09
1    24      626505     06-JUN-09 634330     06-JUN-09
1    25      634330     06-JUN-09 641722     06-JUN-09
1    26      641722     06-JUN-09 646110     06-JUN-09
1    27      646110     06-JUN-09 646121     06-JUN-09
1    28      646121     06-JUN-09 646365     06-JUN-09
1    29      646365     06-JUN-09 646374     06-JUN-09
1    30      646374     06-JUN-09 646385     06-JUN-09
1    31      646385     06-JUN-09 646392     06-JUN-09
1    32      646392     06-JUN-09 647177     06-JUN-09
1    33      647177     06-JUN-09 647181     06-JUN-09
1    34      647181     06-JUN-09 647187     06-JUN-09
1    35      647187     06-JUN-09 647792     06-JUN-09
1    36      647792     06-JUN-09 647891     06-JUN-09

BS Key Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
10      Full    368.00K    DISK        00:00:02     06-JUN-09
        BP Key: 10   Status: AVAILABLE Compressed: NO Tag: TAG20090606T220333
        Piece Name: /u01/db_bk_20090606_0dkgub1m_1_1.bak
List of Datafiles in backup set 10
File LV Type Ckp SCN    Ckp Time Name
---- -- ---- ---------- --------- ----
4       Full 648469     06-JUN-09 /u01/oradata/orcl/users01.dbf

BS Key Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
11      Full    6.80M      DISK        00:00:03     06-JUN-09
        BP Key: 11   Status: AVAILABLE Compressed: NO Tag: TAG20090606T220333
        Piece Name: /u01/db_bk_20090606_0ekgub1q_1_1.bak
Control File Included: Ckp SCN: 648471       Ckp time: 06-JUN-09

BS Key Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
12      Full    17.09M     DISK        00:00:07     06-JUN-09
        BP Key: 12   Status: AVAILABLE Compressed: NO Tag: TAG20090606T220333
        Piece Name: /u01/db_bk_20090606_0ckgub1m_1_1.bak
List of Datafiles in backup set 12
File LV Type Ckp SCN    Ckp Time Name
---- -- ---- ---------- --------- ----
2       Full 648468     06-JUN-09 /u01/oradata/orcl/undotbs01.dbf

BS Key Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
13      Full    80.00K     DISK        00:00:01     06-JUN-09
        BP Key: 13   Status: AVAILABLE Compressed: NO Tag: TAG20090606T220333
        Piece Name: /u01/db_bk_20090606_0fkgub21_1_1.bak
SPFILE Included: Modification time: 04-JUN-09

BS Key Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
14      Full    159.05M    DISK        00:00:29     06-JUN-09
        BP Key: 14   Status: AVAILABLE Compressed: NO Tag: TAG20090606T220333
        Piece Name: /u01/db_bk_20090606_0bkgub1m_1_1.bak
List of Datafiles in backup set 14
File LV Type Ckp SCN    Ckp Time Name
---- -- ---- ---------- --------- ----
3       Full 648467     06-JUN-09 /u01/oradata/orcl/sysaux01.dbf

BS Key Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
15      Full    352.48M    DISK        00:00:39     06-JUN-09
        BP Key: 15   Status: AVAILABLE Compressed: NO Tag: TAG20090606T220333
        Piece Name: /u01/db_bk_20090606_0akgub1m_1_1.bak
List of Datafiles in backup set 15
File LV Type Ckp SCN    Ckp Time Name
---- -- ---- ---------- --------- ----
1       Full 648466     06-JUN-09 /u01/oradata/orcl/system01.dbf

BS Key Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
16      Full    6.80M      DISK        00:00:00     06-JUN-09
        BP Key: 16   Status: AVAILABLE Compressed: NO Tag: TAG20090606T220818
        Piece Name: /u01/control_bk_20090606_0gkgubai_1_1.bak
Control File Included: Ckp SCN: 648603       Ckp time: 06-JUN-09

RMAN> host;

[oracle@oracle10g log]$ rm -rf /u01/logbk_20090606_09kguadi_1_1.bak
[oracle@oracle10g log]$ exit
exit
host command complete

RMAN> list backup;

List of Backup Sets
===================

RMAN> crosscheck backup;

allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=143 devtype=DISK
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/logbk_20090606_09kguadi_1_1.bak recid=9 stamp=688859572
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/db_bk_20090606_0dkgub1m_1_1.bak recid=10 stamp=688860215
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/db_bk_20090606_0ekgub1q_1_1.bak recid=11 stamp=688860218
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/db_bk_20090606_0ckgub1m_1_1.bak recid=12 stamp=688860215
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/db_bk_20090606_0fkgub21_1_1.bak recid=13 stamp=688860225
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/db_bk_20090606_0bkgub1m_1_1.bak recid=14 stamp=688860214
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/db_bk_20090606_0akgub1m_1_1.bak recid=15 stamp=688860214
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/control_bk_20090606_0gkgubai_1_1.bak recid=16 stamp=688860498
Crosschecked 8 objects

RMAN> list expired backup;

List of Backup Sets
===================

BS Key Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
9       62.61M     DISK        00:00:03     06-JUN-09
        BP Key: 9   Status: EXPIRED Compressed: NO Tag: TAG20090606T215250
        Piece Name: /u01/logbk_20090606_09kguadi_1_1.bak

RMAN> delete expired backup;

using channel ORA_DISK_1

List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
9 9 1 1 EXPIRED DISK /u01/logbk_20090606_09kguadi_1_1.bak

Do you really want to delete the above objects (enter YES or NO)? YES
deleted backup piece
backup piece handle=/u01/logbk_20090606_09kguadi_1_1.bak recid=9 stamp=688859572
Deleted 1 EXPIRED objects

RMAN> list backup;

List of Backup Sets
===================

RMAN>