Solved

How to Change Oracle Mount point on Linux serever

Posted on 2011-09-13
3
346 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

920 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

12 Experts available now in Live!

Get 1:1 Help Now