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
No comments:
Post a Comment