Skip to content

Home
About Me
Toggle search form
Search for:

ext#.sql Oracle
get_ratio.sql get the ratio of users from v$session and this uses CASE-WHEN-THEN clause Oracle
Find all users who have DML privileges Oracle
replace alphabets using sed Linux/Unix
To find explain plan for a statement that occurred in past. Oracle
In Addition to previous note, following grants needed on PERFSTAT user. Oracle
oracle Dba site Oracle
Best approach for Oracle database patching sequence to latest/required patchset along with CPU/PSU/any-other-one-off patch ID 865255.1 Oracle
Export With Query Another Example. Oracle
on IBM-AIX for display Linux/Unix
Oracle Recommended Patches — Oracle Database ID 756671.1 Oracle
Default User Profile Oracle
Find Stale DR Physical Standby Oracle
Updated LCK.SQL file. Oracle
backspace in SQL Plus not working then..? 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

configUOCIOTTO.ora Oracle
CTAS with LONG Column for 9i and higher Oracle
PLSQL Table Syntax 1 Oracle
dbinv.sql Oracle
Jai Shree Ram Oracle
ORA-8031 issue and solution if it is occuring due to truncate. 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 (400)
PHP/MYSQL/Wordpress (10)
POSTGRESQL (1)
Power-BI (0)
Python/PySpark (7)
RAC (18)
rman-dataguard (26)
shell (150)
SQL scripts (348)
SQL Server (6)
Uncategorized (3)
Videos (0)

Recent Posts

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
Creating a Container Database using dbaascli08-Apr-2026
track_autoupgrade_copy_progress.sql01-Apr-2026
refre.sql for multitenant01-Apr-2026
prepfiles.sh for step by step generating pending statistics files10-Mar-2026
tracksqltime.sql05-Mar-2026

Archives

2026
2025
2024
2023
2010
2009
2008
2007
2006
2005

Jai Shree Ram Linux/Unix
sqlnet.ora paramters Oracle
sql_doing_fts.sql Oracle
Multiple listeners Oracle
prepfiles.sh for step by step generating pending statistics files Oracle
Metalink Note: Note:250655.1 : ADDM Basics USING THE AUTOMATIC DATABASE DIAGNOSTIC MONITOR Oracle
Oracle 11g Environment Setup Oracle
In Addition to previous note, following grants needed on PERFSTAT user. Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme