Skip to content

Home
About Me
Toggle search form
Search for:

Absolute file number and relative file number Oracle
Rename Oracle Instance Name Oracle
Important Solaris Commands Linux/Unix
TRUNCATE table and disabling referential constraints. Oracle
How to know Number of CPUs on Sun Box Linux/Unix
Very clear article about oracle dataguard Oracle
temp_use.sql diplays usage of temp ts Oracle
Search and replace editor command in vi Linux/Unix
Generating XML from SQLPLUS Oracle
Nice Article about semaphores and init.ora Processes parameter relations Linux/Unix
column level grant syntax Oracle
Explain Plan Doesn’T Change For Sql After New Statistics Generated Oracle
oracle tips… from http://www.bijoos.com/oracle/douknow.htm Oracle
Adding a new disk and mount it automatically. on VMWARE LINUX Linux/Unix
To see only files and/or folders using LS command 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

Oracle Metalink useful notes Oracle
Very clear article about oracle dataguard Oracle
Flowers Resize datafiles Oracle
pvm_rbs1.sql (to collect rbs info from db) Oracle
Parallel DML Oracle
Clean up 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

To seee semaphores and shared memory segments in Solaris Linux/Unix
pvm_metric.sql for gathering report from vmstat tables Oracle
Creating a Container Database using dbaascli Uncategorized
_B_TREE_BITMAP_PLANS issue during 8.1.7 to 9.2.0.8 upgrade Oracle
All Hints for Oracle Databases Oracle
get_aix_vmstat.ksh Oracle
Korn Shell Arithmatic Linux/Unix
rm_backup_arch_file.ksh Linux/Unix

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme