Chinaunix首页 | 论坛 | 博客
  • 博客访问: 2961868
  • 博文数量: 853
  • 博客积分: 8199
  • 博客等级: 中将
  • 技术积分: 11741
  • 用 户 组: 普通用户
  • 注册时间: 2010-05-25 20:19
个人简介

脚踏实地、勇往直前!

文章分类

全部博文(853)

文章存档

2018年(199)

2017年(75)

2016年(48)

2015年(48)

2014年(152)

2013年(49)

2012年(156)

2011年(93)

2010年(30)

分类: Oracle

2018-11-10 18:56:15


全部在rman下操作:
1.backup AS copy datafile 4 format '/u01/app/oracle/oradata/catlogdb_copy/users01.dbf';
2.SQL 'alter database datafile 4 offline';
3.switch datafile 4 TO copy;
4.recover datafile 4;
5.SQL 'alter database datafile 4 online';


  1. RMAN> backup AS copy datafile 4 format '/u01/app/oracle/oradata/catlogdb_copy/users01.dbf';

  2. Starting backup at 10-NOV-18
  3. using channel ORA_DISK_1
  4. using channel ORA_DISK_2
  5. channel ORA_DISK_1: starting datafile copy
  6. input datafile file number=00004 name=/u01/app/oracle/oradata/catlogdb/users01.dbf
  7. output file name=/u01/app/oracle/oradata/catlogdb_copy/users01.dbf tag=TAG20181110T034401 RECID=13 STAMP=991799042
  8. channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
  9. Finished backup at 10-NOV-18

  10. Starting Control File and SPFILE Autobackup at 10-NOV-18
  11. piece handle=/u01/app/oracle/fast_recovery_area/CATLOGDB/autobackup/2018_11_10/o1_mf_s_991799043_fyf6lm83_.bkp comment=NONE
  12. Finished Control File and SPFILE Autobackup at 10-NOV-18

  13. RMAN> SQL 'alter database datafile 4 offline';

  14. sql statement: alter database datafile 4 offline

  15. RMAN> switch datafile 4 TO copy;

  16. datafile 4 switched to datafile copy "/u01/app/oracle/oradata/catlogdb_copy/users01.dbf"

  17. RMAN> recover datafile 4;

  18. Starting recover at 10-NOV-18
  19. using channel ORA_DISK_1
  20. using channel ORA_DISK_2

  21. starting media recovery
  22. media recovery complete, elapsed time: 00:00:01

  23. Finished recover at 10-NOV-18

  24. RMAN> SQL 'alter database datafile 4 online';

  25. sql statement: alter database datafile 4 online

阅读(37) | 评论(0) | 转发(0) |
0

上一篇: Index column size too large

下一篇:没有了

给主人留下些什么吧!~~
评论热议
请登录后评论。

登录 注册