Skip to content

Home
About Me
Toggle search form
Search for:

Resolving RMAN Hung Jobs Oracle
UNderstand and eliminate Latch contention. Oracle
On solaris 10, “S” link is not part of $ORACLE_HOME/bin/oracle as default. ( For 9.2.0.8) Oracle
cur_sql.sql Oracle
True Session Wait Activity in Oracle 10g Verygood Oracle
Generating XML from SQLPLUS Oracle
Index Range Scan Oracle
create PLAN_TABLE command. Oracle
DBMS_Shared_pool pinning triggers Oracle
Query to Generate aggregate on every 30 mins. Oracle
crontab syntax Linux/Unix
Wait time tuning research Oracle
DBMS_SQL for alter session. Oracle
create database syntax Oracle
exp syntax in oracle 10g 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

Rman Notes -1 Oracle
ORA-01220 Oracle
Identical Dblink Issue… Oracle
Global Unique Identifier Generation in Oracle 9.2 SYS_GUID() Oracle
272332.1 CRS 10g Diagnostic Collection Guide Oracle
oracle Dba site 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 (392)
PHP/MYSQL/Wordpress (10)
POSTGRESQL (0)
Power-BI (0)
Python/PySpark (7)
RAC (17)
rman-dataguard (26)
shell (149)
SQL scripts (341)
SQL Server (6)
Uncategorized (0)
Videos (0)

Recent Posts

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
MYSQL and Oracle Comparison for Oracle DBA24-Jul-2025

Archives

2025
2024
2023
2010
2009
2008
2007
2006
2005

Find sort details from Db find_sort.sql Oracle
Generate SSH without password authentication. Linux/Unix
Export With Query Another Example. Oracle
Find All internal Parameters Oracle
DBMS_JOB all example Oracle
How to calculate PROCESSES parameter Oracle
avail.sh ( find filesystem spae usage) Linux/Unix
send email from unix mailx with attachment. Linux/Unix

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme