ORA-01113、ORA-01110经典有关问题
发布时间:2010-05-20 14:01:29 文章来源:www.iduyao.cn 采编人员:星星草
ORA-01113、ORA-01110经典问题
数据库断电后,经过各种折腾,现在启动的时候如下:
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 重建了控制文件吗?
友情提示:
信息收集于互联网,如果您发现错误或造成侵权,请及时通知本站更正或删除,具体联系方式见页面底部联系我们,谢谢。
其他相似内容:
-
创建同义词报ORA-00955
各位大神,我创建公有同义词,怎么会报ORA-00955错?很多人遇到建立私有同义词有这个错,我怎么建立公有同义词也...
-
impdp导入为什么索引会占的非常大。
本帖最后由 xixi_168 于 2014-07-19 23:10:47 编辑
在做数据...
-
ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务
测试没有成功。
ORA-12514: TNS: 监听程序当前无法识别连接描述...
-
oracle神牛进!!!
1、如何用sql查出oracle自带的所有函数?
2、给定ascii码,如何用sql查出对应的字符?
3、为什么在java中和在oracl...
-
oracle的cmd执行一个.sql文件,遇到异常时退出而不是继续执行
假设有一个1.sql文件,内容是
Declare
X varchar2(20);
Begin
Sc...
-
oracle查看某一条记录中为空的字段总数
oralce中,某一条记录中怎么得到这条记录中字段值为空的总数呢?(不为空的总数也可)
比如:id a1...
-
三台ORACLE通信,DBLINK
三台ORACLE服务器,A、B、C,其中A和B在同一个内网,B为双网卡可以连接外网,C为外网ORACLE。现在在B上已经建立DBL...
-
OracleOraDb10g_home1TNSListener无法启动
OracleOraDb10g_home1TNSListener无法启动,每次启动都提示:“在本地计算机无法启动Ora...
-
虚拟机安装RAC,网卡可以用NAT方式连接吗?
大家好:
我看教程上设的,安装配置RAC,配置虚拟机的两块网卡,第一块网卡(eth0,配置公用I...
-
求解oracle监听服务名问题
最近在做服务器的双机热备时,发现两边的监听服务名不一致,一个是OracleOraDb11g_home1TNSListen...