Switchover
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Switchover

  1. #1
    Join Date
    Nov 2000
    Location
    London
    Posts
    94

    Switchover

    on 9i

    Server A Primary LIVE
    Server B Physical standby DR

    Switched successfully so DB on Server B is now primary and physical standby on server A.


    Tried to switch back.

    On ServerB:

    alter database commit to switchover to standby with session shutdown;

    ERROR at line 1:
    ORA-16014: log 2 sequence# 7 not archived, no available destinations
    ORA-00312: online log 2 thread 1: '/u3/oradata/LIVE/redo02.log'

    SQL> ALTER DATABASE MOUNT STANDBY DATABASE;
    ALTER DATABASE MOUNT STANDBY DATABASE
    *
    ERROR at line 1:
    ORA-01665: controlfile is not a standby controlfile


    So now I have a standby on server A and a partial (broken) Primary on server B.

    init.ora on Server B:

    *.log_archive_dest_1='LOCATION=/u2/oradata/LIVE/archive'
    *.standby_archive_dest=/u2/oradata/LIVE/archive

    Any ideas?

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Whats the log_archive_dest2 parameter set on server B ?

    When you tried to switch from server B to server A the switch over actullay failed with the following error log 2 sequence# 7 not archived

    is there space available on server b
    '/u2/oradata/LIVE/archive'

  3. #3
    Join Date
    Nov 2000
    Location
    London
    Posts
    94
    there is 90G free on /u2

    log_archive_dest_2 is not set on server B init.ora (maybe this is the issue?)

  4. #4
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,443

    Cool

    Quote Originally Posted by rgaskell View Post
    there is 90G free on /u2

    log_archive_dest_2 is not set on server B init.ora (maybe this is the issue?)
    Yes,
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  5. #5
    Join Date
    Nov 2000
    Location
    London
    Posts
    94
    Quote Originally Posted by LKBrwn_DBA View Post
    Yes,
    Seems like 9i needs manual intervention during switchover/switchback.

    Has anyone got a complete document/link on the exact steps to take to get this working? I need to get this up and running and test switchover asap.I've found some docs on oracle/metalink but they dont lay it out step by step.(Some dont even mention setting fal_server/fal_client).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width