Skip to content

Home
About Me
Toggle search form
Search for:

Committing distributed transaction using commit force Oracle
Jai Shree Ram PHP/MYSQL/Wordpress
How to change hostname in Linux Linux/Unix
scripts to take listener.log backup Linux/Unix
DBMS_UTILITY.ANALYZE_SCHEMA Oracle
Rman Notes -1 Oracle
Export Import with QUERY Oracle
Vivek’s egrep commands to trace problem. (on linux x86-64) Linux/Unix
Test Case for Inserting Multiple (2.3 Million rows in 26 Seconds) Oracle
Gather Stats manually using DBMS_STATS after disabling DBMS_SCHEDULER jobs as previous entry Oracle
V$CONTROLFILE_RECORD_SECTION reference notes. Oracle
Remove duplicate rows from table Oracle
create PLAN_TABLE command. Oracle
logminer and my_lbu Oracle
fkwoind.sql fkwoindex.sql 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

Changing unix system clock when Oracle database is running. Oracle
sqlnet.ora paramters Oracle
Find average Row Length and other table size calculation. metalink notes Oracle
dbms_job.submit example Oracle
plan10g.sql good Oracle
Good Site for Oracle Internals 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

sess1.sql Oracle
restarting network in linux Linux/Unix
556976.1 Oracle Clusterware: Components installed Oracle
v$event_name Oracle
oracle_env_10g_CADEV Linux/Unix
How to calculate PROCESSES parameter Oracle
Benefits and Usage of RMAN with Standby Databases Oracle
How to specify 2 arch location to avoid any kind of DB hanging. Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme