用sqlplus 登录oracle 报下面的错
:
检查了log 发现有下面的警告:
解决办法:
利于google.comr搜索相关错误代码
sqlplsu /as sysdba
SQL> show parameter db_recovery
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string e:\oracle\product\10.2.0/flash
_recovery_area
db_recovery_file_dest_size big integer 2G
1.加大db_recovery_file_dest_size大小
alter system set db_recovery_file_dest_size=3G scope=both;
然后重新启动数据库即可。
2.重新指定文件的存储位置
3.删除多余的文件(我采用的便是这种办法)
第一步:启动rman
c:\>rman target /
第二步:检查归档日志文件
RMAN>crosscheck archivelog all;
第三步:删除文件
RMAN> delete expired archivelog all;
.....
然后重新启动数据库alter database open
引用了 [url] http://space.itpub.net/67668/viewspace-281075[/url]文章
:
ORA-01033: ORACLE initialization or shutdown in progress
检查了log 发现有下面的警告:
Errors in file e:\oracle\product\10.2.0
\admin\orcl\udump\orcl_ora_4836.trc:
ORA-19815: 警告: db_recovery_file_dest_size 字节 (共 2147483648
字节) 已使用 100.00%, 尚有 0 字节可用。
Sat Jul 24 16:59:32 2010
**************************************************************
**********
You have following choices to free up space from flash
recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using
Data Guard,
then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size
parameter to
reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an
operating
system command was used to delete files, then use RMAN
CROSSCHECK and
DELETE EXPIRED commands.
**************************************************************
**********
Sat Jul 24 16:59:32 2010
Errors in file e:\oracle\product\10.2.0
\admin\orcl\udump\orcl_ora_4836.trc:
ORA-19809: 超出了恢复文件数的限制
ORA-19804: 无法回收 47713792 字节磁盘空间 (从 2147483648 限制中)
解决办法:
利于google.comr搜索相关错误代码
sqlplsu /as sysdba
SQL> show parameter db_recovery
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string e:\oracle\product\10.2.0/flash
_recovery_area
db_recovery_file_dest_size big integer 2G
1.加大db_recovery_file_dest_size大小
alter system set db_recovery_file_dest_size=3G scope=both;
然后重新启动数据库即可。
2.重新指定文件的存储位置
3.删除多余的文件(我采用的便是这种办法)
第一步:启动rman
c:\>rman target /
第二步:检查归档日志文件
RMAN>crosscheck archivelog all;
第三步:删除文件
RMAN> delete expired archivelog all;
.....
然后重新启动数据库alter database open
引用了 [url] http://space.itpub.net/67668/viewspace-281075[/url]文章