Skip to content

Home
About Me
Toggle search form
Search for:

Find execution plan from dba_hist_sql_plan for a specific SQL_ID and PLAN_HASH_VALUE fplan.sql Oracle
Adding or Dropping Online Redo Log Files When Physical Standby in place Oracle
Locktree.sql Oracle
Convert multiple rows to single column Oracle
findobj.sql Oracle
SQL_PLAN.sql for checking real execution plan Oracle
How do I get Oracle to automatically start when my server boots up? Oracle
Adding Datafile on Primary Server and Impact on Standby Server Oracle
findinfo.sql (SQL for getting CPU and Active session info) Oracle
find_idle_cpu.sql Oracle
DBMS_PROFILER for tuning PLSQL programs. Oracle
normal maintenance for exp-imp and renaming table Oracle
proper cpu stats Linux/Unix
pvm_pre_change.sql Oracle
perf_today.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

Database link password in user_db_links Oracle
db_status.sql Oracle
Another Tuning Article for subheap of shared pool Oracle
How to find the real execution plan and binds used in that explain plan in Oracle 10g?? Oracle
findinfo.sql (SQL for getting CPU and Active session info) Oracle
Query to Generate aggregate on every 30 mins. 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

Ansible (0)
AWS (2)
Azure (1)
Django (0)
GIT (1)
Linux/Unix (150)
MYSQL (5)
Oracle (403)
PHP/MYSQL/Wordpress (10)
POSTGRESQL (1)
Power-BI (0)
Python/PySpark (7)
RAC (18)
rman-dataguard (26)
shell (151)
SQL scripts (349)
SQL Server (6)
Uncategorized (5)
Videos (0)

Recent Posts

Key Management in Oracle: The Core Issue: Missing Master Key12-May-2026
SAT Mathematics 10 questions and answer at the end.30-Apr-2026
top 10 AI news today30-Apr-2026
runon_allpdbs_show_conname.sh23-Apr-2026
runon_allcdbs_find_pdbs.sh23-Apr-2026
Running PDB on single node in RAC09-Apr-2026
find_arc.sql09-Apr-2026
pvm_pre_change.sql08-Apr-2026
find_encr_wallet.sql08-Apr-2026
find_pdbs.sql08-Apr-2026

Archives

2026
2025
2024
2023
2010
2009
2008
2007
2006
2005

chk_space_SID.ksh Linux/Unix
DBA_HIST_SQLSTAT contents Oracle
SQL Server Vs Oracle Architecture difference SQL Server
To find all disk io ( EMC as well as local) Linux/Unix
cif crons Linux/Unix
get_vmstat.ksh Linux/Unix
xargs use Linux/Unix
get_vmstat_linux Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme