Skip to content

Home
About Me
Toggle search form
Search for:

Explain Plan Output 2 Oracle
create trigger syntax Oracle
Gather Stats manually using DBMS_STATS after disabling DBMS_SCHEDULER jobs as previous entry Oracle
copying/removing directory with all its subdirectory Linux/Unix
DETERMINING WHICH INSTANCE OWNS WHICH SHARED MEMORY & SEMAPHORE SEGMENTS Oracle
Histogram information Oracle
Restoring a user’s original password 1051962.101 Oracle
Export With Query Another Example. Oracle
Drop specific SQL plan baseline – spm Oracle
Locally Managed Tablespace and Dictionary managed tablespace (LMT-DMT) Oracle
fdisk -l explaination about Primary-Logical-Extended Partitions Linux/Unix
Configure ssh authentications for RAC Oracle
Oracle Identifiers Oracle
setting prompt display with .profile Linux/Unix
find_longsql.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

Does DBMS_JOB recompute the NEXT_DATE interval after or before Oracle
get_vmstat.ksh for Solaris Oracle
FGA Part-I Oracle
DBMS_STATS Metalinks Notes Oracle
Find_planinfo.sql Oracle
Goldengate Tutorial 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

Configure ssh authentications for RAC Oracle
272332.1 CRS 10g Diagnostic Collection Guide Oracle
Windows based Command line mailing program like mailx (Sednmail for windows) PHP/MYSQL/Wordpress
changing kernel parameter in Oracle Enterpise Linux Linux/Unix
DETERMINING WHICH INSTANCE OWNS WHICH SHARED MEMORY & SEMAPHORE SEGMENTS Oracle
How to know Number of CPUs on Sun Box Linux/Unix
send email from unix mailx with attachment. Linux/Unix
This is im telling Kishore Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme