--Oracle服务没起来吧?---是Windows操作系统的话,你打开“服务”,里面有OracleService.... ---把它起动一下,就OK了。--或者:sqlplus /nolog; conn / as sysdba; startup;
不是的,服务已经启动了,sys也能连上,就是我用scott登陆的时候就是报那个错!
这个只是现象,看本质需要查看alert_(yoursid).log 把alertlog内容贴一下吧
主要应该就是这个吧: ARC0: Failed to archive thread 1 sequence 66 (19809) ARCH: Archival stopped, error occurred. Will continue retrying Thu Oct 15 18:12:06 2009 Errors in file d:\admin\orcl\bdump\orcl_arc0_4060.trc: ORA-16038: log 2 sequence# 66 cannot be archived ORA-19809: limit exceeded for recovery files ORA-00312: online log 2 thread 1: 'D:\ORADATA\ORCL\REDO02.LOG' 麻烦高手帮我看看!
ORA-19809: limit exceeded for recovery files Cause: The limit for recovery files specified by the DB_RECOVERY_FILE_DEST_SIZE was exceeded.
Action: The error is accompanied by 19804. See message 19804 for further details. 楼主检查下归档目录的大小,是不是满了..SQL> show parameter db_recovery NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest string D:\oracle\product\10.2.0/flash_recovery_area db_recovery_file_dest_size big integer 2G SQL> alter system set db_recovery_file_dest_size=3G scope=both; 系统已更改。 SQL> alter database open; 数据库已更改。 Flash Recovery Area空间不足导致数据库不能打开或hang住 http://blog.csdn.net/tianlesoftware/archive/2009/10/14/4668991.aspx
redo log 没办法归档导致的,原因是(limit exceeded for recovery files ) 用楼上的方法应该可以解决.
---把它起动一下,就OK了。--或者:sqlplus /nolog;
conn / as sysdba;
startup;
把alertlog内容贴一下吧
ARC0: Failed to archive thread 1 sequence 66 (19809)
ARCH: Archival stopped, error occurred. Will continue retrying
Thu Oct 15 18:12:06 2009
Errors in file d:\admin\orcl\bdump\orcl_arc0_4060.trc:
ORA-16038: log 2 sequence# 66 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 2 thread 1: 'D:\ORADATA\ORCL\REDO02.LOG'
麻烦高手帮我看看!
ORA-19809: limit exceeded for recovery files
Cause: The limit for recovery files specified by the DB_RECOVERY_FILE_DEST_SIZE was exceeded.
Action: The error is accompanied by 19804. See message 19804 for further details.
楼主检查下归档目录的大小,是不是满了..SQL> show parameter db_recovery
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string D:\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size big integer 2G
SQL> alter system set db_recovery_file_dest_size=3G scope=both;
系统已更改。
SQL> alter database open;
数据库已更改。 Flash Recovery Area空间不足导致数据库不能打开或hang住
http://blog.csdn.net/tianlesoftware/archive/2009/10/14/4668991.aspx
用楼上的方法应该可以解决.