Topic: Backup & Recovery >> ORA-01180: can not create SYSTEM datafile
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: ORA-01180: can not create SYSTEM datafile |
| Navi |
Posted: Aug 30, 2007 07:25:51 AM |
Total Post: 60
Joined: Jun, 2007
|
Hi,
I am studying Backup and Recovery I am doing user-managed Backup and Recovery since i have not yet learnt RMAN.
My database is running in Archive Log mode and i have all the archives.
I came across a scenario of "Recreating DATAFILE" and deleted one non-system datafile and i tried this command:-
Alter database create datafile 'C:\ORACLE\ORADATA\VENKAT\Nav01.DBF';
It worked, but i deleted SYSTEM datafile purposely and when i tried to recreate it gave error:-
SQL> Alter database create datafile 'C:\ORACLE\ORADATA\VENKAT\SYSTEM01.DBF';
alter database create datafile 'C:\ORACLE\ORADATA\VENKAT\SYSTEM01.DBF'
*
ERROR at line 1:
ORA-01180: can not create datafile 1
ORA-01110: data file 1: 'C:\ORACLE\ORADATA\VENKAT\SYSTEM01.DBF'
Question:-
1) I searched on net and i came to know we cannot recreate SYSTEM datafile but i was not able to get information why we cannot recreate SYSTEM datafile but only we can recreate Non-SYSTEM datafile.
2) What should be my next step to solve this problem.
Please guide me.
Regards,
Naveen |
|
|
 Mohammed Taj |
| Posted: Aug 30, 2007 09:01:42 AM |  |
|
Total Post: 746
Joined: Jul, 2007
|
You can't create system or any tablespace which content ACTIVE UNDO segments.
for you 2nd question ... you have to restore last valid backup.
|
|
|
|
|
| Navi |
| Posted: Aug 30, 2007 09:35:53 AM | |
|
Total Post: 60
Joined: Jun, 2007
|
Hi,
I dont no properly but i am making a guess.
System Datafile:-
A System Datafile cannot be recreated because the Archives and RedoLogs cannot contain information such as Privilegs, names of all the users, Columns of the table etc that are present in the Data Dictionary.
Non-System Datafile:-
A Non-System Datafile can be recreated because the Archives and RedoLogs contain Changed Data(DML) which is needed for recreation of Non-System Datafile.
Please guide me.
Regards,
Naveen
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 857 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Gopu Gopi | 335 |
| Gitesh Trivedi | 322 |
| Vinoth Kumar | 264 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
