sql>STARTUP NOMOUNTsql>CREATE CONTROLFILE REUSE DATABASE "UNIGUARD" NORESETLOGS NOARCHiveLOGMAXLO
sql>STARTUP NOMOUNT
sql>CREATE CONTROLFILE REUSE DATABASE "UNIGUARD" NORESETLOGS NOARCHiveLOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 4672
LOGFILE
GROUP 1 '/product/app/oracle/oradata/uniguard/redo01.log' SIZE 50M,
GROUP 2 '/product/app/oracle/oradata/uniguard/redo02.log' SIZE 50M,
GROUP 3 '/product/app/oracle/oradata/uniguard/redo03.log' SIZE 50M
-- STANDBY LOGFILE
DATAFILE
'/product/app/oracle/oradata/uniguard/system01.dbf',
'/product/app/oracle/oradata/uniguard/undotbs01.dbf',
'/product/app/oracle/oradata/uniguard/sysaux01.dbf',
'/product/app/oracle/oradata/uniguard/users01.dbf',
'/product/app/oracle/oradata/uniguard/info01.dbf',
'/index/oradata/uniguard/index01.dbf',
'/devdata/oradata/uniguard/index01.dbf',
'/devdata/oradata/uniguard/indexdata02.dbf',
'/devdata/oradata/uniguard/dev01.dbf'
CHARACTER SET ZHS16GBK
;
sql>RECOVER DATABASE
sql>ALTER DATABASE OPEN;
--结束END--
本文标题: 控制文件丢失,重建控制文件
本文链接: http://www.lsjlt.com/news/41151.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-21
2024-05-21
2024-05-21
2024-05-21
2024-05-21
2024-05-21
2024-05-21
2024-05-21
2024-05-21
2024-05-21
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0