INTRODUCTION:

 

The activity of moving redo logs online can gain us more space in mount points.

 

STEPS:

STEP 1:

Check the size of the mount points using df -h

STEP 2:

Moving the datafiles without bringing down the database,

Issue the following command,

ALTER DATABASE MOVE DATAFILE ‘/prdadata01/oracle/PRODA/db/apps_st/sample/sample.dbf’ TO ‘/prdadata01/oracle/PRODA/db/apps_st/data/sample.dbf’;

 

STEP 3:

Moving the redo logs from one mount point to another mount point,

Bring down the application node,

sh $ADMIN_SCRIPTS_HOME/adstpall.sh apps/<appspassword>

Bring down the listener and database

lsnrctl stop

shut immediate

 

STEP 4:

Issue the following OS command

 

mv /prdadata02/oracle/PRODA/db/apps_st/data/log01a.dbf to /prdadata01/oracle/PRODA/db/apps_st/data/log01a.dbf

mv /prdadata02/oracle/PRODA/db/apps_st/data/log01b.dbf to /prdadata01/oracle/PRODA/db/apps_st/data/log01b.dbf

mv /prdadata03/oracle/PRODA/db/apps_st/data/log02b.dbf to /prdadata01/oracle/PRODA/db/apps_st/data/log02b.dbf

mv /prdadata03/oracle/PRODA/db/apps_st/data/log02a.dbf to /prdadata01/oracle/PRODA/db/apps_st/data/log02a.dbf

 

STEP 5:

Bring the database to mount stage,

startup mount

Issue the following command,

 

ALTER DATABASE RENAME FILE ‘prdadata02/oracle/PRODA/db/apps_st/data/log01a.dbf’ to ‘/prdadata01/oracle/PRODA/db/apps_st/data/log01a.dbf’;

ALTER DATABASE RENAME FILE ‘prdadata02/oracle/PRODA/db/apps_st/data/log01b.dbf’ to ‘/prdadata01/oracle/PRODA/db/apps_st/data/log01b.dbf’;

ALTER DATABASE RENAME FILE ‘prdadata03/oracle/PRODA/db/apps_st/data/log02b.dbf’ to ‘/prdadata01/oracle/PRODA/db/apps_st/data/log02b.dbf’;

ALTER DATABASE RENAME FILE ‘prdadata03/oracle/PRODA/db/apps_st/data/log02a.dbf’ to ‘/prdadata01/oracle/PRODA/db/apps_st/data/log02a.dbf’;

 

STEP 6:

Now open the database and issue the below command,

alter database open;

select member from v$logfile;

 

STEP 7:

Now check the mount point size

Recent Posts

Start typing and press Enter to search