Friday, October 31, 2014
How to fix ORA-01103 during DB clone
Option 1:
CREATE CONTROLFILE REUSE
SET DATABASE dbname
LOGFILE GROUP 1 ('FILENAME','FILENAME2') SIZE 50K,
GROUP 2 ('FILENAME','FILENAME2') SIZE 50K
RESETLOGS
DATAFILE 'FILENAME' SIZE 2M
Option 2:
use backup controlfile to trace
Option 3:
Use NID to reset DBname
Subscribe to:
Posts (Atom)
My own Mind Map program in Java script and Python
I had been searching online mindmap apps for my study for a while and never got one that I am really happy with. Then I asked myself what I...
-
During performance tuning or being called to debug a performance issues of the database system, we always would like to know the current I/O...
-
There is a bug in 11.2.0.2 and 11.2.0.3 that causes worse plan. need to add hint /*+OPT_PARAM('_optimizer_use_feedback','false...
-
This script shows you information about your memory configurations, current usage, adviser views, etc. Before jumping into any conclusions, ...