Due to improper operation caused by the damage of the database log

Displays error when open the PL/SQL and unable to establish connection with database

WIN + R open the CMD input up sqlplus sys/sys as sysdba
Get
SQL * Plus: Release 11.2.0.1.0 Production on Monday February 22 09:07:10 2021

Copyright (c) 1982, 2010, Oracle. All rights reserved.


To connect to:
Oracle Database 11 g Enterprise Edition Release 11.2.0.1.0-64 - bit Production
With the Partitioning, OLAP, Data Mining, and Real Application Testing options

Input shutdown for
ORA - 01109: the database is not open


Have unloaded database,
ORACLE routines have been closed,

Then enter the startup get
ORACLE routines are started,

The Total System Global Area 3373858816 bytes
Fixed Size of 2180424 bytes
Variable Size of 1862273720 bytes
The Database Buffers 1493172224 bytes
Redo Buffers 16232448 bytes
Database finished loading,
ORA - 00354: damage to redo log header
ORA - 00353: log damage close to change 3310546 time 27974 02/05/2021 15:09:11
ORA - 00312: online LOG 2 thread 1: 'E: \ \ 16527 \ ORADATA \ APP wouldn \ REDO02 LOG'

Can see due to personal operation not put log is damaged, so I don't feel too good access to repair using another method to delete database built again and be able to solve (this method restore factory Settings like mobile phone, prudent operation)


Find Oracle start menu folder called the Database Configuration Assistant program (the program for creating management delete Database using)

After open interface found in delete database, choose to delete the database, input password password management,
Delete completed back to the home page, click create database, according to individual needs the latter baidu tutorials created can be normal use


This method is more extreme, please careful operation, the other, if there is a big back log method to solve the above problem, please enlighten me, thank you
Email:[email protected]

CodePudding user response:

This recovery is simple reference: https://www.xifenfei.com/2016/01/ora-00354_ora-00353_ora-00312.html
The

references the building Lord, I am a P tag response:

database log damage due to improper operation and

Displays error when open the PL/SQL and unable to establish connection with database

WIN + R open the CMD input up sqlplus sys/sys as sysdba
Get
SQL * Plus: Release 11.2.0.1.0 Production on Monday February 22 09:07:10 2021

Copyright (c) 1982, 2010, Oracle. All rights reserved.


To connect to:
Oracle Database 11 g Enterprise Edition Release 11.2.0.1.0-64 - bit Production
With the Partitioning, OLAP, Data Mining, and Real Application Testing options

Input shutdown for
ORA - 01109: the database is not open


Have unloaded database,
ORACLE routines have been closed,

Then enter the startup get
ORACLE routines are started,

The Total System Global Area 3373858816 bytes
Fixed Size of 2180424 bytes
Variable Size of 1862273720 bytes
The Database Buffers 1493172224 bytes
Redo Buffers 16232448 bytes
Database finished loading,
ORA - 00354: damage to redo log header
ORA - 00353: log damage close to change 3310546 time 27974 02/05/2021 15:09:11
ORA - 00312: online LOG 2 thread 1: 'E: \ \ 16527 \ ORADATA \ APP wouldn \ REDO02 LOG'

Can see due to personal operation not put log is damaged, so I don't feel too good access to repair using another method to delete database built again and be able to solve (this method restore factory Settings like mobile phone, prudent operation)


Find Oracle start menu folder called the Database Configuration Assistant program (the program for creating management delete Database using)

After open interface found in delete database, choose to delete the database, input password password management,
Delete completed back to the home page, click create database, according to individual needs the latter baidu tutorials created can be normal use


This method is more extreme, please careful operation, the other, if there is a big back log method to solve the above problem, please enlighten me, thank you
Email:[email protected]