Skip to content

Home
About Me
Toggle search form
Search for:

Composite Index creation tip from Vivek Oracle
USE_NL and INDEX hints example Oracle
CTAS with LONG Column for 9i and higher Oracle
All About oracle password and security from metalink Oracle
standard Monitoring – 1 Oracle
Oracle Identifiers Oracle
move_arch_files.ksh Linux/Unix
Oracle Material from OTN Oracle
Adding or Dropping Online Redo Log Files When Physical Standby in place Oracle
Absolute file number and relative file number Oracle
Oracle 11g Environment Setup Oracle
CPU Core related projections AWS
USER_TABLES.Freelists Oracle
Very Good Oralce Internal Tuning Book Oracle
cur_sql.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

How to stop OCSSD Daemon Oracle
When to rebuld B-tree index Oracle
Reclaim temp tablespace for oracle 8, 8i Oracle
import-export with multiple files Oracle
eplan.sql Oracle
Backup and Recovery Scenarios 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 (393)
PHP/MYSQL/Wordpress (10)
POSTGRESQL (1)
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

Complete Git Tutorial for Beginners25-Dec-2025
Postgres DB user and OS user.25-Dec-2025
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

Archives

2025
2024
2023
2010
2009
2008
2007
2006
2005

Oracle Support Metalink ID 161818.1 Oracle
How to know Number of CPUs on Sun Box Linux/Unix
Find average Row Length and other table size calculation. metalink notes Oracle
DETERMINING WHICH INSTANCE OWNS WHICH SHARED MEMORY & SEMAPHORE SEGMENTS Oracle
Session_info.ksh Linux/Unix
good note for shared pool tunnig Oracle
Global Unique Identifier Generation in Oracle 9.2 SYS_GUID() Oracle
Find Stale DR Physical Standby Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme