|
-
1. Make sure the database is down
2. Backup your existing database in case you have to get back to ground 0 again.
3. edit your init.ora file to use only one of your control files.
4. startup mount
5. alter database recover until cancel using backup controlfile
6. alter database recover cancel
7. alter database open resetlogs
8. Shutdown immediate
9. Start a backup
With any luck, you will be able to recover to some consistent point. Otherwise, you will have to re-create your database. If this doesn't work, restore the backup that was taken with the database open and try the same steps.
Running in noarchivelog mode, you have esentially given yourself no option to recover. Backing up the database while it is open did not help you either.
You might want to consider re-vamping your backup strategy sometime in the near future.
Jeff Hunter
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
|