Jason Yu
asked on
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.2 72.8191085 39'
ORA-00312: online log 8 thread 2:
'+ASM_REDO2/essp/onlinelog /group_8.2 72.8191085 43'
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
ORA-00312: online log 8 thread 2:
'+ASM_REDO2/essp/onlinelog
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
the filesystem is mounted.
how should I check the ownership of the ASM disks?
how should I check the ownership of the ASM disks?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
How to check this parameter? db_recovery_file_dest_size ??
ASKER
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
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
ASKER
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
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes, you are correct. We changed the parameter to save the achieve log to local file system resolved this issue.
ASKER
We had successfully retarted the db.
BTW, we increased the lun size, but the asm didn't see it, could you explain why?
BTW, we increased the lun size, but the asm didn't see it, could you explain why?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
>>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.
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.
>> 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.
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
All this your DBA should be able to help you with.
ASKER
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.
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
thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Very good answer and helpful suggestions.
thank you.
thank you.
ASKER