on 01-19-2010 8:39 AM
Hi,
I am getting the following warning message in backup log(DB12). I tried to check the at mirrlogA & mirrlogB. There are no files inside this folder. Need someone's interventions to solve this warning messages in DB12 backup logs.
BR0335W Status of online redo log file /oracle/UQ1/mirrlogA/log_g11m2.dbf is INVALID
BR0274W File '/oracle/UQ1/mirrlogA/log_g11m2.dbf' not found
BR0335W Status of online redo log file /oracle/UQ1/mirrlogB/log_g12m2.dbf is INVALID
BR0274W File '/oracle/UQ1/mirrlogB/log_g12m2.dbf' not found
BR0335W Status of online redo log file /oracle/UQ1/mirrlogA/log_g13m2.dbf is INVALID
BR0274W File '/oracle/UQ1/mirrlogA/log_g13m2.dbf' not found
BR0335W Status of online redo log file /oracle/UQ1/mirrlogB/log_g14m2.dbf is INVALID
BR0274W File '/oracle/UQ1/mirrlogB/log_g14m2.dbf' not found
regards,
Kaspar
Hi ,
Seems as if only the online Mirrorlogs are missing and the original logfiles must be there,,otherwise your database would have crashed.
Check the original log directories('/oracle/UQ1/origlogA/ & '/oracle/UQ1/origlogB/' and you must be having files there and proceed as following.
1. If the database is shut down
just copy the member that is still available to the locatation & name of the missing member
2. If the database is open
drop the member out of the group and recreate it sqlplus '/ as sysdba'
SQL> ALTER DATABASE DROP LOGFILE MEMBER '<path/filename>';
SQL> ALTER DATABASE ADD LOGFILE MEMBER '<path/filename>' to group X;
If the disk, on which the member was created on, does not exist anymore, you can specify a different location in the add logfile member command
This should help.
Regards
Amit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi SAP friends,
please, can you help me with this issue on our Oracle 12.0.1.2 Production database?
If I run the query
SQL> SELECT GROUP#, STATUS, MEMBER FROM V$LOGFILE;
The result is:
GROUP# STATUS MEMBER
4 INVALID I:\ORACLE\ITP\ORIGLOGB\LOG_G14M1.DBF
4 K:\ORACLE\ITP\MIRRLOGB\LOG_G14M2.DBF
3 INVALID I:\ORACLE\ITP\ORIGLOGA\LOG_G13M1.DBF
3 K:\ORACLE\ITP\MIRRLOGA\LOG_G13M2.DBF
2 INVALID I:\ORACLE\ITP\ORIGLOGB\LOG_G12M1.DBF
2 K:\ORACLE\ITP\MIRRLOGB\LOG_G12M2.DBF
1 INVALID I:\ORACLE\ITP\ORIGLOGA\LOG_G11M1.DBF
1 K:\ORACLE\ITP\MIRRLOGA\LOG_G11M2.DBF
Our database is UP&Running.
Please can you explain me how to use the query showed in the correct answer with my real data?
2. If the database is open
drop the member out of the group and recreate it sqlplus '/ as sysdba'
SQL> ALTER DATABASE DROP LOGFILE MEMBER '<path/filename>';
SQL> ALTER DATABASE ADD LOGFILE MEMBER '<path/filename>' to group X;
Is this operation dangerous for our production database?
Please help me. Thanks in advance,
Alessandro
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Kaspar,
please execute the following query and post the output.
shell> sqlplus / as sysdba
SQL> set linesize 900
SQL> SELECT GROUP#, STATUS, MEMBER FROM V$LOGFILE;
Regards
Stefan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.