ORA-01511: error in renaming log/data files

How to rename Oracle-Managed Files (OMFs) (文档 ID 191574.1)转到底部

---

修改时间:2012-7-25类型:HOWTO

APPLIES TO:

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.

How to rename Oracle-Managed Files (OMFs) (文档 ID 191574.1)转到底部

---

修改时间:2012-7-25类型:HOWTO

APPLIES TO:

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.