Oracle Database Restore with BCT enabled

  • 10 February 2024
  • 3 comments
  • 35 views

Userlevel 4
Badge +1
  • Comes here often
  • 6 comments

Restoring a database can often be a straightforward process, but complexities arise when you're working on the same server as the active original database. A common issue encountered in such scenarios involves the database's inability to start due to conflicts with BCT file access. This blog post is designed to guide you through resolving this issue when using Veeam Explorer for Oracle database restoration.
 

Understanding the Problem:

When you restore a database with a different name on the same server where the original database is still active, you might encounter an error where the newly restored database fails to start. This issue often stems from conflicts with accessing the BCT file. The BCT file, which is crucial for database operations, might still be in use or locked by the original database, leading to access conflicts.

 

Step-by-Step Solution:

To successfully restore your database without encountering the BCT file access issue, follow these steps:

 

  Step1: -  Just restore(and not recover) from the explorer

 

     

 

     Step2:- Bring the DB to mount stage

     

 

    Step3:- Disable block change tracking;

    

 

    Step4:- Perform PIT

    SQL>until cancel/until time

    

    Step5:- Open the DB

    SQL>Alter database open;

 


3 comments

Userlevel 7
Badge +20

Very interesting post, I don't use Oracle but it is great learning.

Userlevel 7
Badge +17

We have Oracle DB but back it up natively, then use Veeam to backup the DB VM. Restore would be done within Oracle. That being said, this is a good post @vmali , if ever we were to switch that process up. Thanks!

Userlevel 7
Badge +8

Good to know, thank you for sharing :)

Comment