重启oracle服务器

来源:互联网 发布:java高级开发工程师证 编辑:程序博客网 时间:2024/04/27 14:47
以oracle用户登录系统
启动数据库
sqlplus / as sysdba
SQL> startup
关闭数据库
sqlplus / as sysdba
SQL> shutdown immediate
启动监听器: lsnrctl start
出现下列错误,是非正常关闭导致LOG损坏
ORA-16038: log 2 sequence# 1 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 2 thread 1: '/home/oracle/oradata/orc2/redo02.log'
需进行不完全恢复
SQL>startup mount
SQL>recover database until cancel
SQL>alter database open resetlogs;