You have found corruption in a tablespace that contains
static tables that are part of a database that is in
NOARCHIVE log mode. How would you restore the tablespace
without losing new data in the other tablespaces?
- 1 Answers
- 2896 Views
- I also Faced
- E-Mail Answers
Answer Posted / Girish Kumar Arya
Since the database is in NOARCHIVE log mode, you cannot recover from backup as point-in-time recovery (PITR) is not possible. You would need to restore a good copy of the corrupted tablespace from a backup taken before corruption occurred. However, any changes made to the other tablespaces after the backup will be lost. To avoid data loss, consider switching to ARCHIVE log mode and performing PITR.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is the last version,the release date of that version and fix pack of ibm db2 udb?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
