database cannot be started, urgent!!!

Total System Global Area 9637228544 bytes
Fixed Size                  2248088 bytes
Variable Size            5687476840 bytes
Database Buffers         3925868544 bytes
Redo Buffers               21635072 bytes
Database mounted.
ORA-16038: log 8 sequence# 12796 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 8 thread 2:
'+ASM_REDO1/essp/onlinelog/group_8.272.819108539'
ORA-00312: online log 8 thread 2:
'+ASM_REDO2/essp/onlinelog/group_8.272.819108543'
Jason YuAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
>>I am the system admin here and learned some DBA's skill.

I would be very careful about making database changes without the DBA approving them.

Many shops have a separation of duties that defines who can do what in the system.

I assume you are authorized to make database changes?

Remember: Ability to do something and permission to do it are two different things.

Making changes to the database on the fly without authorization might get you fired!

>>If I want to add more space to ASM_ARCH_ESSP, how could I do it.

You can keep asking this but my answer will be the same:
I don't know.  I've never used ASM.  Your DBA should know.

>> Does this mean we don't use flash backup at all?

It may be an ASM item.  Since I've never used ASM I don't know if this parameter does anything.  Your DBA should know.
0
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
What is the parameter log_archive_dest_1 set to?

Is that filesystem mounted?
Is the ownership correct?
0
 
Jason YuAuthor Commented:
log_archive_dest_1                   string      LOCATION=+ASM_ARCH_ESSP
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
Jason YuAuthor Commented:
the filesystem is mounted.


how should I check the ownership of the ASM disks?
0
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
Sorry, I'm not an ASM Expert.  I was thinking the archived redo would be on a regular filesystem.

What is db_recovery_file_dest_size set to?   If you have space available, you might just need to increase this parameter.

I assume you have been removing the archived redo logs that you no longer need for recovery?
0
 
Jason YuAuthor Commented:
How to check this parameter?  db_recovery_file_dest_size ??
0
 
Jason YuAuthor Commented:
ASMCMD> lsdg
State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  EXTERN  N         512   4096  1048576    101982      486                0             486              0             N  ASM_ARCH_ESSP/
MOUNTED  EXTERN  N         512   4096  1048576    305964   305826                0          305826              0             N  ASM_ARCH_MEMBP/
MOUNTED  EXTERN  N         512   4096  1048576     10134     9736                0            9736              0             Y  ASM_CLUSTER/
MOUNTED  EXTERN  N         512   4096  1048576     20387    20284                0           20284              0             N  ASM_CONFIG_ESSP/
MOUNTED  EXTERN  N         512   4096  1048576     20387    20284                0           20284              0             N  ASM_CONFIG_MEMBP/
MOUNTED  EXTERN  N         512   4096  1048576     10134    10006                0           10006              0             N  ASM_CTL_ESSP/
MOUNTED  EXTERN  N         512   4096  1048576     10134    10006                0           10006              0             N  ASM_CTL_MEMBP/
MOUNTED  EXTERN  N         512   4096  1048576    150513    17143                0           17143              0             N  ASM_DATA_ESSP/
MOUNTED  EXTERN  N         512   4096  1048576    301026   215527                0          215527              0             N  ASM_DATA_MEMBP/
MOUNTED  EXTERN  N         512   4096  1048576    255996   146173                0          146173              0             N  ASM_DATA_MPDP/
MOUNTED  EXTERN  N         512   4096  1048576    409618   373610                0          373610              0             N  ASM_FRA_MPDP/
MOUNTED  EXTERN  N         512   4096  1048576     61168    24128                0           24128              0             N  ASM_REDO1/
MOUNTED  EXTERN  N         512   4096  1048576     61168    24128                0           24128              0             N  ASM_REDO2/
ASMCMD> exit
0
 
Jason YuAuthor Commented:
ASMCMD> lsdg
State    Type    Rebal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  EXTERN  N         512   4096  1048576    101982      486                0             486              0             N  ASM_ARCH_ESSP/
MOUNTED  EXTERN  N         512   4096  1048576    305964   305826                0          305826              0             N  ASM_ARCH_MEMBP/
MOUNTED  EXTERN  N         512   4096  1048576     10134     9736                0            9736              0             Y  ASM_CLUSTER/
MOUNTED  EXTERN  N         512   4096  1048576     20387    20284                0           20284              0             N  ASM_CONFIG_ESSP/
MOUNTED  EXTERN  N         512   4096  1048576     20387    20284                0           20284              0             N  ASM_CONFIG_MEMBP/
MOUNTED  EXTERN  N         512   4096  1048576     10134    10006                0           10006              0             N  ASM_CTL_ESSP/
MOUNTED  EXTERN  N         512   4096  1048576     10134    10006                0           10006              0             N  ASM_CTL_MEMBP/
MOUNTED  EXTERN  N         512   4096  1048576    150513    17143                0           17143              0             N  ASM_DATA_ESSP/
MOUNTED  EXTERN  N         512   4096  1048576    301026   215527                0          215527              0             N  ASM_DATA_MEMBP/
MOUNTED  EXTERN  N         512   4096  1048576    255996   146173                0          146173              0             N  ASM_DATA_MPDP/
MOUNTED  EXTERN  N         512   4096  1048576    409618   373610                0          373610              0             N  ASM_FRA_MPDP/
MOUNTED  EXTERN  N         512   4096  1048576     61168    24128                0           24128              0             N  ASM_REDO1/
MOUNTED  EXTERN  N         512   4096  1048576     61168    24128                0           24128              0             N  ASM_REDO2/
ASMCMD> exit

Open in new window

0
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
>>How to check this parameter?  db_recovery_file_dest_size ??

Same way you checked log_archive_dest_1.  It is an spfile parameter.



The lsdg commands don't mean anything to me since I'm not an ASM person.
0
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
Sorry.  Missed this.

Even though I'm not an ASM person it looks like ASM_ARCH_ESSP is about out of space with only 486M free.
0
 
Jason YuAuthor Commented:
Yes, you are correct. We changed the parameter to save the achieve log to local file system resolved this issue.
0
 
Jason YuAuthor Commented:
We had successfully retarted the db.

BTW, we increased the lun size, but the asm didn't see it, could you explain why?
0
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
>>We changed the parameter to save the achieve log to local file system resolved this issue.

You need to be careful now that you will have archived redo logs in two different locations!!!

>>we increased the lun size, but the asm didn't see it, could you explain why?

Nope.  I'm not an ASM person.  Never used it.

I would check with the DBA that set everything up to see how to tweak the space.  You might even open an SR with Oracle Support.

While you wait for them I would dive into the online documentation and start reading up on administering ASM.  There has to be information in there about increasing available space.
0
 
Jason YuAuthor Commented:
>>We changed the parameter to save the achieve log to local file system resolved this issue.

You need to be careful now that you will have archived redo logs in two different locations!!!


How should I resolve this issue?

Thanks for remindering.
0
 
slightwv (䄆 Netminder) Commented:
>> How should I resolve this issue?

I would verify that you are removing old archived redo logs after they have been backed up so the space can be reused.

If they are all necessary this implies adequate space wasn't allocated when ASM was set up.  I would look ad adding more space to ASM_ARCH_ESSP.

I would also make sure that db_recovery_file_dest_size is set correctly.

All this your DBA should be able to help you with.
0
 
Jason YuAuthor Commented:
HI, Slightwv:

Thank you very much, I will work with our DBA on this. I am the system admin here and learned some DBA's skill.

If I want to add more space to ASM_ARCH_ESSP, how could I do it. I already increased the lun size on the SAN side, however, after that, the Oracle ASM still doesn't recognize the increased size. I may need research on how to make ASM expand the size.


Also, for the parameter db_recovery_file_dest_size, it was set "0". Does this mean we don't use flash backup at all?

thanks.
0
 
Jason YuAuthor Commented:
Very good answer and helpful suggestions.

thank you.
0
All Courses

From novice to tech pro — start learning today.