-
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?
-
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'
-
there is 90G free on /u2
log_archive_dest_2 is not set on server B init.ora (maybe this is the issue?)
-
Originally Posted by rgaskell
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
-
Originally Posted by LKBrwn_DBA
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|