alter database open 出什么错呢?
ORA-01219 database not open: queries allowed on fixed tables/views onlyCause: A query was issued against an object not recognized as a fixed table or fixed view before the database has been opened.Action: Re-phrase the query to include only fixed objects, or open the database.
ORA-01219 database not open: queries allowed on fixed tables/views onlyCause: A query was issued against an object not recognized as a fixed table or fixed view before the database has been opened.Action: Re-phrase the query to include only fixed objects, or open the database.
解决方案 »
- SQLdeveloper求助
- 请高手(DBA)帮忙解决一下ORA-00600: Message 600 not found; No message file for product=RDBM
- 求助,win2003serv+ora9i2,agent服务不能启动,没改过计算机名
- plsql中输入的varchar2参数的最大长度
- (+)符号什么用处?
- 畫面輸入一個特殊的繁體字符到提交到oracle10g后天確變成了"峯"怎么回事情﹖
- oracle嵌套表显示问题?
- 怎么修改internal用户的密码
- oracle客户端出现如下错误,连不上数据库
- 修改用户密码后,提示end of file communation channel.谢谢帮助!
- 紧急求助,执行pl/sql的时候,说协议适配器错误
- How to solve the problem?(ORA-12703)
出错的信息贴上来
解决方法:
首先执行语句 SQL〉shutdown immediate;
然后执行 sql〉startup mount;
然后
用CLEAR命令重建该日志文件
SQL>alter database clear logfile group 1;
如果是该日志组还没有归档,则需要用
SQL> alter database clear unarchived logfile group 1;
发现clear不成功
SQL> alter database clear unarchived logfile group 1;
alter database clear unarchived logfile group 1 ;