Chinaunix首页 | 论坛 | 博客

美丽人生yanshoupeng.blog.chinaunix.net

首页　| 　博文目录　| 　关于我

TOMSYAN

  • 博客访问： 2886598
  • 博文数量： 599
  • 博客积分： 16398
  • 博客等级： 上将
  • 技术积分： 6875
  • 用 户 组： 普通用户
  • 注册时间： 2009-11-30 12:04
个人简介

WINDOWS下的程序员出身，偶尔也写一些linux平台下小程序， 后转行数据库行业，专注于ORACLE和DB2的运维和优化。 同时也是ios移动开发者。欢迎志同道合的朋友一起研究技术。 数据库技术交流群：58308065，23618606

文章分类

全部博文（599）

文章存档

2014年（12）

2013年（56）

2012年（199）

2011年（105）

2010年（128）

2009年（99）

我的朋友
最近访客
推荐博文
相关博文
跳过归档日志的完全非常规恢复(一)

分类： Oracle

2012-07-31 22:10:23

跳过归档日志的完全非常规恢复(一) http://blog.chinaunix.net/uid-22948773-id-3294762.html
跳过归档日志的完全非常规恢复(二) http://blog.chinaunix.net/uid-22948773-id-3294763.html
跳过归档日志的完全非常规恢复(三) http://blog.chinaunix.net/uid-22948773-id-3294767.html
跳过归档日志的完全非常规恢复(四) http://blog.chinaunix.net/uid-22948773-id-3294770.html
跳过归档日志的完全非常规恢复(五) http://blog.chinaunix.net/uid-22948773-id-3294773.html

 

 

步骤一、首先创建测试环境

 


 

点击(此处)折叠或打开

  1. SQL> select name from v$dbfile;

  3. NAME
  4. --------------------------------------------------------------------------------

  6. /u01/app/oracle/oradata/huateng/users01.dbf
  7. /u01/app/oracle/oradata/huateng/undotbs01.dbf
  8. /u01/app/oracle/oradata/huateng/sysaux01.dbf
  9. /u01/app/oracle/oradata/huateng/system01.dbf
  10. /u01/app/oracle/oradata/huateng/example01.dbf

  12. SQL> create tablespace htyansp datafile '/u01/app/oracle/oradata/huateng/htyansp01.dbf' size 10m;

  14. Tablespace created.

  16. SQL> create user htyansp identified by htyansp;

  18. User created.

  20. SQL> alter user htyansp default tablespace htyansp;

  22. User altered.

  24. SQL> grant dba to htyansp;

  26. Grant succeeded.

  28. SQL> alter system switch logfile;

  30. System altered.

  32. SQL> archive log list
  33. Database log mode Archive Mode
  34. Automatic archival Enabled
  35. Archive destination /archivelog
  36. Oldest online log sequence 5
  37. Next log sequence to archive 7
  38. Current log sequence 7


上面创建了一个用户htyansp 及其相应的表空间htyansp，当前的日志序列号是7。

 

步骤二、对数据库做一个全备份

 


 

点击(此处)折叠或打开

  1. [oracle@db2server ~]$ rman target /

  3. Recovery Manager: Release 11.2.0.1.0 - Production on Tue Jul 31 00:09:04 2012

  5. Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

  7. connected to target database: HUATENG (DBID=2134565240)

  9. RMAN> backup database;

  11. Starting backup at 2012-07-31 00:09:14
  12. using target database control file instead of recovery catalog
  13. allocated channel: ORA_DISK_1
  14. channel ORA_DISK_1: SID=36 device type=DISK
  15. channel ORA_DISK_1: starting full datafile backup set
  16. channel ORA_DISK_1: specifying datafile(s) in backup set
  17. input datafile file number=00001 name=/u01/app/oracle/oradata/huateng/system01.dbf
  18. input datafile file number=00002 name=/u01/app/oracle/oradata/huateng/sysaux01.dbf
  19. input datafile file number=00005 name=/u01/app/oracle/oradata/huateng/example01.dbf
  20. input datafile file number=00003 name=/u01/app/oracle/oradata/huateng/undotbs01.dbf
  21. input datafile file number=00006 name=/u01/app/oracle/oradata/huateng/htyansp01.dbf
  22. input datafile file number=00004 name=/u01/app/oracle/oradata/huateng/users01.dbf
  23. channel ORA_DISK_1: starting piece 1 at 2012-07-31 00:09:16
  24. channel ORA_DISK_1: finished piece 1 at 2012-07-31 00:10:41
  25. piece handle=/u01/app/oracle/flash_recovery_area/HUATENG/backupset/2012_07_31/o1_mf_nnndf_TAG20120731T000915_81fdfg00_.bkp tag=TAG20120731T000915 comment=NONE
  26. channel ORA_DISK_1: backup set complete, elapsed time: 00:01:25
  27. channel ORA_DISK_1: starting full datafile backup set
  28. channel ORA_DISK_1: specifying datafile(s) in backup set
  29. including current control file in backup set
  30. including current SPFILE in backup set
  31. channel ORA_DISK_1: starting piece 1 at 2012-07-31 00:10:45
  32. channel ORA_DISK_1: finished piece 1 at 2012-07-31 00:10:46
  33. piece handle=/u01/app/oracle/flash_recovery_area/HUATENG/backupset/2012_07_31/o1_mf_ncsnf_TAG20120731T000915_81fdj56h_.bkp tag=TAG20120731T000915 comment=NONE
  34. channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
  35. Finished backup at 2012-07-31 00:10:46

  37. RMAN>


 

步骤三、创建测试数据

 


 

点击(此处)折叠或打开

  1. SQL> archive log list
  2. Database log mode Archive Mode
  3. Automatic archival Enabled
  4. Archive destination /archivelog
  5. Oldest online log sequence 5
  6. Next log sequence to archive 7
  7. Current log sequence 7
  8. SQL> conn htyansp/htyansp
  9. Connected.
  10. SQL> create table test(seq varchar2(20));
  12. Table created.
  14. SQL> insert into test values('sequence 7');
  16. 1 row created.
  18. SQL> commit;
  20. Commit complete.
  22. SQL> alter system switch logfile;
  24. System altered.
  27. 当前的日志文件序列号是7，:因此上面的记录将会存放到日志序列号为7的归档日志中。
  30. SQL> insert into test values('sequence 8');
  32. 1 row created.
  34. SQL> commit;
  36. Commit complete.
  38. SQL> alter system switch logfile;
  40. System altered.
  42. SQL> insert into test values('sequence 9');
  44. 1 row created.
  46. SQL> commit;
  48. Commit complete.
  50. SQL> alter system switch logfile;
  52. System altered.
  54. SQL> insert into test values('sequence 10');
  56. 1 row created.
  58. SQL> commit;
  60. Commit complete.
  62. SQL> alter system switch logfile;
  64. System altered.
  66. SQL> insert into test values('sequence 11');
  68. 1 row created.
  70. SQL> commit;
  72. Commit complete.
  74. SQL> alter system switch logfile;
  76. System altered.
  78. SQL> select * from htyansp.test;
  80. SEQ
  81. --------------------
  82. sequence 7
  83. sequence 8
  84. sequence 9
  85. sequence 10
  86. sequence 11


 

每次插入一条记录切换一次日志，上面的记录每条记录存放到一个日志文件中。

 


 

点击(此处)折叠或打开

  1. SQL> conn / as sysdba
  2. Connected.
  3. SQL> archive log list
  4. Database log mode Archive Mode
  5. Automatic archival Enabled
  6. Archive destination /archivelog
  7. Oldest online log sequence 10
  8. Next log sequence to archive 12
  9. Current log sequence 12
  10. SQL>


 

阅读(3068) | 评论(0) | 转发(2) |
0

上一篇：create pfile from spfile 为什么没有instance_name参数

下一篇：跳过归档日志的完全非常规恢复(三)

给主人留下些什么吧！~~
关于我们 | 关于IT168 | 联系方式 | 广告合作 | 法律声明 | 免费注册

Copyright 2001-2010 ChinaUnix.net All Rights Reserved 北京皓辰网域网络信息技术有限公司. 版权所有

感谢所有关心和支持过ChinaUnix的朋友们

16024965号-6