ORA-01237: cannot extend datafile, (Using ASM, and standby)

Posted on 2009-04-15
Last Modified: 2013-12-18
Hi, we have a standby server and the replication stopped with space issue on disk group ORADATA00,  and i checked that ORADATA01 have a lot of disk space,
Can i resize ORADATA01 to occupie less space and increase the ORADATA00?
I´m think that it is not possible because raw device, but i´m not sure.
Anyone have better idea? (it´s complicate to add raw space), but we have a disk with some some space, (can we use part of this volume?)

Important, we don´t have access to primary server.

ORA-01237: cannot extend datafile 27
ORA-01110: data file 27: '+ORADATA00/ihstb02/datafile/tbs_uni.26.62551482'
asm->select name, header_status, path from v$asm_disk;

NAME                           HEADER_STATU
------------------------------ ------------
ORADATA00_0000                 MEMBER

ORADATA01_0000                 MEMBER

asm->select name, type, total_mb, free_mb, required_mirror_free_mb,
usable_file_mb from v$asm_diskgroup;  2

NAME                           TYPE     TOTAL_MB    FREE_MB
------------------------------ ------ ---------- ----------
----------------------- --------------
ORADATA00                      EXTERN     602183        871
                      0            871

ORADATA01                      EXTERN     114688      64642
                      0          64642

********** Below is the area that we have space
asm->!df -h|grep arch
/dev/vx/dsk/disk_group2/archive   137G   7.0G   122G     6%    /arch

Thank you very much for any help

Question by:Thiago_corporative
    LVL 40

    Expert Comment

    Have you considered making temporary use of the ORADATA01 disk group by adding a datafile in that disk group to the tablespace that needs extending? Even though it appears that is your archive group, that appears to be your only source of free space, unless you had another disk.

    Then look at your objects and see if a possible reorg is possible. Also check other tablespaces and see if they can be shrunk.

    Looks like possible time for a new disk.

    Author Comment

    Dear mrjoltcola, the database is standby, so it is in mount stage, then we can´t change the instance.
    IMHO only we can do is on the ASM instance.

    LVL 40

    Expert Comment

    What is the low level device type? An actual disk partition or an OS logical volume?
    LVL 40

    Expert Comment

    Never mind, I see you already posted that.

    I also see you have a Veritas volume. Depending on the RAID type of the vx volume, you could remove a disk from that and assign to ASM. Does the arch volume have a disk to spare? Looking at its size it looks like its possible a single disk or a mirror.

    Author Comment

    Dear Mrjoltcola
     ls -ltr
    total 4
    lrwxrwxrwx   1 oracle   oinstall      34 Jun  8  2007 raw_oradata_02 -> /dev/vx/rdsk/oracle/raw_oradata_02
    lrwxrwxrwx   1 oracle   oinstall      34 Jun  8  2007 raw_oradata_01 -> /dev/vx/rdsk/oracle/raw_oradata_01

    df -h|grep dev
    /dev/vx/dsk/bootdg/rootvol    30G   9.3G    20G    32%    /
    /devices                 0K     0K     0K     0%    /devices
    fd                       0K     0K     0K     0%    /dev/fd
    /dev/vx/dsk/bootdg/var   9.8G   1.6G   8.1G    17%    /var
    swap                   8.0G     0K   8.0G     0%    /dev/vx/dmp
    swap                   8.0G     0K   8.0G     0%    /dev/vx/rdmp


    Author Comment

    So Mrjoltcola
    Can´t you see a "magic solution" that don´t need to make changes on OS?
    LVL 40

    Accepted Solution

    If any of your vx volumes have a spare disk, depending on the RAID type, it is possible to remove a disk from the volume, though it may take a while to rebuild.

    Are there any spare partitions or disks anywhere in the system that can be added to ASM? If not, I really think your only option is to install a new disk if your data disk groups are indeed full.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
    I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
    This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now