使用RMAN进行备份和恢复(二)

最新推荐文章于 2019-07-11 08:54:04 发布
最新推荐文章于 2019-07-11 08:54:04 发布
阅读量149 收藏
点赞数

使用RMAN常用命令的演示

[@more@]

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default

RMAN> report schema;

Report of database schema
File K-bytes Tablespace RB segs Datafile Name
---- ---------- -------------------- ------- -------------------
1 256000 SYSTEM YES /opt/oracle/localdata/system01.dbf
2 204800 UNDOTBS1 YES /opt/oracle/localdata/undotbs01.dbf
3 25600 INDX NO /opt/oracle/localdata/indx01.dbf
4 10240 TOOLS NO /opt/oracle/localdata/tools01.dbf
5 25600 USERS NO /opt/oracle/localdata/users01.dbf
6 512000 *** NO /opt/oracle/localdata/***.dbf
8 2097152 SD NO /opt/oracle/localdata/sd.dbf
9 3145728 WANG NO /opt/oracle/localdata/wang.dbf

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 270621 21-MAR-08
Backup Piece 270622 21-MAR-08 bk_ora_340_1_649942781
Backup Set 270638 21-MAR-08
Backup Piece 270639 21-MAR-08 al_ora_649943196_341_1
Backup Set 270644 21-MAR-08
Backup Piece 270645 21-MAR-08 c-3933374767-20080321-00


RMAN> report unrecoverable;

Report of files that need backup due to unrecoverable operations
File Type of Backup Required Name
---- ----------------------- -----------------------------------

############# show backup summary #############

RMAN> list backup summary;

List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Tag
------- -- -- - ----------- --------------- ------- ------- ---
270621 B 0 A SBT_TAPE 21-MAR-08 1 1 DB_LEVEL0
270638 B A A SBT_TAPE 21-MAR-08 1 1 TAG20080321T114636
270644 B F A SBT_TAPE 21-MAR-08 1 1
270690 B F A DISK 21-MAR-08 1 1
270698 B A A SBT_TAPE 21-MAR-08 1 1 TAG20080321T115856
270702 B F A SBT_TAPE 21-MAR-08 1 1
270939 B 0 A SBT_TAPE 21-MAR-08 1 1 DB_LEVEL0


############## show all backup ###############


RMAN>list backup;

S Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
277716 18M SBT_TAPE 00:02:32 08-APR-08
BP Key: 277717 Status: AVAILABLE Tag: TAG20080408T115101
Piece Name: al_ora_651498661_443_1

List of Archived Logs in backup set 277716
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 49 86502872 07-APR-08 86531859 07-APR-08
1 50 86531859 07-APR-08 86572453 08-APR-08

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
277721 Full 1M SBT_TAPE 00:00:30 08-APR-08
BP Key: 277722 Status: AVAILABLE Tag:
Piece Name: c-3933374767-20080408-00
SPFILE Included: Modification time: 21-MAR-08

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
278048 Incr 0 468M SBT_TAPE 00:01:56 08-APR-08
BP Key: 278049 Status: AVAILABLE Tag: DB_LEVEL0
Piece Name: bk_ora_445_1_651534652
List of Datafiles in backup set 278048
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 0 Incr 86601338 08-APR-08 /opt/oracle/***/system01.dbf
2 0 Incr 86601338 08-APR-08 /opt/oracle/***/undotbs01.dbf
3 0 Incr 86601338 08-APR-08 /opt/oracle/***/indx01.dbf
4 0 Incr 86601338 08-APR-08 /opt/oracle/***/tools01.dbf
5 0 Incr 86601338 08-APR-08 /opt/oracle/***/users01.dbf
6 0 Incr 86601338 08-APR-08 /opt/oracle/***/sXdgov.dbf
8 0 Incr 86601338 08-APR-08 /opt/oracle/***/sd.dbf
9 0 Incr 86601338 08-APR-08 /opt/oracle/***/wang.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
278059 Full 1M SBT_TAPE 00:00:29 08-APR-08
BP Key: 278060 Status: AVAILABLE Tag:
Piece Name: c-3933374767-20080408-01
SPFILE Included: Modification time: 21-MAR-08


############# show database backup ################

RMAN> list backup of database;


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

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
270621 Incr 0 487M SBT_TAPE 00:05:05 21-MAR-08
BP Key: 270622 Status: AVAILABLE Tag: DB_LEVEL0
Piece Name: bk_ora_340_1_649942781
List of Datafiles in backup set 270621
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 0 Incr 85213366 21-MAR-08 /opt/oracle/localdata/system01.dbf
2 0 Incr 85213366 21-MAR-08 /opt/oracle/localdata/undotbs01.dbf
3 0 Incr 85213366 21-MAR-08 /opt/oracle/localdata/indx01.dbf
4 0 Incr 85213366 21-MAR-08 /opt/oracle/localdata/tools01.dbf
5 0 Incr 85213366 21-MAR-08 /opt/oracle/localdata/users01.dbf
6 0 Incr 85213366 21-MAR-08 /opt/oracle/localdata/***.dbf
8 0 Incr 85213366 21-MAR-08 /opt/oracle/localdata/sd.dbf
9 0 Incr 85213366 21-MAR-08 /opt/oracle/localdata/wang.dbf

############## show controlfile ############

RMAN>list backup of controlfile;

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

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
274807 Full 1M DISK 00:00:00 31-MAR-08
BP Key: 274809 Status: AVAILABLE Tag:
Piece Name: /opt/oracle/product/9.2.0.4/dbs/c-3933374767-20080331-02
Controlfile Included: Ckp SCN: 86006674 Ckp time: 31-MAR-08

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
274835 Full 1M SBT_TAPE 00:00:29 31-MAR-08
BP Key: 274836 Status: AVAILABLE Tag:
Piece Name: c-3933374767-20080331-03
Controlfile Included: Ckp SCN: 86035866 Ckp time: 31-MAR-08


############## show spfile ###################

RMAN> list backup of spfile;

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
277721 Full 0 SBT_TAPE 00:00:30 08-APR-08
BP Key: 277722 Status: AVAILABLE Tag:
Piece Name: c-3933374767-20080408-00
SPFILE Included: Modification time: 21-MAR-08

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
278059 Full 0 SBT_TAPE 00:00:29 08-APR-08
BP Key: 278060 Status: AVAILABLE Tag:
Piece Name: c-3933374767-20080408-01
SPFILE Included: Modification time: 21-MAR-08


############ show archivelog all ################


RMAN> list backup of archivelog all;


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

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
270638 242K SBT_TAPE 00:01:36 21-MAR-08
BP Key: 270639 Status: AVAILABLE Tag: TAG20080321T114636
Piece Name: al_ora_649943196_341_1

List of Archived Logs in backup set 270638
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 1 85212794 21-MAR-08 85212998 21-MAR-08
1 2 85212998 21-MAR-08 85213363 21-MAR-08
1 3 85213363 21-MAR-08 85213707 21-MAR-08


############ show copy all ######################

RMAN> list copy;


List of Controlfile Copies
Key S Completion Time Ckp SCN Ckp Time Name
------- - --------------- ---------- --------------- ----
278172 A 09-APR-08 86601440 08-APR-08 /opt/oracle/backup_test.ctl
278170 A 09-APR-08 86601440 08-APR-08 /opt/oracle/

List of Archived Log Copies
Key Thrd Seq S Low Time Name
------- ---- ------- - --------- ----
270615 1 463 A 11-MAR-08 /opt/oracle/***/archive/1_463.dbf
278046 1 51 A 08-APR-08 /opt/oracle/***/archive/1_51.dbf


########### crosscheck all ###################

MAN> crosscheck backup;

using channel ORA_DISK_1
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/opt/oracle/product/9.2.0.4/dbs/c-3933374767-20080321-01 recid=329 stamp=649943581
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/opt/oracle/rman/20080324b7jc2k62 recid=342 stamp=650203331
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/opt/oracle/rman/bdjc2kgr_1_120080324 recid=343 stamp=650203675
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/opt/oracle/rman/bcjc2kgr_1_120080324 recid=344 stamp=650203675
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/opt/oracle/rman/bejc2kgr_1_120080324 recid=345 stamp=65020367

############## list expired archivelog ############

RMAN> list expired archivelog all;


List of Archived Log Copies
Key Thrd Seq S Low Time Name
------- ---- ------- - --------- ----
278191 1 52 X 08-APR-08 /opt/oracle/oradata/***/archive/1_52.dbf


########### list expired backup ##############

RMAN> list expired backup;


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

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
271884 Full 42M DISK 00:00:12 24-MAR-08
BP Key: 271891 Status: EXPIRED Tag: TAG20080324T120210
Piece Name: /opt/oracle/rman/20080324b7jc2k62
List of Datafiles in backup set 271884
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
3 Full 85427718 24-MAR-08 /opt/oracle/localdata/indx01.dbf
5 Full 85427718 24-MAR-08 /opt/oracle/localdata/users01.dbf
8 Full 85427718 24-MAR-08 /opt/oracle/localdata/sd.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
271885 Full 42M DISK 00:00:09 24-MAR-08
BP Key: 271892 Status: EXPIRED Tag: TAG20080324T120755
Piece Name: /opt/oracle/rman/bdjc2kgr_1_120080324
List of Datafiles in backup set 271885
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
3 Full 85428002 24-MAR-08 /opt/oracle/localdata/indx01.dbf
5 Full 85428002 24-MAR-08 /opt/oracle/localdata/users01.dbf
8 Full 85428002 24-MAR-08 /opt/oracle/localdata/sd.dbf

############ report obsolete ###############

MAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 270621 21-MAR-08
Backup Piece 270622 21-MAR-08 bk_ora_340_1_649942781
Backup Set 270638 21-MAR-08
Backup Piece 270639 21-MAR-08 al_ora_649943196_341_1
Backup Set 270644 21-MAR-08
Backup Piece 270645 21-MAR-08 c-3933374767-20080321-00

########## delete expired backup ################

RMAN> crosscheck backup;
RMAN> list expired backup;
RMAN> delete expired backup;

using channel ORA_DISK_1

List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
271891 271884 1 1 EXPIRED DISK /opt/oracle/rman/20080324b7jc2k62
271892 271885 1 1 EXPIRED DISK /opt/oracle/rman/bdjc2kgr_1_120080324
271893 271886 1 1 EXPIRED DISK /opt/oracle/rman/bcjc2kgr_1_120080324
271894 271887 1 1 EXPIRED DISK /opt/oracle/rman/bejc2kgr_1_120080324
275732 275730 1 1 EXPIRED DISK /opt/oracle/rman/rmanbakup***

Do you really want to delete the above objects (enter YES or NO)? y
deleted backup piece
backup piece handle=/opt/oracle/rman/20080324b7jc2k62 recid=342 stamp=650203331
deleted backup piece
backup piece handle=/opt/oracle/rman/bdjc2kgr_1_120080324 recid=343 stamp=650203675
deleted backup piece
backup piece handle=/opt/oracle/rman/bcjc2kgr_1_120080324 recid=344 stamp=650203675
deleted backup piece
backup piece handle=/opt/oracle/rman/bejc2kgr_1_120080324 recid=345 stamp=650203675
deleted backup piece
backup piece handle=/opt/oracle/rman/rmanbakup*** recid=395 stamp=650980801
Deleted 5 EXPIRED objects

########### delete expired archivelog ##############

RMAN> crosscheck archivelog all;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=19 devtype=DISK
validation succeeded for archived log
archive log filename=/opt/oracle/oradata/***/archive/1_463.dbf recid=469 stamp=649941833
validation succeeded for archived log
archive log filename=/opt/oracle/oradata/***/archive/1_51.dbf recid=520 stamp=651534651
validation failed for archived log
archive log filename=/opt/oracle/oradata/***/archive/1_52.dbf recid=521 stamp=651581447
Crosschecked 3 objects


RMAN> list expired archivelog all;


List of Archived Log Copies
Key Thrd Seq S Low Time Name
------- ---- ------- - --------- ----
278191 1 52 X 08-APR-08 /opt/oracle/oradata/***/archive/1_52.dbf

RMAN> delete expired archivelog all;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=19 devtype=DISK

List of Archived Log Copies
Key Thrd Seq S Low Time Name
------- ---- ------- - --------- ----
278191 1 52 X 08-APR-08 /opt/oracle/oradata/***/archive/1_52.dbf

Do you really want to delete the above objects (enter YES or NO)? y
deleted archive log
archive log filename=/opt/oracle/oradata/***/archive/1_52.dbf recid=521 stamp=651581447
Deleted 1 EXPIRED objects

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/216109/viewspace-1002140/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/216109/viewspace-1002140/

cl298810871
关注
使用RMAN进行备份和恢复的常用命令介绍
03-04
在本文中，我们将深入探讨RMAN的一些常用命令，帮助你更好地理解和使用RMAN进行数据库管理。 首先，连接到目标数据库是RMAN操作的基础。你可以通过以下命令不使用恢复目录数据库直接连接到目标数据库： ```sql ...
Oracle 11g R2 Rman备份与恢复_刘耀龙的博客-优快云博客_rman备份.pdf
09-13
Oracle 11g R2 的 RMAN (Recovery Manager) 是 Oracle 数据库管理系统中的一个关键工具，主要用于数据库的备份和恢复。RMAN 提供了一种高效且灵活的方式来管理和保护数据库，确保在数据丢失或系统故障时能够快速恢复...
RMAN 配置归档日志删除策略
乐沙弥的世界
11-12 2万+
Oracle 11g中对于归档日志的删除，除了遵循RMAN保留策略外，也可以通过RMAN来配置归档日志的删除策略，也就是归档日志何时可以被删除。归档日志删除策略适用于所有归档位置(使用快速闪回区FRA/不使用FRA)。本文主要描述归档日志删除策略并给出了具体的演示。 1、关于归档日志删除策略      也就是哪些归档日志符合删除策略能够被删除，如前所述，归档位置适用于所有归档位置(使用快速闪回区F
crosscheck archivelog all;crosscheck backup of区别
乡下人
05-14 6257
crosscheck archivelog all; 验证的是DB的归档日志即log_archive_dest参数指定位置的文件，当手工删除了归档日志以后，Rman备份会检测到日志缺失，从而无法进一步继续执行。 所以此时需要手工执行crosscheck过程，之后Rman备份可以恢复正常。 RMAN> crosscheck archivelog all; 释放的通道: ORA_DISK
RMAN crosscheck archivelog all; 失败！
07-11 1997
今天碰到了一个怪问题，明明archivelog 备份成功，可是crosscheck的时候去显示 对归档日志的验证失败，到网上搜了一下，发现是NLS_LANG的问题，set NLS_LANG=AMERICAN_AMERICA.ZH...
backup archivelog all 和plus archivelog
乡下人
05-14 7820
OLTP系统的生产库一般都是打开归档模式，当CUD操作频繁并且时常使用大批量处理时，每天的归档日志也是超级大的，如果长期保留这些归档日志磁盘空间消耗是很恐怖的，所以我们在使用RMAN进行数据库备份时，将归档日志进行备份，来释放磁盘空间。 备份归档日志方式：   单独备份归档日志：backup archivelog all   在执行备库时一起备份归档日志：backup datab
ORACLE——RMAN 参数解读
weixin_34192816的博客
07-04 403
查看默认rman配置参数 oracle用户下登录rman：rman target / 查看所有配置参数详情：show all show all的第一行：using target database control file instead of recovery catalog，指的是使用目标数据库控制文件代替恢复目录 备份记录的两种模式catalog和nocatlog，参考...
windows下的oracle数据库rman自动备份和恢复.pdf
10-12
RMAN具有独特的优势，例如跳过未使用的数据块，当备份一个RMAN备份集时，RMAN不会备份从未被写入的数据块。 二、系统规划 在进行备份和恢复之前，需要进行系统规划，包括创建备份文件夹、归档日志文件夹等。同时，...
Oracle19c rac备份数据通过rman恢复到单实例
最新发布
07-02
在进行Oracle 19c RAC（Real Application Clusters）数据库的数据备份与恢复操作时，可能会遇到需要将RAC集群环境下的备份数据恢复到单实例环境中的场景。这种情况下，RMAN（Recovery Manager）作为Oracle提供的强大...
傻瓜式实战OracleRMAN数据库备份和恢复视频
07-23
教程名称：傻瓜式实战Oracle RMAN数据库备份和恢复视频课程目录：【】数据库备份和恢复系列].ITBOBA_RMAN_1【】数据库备份和恢复系列].ITBOBA_RMAN_10【】数据库备份和恢复系列].ITBOBA_RMAN_2【】数据库备份和恢复...
如何搭建RMAN备份平台
长亭路
04-07 291
原 如何 搭建 RMAN 备份平台https://blog.youkuaiyun.com/tianlesoftware/article/details/5740896版权声明： https://blog.youkuaiyun.com/tianlesoftware/article/details/5740896 一． RMAN 的一些理论知识 RMAN Catalog 和 Nocatalog 的区别 http://b...
delete archivelog all 无法彻底删除归档日志？
乐沙弥的世界
12-01 1万+
最近在因归档日志暴增，使用delete archivelog all貌似无法清除所有的归档日志，到底是什么原因呢？1、演示环境 SQL> select * from v$version where rownum<2; BANNER ---------------------------------------------------------------- Oracle Databa
一些FREEBSD 的常用知识
10-10 821
来源：http://www.phpchina.com/1220/viewspace_9752.html1、在 unix-like 中档案结构是满重要的，那么要如何去看相关档案目录结构的说明呢？ 难道是 cd 到每个目录下吗？其实有更好的方法.. 那就是用好男人 man 来看： # man hier 2、在 console 下操作时，由于屏幕显示有限，有时需看前面显示的资料，这时
RMAN备份与恢复（新旧控制文件及归档日志）测试（叙）
cri5768的博客
06-09 198
（我的学习过程） 继上一次做的试验，过后我又思考了下，当然其中的4点结论没有问题，但是却忽略了一点，上次的试验证明了在不使用恢复目录的情况下，做恢复时使用的归档重做日志文件只能是在控制文件中有记录的，backup format...
Oracle RMAN 的 show,list,crosscheck,delete命令整理
clke32966的博客
09-08 133
1、SHOW命令：显示rman配置： RMAN> show all;[@more@]Oracle RMAN 的 show,list,crosscheck,delete命令整理1、SHOW命令：显示rman配置： RMAN&...
android.mk中LOCAL_MODULE_TAGS说明
sunnylgz
12-19 1万+
转自http://blog.youkuaiyun.com/evilcode/article/details/6459299 LOCAL_MODULE_TAGS ：=user eng tests optional user: 指该模块只在user版本下才编译 eng: 指该模块只在eng版本下才编译 tests: 指该模块只在tests版本下才编译 optional:指该模块在所有
/etc/hosts.allow 限制ip登陆很好使
热门推荐
12-30 9万+
/etc/hosts.allow  用来限制服务器允许执行的ip登陆感觉比防火墙方便很多。 就像是 限制特定IP来访 想法 看起来通常的做法是利用hosts的拒绝设置，而它的设置是针对某一个具体的进程，具体的服务，在这里就是sshd了看起来设置一个网段使用的是 x.x.x.0/24 后面加个24真是有趣，是保持所有的可能性吗 上面的方法看起来
Linux中LANG,LC_ALL,local详解
z4213489的专栏
09-03 4万+
locale 是国际化与本土化过程中的一个非常重要的概念，个人认为，对于中文用户来说，通常会涉及到的国际化或者本土化，大致包含三个方面：看中文，写中文，与 window中文系统的兼容和通信。从实际经验上看来，locale的设定与看中文关系不大，但是与写中文，及window分区的挂载方式有很密切的关系。本人认为就像一个纯英文的Windows能够浏览中文，日文或者意大利文网页一样，你不需要设定loca
"使用Oracle RMAN备份和恢复管理器进行数据库备份和恢复操作
4. RMAN还提供了其他功能，例如增量备份、增量恢复、备份集合和备份优化等，可以根据具体需求进行配置和使用。 总之，通过启动Oracle的归档日志功能并使用RMAN进行备份，可以保证数据库的数据安全性和可靠性。备份...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值