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)
Added more to my mindmap tool
This essay version allows you to add long essays to each topic. https://www.free-mindmap.com/Mindmap4LawSchoolEssay.html As I promised, the...
-
Which three actions are performed by the Oracle Preinstallation RPM, oracle-database-server-xxxx-preinstall , for Oracle Grid Infrastructure...
-
This script shows you information about your memory configurations, current usage, adviser views, etc. Before jumping into any conclusions, ...
-
This essay version allows you to add long essays to each topic. https://www.free-mindmap.com/Mindmap4LawSchoolEssay.html As I promised, the...