How to flashback primary database in standby configuration


Solution

To Flashback primary database execute following steps :

1. Shutdown primary database .
SQL> SHUTDOWN IMMEDIATE
2. Start primary database in mount stage
SQL> STARTUP MOUNT
3. Flashback primary database to specified scn
SQL> FLASHBACK DATABASE TO SCN <scn_number>;
4. Open primary database with reset logs.
SQL> ALTER DATABASE OPEN RESETLOGS;
5. Cancel media recovery on the standby database.
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
6. Check current_scn on the standby database, If flashback scn is greater then current_scn then skip next step (step 7).
SQL> SELECT CURRENT_SCN FROM V$DATABASE;
7. Flashback Standby database
SQL> FLASHBACK STANDBY DATABASE TO SCN <scn_number -2>; (on standby database)
8. Start managed recovery on the standby database .
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;


Comments

Post a Comment

Popular posts from this blog

Key points on Read-Only Instance and Read-Only Database

 In Oracle, both Read-Only Instance and Read-Only Database provide mechanisms to limit data modifications, but they are used in different contexts and for different purposes. Here's a comparison: 1. Read-Only Instance Definition : A read-only instance is a configuration in Oracle Real Application Clusters (RAC) where one or more instances of a multi-instance database are set up to operate in read-only mode. This is typically done in environments with high concurrency for both read and write operations. Key Features : Allows real-time query scaling by dedicating specific instances to read-only operations. Write operations are not allowed on the designated read-only instance, but other instances in the cluster can still handle write operations. Useful in RAC configurations for load balancing , where read workloads can be distributed across multiple read-only instances. Instance-specific: The database remains fully functional (read-write) when accessed through other instances. Us...
Read more

Steps to create database link between Oracle database and SQL Server

 Creating a database link between SQL Server and Oracle allows seamless data exchange between the two systems. Here’s a step-by-step guide: Step 1: Install the Required Drivers Install Oracle Database Gateway for SQL Server (ODG4MS). This acts as a bridge between Oracle and SQL Server. Ensure the Oracle Client is installed on the Oracle database server or the server acting as the gateway. Step 2: Configure the Oracle Database Gateway Locate Configuration Files: Navigate to the $ORACLE_HOME/network/admin directory on the Oracle Gateway server. Edit tnsnames.ora: Add an entry for the database link pointing to the SQL Server database: dg4msql =   (DESCRIPTION =     (ADDRESS = (PROTOCOL = TCP)(HOST = <SQL_SERVER_HOSTNAME>)(PORT = 1521))     (CONNECT_DATA = (SID = dg4msql))     (HS=OK)  -- Required for heterogeneous services   )   Edit listener.ora: Update the Oracle listener configuration to recognize the gateway: SID_LIST_LISTENE...
Read more

Oracle 23c AI RMAN New Features....

 Oracle 23c AI (also known as Oracle Database 23c: The Long-Term Release ) introduces several cutting-edge features, enhancements, and optimizations to RMAN (Recovery Manager), ensuring even more robust backup and recovery capabilities. RMAN remains an essential tool for Oracle DBAs, and with 23c, it becomes even more powerful, particularly with AI-assisted capabilities. Below are 10 new features in RMAN in Oracle 23c : 1. AI-Assisted Backup and Recovery Optimization Feature Overview : Oracle 23c introduces AI-driven algorithms that analyze system workload patterns, storage usage, and historical backup performance to optimize backup windows, schedules, and methods. The AI assistant learns from past recovery operations to suggest optimal backup strategies. Benefit : More efficient backups with minimal impact on production, and faster, more predictable recovery times based on learned behavior. 2. Automatic Block Repair with AI Feature Overview : This feature enhances RMAN’s block med...
Read more