`

rman maintains

 
阅读更多

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
===================

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> 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

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

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
===================

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>

分享到：
| exp schema && imp schema
评论
发表评论

您还没有登录,请您登录后再发表评论

相关推荐

    一步一步学RMAN oracle备份RMAN使用教程

    一、进入rman 二、rman命令知多少 三、rman备份演练初级篇 四、rman备份演练进阶篇 五、rman外传-基础资料篇1 六、实战rman备份 七、rman外传-基础资料篇2 八、演练rman恢复 九、实战rman恢复(1)丢失控制文件的恢复 ...

    RMAN数据库备份详解

    RMAN 数据库备份详解 本文详细讲解了 RMAN 的备份机制以及如何备份，涵盖了数据库备份和 RMAN 备份的概念、RMAN 备份的类型、备份集和镜像副本、备份路径、备份限制等知识点。 一、数据库备份与 RMAN 备份的概念 ...

    手把手教你ORACLE RMAN异地备份

    "手把手教你ORACLE RMAN异地备份" 该教程旨在教你如何使用ORACLE RMAN实现异地备份，解决了由于数据量急剧增加、备份和恢复的困难问题。通过使用RMAN和EXP/IMP工具，用户可以实现本地数据库的异地备份，避免服务器...

    [三思笔记] 一步一步学RMAN

    [三思笔记]一步一步学rman 一、进入rman 二、rman命令知多少 三、rman备份演练初级篇 四、rman备份演练进阶篇 五、rman外传-基础资料篇1 六、实战rman备份 七、rman外传-基础资料篇2 八、演练rman恢复 九、实战rman...

    RMAN备份脚本（详细）

    RMAN（Recovery Manager）是Oracle数据库管理系统中的一个重要工具，用于执行数据库的备份、恢复以及维护操作。在Oracle环境中，DBA（数据库管理员）经常使用RMAN来确保数据的安全性和可恢复性。以下是对"RMAN备份...

    RMAN备份命令详解

    RMAN备份命令详解 RMAN（Recovery Manager）是Oracle数据库备份和恢复的工具，提供了多种备份方式和恢复选项。下面是RMAN备份命令的详细解释： 一、切换服务器归档模式 在开始备份之前，需要切换服务器到归档模式...

    RMAN快速入门指南

    RMAN（Recovery Manager）是Oracle数据库管理系统中的一个重要工具，专为数据库备份、恢复和维护设计。本快速入门指南将帮助你理解RMAN的基础知识，包括它的功能、使用方法以及如何进行有效的数据库备份策略。 一、...

    一步一步学RMAN进入rman[1].zip

    RMAN，全称为Recovery Manager，是Oracle数据库管理系统中的一个重要工具，主要用于数据库的备份与恢复操作。本套学习资料“一步一步学RMAN进入rman[1].zip”包含了一系列的文档，旨在帮助初学者逐步掌握RMAN的使用...

    [三思笔记]一步一步学RMAN

    《[三思笔记]一步一步学rman(01)-进入rman.doc》 《[三思笔记]一步一步学rman(02)-rman命令知多少.doc》 《[三思笔记]一步一步学rman(03)-rman备份演练初级篇.doc》 《[三思笔记]一步一步学rman(04)-rman备份演练...

    rman参考手册 rman参考PDF

    《RMAN参考手册》是Oracle数据库管理员的重要工具书，它详细介绍了恢复管理器（RMAN）的使用方法和各种操作。RMAN是Oracle数据库提供的一个内置工具，专门用于数据库备份、恢复以及性能优化。以下是对RMAN核心知识点...

    RMAN参考手册.pdf

    RMAN（Recovery Manager）是Oracle数据库提供的一个用于数据库备份、恢复以及迁移的工具。它能够备份和恢复Oracle数据库中的数据文件、控制文件、参数文件和归档日志文件等关键组件。RMAN可以与目标数据库进行通信，...

    Oracle 11g R2 Rman备份与恢复_刘耀龙的博客-CSDN博客_rman备份.pdf

    Oracle 11g R2 的 RMAN (Recovery Manager) 是 Oracle 数据库管理系统中的一个关键工具，主要用于数据库的备份和恢复。RMAN 提供了一种高效且灵活的方式来管理和保护数据库，确保在数据丢失或系统故障时能够快速恢复...

    RMAN 最权威的rman官方文档

    ### RMAN：Oracle数据库备份与恢复的高级指南 #### 一、引言 RMAN（Recovery Manager）是Oracle数据库管理工具集中的一个关键组成部分，主要用于实现高效且可靠的备份、恢复以及灾难恢复策略。根据提供的文件信息...

    oracle rman命令详解

    ### Oracle RMAN 命令详解 #### 一、RMAN 概述 RMAN (Recovery Manager) 是 Oracle 提供的一种强大而灵活的工具，主要用于数据库备份与恢复。RMAN 支持多种类型的命令，主要包括独立命令和作业命令。 - **独立...

    RMAN备份与恢复

    RMAN 备份与恢复 RMAN（Recovery Manager）是 Oracle 官方提供的一种备份和恢复工具，旨在帮助数据库管理员快速、可靠地备份和恢复数据库。下面将详细介绍 RMAN 备份与恢复的相关知识点。 一、RMAN 连接 RMAN ...

    RMAN 老师的经典

    根据提供的信息，“RMAN 老师的经典”这一标题似乎是指某个关于RMAN（Recovery Manager）的主题或教程，而“经典私人”这部分可能是指该内容是某位老师私授的经验或者是一些非常有价值的经典案例。然而，由于描述...

Magicbox
Global site tag (gtag.js) - Google Analytics