You have found corruption in a tablespace that contains static tables that are

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?

Question Posted / narmada kumari

0 Answers
2387 Views
I also Faced
E-Mail Answers

No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB Administration Interview Questions

Explain the difference between a hot backup and a cold backup and the benefits associated with each?

7 Answers TCS,

How many memory layers are in the shared pool?

3 Answers

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode? 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?

11 Answers

Name two files used for network connection to a database.

5 Answers

what is a user-defined lock?

0 Answers Oracle,

WHEN DOWN TIME WHAT CAN U DO?

1 Answers TCS,

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

0 Answers

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers IBM,

What is replication? : sql server DBA