数据库断电后，经过各种折腾，现在启动的时候如下：
SQL> startup
ORACLE instance started.
Total System Global Area 5161005056 bytes
Fixed Size 2237328 bytes
Variable Size 2348813424 bytes
Database Buffers 2785017856 bytes
Redo Buffers 24936448 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-01173: data dictionary indicates missing data file from system tablespace
Process ID: 29809
Session ID: 551 Serial number: 3
之前在重做控制文件的时候，少做了undotbs01.dbf，造成undotbs01.dbf在v$datafile没有了，如下：SQL> select name,status from v$datafile;
NAME
--------------------------------------------------------------------------------
STATUS
-------
/opt/oracle/oradata/ods/system01.dbf
SYSTEM
/opt/oracle/oradata/ods/sysaux01.dbf
ONLINE
/opt/oracle/oradata/ods/users01.dbf
ONLINE
NAME
--------------------------------------------------------------------------------
STATUS
-------
/home/oracle/oradata/moo/moo_01.dbf
ONLINE
拷贝了个pfile出来设置了undo_management='manual'和_corrupted_rollback_segments，启动的时候是另外一个错：
ORACLE instance shut down.
SQL> startup mount pfile='/opt/oracle/product/OraHomes/initods.ora'
ORACLE instance started.
Total System Global Area 5161005056 bytes
Fixed Size 2237328 bytes
Variable Size 2348813424 bytes
Database Buffers 2785017856 bytes
Redo Buffers 24936448 bytes
Database mounted.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/opt/oracle/oradata/ods/system01.dbf'
日志：
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
ORACLE_HOME = /opt/oracle/product/OraHome
System name: Linux
Node name: server-db02
Release: 2.6.32-220.el6.x86_64
Version: #1 SMP Wed Nov 9 08:03:13 EST 2011
Machine: x86_64
Using parameter settings in server-side spfile /opt/oracle/product/OraHome/dbs/spfileods.ora
System parameters with non-default values:
processes = 500
sessions = 800
sga_target = 4944M
control_files = "/opt/oracle/oradata/ods/control01.ctl"
control_files = "/opt/oracle/oradata/ods/control02.ctl"
db_block_size = 8192
compatible = "11.2.0.0.0"
_allow_resetlogs_corruption= TRUE
_corrupted_rollback_segments= "_SYSSMU1$"
_corrupted_rollback_segments= "_SYSSMU2$"
_corrupted_rollback_segments= "_SYSSMU3$"
_corrupted_rollback_segments= "_SYSSMU4$"
_corrupted_rollback_segments= "_SYSSMU5$"
_corrupted_rollback_segments= "_SYSSMU6$"
_corrupted_rollback_segments= "_SYSSMU7$"
_corrupted_rollback_segments= "_SYSSMU8$"
_corrupted_rollback_segments= "_SYSSMU9$"
_corrupted_rollback_segments= "_SYSSMU10$"
_corrupted_rollback_segments= "_SYSSMU10_3271578125$"
undo_management = "MANUAL"
undo_tablespace = "SYSTEM"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=odsXDB)"
audit_file_dest = "/opt/oracle/admin/ods/adump"
audit_trail = "DB"
db_name = "ods"
open_cursors = 300
pga_aggregate_target = 1645M
diagnostic_dest = "/opt/oracle"
Wed Nov 19 15:51:10 2014
PMON started with pid=2, OS id=29952
Wed Nov 19 15:51:10 2014
PSP0 started with pid=3, OS id=29954
Wed Nov 19 15:51:11 2014
VKTM started with pid=4, OS id=29956 at elevated priority
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Wed Nov 19 15:51:11 2014
GEN0 started with pid=5, OS id=29960
Wed Nov 19 15:51:11 2014
DIAG started with pid=6, OS id=29962
Wed Nov 19 15:51:11 2014
DBRM started with pid=7, OS id=29964
Wed Nov 19 15:51:11 2014
DIA0 started with pid=8, OS id=29966
Wed Nov 19 15:51:11 2014
MMAN started with pid=9, OS id=29968
Wed Nov 19 15:51:11 2014
DBW0 started with pid=10, OS id=29970
Wed Nov 19 15:51:11 2014
DBW1 started with pid=11, OS id=29972
Wed Nov 19 15:51:11 2014
DBW2 started with pid=12, OS id=29974
Wed Nov 19 15:51:11 2014
DBW3 started with pid=13, OS id=29976
Wed Nov 19 15:51:11 2014
LGWR started with pid=14, OS id=29978
Wed Nov 19 15:51:11 2014
CKPT started with pid=15, OS id=29980
Wed Nov 19 15:51:11 2014
SMON started with pid=16, OS id=29982
Wed Nov 19 15:51:11 2014
RECO started with pid=17, OS id=29984
Wed Nov 19 15:51:11 2014
MMON started with pid=18, OS id=29986
Wed Nov 19 15:51:11 2014
MMNL started with pid=19, OS id=29988
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /opt/oracle
Wed Nov 19 15:51:11 2014
ALTER DATABASE MOUNT
Successful mount of redo thread 1, with mount id 133548399
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE MOUNT
Wed Nov 19 15:56:26 2014
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 2
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
ALTER DATABASE DISMOUNT
Shutting down archive processes
Archiving is disabled
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Wed Nov 19 15:56:29 2014
Stopping background process VKTM
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Wed Nov 19 15:56:31 2014
Instance shutdown complete
Wed Nov 19 15:56:36 2014
Adjusting the default value of parameter parallel_max_servers
from 1280 to 485 due to the value of parameter processes (500)
Starting ORACLE instance (normal)
****************** Large Pages Information *****************
Total Shared Global Region in Large Pages = 0 KB (0%)
Large Pages used by this instance: 0 (0 KB)
Large Pages unused system wide = 0 (0 KB) (alloc incr 16 MB)
Large Pages configured system wide = 0 (0 KB)
Large Page size = 2048 KB
RECOMMENDATION:
Total Shared Global Region size is 4946 MB. For optimal performance,
prior to the next instance restart increase the number
of unused Large Pages by atleast 2473 2048 KB Large Pages (4946 MB)
system wide to get 100% of the Shared
Global Region allocated with Large pages
***********************************************************
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as /opt/oracle/product/OraHome/dbs/arch
Autotune of undo retention is turned off.
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
ORACLE_HOME = /opt/oracle/product/OraHome
System name: Linux
Node name: server-db02
Release: 2.6.32-220.el6.x86_64
Version: #1 SMP Wed Nov 9 08:03:13 EST 2011
Machine: x86_64
Using parameter settings in client-side pfile /opt/oracle/product/OraHome/dbs/initods.ora on machine server-db02
System parameters with non-default values:
processes = 500
sessions = 800
sga_target = 4944M
control_files = "/opt/oracle/oradata/ods/control01.ctl"
control_files = "/opt/oracle/oradata/ods/control02.ctl"
db_block_size = 8192
compatible = "11.2.0.0.0"
_allow_resetlogs_corruption= TRUE
_corrupted_rollback_segments= "_SYSSMU1$"
_corrupted_rollback_segments= "_SYSSMU2$"
_corrupted_rollback_segments= "_SYSSMU3$"
_corrupted_rollback_segments= "_SYSSMU4$"
_corrupted_rollback_segments= "_SYSSMU5$"
_corrupted_rollback_segments= "_SYSSMU6$"
_corrupted_rollback_segments= "_SYSSMU7$"
_corrupted_rollback_segments= "_SYSSMU8$"
_corrupted_rollback_segments= "_SYSSMU9$"
_corrupted_rollback_segments= "_SYSSMU10$"
undo_management = "MANUAL"
undo_tablespace = "SYSTEM"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=odsXDB)"
audit_file_dest = "/opt/oracle/admin/ods/adump"
audit_trail = "DB"
db_name = "ods"
open_cursors = 300
pga_aggregate_target = 1645M
diagnostic_dest = "/opt/oracle"
Wed Nov 19 15:56:36 2014
PMON started with pid=2, OS id=30461
Wed Nov 19 15:56:36 2014
PSP0 started with pid=3, OS id=30463
Wed Nov 19 15:56:37 2014
VKTM started with pid=4, OS id=30466 at elevated priority
VKTM running at (1)millisec precision with DBRM quantum (100)ms
Wed Nov 19 15:56:37 2014
GEN0 started with pid=5, OS id=30470
Wed Nov 19 15:56:37 2014
RECO started with pid=17, OS id=30494
Wed Nov 19 15:56:37 2014
MMON started with pid=18, OS id=30496
Wed Nov 19 15:56:37 2014
MMNL started with pid=19, OS id=30498
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /opt/oracle
Wed Nov 19 15:56:37 2014
ALTER DATABASE MOUNT
Successful mount of redo thread 1, with mount id 133515957
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE MOUNT
Wed Nov 19 15:56:46 2014
alter database open
Errors in file /opt/oracle/diag/rdbms/ods/ods/trace/ods_ora_30509.trc:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/opt/oracle/oradata/ods/system01.dbf'
ORA-1113 signalled during: alter database open...
------解决思路----------------------
使用http://www.orasos.com/oracle-recovery-check-script脚本检查数据库，然后发我html和alert日志
------解决思路----------------------
LZ 重建了控制文件吗？