Skip to content

Home
About Me
Toggle search form
Search for:

How to change hostname in Linux Linux/Unix
To find all disk io ( EMC as well as local) Linux/Unix
Passing from Unix to PLSQL using bind variables Linux/Unix
plan10g.sql Oracle
In Addition to previous note, following grants needed on PERFSTAT user. Oracle
Standby Database Behavior when a Datafile is Resized on the Primary Database Note:123883.1 Oracle
secure crt settings Linux/Unix
Processes parameter and its dependencies on OS kernel parameters Linux/Unix
MYSQL and Oracle Comparison for Oracle DBA MYSQL
JSON/XML Types in Oracle Oracle
Oracle Release Explaination Oracle
sess_server.sql Oracle
Identical Dblink Issue… Oracle
Gather Stats manually using DBMS_STATS after disabling DBMS_SCHEDULER jobs as previous entry Oracle
.profile Linux/Unix

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

How to find the real execution plan and binds used in that explain plan in Oracle 10g?? Oracle
Another Tuning Article for subheap of shared pool Oracle
sql_doing_fts.sql Oracle
Pending Distributed Transations Oracle
All About Trace Fils Oracle
Database logon trigger issue 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)
Linux/Unix (149)
MYSQL (5)
Oracle (393)
PHP/MYSQL/Wordpress (10)
POSTGRESQL (0)
Power-BI (0)
Python/PySpark (7)
RAC (17)
rman-dataguard (26)
shell (149)
SQL scripts (342)
SQL Server (6)
Uncategorized (0)
Videos (0)

Recent Posts

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
Checking SQL Server Version25-Jul-2025
Oracle vs MYSQL Architecture differences (For DBAs)24-Jul-2025
V$INSTANCE of Oracle in MYSQL24-Jul-2025
Day to day MYSQL DBA operations (Compared with Oracle DBA)24-Jul-2025

Archives

2025
2024
2023
2010
2009
2008
2007
2006
2005

Finding last recovered file on DR and remove all chanracters before any “/” Linux/Unix
Exadata Basics Oracle
Removing first line Linux/Unix
Nice Article about semaphores and init.ora Processes parameter relations Linux/Unix
Adding a new disk and mount it automatically. on VMWARE LINUX Linux/Unix
column level grant syntax Oracle
How To Limit The Access To The Database So That Only One User Per Schema Are Connected (One Concurrent User Per Schema) Oracle
database trigger failing Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme