with backup control file recovery, the control file does not contain data files, but the online log has
ALTER DATABASE backup Controlfile to ' D:\control.ctl ';
Create tablespace tp1 datafile ' d:/tp1.dbf ' size 10M;
CREATE TABLE t1 (ID int,name varchar2 (Ten)) tablespace TP1;
INSERT INTO T1 values (1, ' pl1 ');
commit;
stop Service ==>services.msc==> stop Oracle Process
RM-RF control*
shutdown abort;
copy D:\control.ctl D:\app\administrator\oradata\orcl\control01.ctl
startup Mount;
select file#,checkpoint_change# from V$datafile;
select file#,checkpoint_change# from V$datafile_header;
ALTER DATABASE open;//hint control file old
Recover database using Backup controlfile;
Select * from V$log find current log
Input D:\oradata\orcl\redo02.log--Status is current
650) this.width=650; "src=" http://s2.51cto.com/wyfs02/M00/7F/43/wKiom1cYLD7Dh_5kAALqDv1rqlE607.bmp "style=" float: none; "title=" 1.bmp "alt=" Wkiom1cyld7dh_5kaalqdv1rqle607.bmp "/>
Hint that there is a file that does not recognize
select File#,name from V$datafile;
650) this.width=650; "Src=" http://s4.51cto.com/wyfs02/M02/7F/41/ Wkiol1cylagrvgymaasdkmwo5yk165.bmp "title=" 2.bmp "alt=" Wkiol1cylagrvgymaasdkmwo5yk165.bmp "/>
ALTER DATABASE rename file ' D:\ app/administrator\product\11.2.0\dbhome_1\database\unnamed00005 ' to ' D:\tp1.dbf ';
650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/7F/41/wKioL1cYLk-AtgIqAAmbzkMeqU8739.bmp "title=" 3.bmp " alt= "Wkiol1cylk-atgiqaambzkmequ8739.bmp"/>
Recover database using Backup controlfile;
Input:/oradata/orcl/redo02.log--a SELECT * from V$log;
ALTER DATABASE open resetlogs;
Control file Recovery with backup