blog.contractoracle.com
Contract Oracle Limited is not affiliated to Oracle Corporation.
Blog Archive
►
2011
(1)
►
October
(1)
Enable APEX in Oracle 11.2
►
2010
(22)
►
October
(2)
Script to detect duplicate file names in different...
Script to increment sequences
►
May
(2)
Rebuilding unusable indexes, index partitions, and...
Diagnosing RAC cluster waits.
►
April
(1)
MMON automatically deletes AWR snaps if SYSAUX is ...
►
March
(7)
Freeing up db_recovery_file_dest reclaimable space...
DBMS_SHARED_POOL.PURGE
DBMS_ROWID
Test of parameter NOSYSDBA
using DBMS_SESSION.SET_CONTEXT to store variables
Duplicate database from active
Create a Dataguard Broker Configuration
►
February
(4)
ORA-07445: exception encountered: core dump [ktuGe...
ORA-28378: Wallet not open after setting the Maste...
DBA_FEATURE_USAGE_STATISTICS
An open database is not really open ?
►
January
(6)
ORA-00600: internal error code, arguments: [kcvhvd...
Allow 11g to access UTL_SMTP
Oracle 11.1.0.7.2 DB cannot write to 11.1.0.7.1 AS...
ASM diagnostics Report
Auditing feature usage in Oracle
Using PLSQL to load images into a BLOB
▼
2009
(94)
►
December
(2)
Using Flashback Archive to avoid ORA-01555
asmcmd CP command fails
►
November
(11)
Cannot export empty tables in 11.2
ORA-32016: parameter "db_name" cannot be updated i...
Global Temporary Tables generate REDO and UNDO
Analysis of Oracle password expiry
Changing NLS session parameters changes the plan
MAA for Active Dataguard
Checking Dataguard Transport Lag
Using x$logbuf_readhist to check for Dataguard Tra...
Enable Active Standby on a database with Dataguard...
Sqlnet Listener :- status READY, has 0 handler(s) ...
ORA-01503, ORA-12720 when creating controlfile
►
October
(1)
Identifying low cardinality indexes
►
September
(12)
Recover standby database using incremental backup
Table DML auditing to identify unused tables
Index monitoring to identify unused indexes.
Enable Oracle auditing BEFORE you need it.
Shared pool contents - v$db_object_cache
ORA-00604, ORA-01405 when dropping a table
SP2-0618: Cannot find the Session Identifier. Che...
PRKS-1009 : Failed to start ASM instance
Opatch - Inventory check failed
dbms_scheduler job class
Streams Heartbeat example
11gR2 released. Time to play.
►
August
(11)
adcri commands
▼
July
(18)
Identifying default passwords in Oracle databases....
Script to list connections to all databases on a s...
Best Practices for Securing Oracle E-Business Suit...
Test flashback
Create a Dataguard Broker configuration
ORA-16714 Dataguard broker sensitive to "alter dat...
dgmgrl switchover
Manual Dataguard Switchover
DBA_RECYCLEBIN
Cleanup invalid objects
Generate DDL for invalid objects
Oracle 11gR2 new features
ORA-26723: user "STRMADMIN" requires the role "DBA...
Change AWR snapshot frequency
Script to generate Oracle password hashes
Fast Refresh Materialized View
How to reduce Oracle infrastructure costs (and kee...
Audit DDL with a BEFORE DDL Trigger.
►
June
(14)
►
May
(4)
►
April
(4)
►
March
(8)
►
February
(5)
►
January
(4)
►
2008
(156)
►
December
(2)
►
November
(1)
►
October
(28)
►
September
(35)
►
August
(90)
Thursday, July 16, 2009
dgmgrl switchover
# alter system set dg_broker_start=TRUE;
dgmgrl
connect sys
show configuration
# Switchover
switchover to pl01cfd
0 comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment