-
How to restore and recover DB when SYSTEM tablespace was corrupted?
Hi,
How to restore and recover DB when SYSTEM tablespace was corrupted?
In the following Conditions..
Conditions..
1) My DB is running in NOARCHIEVE LOG mode.
2) My DB is running in ARCHIEVE LOG mode.
I am not havng any previous old backups.
Can anybody help me?
Thanks & Regards
Rajesh
-
Originally Posted by rajeshbalusu
Hi,
...Blah, blah, blah...
I am not havng any previous old backups.
Can anybody help me?
Sorry, no backups = no recovery.
Maybe you will need to resign, a dba is as good as his/her backups.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
-
Originally Posted by rajeshbalusu
1) My DB is running in NOARCHIEVE LOG mode.
2) My DB is running in ARCHIEVE LOG mode.
Can't have it both ways.
By the way, I'm in agreement with LKBrwn_DBA's statement.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
Originally Posted by PAVB
Can't have it both ways.
By the way, I'm in agreement with LKBrwn_DBA's statement.
The exception to that, is that if there is enough online redo available you might be able to resolve the issue with online redo. But yes, generally speaking you can't do point in time recovery when you aren't in archivelog mode.
-
Originally Posted by gandolf989
The exception to that, is that if there is enough online redo available you might be able to resolve the issue with online redo. But yes, generally speaking you can't do point in time recovery when you aren't in archivelog mode.
no backup, so online redo wont help here either
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
|