Solved

How to Change Oracle Mount point on Linux serever

Posted on 2011-09-13
3
339 Views
Last Modified: 2013-12-19
Hi this is production server. Due recent increase of space usage, A new mount point /oracle/oradata2 have been created with 600GB on server ***dbprod.

"If Addtional space is required, please use the new mount point, the data files should be under /oracle/oradata2/prod. Please make sure the filenames are unique within the tablespaces. The original mount point /oracle is at 97%, we should not adding or expending any datafile there whenever possible. "

Please give me steps in brief to do this activity.

0
Comment
Question by:udayveera123
  • 2
3 Comments
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 36535679
Look for what data files are allowed to autoextend in the current filesystem:
select file_name,file_id,autoextensible from dba_data_files;

then disable them.

from:
http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/dfiles003.htm

The next example disables the automatic extension for the datafile.
 ALTER DATABASE DATAFILE '/u02/oracle/rbdb1/users03.dbf'
    AUTOEXTEND OFF;


then you should probably alter the tablespaces and create autoextending datafiles on the new filesystem.

Same doc should have the syntax.


I suppose you could also just MOVE some of the datafiles to the new filesystem.
0
 

Author Comment

by:udayveera123
ID: 36558396
Actually its Production DB, and current mount point is filled up to capacity, so i have to move it to new mount point. I am not able to extend datafiles due to lack of space.

so please guide me for the steps what should i have to follow.

Is there requirement of down time while doing this activity?
0
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 36560189
>>so please guide me for the steps what should i have to follow.

I thought I had.

>>Is there requirement of down time while doing this activity?

Minimal if you move some of the old data files to the new mount point.

If you just disable autoextend on the old files and add new datafiles to the existing tablespaces there is no downtime.

The link I posted above also shows the command:
ALTER TABLESPACE users
    ADD DATAFILE ...

What additional parameters you need to add are based on your configuration.  We really cannot say the exact ones you need to set or what their values should be.

Do you have a Senior DBA or someone that can assist you with this?
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

758 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