ITPub博客

首页 > Linux操作系统 > Linux操作系统 > standby(8i)在primary上增加新的数据表空间的方法

standby(8i)在primary上增加新的数据表空间的方法

原创 Linux操作系统 作者:crpp0902 时间:2019-05-09 08:36:05 0 删除 编辑

beacause the db release is 8I,so when add a new tablespace or datafile on the primary,you must mually do following:


on primary db:

sqlplus> create tablespace MID datafile 'path/mid_01.dbf' size 1000m;

etc....

sqlplus>alter system switch logfile;

on standby db:

during apply the archived log,the alert log warning follow:

Errors in file /opt/oracle/admin/MEDIA/bdump/media_dbw0_21507.trc:
ORA-01157: cannot identify/lock data file 24 - see DBWR trace file
ORA-01110: data file 24: '/opt/oracle/oradata/MEDIA/mid_03.dbf'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3

solution:

alter database CREATE DATAFILE '/opt/oracle/oradata/MEDIA/mid_03.dbf' as '/opt/oracle/oradata/MEDIA/mid_03.dbf'

ok,then do follow:

svrmgrl >/dev/null <connect internal
set autorecovery on
recover automatic standby database;
exit
EOF

it's ok.....

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

下一篇: DB AND OS
请登录后发表评论 登录
全部评论

注册时间:2002-11-14

  • 博文量
    59
  • 访问量
    46116