database cannot be started, urgent!!!

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

log_archive_dest_1 string LOCATION=+ASM_ARCH_ESSP

ASKER

the filesystem is mounted.

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

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

Open in new window

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?

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.

>> 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.

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.

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.