Monday 18 February 2019

Rename the undo datafile in oracle database 11gr2

1)shutdown the database cleanly

shutdown immediate

2)Move the undo datafiles

[oracle@induatdb induat]$ ls -ldh /u02/oracle/datafiles/induat/undotbs01.dbf /u03/oracle/datafiles/undotbs01.dbf
ls: cannot access /u03/oracle/datafiles/undotbs01.dbf: No such file or directory
-rw-r-----. 1 oracle oinstall 11G Feb 12 15:11 /u02/oracle/datafiles/induat/undotbs01.dbf

[oracle@induatdb induat]$ mv /u02/oracle/datafiles/induat/undotbs01.dbf /u03/oracle/datafiles/undotbs01.dbf

[oracle@induatdb induat]$ ls -ldh /u02/oracle/datafiles/induat/undotbs01.dbf /u03/oracle/datafiles/undotbs01.dbf
ls: cannot access /u02/oracle/datafiles/induat/undotbs01.dbf: No such file or directory
-rw-r-----. 1 oracle oinstall 11G Feb 12 15:11 /u03/oracle/datafiles/undotbs01.dbf
[oracle@induatdb induat]$



3)Startup the database in mount stage

SQL> startup mount
ORACLE instance started.
Total System Global Area 5344731136 bytes
Fixed Size                  2262656 bytes
Variable Size            1040189824 bytes
Database Buffers         4294967296 bytes
Redo Buffers                7311360 bytes
Database mounted.

4)Rename the database file at SQL level
SQL> ALTER DATABASE RENAME FILE '/u02/oracle/datafiles/induat/undotbs01.dbf' TO '/u03/oracle/datafiles/undotbs01.dbf';
Database altered.

5)Open the database
SQL> alter database open;
Database altered.

No comments:

Post a Comment