Controlfile-Backup & amp; recovery-005

1. Back up the database
SQL> alter database backup controlfle to trace;
Default backup file storage path:
E: \ oracle \ product \ 10.1.0 \ admin \ orcl \ udump
2. E: \ oracle \ product \ 10.1.0 \ oradata \ orcl
Delete the controlfie File
Error message when enabling database:
SQL> startup
ORACLE instance started.
 
Total System Global Area 171966464 bytes
Fixed Size 787988 bytes
Variable Size 145488364 bytes
Database Buffers 25165824 bytes
Redo Buffers 524288 bytes
ORA-00205: error in identifying controlfile, check alert log for more info
3. Run the script in the backup file to create the CONTROLO1.CTL file again:
-- Save the script as control. SQL
Create controlfile reuse database "ORCL" NORESETLOGS NOARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
# MAXLOGHISTORY 454
LOGFILE
GROUP 1 'e: \ ORACLE \ PRODUCT \ 10.1.0 \ ORADATA \ ORCL \ redo01.log' SIZE 10 M,
GROUP 2 'e: \ ORACLE \ PRODUCT \ 10.1.0 \ ORADATA \ ORCL \ REDO02.LOG 'SIZE 10 M,
GROUP 3 'e: \ ORACLE \ PRODUCT \ 10.1.0 \ ORADATA \ ORCL \ REDO03.LOG 'SIZE 10 M
-- STANDBY LOGFILE
DATAFILE
'E: \ ORACLE \ PRODUCT \ 10.1.0 \ ORADATA \ ORCL \ system01.dbf ',
'E: \ ORACLE \ PRODUCT \ 10.1.0 \ ORADATA \ ORCL \ undotbs01.dbf ',
'E: \ ORACLE \ PRODUCT \ 10.1.0 \ ORADATA \ ORCL \ sysaux01.dbf ',
'E: \ ORACLE \ PRODUCT \ 10.1.0 \ ORADATA \ ORCL \ users01.dbf ',
'E: \ ORACLE \ PRODUCT \ 10.1.0 \ ORADATA \ ORCL \ example01.dbf'
Character set ZHS16GBK
;
4. Recovery steps:
SQL> startup
ORACLE instance started.
 
Total System Global Area 171966464 bytes
Fixed Size 787988 bytes
Variable Size 145488364 bytes
Database Buffers 25165824 bytes
Redo Buffers 524288 bytes
ORA-00205: error in identifying controlfile, check alert log for more info
 
-- Use the script control. SQL to create the CONTROLO1.CTL file again:
SQL> @ f: \ control. SQL;
 
Control file created.
 
SQL> alter database open;
 
Database altered.
 
-- Check that the database can run
SQL> show parameter sga;
 
NAME TYPE VALUE
-----------------------------------------------------------------------------
Lock_sga boolean FALSE
Pre_page_sga boolean FALSE
Sga_max_size big integer 164 M
Sga_target big integer

Author: "fly @ lwy"