Home » RDBMS Server » Server Administration » Cannot start Oracle -- unable to find file (Oracle 11g XE)
Cannot start Oracle -- unable to find file [message #643308] Sun, 04 October 2015 02:24 Go to previous message
Eric Langager
Messages: 38
Registered: April 2004
Location: Beijing, China
Member
Hi.

I am trying to start my Oracle database and continue to get the following errors:

ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated
ORA-01263: Name given for file destination directory is invalid
OSD-04018: Unable to access the specified directory or device.
O/S-Error: (OS 3) The system cannot find the path specified.

I cannot understand this, because the archived redo log files are where they are supposed to be. But I notice that the backup I did last night (see log below) does not appear to be anywhere in sight. So I am wondering if there is a problem with the backup that affected archiving.

Since my database is for personal data and not always on, I could get by without archiving. But the problem is that I cannot turn off archiving without starting the database and the database won't start.

Any ideas?




Recovery Manager: Release 11.2.0.2.0 - Production on Sat Oct 3 22:15:54 2015

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Windows NT Version V6.1 Service Pack 1
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x0x00000000
Memory (Avail/Total): Ph:1753M/3062M, Ph+PgF:4079M/6122M, VA:1940M/2047M
Starting with debugging turned off

connected to target database: XE (DBID=2729942492)

RMAN> set echo on;
2> sql 'alter system archive log current';
3>
echo set on

using target database control file instead of recovery catalog
sql statement: alter system archive log current

Recovery Manager complete.



 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Oracle 10g upgrade to 11g with asm non rac
Next Topic: How we can check all DB Link connections.
Goto Forum:
  


Current Time: Sat Apr 20 02:38:13 CDT 2024