Skip to content

Home
About Me
Toggle search form
Search for:

UTL_FILE test program Oracle
Very clear article about oracle dataguard Oracle
find_log_switch.sql Find log switches in graphical manner Oracle
V$INSTANCE of Oracle in MYSQL MYSQL
How to find pinned objects from shared pool. (pinned via dbms_shared_pool.keep) Oracle
Logic to chech # of parameters command line parameters Linux/Unix
Running select from V$ views from remote server Linux/Unix
scp with ssh2 Linux/Unix
Getting started with notebook Python/PySpark
AWR settings- MMON is not taking snapshot. Oracle
USER_TABLES.Freelists Oracle
create trigger syntax Oracle
UNderstand and eliminate Latch contention. Oracle
The most important Tuning Notes Oracle
Good notes for shared pool 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

751131.1 New Article Error 2819 While Requesting a Systemstate Dump Oracle
USE_NL and INDEX hints example Oracle
find_idle_cpu.sql Oracle
compile_inv.sql Oracle
metalink all dynamic view reference notes. Oracle
db_status.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

Ansible (0)
AWS (2)
Azure (1)
Django (0)
GIT (1)
Linux/Unix (149)
MYSQL (5)
Oracle (403)
PHP/MYSQL/Wordpress (10)
POSTGRESQL (1)
Power-BI (0)
Python/PySpark (7)
RAC (18)
rman-dataguard (26)
shell (150)
SQL scripts (350)
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.sql23-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

Privileges Required to Create Procedures and Functions that uses objects from other schema. Oracle
Which environment is used by currently running process ( Very good) Linux/Unix
Pending Transaction Neighbors Script Oracle
lck.sql Oracle
UTL_FILE test program Oracle
Passing from Unix to PLSQL using bind variables Linux/Unix
Find average Row Length and other table size calculation. metalink notes Oracle
SAN Linux/Unix

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme