oracle启动时出现归档错误

ailiy

SQL> startup
ORACLE instance started.

Total System Global Area 2147483648 bytes
Fixed Size                  1220432 bytes
Variable Size             469762224 bytes
Database Buffers         1660944384 bytes
Redo Buffers               15556608 bytes
Database mounted.
ORA-16038: log 2 sequence# 1712 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 2 thread 1: '/oracledata/syntong/redo02.log'
首次报错：归档日志是出现错误

SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@linux55 archivelog]$ ls -l
total 4
drwxr-x--- 2 oracle oinstall 4096 May 14 00:00 2013_05_14
[oracle@linux55 archivelog]$ cd ..
[oracle@linux55 SYNTONG]$ ls -l
total 12
drwxr-x--- 3 oracle oinstall 4096 May 14 10:13 archivelog
drwxr-x--- 3 oracle oinstall 4096 May 11 11:22 autobackup
drwxr----- 3 oracle oinstall 4096 May 11 11:22 backupset
[oracle@linux55 SYNTONG]$ cd autobackup/
[oracle@linux55 autobackup]$ ls -l
total 4
drwxr-x--- 2 oracle oinstall 4096 May 11 11:22 2013_05_11
[oracle@linux55 autobackup]$ cd 2013_05_11/
[oracle@linux55 2013_05_11]$ ls -l
total 6988
-rw-r----- 1 oracle oinstall 7143424 May 11 11:22 o1_mf_s_815138542_8rwrkhbt_.bkp
[oracle@linux55 2013_05_11]$ cd ..
[oracle@linux55 autobackup]$ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.1.0 - Production on Tue May 14 10:16:32 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> shutdown abort
ORACLE instance shut down.
SQL> startup mount 先进入mount模式
ORACLE instance started.

Total System Global Area 2147483648 bytes
Fixed Size                  1220432 bytes
Variable Size             469762224 bytes
Database Buffers         1660944384 bytes
Redo Buffers               15556608 bytes
Database mounted.
SQL> alter system set db_recovery_dest_size=20G scope=both;
alter system set db_recovery_dest_size=20G scope=both
                *
ERROR at line 1:
ORA-02065: illegal option for ALTER SYSTEM


SQL> alter system set db_recovery_dest_size=20G scope=both;
alter system set db_recovery_dest_size=20G scope=both
                *
ERROR at line 1:
ORA-02065: illegal option for ALTER SYSTEM


SQL> alter system set db_recovery_file_dest_size=20G scope=both;
修改为20G空间
System altered.

SQL> alter database open;
启动数据库
Database altered.

SQL> quit         
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@linux55 autobackup]$ su - school
Password:
[school@linux55 ~]$ st
kill b_actl
kill b_atra
kill b_trade
kill b_trade
kill b_trade
kill b_detra
kill b_radar
kill bserve
delete share memory [40012]
stop nserve...
stop dbserve...
stop dserve...
stop b_actl...
stop b_atra...
stop b_detra...
stop b_trade...
stop sdb2...
stop msr...
stop mss...
stop dsqlserv...
stop dbproc...
stop userve...
stop accserv...
stop ftpserv...
stop mserve...
中心机服务进程已经关闭!
sserve start...
msr start...
mss start...
dserve start...
dbserve start...
ftpserv start...
dsqlserv start...
dsqlserv start...
dbproc start...
oserve start...
userve start...
accserv start...
bserve start...
sdb2 start...
nserve start...
中心机服务进程起动完毕!
[school@linux55 ~]$ disp
school    3578     1  0 10:21 ?        00:00:00 nserve
school    2961     1  0 10:21 pts/1    00:00:00 dbserve
school    2927     1  0 10:21 ?        00:00:00 dserve
school    3236     1  1 10:21 pts/1    00:00:00 b_actl
school    3238     1  0 10:21 pts/1    00:00:00 b_atra
school    3240     1  0 10:21 pts/1    00:00:00 b_detra
school    3242     1  0 10:21 pts/1    00:00:00 b_trade
school    3499     1  0 10:21 pts/1    00:00:00 sdb2
school    2854     1  0 10:21 pts/1    00:00:00 msr
school    2891     1  0 10:21 ?        00:00:00 mss
school    3038     1  0 10:21 ?        00:00:00 dsqlserv
school    3117     1  0 10:21 pts/1    00:00:00 dbproc
school    3155     1  0 10:21 pts/1    00:00:00 userve
school    3193     1  0 10:21 pts/1    00:00:00 accserv
school    3002     1  0 10:21 ?        00:00:00 ftpserv
school    3622     1  0 10:21 pts/1    00:00:00 mserve
[school@linux55 ~]$ su - idmanage
Password:
[idmanage@linux55 ~]$ st
stop nserve...
stop dserve...
stop idserve...
stop msr...
stop mss...
stop ftpserv...
stop mserve...
中心机服务进程已经关闭!
sserve start...
dserve start...
msr start...
mss start...
ftpserv start...
idserve start ...
nserve start...
中心机服务进程起动完毕!
[idmanage@linux55 ~]$ disp
idmanage  4027     1  0 10:22 ?        00:00:00 nserve
idmanage  3851     1  0 10:21 ?        00:00:00 dserve
idmanage  3990     1  0 10:22 ?        00:00:00 idserve
idmanage  3885     1  0 10:21 pts/1    00:00:00 msr
idmanage  3921     1  0 10:21 ?        00:00:00 mss
idmanage  3956     1  0 10:21 ?        00:00:00 ftpserv
idmanage  4067     1  0 10:22 pts/1    00:00:00 mserve
[idmanage@linux55 ~]$ su - oracle
Password:
su: incorrect password
[idmanage@linux55 ~]$ su - oracle
Password:
[oracle@linux55 ~]$ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.1.0 - Production on Tue May 14 10:22:47 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL>
SQL> show parameter db_recovery_file 查看表的空间 修改为20G

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      /u01/app/oracle/flash_recovery
                                                _area
db_recovery_file_dest_size           big integer 20G
SQL>

wcdz

这是什么东东啊

renshanshan

丑，但是丑的特别，也就是特别的丑！

q968

鸳鸳相抱何时了，鸯在一边看热闹。

asfsd

我是来刷分的，嘿嘿

FXMAR

找到好贴不容易，我顶你了，谢了

q3256

恋爱就是无数个饭局，结婚就是一个饭局。