-
hello,
1. Today , I added a datafile to a to a tablespace (with DBAStudio), and I forgot the name (sorry)...
Oracle create it but generate a 'pseudo name' like '/oracle/data3/.dbf'
2. Then, immediately , I toke offline the datafile . (so, now, that is empty)
3. I decided to rename it, but the status of that datafile is REVOVER=> I can't take ONLINE , I can't RENAME it :(
Please help me
what can I do and how
SQL> ALTER DATABASE RENAME FILE '/oracle/data3/.dbf' TO '/oracle/data3/int_3.dbf';
ALTER DATABASE RENAME FILE '/oracle/data3/.dbf' TO '/oracle/data3/int_3.dbf'
*
ERROR at line 1:
ORA-01511: error in renaming log/data files
ORA-01141: error renaming data file 45 - new file '/oracle/data3/int_3.dbf'
not found
ORA-01110: data file 45: '/oracle/data3/.dbf'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
ALTER DATABASE DATAFILE '/oracle/data3/.dbf' ONLINE;
ALTER DATABASE DATAFILE '/oracle/data3/.dbf' ONLINE
*
ERROR at line 1:
ORA-01113: file 45 needs media recovery
ORA-01110: data file 45: '/oracle/data3/.dbf'
-
Is your database in archivelog or in Noarchivelog mode.
copy the datafile from the old location to the new location ...
then do the rename command ...
then issue
then you have to issue the recover command then make it
Radhakrishnan.M
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|