DBA Hub

📋Steps in this guide1/3

How To Open Standby Database When Primary Database Is Lost

If your primary database is not accessible or crashed for any issue, then we can use the standby database.

oracle configurationintermediate
by OracleDba
11 views
1

Overview

If your primary database is not accessible or crashed for any issue, then we can use the standby database. Follow the Below  steps for opening standby database when the primary database is lost: - Recover standby database:

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
shut immediate;
startup mount;

SQL> SELECT OPEN_MODE,PROTECTION_MODE,DATABASE_ROLE FROM V$DATABASE;
OPEN_MODE PROTECTION_MODE DATABASE_ROLE
---------- -------------------- ----------------
MOUNTED MAXIMUM PERFORMANCE PHYSICAL STANDBY

SQL> ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE;
2

Section 2

- Finish the recovery process: - Activate the standby database: - Check the status:

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
SQL> RECOVER STANDBY DATABASE;

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH;

Database altered

SQL> ALTER DATABASE ACTIVATE PHYSICAL STANDBY DATABASE;

Database altered.
3

Section 3

- Open the database:

Code/Command (click line numbers to comment):

1
2
3
4
5
6
SQL> SELECT OPEN_MODE,PROTECTION_MODE,DATABASE_ROLE FROM V$DATABASE;
OPEN_MODE PROTECTION_MODE DATABASE_ROLE
---------- -------------------- ----------------
MOUNTED MAXIMUM PERFORMANCE PRIMARY

SQL> ALTER DATABASE OPEN;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!