This content has been marked as final. Show 5 replies
Hi, can you give the open mode of your database: select open_mode from v$database;
Edited by: user12215372 on 10/11/2012 11:37 PM
can you perform the on standby and paste the result:
1. select name from v$datafile
2. show parameter file_name_convert
3. show parameter db_unique_name
If locks on data files were not released follow these steps :
Reboot the Server
If you are using NFS you should do this before the reboot :
clear_locks -s <nfs_server_host>
And then restart the NFS client
Can you please confirm if the data files are present on both primary and standby?
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_dbw0_11087.trc:
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
ORA-01110: data file 5: '/u01/app/oracle/orcl/example01.dbf'
ORA-27086: unable to lock file - already in use
Linux Error: 11: Resource temporarily unavailable
Additional information: 8
Additional information: 10950
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_11152.trc:
ORA-01157: cannot identify/lock data file 2 - see DBWR trace file
ORA-01110: data file 2: '/u01/app/oracle/orcl/sysaux01.dbf'
ORA-1157 signalled during: ALTER DATABASE OPEN...
I think you have already lot of questions. Besides update output of the below query also
Shutdown completely, again startup in "MOUNT" status and then
SQL> select file#, name,status,error,fuzzy from v$datafile_header;and
$ls -ltr /u01/app/oracle/orcl/