| how can recover in this case [message #137836] |
Sat, 17 September 2005 06:54  |
c_gajen
Messages: 8
Registered: September 2005
Location: Nagpur
|
Junior Member |
|
|
hello,
I have only controlfile and all archive log on 9i
but all datafile lost .............
also no backup,no exp..............
how can i up my database PLZ.......
guide me with steps
thanks !!
Gajen .
|
|
|
|
| Re: how can recover in this case [message #137857 is a reply to message #137836] |
Sat, 17 September 2005 14:55  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi Gajen,
I don't think you can. You would at least need a control file, a backup copy of the system tablespace, and all archived log files (from when your DB files were created).
Best regards.
Frank
|
|
|
|
| Re: how can recover in this case [message #137868 is a reply to message #137836] |
Sun, 18 September 2005 02:37 |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
I agree with Frank,
| Quote: |
Oracle enables you to recover data files that have no Backups and belong to Non-System tablespace
|
but in ur case u dnt even hav the backup of System tablespace so not possible.
regards,
tarun
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
