Oracle Database Restore with BCT enabled

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