startup Nomount;
CREATE CONTROLFILE SET DATABASE "BID" RESETLOGS ARCHIVELOG
MAXLOGFILES 255
MAXLOGMEMBERS 3
MAXDATAFILES 254
MAXINSTANCES 50
MAXLOGHISTORY 46720
LOGFILE
GROUP 1 (
'F:\oracle\BID\origlogA\LOG_G11M1.DBF',
'F:\oracle\BID\mirrlogA\LOG_G11M2.DBF'
) SIZE 50M,
GROUP 2 (
'F:\oracle\BID\origlogB\LOG_G12M1.DBF',
'F:\oracle\BID\mirrlogB\LOG_G12M2.DBF'
) SIZE 50M,
GROUP 3 (
'F:\oracle\BID\origlogA\LOG_G13M1.DBF',
'F:\oracle\BID\mirrlogA\LOG_G13M2.DBF'
) SIZE 50M,
GROUP 4 (
'F:\oracle\BID\origlogB\LOG_G14M1.DBF',
'F:\oracle\BID\mirrlogB\LOG_G14M2.DBF'
) SIZE 50M
DATAFILE
'F:\oracle\BID\sapdata1\sysaux_1\sysaux.data1',
'F:\oracle\BID\sapdata1\system_1\system.data1',
'F:\oracle\BID\sapdata1\undo_1\undo.data1',
'F:\oracle\BID\sapdata2\bid_1\bid.data1',
'F:\oracle\BID\sapdata2\bid_2\bid.data2',
'F:\oracle\BID\sapdata2\bid_3\bid.data3',
'F:\oracle\BID\sapdata2\bid_4\bid.data4',
'F:\oracle\BID\sapdata2\bid_5\bid.data5',
'F:\oracle\BID\sapdata2\bid_6\bid.data6',
'F:\oracle\BID\sapdata2\bid_7\bid.data7',
'F:\oracle\BID\sapdata2\bid_8\bid.data8',
'F:\oracle\BID\sapdata2\bid_9\bid.data9',
'F:\oracle\BID\sapdata2\bid_10\bid.data10',
'F:\oracle\BID\sapdata2\bid_11\bid.data11',
'F:\oracle\BID\sapdata2\bid_12\bid.data12',
'F:\oracle\BID\sapdata2\bid_13\bid.data13',
'F:\oracle\BID\sapdata2\bid_14\bid.data14',
'F:\oracle\BID\sapdata2\bid_15\bid.data15',
'F:\oracle\BID\sapdata2\bid_16\bid.data16',
'F:\oracle\BID\sapdata2\bid_17\bid.data17',
'F:\oracle\BID\sapdata2\bid_18\bid.data18',
'F:\oracle\BID\sapdata2\bid_19\bid.data19',
'F:\oracle\BID\sapdata2\bid_20\bid.data20',
'F:\oracle\BID\sapdata2\bid_21\bid.data21',
'F:\oracle\BID\sapdata2\bid_22\bid.data22',
'F:\oracle\BID\sapdata2\bid_23\bid.data23',
'F:\oracle\BID\sapdata2\bid_24\bid.data24',
'F:\oracle\BID\sapdata2\bid_25\bid.data25',
'F:\oracle\BID\sapdata2\bid_26\bid.data26',
'F:\oracle\BID\sapdata2\bid_27\bid.data27',
'F:\oracle\BID\sapdata2\bid_28\bid.data28',
'F:\oracle\BID\sapdata2\bid_29\bid.data29',
'F:\oracle\BID\sapdata2\bid_30\bid.data30',
'F:\oracle\BID\sapdata2\bid_31\bid.data31',
'F:\oracle\BID\sapdata2\bid_32\bid.data32',
'F:\oracle\BID\sapdata2\bid_33\bid.data33',
'F:\oracle\BID\sapdata2\bid_34\bid.data34',
'F:\oracle\BID\sapdata2\bid_35\bid.data35',
'F:\oracle\BID\sapdata2\bid_36\bid.data36',
'F:\oracle\BID\sapdata2\bid_37\bid.data37',
'F:\oracle\BID\sapdata2\bid_38\bid.data38',
'F:\oracle\BID\sapdata2\bid_39\bid.data39',
'F:\oracle\BID\sapdata2\bid_40\bid.data40',
'F:\oracle\BID\sapdata2\bid_41\bid.data41',
'F:\oracle\BID\sapdata2\bid_42\bid.data42',
'F:\oracle\BID\sapdata2\bid_43\bid.data43',
'F:\oracle\BID\sapdata2\bid_44\bid.data44',
'F:\oracle\BID\sapdata2\bid_45\bid.data45',
'F:\oracle\BID\sapdata2\bid_46\bid.data46',
'F:\oracle\BID\sapdata2\bid_47\bid.data47',
'F:\oracle\BID\sapdata2\bid_48\bid.data48',
'F:\oracle\BID\sapdata2\bid_49\bid.data49',
'F:\oracle\BID\sapdata2\bid_50\bid.data50',
'F:\oracle\BID\sapdata2\bid_51\bid.data51',
'F:\oracle\BID\sapdata2\bid_52\bid.data52',
'F:\oracle\BID\sapdata2\bid_53\bid.data53',
'F:\oracle\BID\sapdata2\bid_54\bid.data54',
'F:\oracle\BID\sapdata2\bid_55\bid.data55',
'F:\oracle\BID\sapdata2\bid_56\bid.data56',
'F:\oracle\BID\sapdata2\bid_57\bid.data57',
'F:\oracle\BID\sapdata2\bid_58\bid.data58',
'F:\oracle\BID\sapdata2\bid_59\bid.data59',
'F:\oracle\BID\sapdata2\bid_60\bid.data60',
'F:\oracle\BID\sapdata2\bid_61\bid.data61',
'F:\oracle\BID\sapdata2\bid_62\bid.data62',
'F:\oracle\BID\sapdata2\bid_63\bid.data63',
'F:\oracle\BID\sapdata2\bid_64\bid.data64',
'F:\oracle\BID\sapdata2\bid_65\bid.data65',
'F:\oracle\BID\sapdata2\bid_66\bid.data66',
'F:\oracle\BID\sapdata2\bid_67\bid.data67',
'F:\oracle\BID\sapdata2\bid_68\bid.data68',
'F:\oracle\BID\sapdata2\bid_69\bid.data69',
'F:\oracle\BID\sapdata2\bid_70\bid.data70',
'F:\oracle\BID\sapdata2\bid_71\bid.data71',
'F:\oracle\BID\sapdata2\bid_72\bid.data72',
'F:\oracle\BID\sapdata2\bid_73\bid.data73',
'F:\oracle\BID\sapdata2\bid_74\bid.data74',
'F:\oracle\BID\sapdata2\bid_75\bid.data75',
'F:\oracle\BID\sapdata2\bid_76\bid.data76',
'F:\oracle\BID\sapdata2\bid_77\bid.data77',
'F:\oracle\BID\sapdata2\bid_78\bid.data78',
'F:\oracle\BID\sapdata3\bid701_1\bid701.data1',
'F:\oracle\BID\sapdata3\bid701_2\bid701.data2',
'F:\oracle\BID\sapdata3\bid701_3\bid701.data3',
'F:\oracle\BID\sapdata3\bid701_4\bid701.data4',
'F:\oracle\BID\sapdata3\bid701_5\bid701.data5',
'F:\oracle\BID\sapdata3\bid701_6\bid701.data6',
'F:\oracle\BID\sapdata3\bid701_7\bid701.data7',
'F:\oracle\BID\sapdata3\bid701_8\bid701.data8',
'F:\oracle\BID\sapdata3\bid701_9\bid701.data9',
'F:\oracle\BID\sapdata3\bid701_10\bid701.data10',
'F:\oracle\BID\sapdata3\bid731_1\bid731.data1',
'F:\oracle\BID\sapdata3\bid731_2\bid731.data2',
'F:\oracle\BID\sapdata3\bid731_3\bid731.data3',
'F:\oracle\BID\sapdata4\bidusr_1\bidusr.data1'
CHARACTER SET UTF8;
After this control file creation
run the script below : AUTO
recover database using backup controlfile;
then >>> below
recover database using backup controlfile until cancel;
alter database open resetlogs;
this for my reference in future
