- 最后登录
- 2017-5-4
- 在线时间
- 81 小时
- 威望
- 999
- 金钱
- 2391
- 注册时间
- 2013-9-11
- 阅读权限
- 150
- 帖子
- 1124
- 精华
- 5
- 积分
- 999
- UID
- 1220
|
1#
发表于 2017-4-15 10:40:12
|
查看: 2064 |
回复: 0
数据库版本:Release 11.2.0.1.0
1. startup nomount阶段,可以正常。启动到mount状态时,报错:
SQL> startup nomount pfile='/home/oracle/pfile.ora';
ORACLE instance started.
Total System Global Area 2.0310E+10 bytes
Fixed Size 2212976 bytes
Variable Size 1.0737E+10 bytes
Database Buffers 9395240960 bytes
Redo Buffers 175132672 bytes
SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-03135: connection lost contact
Process ID: 27427
Session ID: 919 Serial number: 5
2. 如果直接startup mount:
SQL> create spfile from pfile='/home/oracle/pfile05.ora';
File created.
SQL> startup mount
ORACLE instance started.
Total System Global Area 2.0310E+10 bytes
Fixed Size 2212976 bytes
Variable Size 1.0737E+10 bytes
Database Buffers 9395240960 bytes
Redo Buffers 175132672 bytes
ORA-03113: end-of-file on communication channel
Process ID: 27573
Session ID: 919 Serial number: 3
3.alter里的信息:
Thu Jan 31 08:59:05 2013
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Thu Jan 31 08:59:17 2013
MAX_CONNECTIONS 20 too high - Using 5 connections.
Autotune of undo retention is turned on.
IMODE=BR
ILAT =134
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile /home/oracle/oracle/product/10.2.0/db_1/dbs/spfileorcl.ora
System parameters with non-default values:
processes = 800
memory_target = 19G
control_files = "/u/oracle/oradata/sdb/control01.ctl"
db_file_name_convert = "orcl"
db_file_name_convert = "sdb"
log_file_name_convert = "orcl"
log_file_name_convert = "sdb"
control_file_record_keep_time= 60
db_block_size = 8192
compatible = "11.2.0.0.0"
log_archive_dest_1 = "LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(all_logfiles,all_roles) db_unique_name=sdb"
log_archive_dest_2 = "service=orcl noaffirm async delay=0 net_timeout=600 reopen=10 max_connections=20 valid_for=(online_logfiles,primary_role) db_unique_name=orcl"
log_archive_dest_state_1 = "ENABLE"
log_archive_dest_state_2 = "enable"
log_archive_dest_state_3 = "ENABLE"
fal_client = "sdb"
fal_server = "orcl"
log_archive_config = "DG_CONFIG=(orcl,sdb)"
log_archive_format = "%t_%s_%r.arc"
log_archive_max_processes= 30
db_recovery_file_dest = "/u/oracle/oradata/sdb/flash_recovery_area"
db_recovery_file_dest_size= 500G
standby_file_management = "AUTO"
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
dispatchers = "(PROTOCOL=TCP) (SERVICE=orclXDB)"
local_listener = "LISTENER_ORCL"
audit_file_dest = "/home/oracle/oracle/admin/orcl/adump"
audit_trail = "DB"
db_name = "orcl"
db_unique_name = "sdb"
open_cursors = 300
diagnostic_dest = "/home/oracle/oracle"
Thu Jan 31 08:59:23 2013
PMON started with pid=2, OS id=27523
Thu Jan 31 08:59:23 2013
VKTM started with pid=3, OS id=27525 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Thu Jan 31 08:59:23 2013
GEN0 started with pid=4, OS id=27529
Thu Jan 31 08:59:23 2013
DIAG started with pid=5, OS id=27531
Thu Jan 31 08:59:23 2013
DBRM started with pid=6, OS id=27533
Thu Jan 31 08:59:23 2013
PSP0 started with pid=7, OS id=27535
Thu Jan 31 08:59:23 2013
DIA0 started with pid=8, OS id=27537
Thu Jan 31 08:59:23 2013
MMAN started with pid=9, OS id=27539
Thu Jan 31 08:59:23 2013
DBW0 started with pid=10, OS id=27541
Thu Jan 31 08:59:23 2013
LGWR started with pid=11, OS id=27543
Thu Jan 31 08:59:23 2013
CKPT started with pid=12, OS id=27545
Thu Jan 31 08:59:23 2013
SMON started with pid=13, OS id=27547
Thu Jan 31 08:59:23 2013
RECO started with pid=14, OS id=27549
Thu Jan 31 08:59:23 2013
MMON started with pid=15, OS id=27551
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Thu Jan 31 08:59:23 2013
MMNL started with pid=16, OS id=27553
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /home/oracle/oracle
Spfile /home/oracle/oracle/product/10.2.0/db_1/dbs/spfileorcl.ora is in old pre-11 format and compatible >= 11.0.0; converting to new H.A.R.D. compliant format.
Thu Jan 31 08:59:33 2013
ALTER DATABASE MOUNT
Thu Jan 31 09:00:27 2013
RECO (ospid: 27549): terminating the instance due to error 472
Instance terminated by RECO, pid = 27549
请问这个error 472到底代表什么?到底是什么原因呢?
再次尝试,会报如下错误:
Thu Jan 31 09:34:02 2013
ALTER DATABASE MOUNT
Thu Jan 31 09:35:01 2013
MMNL (ospid: 28345): terminating the instance due to error 472
Instance terminated by MMNL, pid = 28345
主备库用的是同版本的数据库,参数文件也是在主库上创建来的。
|
|