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.
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