摘要：
1、修改完成spfile之后，需要重启Oracle,以使参数生效. 阅读全文
摘要：
1、问题描述View Code [oracle@DG3 admin]$ sqlplus sys/oracle as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Thu Mar 28 16:12:08 2013Copyright (c) 1982, 2009, Oracle. All rights reserved.Connected to an idle instance.SQL> startupORA-00119: invalid specification for system parameter LOCAL_LISTENEROR 阅读全文
摘要：
1、SQL>startup mount数据库进入mount状态，只可以读取控制文件信息，不可以读取数据文件信息；2、SQL>alter database open将数据库切换到open状态3、查询数据库状态SQL> select dbid,name,switchover_status,db_unique_name,database_role,open_mode,current_scn from v$database; DBID NAME SWITCHOVER_STATUS DB_UNIQUE_NAME DATABASE_ROLE ... 阅读全文
摘要：
Types of Incomplete RecoveryTime-based recoveryCancel-based recoveryChange-based recoveryIncomplete RecoveryFollow all steps carefullyTake whole database backups before and after recovery.Always verify that the recovery was successful.Back up and remove archived logs.Incomplete and the Alert LogChec 阅读全文