|
-
Final action what I can sujjest is to use _allow_resetlogs_corruption=TRUE
Do as follows
1.Shutdown the database.
2. Add the following parameter in the init.ora file:
_allow_resetlogs_corruption=TRUE
3. Startup mount;
4. Recover database using backup controlfile until cancel;
5. If prompted for a logfile, type CANCEL.
6. alter database open resetlogs;
Since the database is in Noarchive mode this is the last option.u need to be careful while using _allow_resetlogs_corruption parameter as it may make ur database inconsistent.Since as per replies u only wants ur database open so u can use this option.
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
|