Switchover physical database
16/05/2018 11:47
hiI work on oracle 9.2.0.1.0 win 2ki have a physical standby database...we have implemented it usingdatagaurd.

i want to perform a switchover..

but when i query my primary db the following query : sql>select switchover_status from v$database; SWITCHOVER_STATUS------------------SESSIONS ACTIVE but is't supposed to show me TO STANDBY so can i perform switchover with this switchover_status..


Source is Usenet: comp.databases.oracle.server
Sign in to add a comment

Answer score: 5
16/05/2018 11:47 - alter database commit to switchover to physical standby with sessionshutdown;

Source is Usenet: comp.databases.oracle.server
Sign in to add a comment

eDiscover
Helpforce eDiscover provides technical articles updated each dayHelpforce eDiscover RSS feed contains the latest technical articles in RSS
Click the logo to go back to the main page
Search eDiscover
  
Categories

Click an icon to go to that category

Helpforce eDiscover contains articles about Microsoft Windows Helpforce eDiscover contains articles about Apple products and MacOS Helpforce eDiscover contains articles about Linux and POSIX operating systems Helpforce eDiscover contains articles about Helpforce Helpforce has a large variety of technical information and articles for you to read Helpforce eDiscover contains articles about databases, MYSQL, SQL Server Oracle Helpforce eDiscover contains articles about Java, JVM and the JRE Helpforce eDiscover contains articles about the QNX operating system Helpforce eDiscover contains articles about Oracle Solaris and Open Solaris Helpforce eDiscover contains articles about RISC OS, Acorn and the BBC Micro Helpforce eDiscover contains articles about Amiga and AmigaOS

Type your comment into the box below