Re: Sys1orcl.ora corrupt

Have you done an "alter database backup controlfile to trace" lately? Would it reflect current structure? If not, don't even try the following, it's only an idea. If anyone knows that this won't work, please correct me.

1. Make sure database is fully down
2. Take a backup
3. Create a new database by a different name (including catalog & catproc)
4. Shutdown the new database
5. Copy the new database system datafile over the system datafile of the old database
6. Delete the old database control files
7. startup nomount (old database)
8. Edit the trace file referred to at the beginning of my message
9. Run it
10. shutdown
11. startup mount
12. alter database rename global_name to <OLD-DB-NAME>

If this works, please post back!
If this doesn't work, please let me know I've finally lost my mind!

Ramón Rodríguez wrote in message <7722b2$kot$1_at_talia.mad.ibernet.es>...
>I have a Oracle Workgroup Server 7.3 with the Sys1orcl.ora incorrect, but i
>Have all tablespaces correct and I Know the estructures of my schemas. How
>can I recover my data ?
>
>Thanks
>
>
Received on Fri Jan 15 1999 - 19:42:44 CST