RECOVER database until cancel using backup controlfile; CREATE CONTROLFILE
1008310May 10 2013 — edited May 13 2013I create database but have a problem with recovery. I could not open DB until
allowresetlogs_corruption = true in my init.ora file
I can create tables in DB and open, altering it but I have
ALTER DATABASE RECOVER database until cancel using backup controlfile AUTO option
Media Recovery Start
started logmerger process
Parallel Media Recovery started with 4 slaves
ORA-279 signalled during: ALTER DATABASE RECOVER database until cancel using backup controlfile ...
ALTER DATABASE RECOVER CONTINUE DEFAULT
Media Recovery Log C:\APP\STR\FLASH_RECOVERY_AREA\MYNEWDB1\ARCHIVELOG\2013_05_11\O1_MF_1_1_%U_.ARC
Sat May 11 08:03:53 2013
Errors with log C:\APP\STR\FLASH_RECOVERY_AREA\MYNEWDB1\ARCHIVELOG\2013_05_11\O1_MF_1_1_%U_.ARC
Errors in file C:\APP\STR\diag\rdbms\mynewdb1\mynewdb1\trace\mynewdb1_pr00_16684.trc:
ORA-00308: cannot open archived log 'C:\APP\STR\FLASH_RECOVERY_AREA\MYNEWDB1\ARCHIVELOG\2013_05_11\O1_MF_1_1_%U_.ARC'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
ORA-308 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...
ALTER DATABASE RECOVER CONTINUE DEFAULT
Media Recovery Log C:\APP\STR\FLASH_RECOVERY_AREA\MYNEWDB1\ARCHIVELOG\2013_05_11\O1_MF_1_1_%U_.ARC
Errors with log C:\APP\STR\FLASH_RECOVERY_AREA\MYNEWDB1\ARCHIVELOG\2013_05_11\O1_MF_1_1_%U_.ARC
Errors in file C:\APP\STR\diag\rdbms\mynewdb1\mynewdb1\trace\mynewdb1_pr00_16684.trc:
ORA-00308: cannot open archived log 'C:\APP\STR\FLASH_RECOVERY_AREA\MYNEWDB1\ARCHIVELOG\2013_05_11\O1_MF_1_1_%U_.ARC'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
ORA-308 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...
ALTER DATABASE RECOVER CANCEL
Media Recovery Canceled
Completed: ALTER DATABASE RECOVER CANCEL
Sat May 11 08:05:24 2013
ALTER DATABASE RECOVER database until cancel using backup controlfile cancel
Media Recovery Start
started logmerger process
Parallel Media Recovery started with 4 slaves
ORA-279 signalled during: ALTER DATABASE RECOVER database until cancel using backup controlfile ...
ALTER DATABASE RECOVER CANCEL
Media Recovery Canceled
Completed: ALTER DATABASE RECOVER CANCEL
CREATE CONTROLFILE REUSE DATABASE MYNEWDB1 RESETLOGS
WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command
Default Temporary Tablespace will be necessary for a locally managed database in future release
Errors in file C:\APP\STR\diag\rdbms\mynewdb1\mynewdb1\trace\mynewdb1_ora_16648.trc:
ORA-01565: error in identifying file '%ORACLE_HOME%\DATABASE\DBS1%ORACLE_SID%.ORA'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
ORA-1503 signalled during: CREATE CONTROLFILE REUSE DATABASE MYNEWDB1 RESETLOGS...