Skip to content

Home
About Me
Toggle search form
Search for:

find_pk.sql /* Find Primary Key */ Oracle
Another Tuning Article for subheap of shared pool Oracle
Unix split command to split files Linux/Unix
tuning commmand for cpu, ip and memory stats Linux/Unix
Benefits and Usage of RMAN with Standby Databases Oracle
Search and replace pattern Linux/Unix
Pending Distributed Transations Oracle
How to check current redo log progress redo_progress.sql Oracle
Generating XML from SQLPLUS Oracle
Goldengate document from Porus Oracle
Drop database in Oracle 10g Oracle
How to find pinned objects from shared pool. (pinned via dbms_shared_pool.keep) Oracle
handling filenname with space Linux/Unix
find_cons.sql Oracle
Find All internal Parameters 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

Parallel DML Oracle
How to set Processes Parameter Oracle
How to Decide upto what level you can decrement your datafile size. ( Shrink Datafile) Oracle
Privileges Required to Create Procedures and Functions that uses objects from other schema. Oracle
In Addition to previous note, following grants needed on PERFSTAT user. Oracle
get_ratio.sql get the ratio of users from v$session and this uses CASE-WHEN-THEN clause 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

AMC10 (0)
Ansible (0)
AWS (2)
Azure (1)
Django (0)
GIT (1)
Linux/Unix (150)
MYSQL (5)
Oracle (403)
PHP/MYSQL/Wordpress (10)
POSTGRESQL (1)
Power-BI (0)
Python/PySpark (7)
RAC (18)
rman-dataguard (26)
shell (151)
SQL scripts (349)
SQL Server (6)
Uncategorized (9)
Videos (0)

Recent Posts

Tutornet.US — Source of excellent learning14-Oct-2026
OCI Infrastructure Patching14-Oct-2026
Free API credits for AI models14-Oct-2026
AMC1020-Sep-2026
Key Management in Oracle: The Core Issue: Missing Master Key12-May-2026
SAT Mathematics 10 questions and answer at the end.30-Apr-2026
top 10 AI news today30-Apr-2026
runon_allpdbs_show_conname.sh23-Apr-2026
runon_allcdbs_find_pdbs.sh23-Apr-2026
Running PDB on single node in RAC09-Apr-2026

Archives

2026
2025
2024
2023
2010
2009
2008
2007
2006
2005

Standby Database Behavior when a Datafile is Resized on the Primary Database Note:123883.1 Oracle
ORA-3136 Oracle
Find_stale_dr.sql finding stale physical DR.. Oracle
Jai Shree Ram Linux/Unix
create PLAN_TABLE command. Oracle
Oracle Support Metalink ID 161818.1 Oracle
note id 373303.1 Linux/Unix
find_err.sql for finding errors from dba_errors. Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme