oracle 10g rac转成单机3
数据库nomount以后，找到原来的控制文件trace的脚本，修改里面nomount部分的东西，这次，我直接修改了redo的位置和大小，数据文件的位置，
CREATE CONTROLFILE REUSE DATABASE "KYJXC" RESETLOGS NOARCHIVELOG
MAXLOGFILES 192
MAXLOGMEMBERS 3
MAXDATAFILES 1024
MAXINSTANCES 32
MAXLOGHISTORY 292
LOGFILE
GROUP 1 '/oradata/kyjxc/redo1.ora' SIZE 200M,
GROUP 2 '/oradata/kyjxc/redo2.ora' SIZE 200M,
GROUP 3 '/oradata/kyjxc/redo3.ora' SIZE 200M
-- STANDBY LOGFILE
DATAFILE
'/oradata/kyjxc/system.dat',
'/oradata/kyjxc/undotbs1.dat',
'/oradata/kyjxc/sysaux.dat',
'/oradata/kyjxc/users.dat',
'/oradata/kyjxc/undotbs2.dat',
'/oradata/kyjxc/rbkyjxc.dat'
MAXLOGFILES 192
MAXLOGMEMBERS 3
MAXDATAFILES 1024
MAXINSTANCES 32
MAXLOGHISTORY 292
LOGFILE
GROUP 1 '/oradata/kyjxc/redo1.ora' SIZE 200M,
GROUP 2 '/oradata/kyjxc/redo2.ora' SIZE 200M,
GROUP 3 '/oradata/kyjxc/redo3.ora' SIZE 200M
-- STANDBY LOGFILE
DATAFILE
'/oradata/kyjxc/system.dat',
'/oradata/kyjxc/undotbs1.dat',
'/oradata/kyjxc/sysaux.dat',
'/oradata/kyjxc/users.dat',
'/oradata/kyjxc/undotbs2.dat',
'/oradata/kyjxc/rbkyjxc.dat'
CHARACTER SET ZHS16GBK；
执行创建，一切顺利，控制文件创建成功，数据库到了mount状态。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/13337857/viewspace-738557/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
oracle 10g rac转成单机2
下一篇：
oracle 10g rac转成单机4
请登录后发表评论
登录
全部评论
