Home » RDBMS Server » Performance Tuning » solaris 10 (oracle 10g)
solaris 10 [message #341730] Wed, 20 August 2008 02:19 Go to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
Mon Aug 18 18:11:58 2008
Thread 1 advanced to log sequence 29916
Current log# 2 seq# 29916 mem# 0: /ora10db/oradata/ora10g/redo02.log
Mon Aug 18 18:12:14 2008
Thread 1 cannot allocate new log, sequenCheckpoint not complete Current log# 2 seq# 29916 mem# 0: /ora10db/oradata/ora10g/redo02.log
Mon Aug 18 18:12:25 2008
Thread 1 advanced to log sequence 29917
Current log# 1 seq# 29917 mem# 0: /ora10db/oradata/ora10g/redo01.log
Mon Aug 18 20:28:41 2008
Starting background process EMN0
EMN0 started with pid=22, OS id=24166
Re: solaris 10 [message #341738 is a reply to message #341730] Wed, 20 August 2008 02:28 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Mon Aug 11 15:30:14 2008
Setting recovery target incarnation to 1
Mon Aug 11 15:30:14 2008
Successful mount of redo thread 1, with mount id 1538524864
Mon Aug 11 15:30:14 2008
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Mon Aug 11 15:30:14 2008
alter database open
Mon Aug 11 15:30:15 2008
Thread 1 opened at log sequence 580
Current log# 4 seq# 580 mem# 0: C:\ORACLE\BASES\MIKA\RL_G4_1.RDO
Current log# 4 seq# 580 mem# 1: C:\ORACLE\ARCHIVES\MIKA\RL_G4_2.RDO
Successful open of redo thread 1
Mon Aug 11 15:30:15 2008
SMON: enabling cache recovery
Mon Aug 11 15:30:17 2008
Successfully onlined Undo Tablespace 1.
Mon Aug 11 15:30:17 2008
SMON: enabling tx recovery
Mon Aug 11 15:30:17 2008
Database Characterset is WE8MSWIN1252
Opening with Resource Manager plan: SYSTEM_PLAN
where NUMA PG = 1, CPUs = 2
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=16, OS id=2320
Mon Aug 11 15:30:24 2008
ORA-942 signalled during: alter database open...
Mon Aug 11 15:30:26 2008
db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Mon Aug 11 22:00:08 2008
Thread 1 advanced to log sequence 581 (LGWR switch)
Current log# 1 seq# 581 mem# 0: C:\ORACLE\BASES\MIKA\RL_G1_1.RDO
Current log# 1 seq# 581 mem# 1: C:\ORACLE\ARCHIVES\MIKA\RL_G1_2.RDO
Tue Aug 12 02:29:36 2008
Thread 1 advanced to log sequence 582 (LGWR switch)
Current log# 2 seq# 582 mem# 0: C:\ORACLE\BASES\MIKA\RL_G2_1.RDO
Current log# 2 seq# 582 mem# 1: C:\ORACLE\ARCHIVES\MIKA\RL_G2_2.RDO
Tue Aug 12 07:00:37 2008
Thread 1 advanced to log sequence 583 (LGWR switch)
Current log# 3 seq# 583 mem# 0: C:\ORACLE\BASES\MIKA\RL_G3_1.RDO
Current log# 3 seq# 583 mem# 1: C:\ORACLE\ARCHIVES\MIKA\RL_G3_2.RDO
Tue Aug 12 16:08:18 2008
Thread 1 advanced to log sequence 584 (LGWR switch)
Current log# 4 seq# 584 mem# 0: C:\ORACLE\BASES\MIKA\RL_G4_1.RDO
Current log# 4 seq# 584 mem# 1: C:\ORACLE\ARCHIVES\MIKA\RL_G4_2.RDO
Wed Aug 13 02:00:55 2008
Thread 1 advanced to log sequence 585 (LGWR switch)
Current log# 1 seq# 585 mem# 0: C:\ORACLE\BASES\MIKA\RL_G1_1.RDO
Current log# 1 seq# 585 mem# 1: C:\ORACLE\ARCHIVES\MIKA\RL_G1_2.RDO
Re: solaris 10 [message #341739 is a reply to message #341738] Wed, 20 August 2008 02:32 Go to previous messageGo to next message
dirish
Messages: 205
Registered: November 2006
Senior Member
I got this error in my alert.log

Do you have any idea why i got this error?
Re: solaris 10 [message #341743 is a reply to message #341739] Wed, 20 August 2008 02:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do you know why I got mine?

Regards
Michel
Re: solaris 10 [message #341755 is a reply to message #341739] Wed, 20 August 2008 03:48 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Now do you understand what michal trying to say?
Re: solaris 10 [message #341779 is a reply to message #341738] Wed, 20 August 2008 05:11 Go to previous messageGo to next message
alanm
Messages: 282
Registered: March 2005
Senior Member

Hi,
Some really useful answers already posted.


Have you done any changes to the database or the application that uses the database.

regards

Alan
Re: solaris 10 [message #341796 is a reply to message #341779] Wed, 20 August 2008 06:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Some really useful answers already posted

And you add one more.

Regards
Michel
Re: solaris 10 [message #341848 is a reply to message #341739] Wed, 20 August 2008 09:42 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>I got this error in my alert.log
What error?
Re: solaris 10 [message #341882 is a reply to message #341848] Wed, 20 August 2008 12:40 Go to previous messageGo to next message
alanm
Messages: 282
Registered: March 2005
Senior Member

ora-942

Re: solaris 10 [message #341886 is a reply to message #341882] Wed, 20 August 2008 12:50 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
alanm wrote:
>> ora-942
Must be some black magic stuff as I am not seeing that from OP's posting.

That is from Michel's post, which is to make the point that there is nothing useful to start with in OP's post.
Previous Topic: Performance tunning
Next Topic: Performance Issues After Migration
Goto Forum:
  


Current Time: Fri Dec 09 13:52:43 CST 2016

Total time taken to generate the page: 0.09358 seconds