Skip to content

Home
About Me
Toggle search form
Search for:

To see how much time or progress of long transaction Oracle
How to connect to Oracle Database with Wallet with Python. Oracle
ORA-01220 Oracle
Good notes on Oracle Events Oracle
Error Handling in Proc Oracle
db_status.sql Oracle
find_log_switch.sql Find log switches in graphical manner Oracle
Find Plan Hash value fphv.sql Oracle
executing Function from SQLPLUS prompt Oracle
Rman Notes -1 Oracle
Physical Standby switchover with session active Oracle
Database logon trigger issue Oracle
Jai Shree Ram Oracle
Export Import with QUERY Oracle
create trigger syntax Oracle

switchover for primary database

Posted on 31-Dec-2009 By Admin No Comments on switchover for primary database

ALTER DATABASE commit TO switchover TO physical PRIMARY WITH session shutdown nowait;

Oracle, rman-dataguard

Post navigation

Previous Post: Physical Standby switchover with session active

Next Post: Kernel Parameters for Solaris

Related Posts

Temporary tablespace explaination Oracle
compile_inv.sql Oracle
sess_server.sql Oracle
pvm_metric.sql for gathering report from vmstat tables Oracle
Renaming Global Name GLOBAL_NAME Oracle
Find_planinfo.sql Oracle

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Comment *

Name *

Email *

Website

Save my name, email, and website in this browser for the next time I comment.

Categories

AWS (2)
Azure (1)
Linux/Unix (149)
Oracle (392)
PHP/MYSQL/Wordpress (10)
Power-BI (0)
Python/PySpark (7)
RAC (17)
rman-dataguard (26)
shell (149)
SQL scripts (341)
Uncategorized (0)
Videos (0)

Recent Posts

load SPM baseline from cursor cache05-Jun-2025
Drop all SPM baselines for SQL handle05-Jun-2025
Load SPM baseline from AWR05-Jun-2025
Drop specific SQL plan baseline – spm05-Jun-2025
findinfo.sql (SQL for getting CPU and Active session info)27-May-2025
SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
How to connect to Oracle Database with Wallet with Python.21-Mar-2025
JSON/XML Types in Oracle18-Mar-2025
CPU Core related projections12-Mar-2025
Exadata Basics10-Dec-2024

Archives

2025
2024
2023
2010
2009
2008
2007
2006
2005

Move WordPress site from one hosting service to other. PHP/MYSQL/Wordpress
ORACLE_SID in sqlplus Oracle
eplan9i.sql Oracle
556976.1 Oracle Clusterware: Components installed Oracle
Roles and Stored Procs II Oracle
telnet listening Linux/Unix
The most important Tuning Notes Oracle
Oracle Release Explaination Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme