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