Forum Stats

  • 3,759,874 Users
  • 2,251,609 Discussions
  • 7,870,852 Comments

Discussions

How do I get rid of this problem with my database?

User_4FUV3
User_4FUV3 Member Posts: 1 Green Ribbon

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}


ORA-00308: cannot open archived log

'E:\APP\SARALHOSSAIN\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2021_03_29\O1_MF_1_490_

%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-10879: error signaled in parallel recovery slave

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: 'E:\APP\SARALHOSSAIN\ORADATA\ORCL\SYSTEM01.DBF'



SQL> alter database open resetlogs;

alter database open resetlogs

*

ERROR at line 1:

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: 'E:\APP\SARALHOSSAIN\ORADATA\ORCL\SYSTEM01.DBF'



SQL>

Answers

  • Sridhar_Nalla
    Sridhar_Nalla Member Posts: 8 Blue Ribbon

    Looks like recovery needed before resetting the log files. Make sure the archive log file it's seeking available. Also double check the log_archove_format was not modified after the database corrupted, if modified go to the alert log file and restore back to before the db corrupt.

  • EdStevens
    EdStevens Member Posts: 28,484 Gold Crown

    The log_archive_format will not make a difference. That is used in creating log files, not in locating them for recovery. When an archivelog (or an rman backup of anything) is created, it's full name is recorded in the repository in the control file. That repository is what is used to locate any needed backup pieces or archivelogs.

  • User_4FUV3
    User_4FUV3 Member Posts: 1 Green Ribbon

    E:\app\saralhossain\product\11.2.0\dbhome_2\BIN> rm -rf /u01/oracle/product/10.2.0/db_1/oradata/test/*.ctl

    'rm' is not recognized as an internal or external command,

    operable program or batch file.

    While recovery I'm having this issue, 'rm' is found that on internet>??

  • EdStevens
    EdStevens Member Posts: 28,484 Gold Crown
    edited Apr 1, 2021 3:14PM

    'rm' is the unix commad for deleteing (ReMove) a file.

    The -r flag means "recursive" - remove directories and their contents recursively

    the -f flag means "force" - ignore nonexistent files, never prompt


    You are obviously on a WindBlows system, so you need to use the appropriate DELete command.

    Christyxo