Skip to content

Home
About Me
Toggle search form
Search for:

OPENING A STANDBY DATABASE IN READ-ONLY MODE Oracle
cif crons Linux/Unix
Drop database in Oracle 10g Oracle
Day to day MYSQL DBA operations (Compared with Oracle DBA) MYSQL
rm_backup_arch_file.ksh Linux/Unix
Rename Oracle Instance Name Oracle
How to specify 2 arch location to avoid any kind of DB hanging. Oracle
oracle fast start failover best practice Oracle
Find average Row Length and other table size calculation. metalink notes Oracle
refre.sql Oracle
cp_filesystem.sql Oracle
Query to Generate aggregate on every 30 mins. Oracle
10g oem configuration Oracle
My Minimum Tuning Programs Oracle
DETERMINING WHICH INSTANCE OWNS WHICH SHARED MEMORY & SEMAPHORE SEGMENTS 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

Implementing Listener Security Oracle
Library cahe Latches and internal explaination Oracle
TOP-N Sql to find Nth max or Top N rows Oracle
When error comes for temporary tablespace with version <= 9i Oracle
ORA-00064: object is too large to allocate on this O/S during startup Oracle
Find Plan Hash value fphv.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 (395)
PHP/MYSQL/Wordpress (10)
POSTGRESQL (1)
Power-BI (0)
Python/PySpark (7)
RAC (17)
rman-dataguard (26)
shell (150)
SQL scripts (343)
SQL Server (6)
Uncategorized (0)
Videos (0)

Recent Posts

prepfiles.sh for step by step generating pending statistics files10-Mar-2026
tracksqltime.sql05-Mar-2026
Complete Git Tutorial for Beginners25-Dec-2025
Postgres DB user and OS user.25-Dec-2025
Trace a SQL session from another session using ORADEBUG30-Sep-2025
SQL Server Vs Oracle Architecture difference25-Jul-2025
SQL Server: How to see historical transactions25-Jul-2025
SQL Server: How to see current transactions or requests25-Jul-2025
T-SQL Vs PL/SQL Syntax25-Jul-2025
Check SQL Server edition25-Jul-2025

Archives

2026
2025
2024
2023
2010
2009
2008
2007
2006
2005

Running some SQL on multiple databases connecting using monitoring userid and password Linux/Unix
Giving Grant on v$DATABASE Oracle
v$backup.status information Oracle
Which environment is used by currently running process ( Very good) Linux/Unix
Jai Shree Ram PHP/MYSQL/Wordpress
online_bkup.sql Oracle
DB Console Mainenance. Oracle
scp with ssh2 Linux/Unix

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme