oradb啟動時報錯ORA-01261&&ORA-00202怎么辦

小編給大家分享一下oradb啟動時報錯ORA-01261&&ORA-00202怎么辦，希望大家閱讀完這篇文章之后都有所收獲，下面讓我們一起去探討吧！

    系統(tǒng)環(huán)境：windows server 2008R2
   數(shù)據(jù)庫環(huán)境：oracle 11.2.0.1
   問題描述：一測試數(shù)據(jù)庫oradb啟動時報錯ORA-01261&&ORA-00202，報錯日志如下：
C:\Users\localadmin>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on 星期二 8月 8 10:12:29 2017
Copyright (c) 1982, 2010, Oracle.  All rights reserved.
已連接到空閑例程。
SQL> startup;
ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated
ORA-01263: Name given for file destination directory is invalid
OSD-04018: ??????????????????????????
O/S-Error: (OS 2) ??????????????????????
SQL> 
   startup報錯ORA-01261&&ORA-01263的意思是：當(dāng)前數(shù)據(jù)庫開啟了閃回區(qū)，但是當(dāng)前閃回區(qū)參數(shù)db_recovery_file_dest設(shè)置的目錄不存在了：ORA-01263: Name given for file destination directory is invalid
   解決方法很簡單，查看啟動參數(shù)文件pfile（ORACLE_HOME/dbs/initoradb.ora），看db_recovery_file_dest的文件目錄配置，查看存儲并創(chuàng)建改目錄 ：
*.aq_tm_processes=0
*.audit_file_dest='C:\oracle\admin\oradb\adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='C:\oracle\oradata\oradb\control01.ctl','C:\oracle\flash_recovery_area\oradb\control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='oradb'
*.db_recovery_file_dest='C:\oracle\flash_recovery_area'
*.db_recovery_file_dest_size=4294967296
*.diagnostic_dest='C:\oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=oradbXDB)'
*.job_queue_processes=0
*.log_archive_format='ARC%S_%R.%T'
*.memory_target=3294625792
*.nls_language='SIMPLIFIED CHINESE'
*.nls_territory='CHINA'
*.open_cursors=300
*.optimizer_use_sql_plan_baselines=TRUE
*.processes=200
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'

需要注意的是，還需要在flash_recovery_area目錄下創(chuàng)建oradb文件夾，然后從數(shù)據(jù)文件目錄拷貝最新的控制文件到oradb下并重命名為control02.ctl
否則，啟動數(shù)據(jù)庫時會報錯：
SQL> startup;
ORACLE 例程已經(jīng)啟動。
Total System Global Area 3290345472 bytes
Fixed Size                  2180224 bytes
Variable Size            1979714432 bytes
Database Buffers         1291845632 bytes
Redo Buffers               16605184 bytes
ORA-00205: ?????????, ??????, ???????

告警日志內(nèi)容：
Tue Aug 08 10:14:41 2017
MMNL started with pid=16, OS id=11856 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = C:\oracle
Tue Aug 08 10:14:41 2017
ALTER DATABASE   MOUNT
ORA-00210: ???????????
ORA-00202: ????: ''C:\ORACLE\FLASH_RECOVERY_AREA\ORADB\CONTROL02.CTL''
ORA-27041: ??????
OSD-04002: 無法打開文件
O/S-Error: (OS 3) 系統(tǒng)找不到指定的路徑。
ORA-205 signalled during: ALTER DATABASE   MOUNT...
   然后，再次啟動數(shù)據(jù)庫能夠正常啟動：
SQL> startup;
ORACLE 例程已經(jīng)啟動。
Total System Global Area 3290345472 bytes
Fixed Size                  2180224 bytes
Variable Size            1979714432 bytes
Database Buffers         1291845632 bytes
Redo Buffers               16605184 bytes
數(shù)據(jù)庫裝載完畢。
數(shù)據(jù)庫已經(jīng)打開。
SQL>

看完了這篇文章，相信你對“oradb啟動時報錯ORA-01261&&ORA-00202怎么辦”有了一定的了解，如果想了解更多相關(guān)知識，歡迎關(guān)注億速云行業(yè)資訊頻道，感謝各位的閱讀！