1 .昨天更换了PFILE ，忘了增加ARCHIVE 的部分了

###########################################
# Archive
###########################################
log_archive_dest_1='LOCATION=/testarch2'
log_archive_format=%t_%s_%r.dbf

2.晚上备份出现如下错误

sql statement: alter system archive log current
released channel: t1
released channel: t2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of sql command on default channel at 01/31/2007 00:09:19
RMAN-11003: failure during parse/execution of SQL statement: alter system archiv
e log current
ORA-16038: log 1 sequence# 53 cannot be archived

ORA-19809: limit exceeded for recovery files

ORA-00312: online log 1 thread 1: '/testinddata/oradata/test/redo01.log'

:q!
3。查看数据库状态
[test:oradev] /oradev1/home/rman>
[test:oradev] /oradev1/home/rman>
[test:oradev] /oradev1/home/rman>
[test:oradev] /oradev1/home/rman>
[test:oradev] /oradev1/home/rman> ps -ef | grep ora_
oradev 327874 1 0 11:25:32 - 0:01 ora_psp0_test
oradev 336034 1 0 11:25:32 - 0:02 ora_mman_test
oradev 344306 753790 0 09:49:08 pts/0 0:00 grep ora_
oradev 385106 1 0 11:25:32 - 0:07 ora_lgwr_test
oradev 393464 1 0 11:25:32 - 0:16 ora_ckpt_test
oradev 413834 1 0 11:25:32 - 0:00 ora_reco_test
oradev 462888 1 0 11:25:37 - 0:02 ora_rvwr_test
oradev 475352 1 0 11:25:32 - 0:04 ora_smon_test
oradev 524528 1 0 11:25:32 - 0:10 ora_pmon_test
oradev 540718 1 0 11:25:48 - 0:01 ora_q000_test
oradev 565282 1 0 11:25:32 - 0:03 ora_dbw0_test
oradev 667888 1 0 11:25:32 - 0:13 ora_cjq0_test
oradev 684150 1 0 11:25:33 - 0:00 ora_s000_test
oradev 704604 1 0 11:25:38 - 0:00 ora_qmnc_test
oradev 725046 1 0 11:25:32 - 0:08 ora_mmon_test
oradev 827424 1 0 11:25:32 - 0:34 ora_mmnl_test
oradev 835778 1 0 11:25:37 - 0:07 ora_arc0_test
oradev 864290 1 0 11:25:48 - 0:00 ora_q001_test
oradev 868552 1 0 11:25:32 - 0:00 ora_d000_test
[test:oradev] /oradev1/home/rman>
[test:oradev] /oradev1/home/rman>

4。RESTART DB 报错
[test:oradev] /oradev1/home/rman> sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.2.0 - Production on Wed Jan 31 09:49:15 2007

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

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 3758096384 bytes
Fixed Size 2075728 bytes
Variable Size 721421232 bytes
Database Buffers 3019898880 bytes
Redo Buffers 14700544 bytes
Database mounted.
ORA-16038: log 1 sequence# 53 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 1 thread 1: '/devtestdata/oradata/test/redo01.log'
SQL> recovery
SP2-0042: unknown command "recovery" - rest of line ignored.
SQL> recover database
ORA-00283: recovery session canceled due to errors
ORA-00264: no recovery required

5。根据提示做RECOVER

SQL> recover database until cancel;
Media recovery complete.
SQL> shutdown immediate
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 3758096384 bytes
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

6。做RESETLOGS

SQL> alter database open resetlogs;

Database altered.

SQL>

7。 PFILE 增加如下
###########################################
# Archive
###########################################
log_archive_dest_1='LOCATION=/devtestarch1/arch'
log_archive_format=%t_%s_%r.dbf

8。重新启动DB ，一切正常