How to Add Datafiles to SYSAUX / NSP

Asset ID:	1-71-2207274.1
Update Date:	2018-03-28
Keywords:

Solution Type Technical Instruction Sure

Solution 2207274.1 : How to Add Datafiles to SYSAUX / NSP_LOG Tablespace on ASM?

Applies to:

Oracle Communications Performance Intelligence Center (PIC) Software - Version 9.0.4 and later
Information in this document applies to any platform.

Goal

How to extend SYSAUX / NSP_LOG tablespace on ASM when it is full ?

Solution

On ASM systems you cannot see the space occupied by the Oracle tablespaces and datafiles with Linux commands, asm commands have to be used.

Log as grid user on DWH and run the following command:

asmcmd lsdg

The expected output look like that:

[grid@ixp0001-1z ~]$ 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 10269768 1096723 0 1096723 0 N DATA/

In this example the server as storage capacity of 10 269 768 MB (i.e. 10TB) and the remaining space is 1 096 723 MB (i.e. 1TB)

So it is possible to add datafiles in the remaining 1TB of space.

To add the datafiles:

log as oracle
Execute the following command to add SYSAUX tablespace:

echo -e "ALTER TABLESPACE SYSAUX ADD DATAFILE '+DATA' SIZE 1200M REUSE AUTOEXTEND ON NEXT 100M MAXSIZE 8192M;" |sqlplus / as sysdba
Similarly, to add tablespace to NSP_LOG, execute the following command:
echo -e "ALTER TABLESPACE NSP_LOG ADD DATAFILE '+DATA' SIZE 1200M REUSE AUTOEXTEND ON NEXT 100M MAXSIZE 8192M;" |sqlplus / as sysdba

It is possible to execute command multiple times to create multiple datafiles but always make sure there is enough free space available in ASM.

Attachments

This solution has no attachment