查看: 1837|回复: 1

[备份恢复] 关于自动备份的问题

[复制链接]
论坛徽章:
0
发表于 2014-2-25 19:22 | 显示全部楼层 |阅读模式
1、用catalog可以看到两个备份文件没有注册,可是貌似注册不了,没有任何错误提示,用list也看不到。
2、11.2版本开启自动控制文件备份之后,改变数据结构M000会备份控制文件吗,怎么我都等了一天了也没见自动备份啊,好奇怪的说!
以上两个问题不知道有没有大大知道答案啊,求赐教。
-------------------------
操作系统是:Linux babihoo 2.6.9-55.EL #1 Wed May 2 13:52:16 EDT 2007 i686 i686 i386 GNU/Linux
oracle版本:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE    11.2.0.1.0      Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

问题1:
RMAN> catalog db_recovery_file_dest;

searching for all files in the recovery area

List of Files Unknown to the Database
=====================================
File Name: /opt/oracle/flash_recovery_area/BABIHOO11G/autobackup/2014_02_25/o1_mf_s_840451559_9jr0z96j_.bkp
File Name: /opt/oracle/flash_recovery_area/BABIHOO11G/autobackup/2014_02_25/o1_mf_s_840456666_9jr5yv5c_.bkp

Do you really want to catalog the above files (enter YES or NO)? yes
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: /opt/oracle/flash_recovery_area/BABIHOO11G/autobackup/2014_02_25/o1_mf_s_840451559_9jr0z96j_.bkp
File Name: /opt/oracle/flash_recovery_area/BABIHOO11G/autobackup/2014_02_25/o1_mf_s_840456666_9jr5yv5c_.bkp

RMAN> list backup of controlfile;

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

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5       Full    9.36M      DISK        00:00:04     25-FEB-14      
        BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: TAG20140225T120700
        Piece Name: /opt/oracle/flash_recovery_area/BABIHOO11G/autobackup/2014_02_25/o1_mf_s_840456420_9jr5q6bl_.bkp
  Control File Included: Ckp SCN: 914584       Ckp time: 25-FEB-14

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6       Full    9.33M      DISK        00:00:00     25-FEB-14      
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20140225T121059
        Piece Name: /opt/oracle/flash_recovery_area/BABIHOO11G/backupset/2014_02_25/o1_mf_ncnnf_TAG20140225T121059_9jr5ypwr_.bkp
  Control File Included: Ckp SCN: 914735       Ckp time: 25-FEB-14

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7       Full    9.33M      DISK        00:00:05     25-FEB-14      
        BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: TAG20140225T163047
        Piece Name: /opt/oracle/flash_recovery_area/BABIHOO11G/backupset/2014_02_25/o1_mf_ncnnf_TAG20140225T163047_9jro5w9v_.bkp
  Control File Included: Ckp SCN: 926276       Ckp time: 25-FEB-14

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8       Full    9.36M      DISK        00:00:03     25-FEB-14      
        BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: TAG20140225T163055
        Piece Name: /opt/oracle/flash_recovery_area/BABIHOO11G/autobackup/2014_02_25/o1_mf_s_840472255_9jro61vb_.bkp
  Control File Included: Ckp SCN: 926284       Ckp time: 25-FEB-14

[oracle@babihoo 2014_02_25]$ pwd
/opt/oracle/flash_recovery_area/BABIHOO11G/autobackup/2014_02_25
[oracle@babihoo 2014_02_25]$ ll
total 38464
-rw-r-----  1 oracle oinstall 9830400 Feb 25 10:46 o1_mf_s_840451559_9jr0z96j_.bkp
-rw-r-----  1 oracle oinstall 9830400 Feb 25 12:07 o1_mf_s_840456420_9jr5q6bl_.bkp
-rw-r-----  1 oracle oinstall 9830400 Feb 25 12:11 o1_mf_s_840456666_9jr5yv5c_.bkp
-rw-r-----  1 oracle oinstall 9830400 Feb 25 16:30 o1_mf_s_840472255_9jro61vb_.bkp



这两个文件都没有删除过。而且这两个文件曾经都用来恢复过控制文件。
RMAN> restore controlfile from autobackup;
(省略)
channel ORA_DISK_1: AUTOBACKUP /opt/oracle/flash_recovery_area/BABIHOO11G/autobackup/2014_02_25/o1_mf_s_840451559_9jr0z96j_.bkp found in the recovery area
RMAN> recover database;
(省略)
List of Cataloged Files
=======================
File Name: /opt/oracle/flash_recovery_area/BABIHOO11G/autobackup/2014_02_25/o1_mf_s_840451559_9jr0z96j_.bkp
using channel ORA_DISK_1
starting media recovery
archived log for thread 1 with sequence 9 is already on disk as file /opt/oracle/oradata/babihoo11g/redo03.log
archived log file name=/opt/oracle/oradata/babihoo11g/redo03.log thread=1 sequence=9
media recovery complete, elapsed time: 00:00:08
Finished recover at 25-FEB-14

恢复之后,就看不到这个自动备份文件了。
RMAN> list backup of controlfile;
List of Backup Sets
===================
BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1       Full    9.33M      DISK        00:00:07     24-FEB-14      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20140224T193923
        Piece Name: /opt/oracle/flash_recovery_area/BABIHOO11G/backupset/2014_02_24/o1_mf_ncnnf_TAG20140224T193923_9jpcvk7m_.bkp
  Control File Included: Ckp SCN: 888738       Ckp time: 24-FEB-14


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2       Full    9.36M      DISK        00:00:03     24-FEB-14      
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20140224T193932
        Piece Name: /opt/oracle/flash_recovery_area/BABIHOO11G/autobackup/2014_02_24/o1_mf_s_840397172_9jpcvp66_.bkp
  Control File Included: Ckp SCN: 888747       Ckp time: 24-FEB-14


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3       Full    9.33M      DISK        00:00:05     25-FEB-14      
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: TAG20140225T104551
        Piece Name: /opt/oracle/flash_recovery_area/BABIHOO11G/backupset/2014_02_25/o1_mf_ncnnf_TAG20140225T104551_9jr0z3vp_.bkp
  Control File Included: Ckp SCN: 912680       Ckp time: 25-FEB-14
在接下来的恢复控制文件实验中,o1_mf_s_840451559_9jr0z96j_.bkp又出现了:

RMAN> recover database;
(省略)
List of Cataloged Files
=======================
File Name: /opt/oracle/flash_recovery_area/BABIHOO11G/backupset/2014_02_25/o1_mf_ncnnf_TAG20140225T104551_9jr0z3vp_.bkp
File Name: /opt/oracle/flash_recovery_area/BABIHOO11G/autobackup/2014_02_25/o1_mf_s_840451559_9jr0z96j_.bkp
(省略)
但是用list backup 命令看不到

之后我又备份了一次控制文件。就是o1_mf_s_840456666_9jr5yv5c_.bkp用来做控制文件恢复实验。
RMAN> list backupset of controlfile;
List of Backup Sets
===================
BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5       Full    9.36M      DISK        00:00:04     25-FEB-14      
        BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: TAG20140225T120700
        Piece Name: /opt/oracle/flash_recovery_area/BABIHOO11G/autobackup/2014_02_25/o1_mf_s_840456420_9jr5q6bl_.bkp
  Control File Included: Ckp SCN: 914584       Ckp time: 25-FEB-14


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6       Full    9.33M      DISK        00:00:04     25-FEB-14      
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20140225T121059
        Piece Name: /opt/oracle/flash_recovery_area/BABIHOO11G/backupset/2014_02_25/o1_mf_ncnnf_TAG20140225T121059_9jr5ypwr_.bkp
  Control File Included: Ckp SCN: 914735       Ckp time: 25-FEB-14


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7       Full    9.36M      DISK        00:00:02     25-FEB-14      
        BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: TAG20140225T121106
        Piece Name: /opt/oracle/flash_recovery_area/BABIHOO11G/autobackup/2014_02_25/o1_mf_s_840456666_9jr5yv5c_.bkp
  Control File Included: Ckp SCN: 914745       Ckp time: 25-FEB-14

这次实验没有用自动备份,用的是备份集o1_mf_ncnnf_TAG20140225T121059_9jr5ypwr_.bkp,在恢复的时候也可以看到o1_mf_s_840456666_9jr5yv5c_.bkp
RMAN> recover database;
(省略)
List of Cataloged Files
=======================
File Name: /opt/oracle/flash_recovery_area/BABIHOO11G/backupset/2014_02_25/o1_mf_ncnnf_TAG20140225T121059_9jr5ypwr_.bkp
File Name: /opt/oracle/flash_recovery_area/BABIHOO11G/autobackup/2014_02_25/o1_mf_s_840451559_9jr0z96j_.bkp
File Name: /opt/oracle/flash_recovery_area/BABIHOO11G/autobackup/2014_02_25/o1_mf_s_840456666_9jr5yv5c_.bkp
(省略)

但是恢复后打开数据库,却看不到这个自动备份了。
RMAN> alter database open resetlogs;     
database opened
RMAN> list backup of controlfile;
List of Backup Sets
===================
BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5       Full    9.36M      DISK        00:00:04     25-FEB-14      
        BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: TAG20140225T120700
        Piece Name: /opt/oracle/flash_recovery_area/BABIHOO11G/autobackup/2014_02_25/o1_mf_s_840456420_9jr5q6bl_.bkp
  Control File Included: Ckp SCN: 914584       Ckp time: 25-FEB-14


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6       Full    9.33M      DISK        00:00:00     25-FEB-14      
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20140225T121059
        Piece Name: /opt/oracle/flash_recovery_area/BABIHOO11G/backupset/2014_02_25/o1_mf_ncnnf_TAG20140225T121059_9jr5ypwr_.bkp
  Control File Included: Ckp SCN: 914735       Ckp time: 25-FEB-14

之前的那次恢复之后,report obsolete也看不到o1_mf_s_840456666_9jr5yv5c_.bkp.delete obsolete也没有删除这个文件。
这次恢复之后,查看过期的备份也没有这两个文件的任何痕迹。
RMAN> report obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
no obsolete backups found

好诡异的说!该怎么解释这种现象呢。


问题2:
RMAN> show controlfile autobackup;
RMAN configuration parameters for database with db_unique_name BABIHOO11G are:
CONFIGURE CONTROLFILE AUTOBACKUP ON;

然后删除一个表空间:
SQL> drop tablespace newts including contents and datafiles;
Tablespace dropped.
可是,等了一天时间,也没有生成一个自动备份的控制文件备份。
NAME                           VALUE                     ISDEFAULT ISMOD      ISADJ
------------------------------ ------------------------- --------- ---------- -----
_controlfile_autobackup_delay  300                       TRUE      FALSE      FALSE

按理说,如果时间单位是秒,那么5分钟就应该生成备份文件了。



论坛徽章:
0
 楼主| 发表于 2014-2-26 10:20 | 显示全部楼层
自己顶起

使用道具 举报

回复

您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

TOP技术积分榜 社区积分榜 徽章 团队 统计 知识索引树 积分竞拍 文本模式 帮助
  ITPUB首页 | ITPUB论坛 | 数据库技术 | 企业信息化 | 开发技术 | 微软技术 | 软件工程与项目管理 | IBM技术园地 | 行业纵向讨论 | IT招聘 | IT文档
  ChinaUnix | ChinaUnix博客 | ChinaUnix论坛
CopyRight 1999-2011 itpub.net All Right Reserved. 北京盛拓优讯信息技术有限公司版权所有 联系我们 未成年人举报专区 
京ICP备16024965号-8  北京市公安局海淀分局网监中心备案编号:11010802021510 广播电视节目制作经营许可证:编号(京)字第1149号
  
快速回复 返回顶部 返回列表