Shulou(Shulou.com)05/31 Report--

Editor to share with you about the oradb startup times wrong ORA-01261&&ORA-00202 how to do, I hope you will learn something after reading this article, let's discuss it together!

System environment: windows server 2008R2

Database environment: oracle 11.2.0.1

Problem description: a test database oradb starts up with an error ORA-01261&&ORA-00202, and the error log is as follows:

C:\ Users\ localadmin > sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Tuesday August 8 10:12:29 2017

Copyright (c) 1982, 2010, Oracle. All rights reserved.

Connected to an idle routine.

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 error ORA-01261&&ORA-01263 means: the flashback zone is enabled in the current database, but the directory set by the current flashback parameter db_recovery_file_dest no longer exists: ORA-01263: Name given for file destination directory is invalid

The solution is simple: check the startup parameter file pfile (ORACLE_HOME/dbs/initoradb.ora), look at the file directory configuration of db_recovery_file_dest, view the storage, and create a modified directory:

* .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'

Note that you also need to create an oradb folder under the flash_recovery_area directory, and then copy the latest control file from the data file directory to oradb and rename it to control02.ctl

Otherwise, an error will be reported when starting the database:

SQL > startup

The ORACLE routine has been started.

Total System Global Area 3290345472 bytes

Fixed Size 2180224 bytes

Variable Size 1979714432 bytes

Database Buffers 1291845632 bytes

Redo Buffers 16605184 bytes

ORA-00205:?,?,?

Alarm log content:

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: unable to open file

O/S-Error: (OS 3) the system cannot find the specified path.

ORA-205 signalled during: ALTER DATABASE MOUNT...

Then, starting the database again starts normally:

SQL > startup

The ORACLE routine has been started.

Total System Global Area 3290345472 bytes

Fixed Size 2180224 bytes

Variable Size 1979714432 bytes

Database Buffers 1291845632 bytes

Redo Buffers 16605184 bytes

The database is loaded.

The database is already open.

SQL >

After reading this article, I believe you have a certain understanding of "what to do with the wrong ORA-01261&&ORA-00202 in the oradb startup times". If you want to know more about it, welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.