Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

You are recovering a read-only tablespace that was writable when the last backup was performed. How would you recover this tablespace?

April 26, 2017backup Performed read-only recover recovering tablespace writable

0

Posted

You are recovering a read-only tablespace that was writable when the last backup was performed. How would you recover this tablespace?

1 Answer

0

Posted

Restore the last backup and recover until the time that the tablespace was made read-only. When a tablespace becomes read-only, you should take a full backup so that this scenario never occurs. If you should need to recover a tablespace of this type, restore the last backup and apply the redo logs and archived logs to recover the tablespace to the point the tablespace became read-only.