7 Replies Latest reply on Jan 11, 2016 11:23 PM by Beauty_and_dBest

    How to force recover standby?

    Beauty_and_dBest

      Hi ALL,

       

      I have a standby database with archive log location = /home/ARCH_PROD

      I list the contents of this folder, and I can see that the required archive logs are existing.

       

      [oraprod@uatdb ~]$ cd /home/ARCH_PROD

      [oraprod@uatdb ARCH_PROD]$ ls -l

      total 13866072

      -rw-r-----. 1 oraprod dba 939280896 Jan 12 00:47 1_301_898613761.dbf

      -rw-r-----. 1 oraprod dba 943042048 Jan 12 00:48 1_302_898613761.dbf

      -rw-r-----. 1 oraprod dba 962301952 Jan 12 00:47 1_303_898613761.dbf

      -rw-r-----. 1 oraprod dba 965938176 Jan 12 00:48 1_304_898613761.dbf

      -rw-r-----. 1 oraprod dba 965082624 Jan 12 00:48 1_305_898613761.dbf

      -rw-r-----. 1 oraprod dba 953583104 Jan 12 00:49 1_306_898613761.dbf

      -rw-r-----. 1 oraprod dba 950122496 Jan 12 00:49 1_307_898613761.dbf

      -rw-r-----. 1 oraprod dba 968144384 Jan 12 00:49 1_308_898613761.dbf

      -rw-r-----. 1 oraprod dba 954226176 Jan 12 00:50 1_309_898613761.dbf

      -rw-r-----. 1 oraprod dba 953012736 Jan 12 00:51 1_310_898613761.dbf

      -rw-r-----. 1 oraprod dba 955270656 Jan 12 00:52 1_311_898613761.dbf

      -rw-r-----. 1 oraprod dba 947273216 Jan 12 00:50 1_312_898613761.dbf

      -rw-r-----. 1 oraprod dba 766828544 Jan 12 00:52 1_313_898613761.dbf

      -rw-r-----. 1 oraprod dba 940087296 Jan 12 00:53 1_314_898613761.dbf

      -rw-r-----. 1 oraprod dba 947610112 Jan 12 00:55 1_315_898613761.dbf

      -rw-r-----. 1 oraprod dba  86966272 Jan 12 00:55 1_316_898613761.dbf

       

       

      Then I started recovery:

       

      SQL> startup nomount;

      ORACLE instance started.

       

      Total System Global Area 2137886720 bytes

      Fixed Size                  2254952 bytes

      Variable Size             486541208 bytes

      Database Buffers         1627389952 bytes

      Redo Buffers               21700608 bytes

      SQL> ALTER DATABASE MOUNT STANDBY DATABASE;

       

      Database altered.

       

      SQL> RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

      Media recovery complete.

      SQL> archive log list;

      Database log mode              Archive Mode

      Automatic archival             Enabled

      Archive destination            /home/ARCH_PROD

      Oldest online log sequence     300

      Next log sequence to archive   0

      Current log sequence           301

      SQL>

       

       

      I repeated listing the log but it is still on 301

       

      I check the ALERT LOG:

      ==================

      ARC0: Archival started

      ARCH: STARTING ARCH PROCESSES COMPLETE

      ARC0: STARTING ARCH PROCESSES

      Tue Jan 12 01:18:55 2016

      Successful mount of redo thread 1, with mount id 312712314

      Physical Standby Database mounted.

      Lost write protection disabled

      Tue Jan 12 01:18:55 2016

      ARC1 started with pid=19, OS id=18651

      Tue Jan 12 01:18:55 2016

      ARC2 started with pid=20, OS id=18653

      Tue Jan 12 01:18:55 2016

      ARC3 started with pid=21, OS id=18655

      ARC1: Archival started

      ARC2: Archival started

      ARC1: Becoming the 'no FAL' ARCH

      ARC2: Becoming the heartbeat ARCH

      ARC2: Becoming the active heartbeat ARCH

      Completed: ALTER DATABASE MOUNT STANDBY DATABASE

      ARC3: Archival started

      ARC0: STARTING ARCH PROCESSES COMPLETE

      Tue Jan 12 01:19:03 2016

      ALTER DATABASE RECOVER  MANAGED STANDBY DATABASE DISCONNECT FROM SESSION

      Attempt to start background Managed Standby Recovery process (PROD)

      Tue Jan 12 01:19:03 2016

      MRP0 started with pid=22, OS id=18663

      MRP0: Background Managed Standby Recovery process started (PROD)

      started logmerger process

      Tue Jan 12 01:19:08 2016

      Managed Standby Recovery not using Real Time Apply

      Parallel Media Recovery started with 12 slaves

      Waiting for all non-current ORLs to be archived...

      All non-current ORLs have been archived.

      Media Recovery Waiting for thread 1 sequence 301

      Completed: ALTER DATABASE RECOVER  MANAGED STANDBY DATABASE DISCONNECT FROM SESSION

       

       

       

      Please help...

       

      Thanks a lot,

      jc