Oracle Server - Enterprise Edition - Version 9.0.1.0 and later Information in this document applies to any platform.
GOAL
Explain how to rename Oracle Managed Files(OMFs).
FIX
There are 2 different scenarios to consider:
1) Renaming an OMF to a non-OMF name
2) Renaming an OMF to another OMF-compliant name.
Note that renaming an OMF to another OMF-compliant name is not normally recommended.
You should allow Oracle to name the files. But, should you wish to rename one but maintain its OMF status, it can be accomplished.
Here are the 3 methods for renaming an OMF.
METHOD 1
1. ALTER TABLESPACE tsname OFFLINE 2. Move/Rename the file at the OS level 3. ALTER TABLESPACE tsname RENAME DATAFILE 'oldomfname' TO 'newnonomfname'; 4. ALTER TABLESPACE tsname ONLINE
METHOD 2
1. SHUTDOWN IMMEDIATE (or normal) 2. Move/Rename the file at the OS level 3. STARTUP MOUNT 4. ALTER DATABASE RENAME FILE 'oldomfname' TO 'newnonomfname'; 5. ALTER DATABASE OPEN
NOTE: This method is only valid if renaming an OMF to a non-OMF name.
If you attempt to rename an OMF to another OMF-compliant name at mount stage with the ALTER DATABASE command, you will receive the following errors:
ORA-01511: error in renaming log/data files ORA-01276: Cannot add a file with an Oracle Managed Files file name.
METHOD 3
1. SHUTDOWN IMMEDIATE (or normal) 2. Move/Rename the file at the OS level 3. Recreate the controlfile with the desired name. For details on recreating the controlfile, reference Note: 1012929.6.
Oracle Server - Enterprise Edition - Version 9.0.1.0 and later Information in this document applies to any platform.
GOAL
Explain how to rename Oracle Managed Files(OMFs).
FIX
There are 2 different scenarios to consider:
1) Renaming an OMF to a non-OMF name
2) Renaming an OMF to another OMF-compliant name.
Note that renaming an OMF to another OMF-compliant name is not normally recommended.
You should allow Oracle to name the files. But, should you wish to rename one but maintain its OMF status, it can be accomplished.
Here are the 3 methods for renaming an OMF.
METHOD 1
1. ALTER TABLESPACE tsname OFFLINE 2. Move/Rename the file at the OS level 3. ALTER TABLESPACE tsname RENAME DATAFILE 'oldomfname' TO 'newnonomfname'; 4. ALTER TABLESPACE tsname ONLINE
METHOD 2
1. SHUTDOWN IMMEDIATE (or normal) 2. Move/Rename the file at the OS level 3. STARTUP MOUNT 4. ALTER DATABASE RENAME FILE 'oldomfname' TO 'newnonomfname'; 5. ALTER DATABASE OPEN
NOTE: This method is only valid if renaming an OMF to a non-OMF name.
If you attempt to rename an OMF to another OMF-compliant name at mount stage with the ALTER DATABASE command, you will receive the following errors:
ORA-01511: error in renaming log/data files ORA-01276: Cannot add a file with an Oracle Managed Files file name.
METHOD 3
1. SHUTDOWN IMMEDIATE (or normal) 2. Move/Rename the file at the OS level 3. Recreate the controlfile with the desired name. For details on recreating the controlfile, reference Note: 1012929.6.