database recovery

我将9201的数据拷回启动数据库时报ora-600错误，本来想着这是oracle内部的一个bug，今早做了一次尝试，希望能够自己解决，经过网上的查询，说这个错误是由于非法关机或者掉电造成，解决办法就是先把数据库起到mount状态，做一下database recovery，结果成功解决。

操作步骤：

unOS 5.9

 

login: login: root
Password:
Last login: Mon Aug 29 04:47:38 from 192.168.1.209
Sun Microsystems Inc.   SunOS 5.9       Generic May 2002
You have mail.
Sourcing //.profile-EIS.....
# cp -rp /export/home/orabak_20070821/oracle /export/home/oracle
# cp -rp /export/home/orabak_20070821/oracle /export/home/oracle
# su - oracle
Sun Microsystems Inc.   SunOS 5.9       Generic May 2002
b2500% sqlplus "/as sysdba"

SQL*Plus: Release 9.2.0.1.0 - Production on 星期一 8月 29 05:06:25 2005

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area  320308312 bytes
Fixed Size                   730200 bytes
Variable Size             285212672 bytes
Database Buffers           33554432 bytes
Redo Buffers                 811008 bytes
Database mounted.
ORA-00600: internal error code, arguments: [kcratr1_lostwrt], [], [], [], [],
[], [], []

SQL> startup mount
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown immediate
ORA-01109: database not open

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

Total System Global Area  320308312 bytes
Fixed Size                   730200 bytes
Variable Size             285212672 bytes
Database Buffers           33554432 bytes
Redo Buffers                 811008 bytes
Database mounted.
SQL> recover database;
Media recovery complete.
SQL> alter database open;

Database altered.

SQL> select STATUS from v$instance;

STATUS
------------
OPEN

SQL>  select comp_name,version from dba_registry;

COMP_NAME
--------------------------------------------------------------------------------
VERSION
------------------------------
Oracle9i Catalog Views
9.2.0.1.0

Oracle9i Packages and Types
9.2.0.1.0

Oracle Workspace Manager
9.2.0.1.0

COMP_NAME
--------------------------------------------------------------------------------
VERSION
------------------------------
JServer JAVA Virtual Machine
9.2.0.1.0

Oracle XDK for Java
9.2.0.2.0

Oracle9i Java Packages
9.2.0.1.0

COMP_NAME
--------------------------------------------------------------------------------
VERSION
------------------------------
Oracle interMedia
9.2.0.1.0

Spatial
9.2.0.1.0

Oracle Text
9.2.0.1.0

COMP_NAME
--------------------------------------------------------------------------------
VERSION
------------------------------
Oracle XML Database
9.2.0.1.0

Oracle Ultra Search
9.2.0.1.0

Oracle Data Mining
9.2.0.1.0

COMP_NAME
--------------------------------------------------------------------------------
VERSION
------------------------------
OLAP Analytic Workspace
9.2.0.1.0

Oracle OLAP API
9.2.0.1.0

OLAP Catalog
9.2.0.1.0

15 rows selected.

SQL> quit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
b2500% ps -ef |grep ora_
  oracle 24219 23733  0 05:18:40 pts/3    0:00 grep ora_
  oracle 23871     1  0 05:08:59 ?        0:00 ora_d000_allen
  oracle 23853     1  0 05:08:59 ?        0:00 ora_pmon_allen
  oracle 23855     1  0 05:08:59 ?        0:00 ora_dbw0_allen
  oracle 23865     1  0 05:08:59 ?        0:00 ora_cjq0_allen
  oracle 23857     1  0 05:08:59 ?        0:00 ora_lgwr_allen
  oracle 23859     1  0 05:08:59 ?        0:00 ora_ckpt_allen
  oracle 23861     1  0 05:08:59 ?        0:00 ora_smon_allen
  oracle 23867     1  0 05:08:59 ?        0:01 ora_qmn0_allen
  oracle 23869     1  0 05:08:59 ?        0:00 ora_s000_allen
  oracle 23863     1  0 05:08:59 ?        0:00 ora_reco_allen
b2500% lsnrctl start

LSNRCTL for Solaris: Version 9.2.0.1.0 - Production on 29-8月 -2005 05:18:56

Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.

Starting /export/home/oracle/product/9.2.0.1/bin/tnslsnr: please wait...

TNSLSNR for Solaris: Version 9.2.0.1.0 - Production
System parameter file is /export/home/oracle/product/9.2.0.1/network/admin/listener.ora
Log messages written to /export/home/oracle/product/9.2.0.1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=b2500)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Solaris: Version 9.2.0.1.0 - Production
Start Date                29-8月 -2005 05:18:56
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   /export/home/oracle/product/9.2.0.1/network/admin/listener.ora
Listener Log File         /export/home/oracle/product/9.2.0.1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=b2500)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "allen" has 1 instance(s).
  Instance "allen", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully