Database Administrator
Showing posts with label
diaster recovery
.
Show all posts
Showing posts with label
diaster recovery
.
Show all posts
Thursday, February 14, 2013
partition in a partitioned table truncated by mistake
›
Import partition data A partition in a partitioned table was truncated by mistake and data needs to be imported from an export dump. How...
Wednesday, December 14, 2011
Switchover and Failover steps
›
SWITCH OVER 1. SELECT SWITCHOVER_STATUS FROM V$DATABASE; SWITCHOVER_STATUS ----------------- TO STANDBY 1 row selected 2. ALTER DATABASE COM...
Monday, March 14, 2011
Multiplexing of Redo logs
›
SELECT group#, members, status, bytes FROM v$log; SELECT group#, member, type FROM v$logfile; ALTER DATABASE ADD LOGFILE MEMBER 'C:\REDO...
Friday, August 6, 2010
Oracle 10g Standby Database
›
Oracle 10g Standby Database -------------------------------------- PRODUCTION DATABASE: 10.100.0.65 STANDBY DATABASE: 10.100.0.32 ----------...
Wednesday, July 14, 2010
Oracle 11g Standby Database
›
Oracle Standby database on same machine (for testing) -----------------I. Before you get started:------------------- 1. Make sure the operat...
›
Home
View web version