Cannot start Oracle -- unable to find file [message #643308] |
Sun, 04 October 2015 02:24 |
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.
|
|
|