• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2626
  • Last Modified:

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

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

  • 4
  • 3
1 Solution
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.
Thiago_corporativeAuthor Commented:
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.

What is the low level device type? An actual disk partition or an OS logical volume?
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

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.
Thiago_corporativeAuthor Commented:
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

Thiago_corporativeAuthor Commented:
So Mrjoltcola
Can´t you see a "magic solution" that don´t need to make changes on OS?
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.

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now