Home » RDBMS Server » Server Administration » ORA-01507: database not mounted (10.2.0.4.0,Linux 2.6)
ORA-01507: database not mounted [message #626718] |
Sat, 01 November 2014 00:42 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/bad4738d6d6c0d388b7b7a11db3b0430?s=64&d=mm&r=g) |
oracle11
Messages: 29 Registered: October 2014 Location: India
|
Junior Member |
|
|
Hi,
When i try to query database i see following error.
[oracle@server01 ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Sat Nov 1 06:33:40 2014
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select open_mode from v$database;
select open_mode from v$database
*
ERROR at line 1:
ORA-01507: database not mounted
This is standalone server having 2 databases and problem is with one database DB02.The other database DB01 is in read write mode.
And i see both databases are up and running on server as below.
[oracle@server01 ~]$ ps -ef|grep pmon
oracle 11483 11394 0 07:20 pts/1 00:00:00 grep pmon
oracle 13864 1 0 Oct27 ? 00:00:01 ora_pmon_DB01
oracle 19046 1 0 Oct28 ? 00:00:01 ora_pmon_DB02
Thanks,
[Updated on: Sat, 01 November 2014 01:27] Report message to a moderator
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Re: ORA-01507: database not mounted [message #626744 is a reply to message #626738] |
Sat, 01 November 2014 14:49 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
oracle11 wrote on Sat, 01 November 2014 15:59Hi Stevens,
The change is in production database so don't want to take any risk without confirmation.
Regards,
According to your first post, the database has been in this state since at least October 28. It is now November 1. I do wonder what sort of production is going on.
|
|
|
Re: ORA-01507: database not mounted [message #626752 is a reply to message #626744] |
Sat, 01 November 2014 21:31 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/bad4738d6d6c0d388b7b7a11db3b0430?s=64&d=mm&r=g) |
oracle11
Messages: 29 Registered: October 2014 Location: India
|
Junior Member |
|
|
Hi John/Michel/Blackswan,
I followed below steps but ended with error. Could you help me to fix this error.
SQL> alter system set control_files='/sagscm/redo1/control01.ctl','/sagscm/redo2/control02.ctl' scope=spfile;
System altered.
SQL> shutdown immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 3.4360E+10 bytes
Fixed Size 2147040 bytes
Variable Size 905973024 bytes
Database Buffers 3.3437E+10 bytes
Redo Buffers 14626816 bytes
Database mounted.
ORA-00338: log 4 of thread 1 is more recent than control file
ORA-00312: online log 4 thread 1: '/sagscm/redo2/redo04.log'
ORA-00338: log 4 of thread 1 is more recent than control file
ORA-00312: online log 4 thread 1: '/sagscm/redo3/redo04.log'
ORA-00338: log 4 of thread 1 is more recent than control file
ORA-00312: online log 4 thread 1: '/sagscm/redo1/redo04.log'
Regards
[Updated on: Sat, 01 November 2014 23:04] Report message to a moderator
|
|
|
Re: ORA-01507: database not mounted [message #626753 is a reply to message #626752] |
Sat, 01 November 2014 23:23 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/bad4738d6d6c0d388b7b7a11db3b0430?s=64&d=mm&r=g) |
oracle11
Messages: 29 Registered: October 2014 Location: India
|
Junior Member |
|
|
Hi All,
Good news is that database is in read write mode.Not sure how it came to read write mode.
SQL> select name,instance_name,OPEN_MODE,TO_CHAR(STARTUP_TIME,'DD-MON-YYYY HH24:MI:SS') "STARTUP_TIME" ,STATUS,LOGINS,database_role from v$instance,v$database;
NAME INSTANCE_N OPEN_MODE STARTUP_TIME STATU LOGINS DATABASE_ROLE
---------- ---------- ---------- -------------------- ----- ---------- --------------------
CO_DB02 DB02 [b]READ WRITE[/b] 02-NOV-2014 03:29:26 OPEN ALLOWED PRIMARY
Now i could see the output of control_files parameter as below
SQL> select name,value from v$spparameter where name='control_files';
NAME VALUE
--------------- ------------------------------
control_files /sagscm/redo1/control01.ctl
control_files /sagscm/redo2/control02.ctl
SQL> show parameter control
NAME TYPE VALUE
------------------------------------ --------------------------------- ------------------------------
control_file_record_keep_time integer 30
control_files string /sagscm/redo1/control01.ctl, /
sagscm/redo2/control02.ctl
SQL>
Here is the alert log entries during database open.
Sun Nov 2 03:28:56 2014
ALTER SYSTEM SET control_files='/sagscm/redo1/control01.ctl','/sagscm/redo2/control02.ctl' SCOPE=SPFILE;
Sun Nov 2 03:29:12 2014
Shutting down instance: further logons disabled
Sun Nov 2 03:29:12 2014
Stopping background process CJQ0
Sun Nov 2 03:29:12 2014
Stopping background process MMNL
Sun Nov 2 03:29:13 2014
Stopping background process MMON
Sun Nov 2 03:29:14 2014
Shutting down instance (immediate)
License high water mark = 3
Sun Nov 2 03:29:14 2014
Stopping Job queue slave processes, flags = 7
Sun Nov 2 03:29:14 2014
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
Waiting for dispatcher 'D001' to shutdown
Waiting for dispatcher 'D002' to shutdown
Waiting for dispatcher 'D003' to shutdown
Waiting for dispatcher 'D004' to shutdown
All dispatchers and shared servers shutdown
Sun Nov 2 03:29:16 2014
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Shutting down Data Guard Broker processes
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Sun Nov 2 03:29:26 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =154
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.4.0.
System parameters with non-default values:
PMON started with pid=2, OS id=29292
PSP0 started with pid=3, OS id=29294
MMAN started with pid=4, OS id=29296
DBW0 started with pid=5, OS id=29298
DBW1 started with pid=6, OS id=29300
LGWR started with pid=7, OS id=29302
CKPT started with pid=8, OS id=29304
SMON started with pid=9, OS id=29306
RECO started with pid=10, OS id=29308
CJQ0 started with pid=11, OS id=29310
MMON started with pid=12, OS id=29312
Sun Nov 2 03:29:27 2014
starting up 5 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=13, OS id=29314
Sun Nov 2 03:29:27 2014
starting up 12 shared server(s) ...
DMON started with pid=31, OS id=29350
Sun Nov 2 03:29:27 2014
ALTER DATABASE MOUNT
Sun Nov 2 03:29:34 2014
Setting recovery target incarnation to 11
Sun Nov 2 03:29:34 2014
Successful mount of redo thread 1, with mount id 3194398938
Sun Nov 2 03:29:34 2014
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Sun Nov 2 03:29:34 2014
ALTER DATABASE OPEN
Sun Nov 2 03:29:35 2014
Starting Data Guard Broker (DMON)
NSV1 started with pid=33, OS id=30070
Sun Nov 2 03:29:37 2014
Beginning crash recovery of 1 threads
parallel recovery started with 15 processes
Archivelog destination LOG_ARCHIVE_DEST_3 validated for no-data-loss recovery
Sun Nov 2 03:29:38 2014
Errors in file /opt/oracle/admin/GSCM/udump/gscm_ora_30062.trc:
ORA-00338: log 4 of thread 1 is more recent than control file
ORA-00312: online log 4 thread 1: '/sagscm/redo2/redo04.log'
ORA-00338: log 4 of thread 1 is more recent than control file
ORA-00312: online log 4 thread 1: '/sagscm/redo3/redo04.log'
ORA-00338: log 4 of thread 1 is more recent than control file
ORA-00312: online log 4 thread 1: '/sagscm/redo1/redo04.log'
Sun Nov 2 03:29:38 2014
Aborting crash recovery due to error 338
Sun Nov 2 03:29:38 2014
Errors in file /opt/oracle/admin/GSCM/udump/gscm_ora_30062.trc:
ORA-00338: log 4 of thread 1 is more recent than control file
ORA-00312: online log 4 thread 1: '/sagscm/redo2/redo04.log'
ORA-00338: log 4 of thread 1 is more recent than control file
ORA-00312: online log 4 thread 1: '/sagscm/redo3/redo04.log'
ORA-00338: log 4 of thread 1 is more recent than control file
ORA-00312: online log 4 thread 1: '/sagscm/redo1/redo04.log'
Regards,
|
|
|
|
Re: ORA-01507: database not mounted [message #626757 is a reply to message #626755] |
Sun, 02 November 2014 01:03 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/bad4738d6d6c0d388b7b7a11db3b0430?s=64&d=mm&r=g) |
oracle11
Messages: 29 Registered: October 2014 Location: India
|
Junior Member |
|
|
Hi Michel,
Here is the content of the alert log.Please tell me if you need further contents of it for your analyze and help me to fix the issue.
ORA-00202: control file: '/sagscm/redo1/control01.ctl,/sagscm/redo2/control02.ctl'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Sat Nov 1 07:47:35 2014
ORA-205 signalled during: alter database mount...
Sun Nov 2 03:28:56 2014
ALTER SYSTEM SET control_files='/sagscm/redo1/control01.ctl','/sagscm/redo2/control02.ctl' SCOPE=SPFILE;
Sun Nov 2 03:29:12 2014
Shutting down instance: further logons disabled
Sun Nov 2 03:29:12 2014
Stopping background process CJQ0
Sun Nov 2 03:29:12 2014
Stopping background process MMNL
Sun Nov 2 03:29:13 2014
Stopping background process MMON
Sun Nov 2 03:29:14 2014
Shutting down instance (immediate)
License high water mark = 3
Sun Nov 2 03:29:14 2014
Stopping Job queue slave processes, flags = 7
Sun Nov 2 03:29:14 2014
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
Waiting for dispatcher 'D001' to shutdown
Waiting for dispatcher 'D003' to shutdown
Waiting for dispatcher 'D004' to shutdown
All dispatchers and shared servers shutdown
Sun Nov 2 03:29:16 2014
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Shutting down Data Guard Broker processes
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Sun Nov 2 03:29:26 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =154
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.4.0.
PMON started with pid=2, OS id=29292
PSP0 started with pid=3, OS id=29294
MMAN started with pid=4, OS id=29296
DBW0 started with pid=5, OS id=29298
DBW1 started with pid=6, OS id=29300
LGWR started with pid=7, OS id=29302
CKPT started with pid=8, OS id=29304
SMON started with pid=9, OS id=29306
RECO started with pid=10, OS id=29308
CJQ0 started with pid=11, OS id=29310
MMON started with pid=12, OS id=29312
Sun Nov 2 03:29:27 2014
starting up 5 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=13, OS id=29314
Sun Nov 2 03:29:27 2014
starting up 12 shared server(s) ...
DMON started with pid=31, OS id=29350
Sun Nov 2 03:29:27 2014
ALTER DATABASE MOUNT
Sun Nov 2 03:29:34 2014
Setting recovery target incarnation to 11
Sun Nov 2 03:29:34 2014
Successful mount of redo thread 1, with mount id 3194398938
Sun Nov 2 03:29:34 2014
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Sun Nov 2 03:29:34 2014
ALTER DATABASE OPEN
Sun Nov 2 03:29:35 2014
Starting Data Guard Broker (DMON)NSV1 started with pid=33, OS id=30070
Sun Nov 2 03:29:37 2014
Beginning crash recovery of 1 threads
parallel recovery started with 15 processes
Archivelog destination LOG_ARCHIVE_DEST_3 validated for no-data-loss recovery
Sun Nov 2 03:29:38 2014
Errors in file /opt/oracle/admin/DB02/udump/DB02_ora_30062.trc:
ORA-00338: log 4 of thread 1 is more recent than control file
ORA-00312: online log 4 thread 1: '/sagscm/redo2/redo04.log'
ORA-00338: log 4 of thread 1 is more recent than control file
ORA-00312: online log 4 thread 1: '/sagscm/redo3/redo04.log'
ORA-00338: log 4 of thread 1 is more recent than control file
ORA-00312: online log 4 thread 1: '/sagscm/redo1/redo04.log'
Sun Nov 2 03:29:38 2014
Aborting crash recovery due to error 338
Sun Nov 2 03:29:38 2014
Errors in file /opt/oracle/admin/DB02/udump/DB02_ora_30062.trc:
ORA-00338: log 4 of thread 1 is more recent than control file
ORA-00312: online log 4 thread 1: '/sagscm/redo2/redo04.log'
ORA-00338: log 4 of thread 1 is more recent than control file
ORA-00312: online log 4 thread 1: '/sagscm/redo3/redo04.log'
ORA-00338: log 4 of thread 1 is more recent than control file
ORA-00312: online log 4 thread 1: '/sagscm/redo1/redo04.log'
ORA-338 signalled during: ALTER DATABASE OPEN...
INSV started with pid=49, OS id=30120
RSM0 started with pid=50, OS id=2251
INSV started with pid=49, OS id=30120
RSM0 started with pid=50, OS id=2251
Sun Nov 2 03:33:00 2014
ALTER SYSTEM SET log_archive_dest_3='service="(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(HOST=oudwhdb01.europe.nokia.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=DB02_OULU_XPT.nokia.com)(INSTANCE_NAME=DB02)(SERVER=dedicated)))"',' LGWR SYNC AFFIRM delay=0 OPTIONAL max_failure=0 max_connections=1 reopen=300 db_unique_name="DB02_OULU" register net_timeout=180 valid_for=(online_logfile,primary_role)' SCOPE=BOTH;
Sun Nov 2 03:33:00 2014
ALTER SYSTEM SET log_archive_dest_state_3='ENABLE' SCOPE=BOTH;
Sun Nov 2 03:33:00 2014
ALTER DATABASE OPEN
Sun Nov 2 03:33:00 2014
Beginning crash recovery of 1 threads
parallel recovery started with 15 processes
Archivelog destination LOG_ARCHIVE_DEST_3 validated for no-data-loss recovery
ARCH: Standby redo logfile selected for thread 1 sequence 69236 for destination LOG_ARCHIVE_DEST_3
Sun Nov 2 03:33:00 2014
Started redo scan
Sun Nov 2 03:33:08 2014
Completed redo scan
1852300 redo blocks read, 99390 data blocks need recovery
Sun Nov 2 03:33:43 2014
Started redo application at
Thread 1: logseq 69234, block 184004
Sun Nov 2 03:33:46 2014
Recovery of Online Redo Log: Thread 1 Group 2 Seq 69234 Reading mem 0
Mem# 0: /sagscm/redo1/redo02.log
Mem# 1: /sagscm/redo3/redo02.log
Mem# 2: /sagscm/redo2/redo02.log
Sun Nov 2 03:33:49 2014
Recovery of Online Redo Log: Thread 1 Group 3 Seq 69235 Reading mem 0
Regards,
[Updated on: Sun, 02 November 2014 01:14] Report message to a moderator
|
|
|
|
|
|
|
Re: ORA-01507: database not mounted [message #626763 is a reply to message #626760] |
Sun, 02 November 2014 02:25 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
oracle11 wrote on Sun, 02 November 2014 08:00Hi Michel,
Quote:So your database is up and running, no more problem.
I am happy to hear that my database is fine.However i have a query.
In this thread you said below one,but my database is in read write mode.Is that not an issue?Can you confirm ?
Quote:So OPEN_MODE and STATUS should be MOUNTED.
Regards,
Perhaps the problem comes with that you were not telling the truth (presumably, by accident?) You posted this:
Quote:SQL> select name,instance_name,OPEN_MODE,TO_CHAR(STARTUP_TIME,'DD-MON-YYYY HH24:MI:SS') "STARTUP_TIME" ,STATUS,LOGINS,database_role from v$instance,v$database; NAME INSTANCE_N OPEN_MODE STARTUP_TIME STATU LOGINS DATABASE_ROLE ---------- ---------- ---------- -------------------- ----- ---------- -------------------- CO_DB02 DB02 READ WRITE 02-NOV-2014 03:29:26 OPEN ALLOWED PRIMARY Note the time.
Then you posted sections of an alert log that overlapped this time, and show that the query was impossible.
|
|
|
|
Goto Forum:
Current Time: Sat Sep 07 21:38:45 CDT 2024
|