Bo's Oracle Station

查看: 1661|回复: 0

第24/25/26次:2015-11-27星期五,2015-11-30星期一和2015-12-04星期五

[复制链接]

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
发表于 2015-11-30 09:52:04 | 显示全部楼层 |阅读模式
本帖最后由 botang 于 2015-12-4 23:26 编辑

实验8a,8b
实验9a,9b,9c,9d
实验10a,10b,10c,10d

8c_ASM.sql:
  1. select  * from v$log;

  2. select  * from v$logfile;

  3. alter database drop logfile group 1;

  4. alter database add logfile group 1 '/u01/app/oracle/oradata/orcl/redo01.log' size 50M;

  5. alter database drop logfile group 3;

  6. alter database add logfile group 3 '/u01/app/oracle/oradata/orcl/redo03.log' size 50M;

  7. alter system switch logfile;

  8. alter database drop logfile group 2;

  9. alter system checkpoint;

  10. alter database drop logfile group 2;

  11. alter database add logfile group 2 '/u01/app/oracle/oradata/orcl/redo02.log' size 50M;


复制代码


asm.rcv:
  1. run {
  2. allocate channel c1 device type disk format '/u01/app/oracle/oradata/orcl/system01.dbf';
  3. backup as copy datafile 1  ;
  4. release channel c1;
  5. allocate channel c2 device type disk format '/u01/app/oracle/oradata/orcl/sysaux01.dbf';
  6. backup as copy datafile 2;
  7. release channel c2;
  8. allocate channel c3 device type disk format '/u01/app/oracle/oradata/orcl/undotbs1.dbf';
  9. backup as copy datafile 3;
  10. release channel c3;
  11. allocate channel c4 device type disk format '/u01/app/oracle/oradata/orcl/users01.dbf';
  12. backup as copy datafile  4;
  13. release channel c4;
  14. allocate channel c5 device type disk format '/u01/app/oracle/oradata/orcl/example01.dbf';
  15. backup as copy datafile 5;
  16. release channel c5;
  17. }
复制代码



回复

使用道具 举报

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

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-11-1 07:50 , Processed in 0.044823 second(s), 24 queries .

快速回复 返回顶部 返回列表