on 07-09-2009 7:16 AM
Hello,
While performing restore, we found that OriglogA and MirrlogB folders were not backed up(OFFLINE backup).
However, we do have OriglogB and MirrlogA. Now since
OriglogA=MirrlogA
and
MirrlogB=OriglogB
Can we just copy the available .dbf files into the missing directories, rename them accordingly?
will this work?
Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Gautam,
As per me, you can copy the files and paste in the missing directories and rename them according.
Kalyan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You will get answer of your question in the same sap note (491160)
SQL> ALTER DATABASE ADD LOGFILE GROUP <gropuid>
('<path & name member 1>'
'<path & name member 2>') size <size>;for logfile groups
SQL> ALTER DATABASE ADD LOGFILE '<path/filename>' ;for single logfiles.
Thanks
Sushil
Edited by: Sushil Suryawanshi on Jul 9, 2009 12:57 PM
Hello,
I created the control files by running CONTROL.SQL and it created the Origlog and Mirrlog files by itself.
I did not restore any of the Origlog or Mirrlog files from the source, still they were created during creation of control file.
Could you please tell me the reason, how they were created?
Thanks.
it has been mentioned several times regarding SAP note 491160.
if the database is shut down
just copy the member that is still available to the locatation &
name of the missing member
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;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I saw the post -
<a class="jive_macro jive_macro_thread" href="" __jive_macro_name="thread" modifiedtitle="true" __default_attr="1400634"></a>
However in my case, OriglogA and MirrlogB do not exist at all
Could you please confirm if the following commands will create OriglogA from MirrlogA
For ORIGLOGA -
SQL> ALTER DATABASE ADD LOGFILE MEMBER 'H:\ORACLE\SID\ORIGLOGA\LOG_G21M1.DBF' to group 1;
SQL> ALTER DATABASE ADD LOGFILE MEMBER 'H:\ORACLE\SID\ORIGLOGA\LOG_G23M1.DBF' to group 3;
and will this one create MirrlogB from OriglogB
For MIRRLOGB -
SQL> ALTER DATABASE ADD LOGFILE MEMBER 'H:\ORACLE\SID\MIRRLOGB\LOG_G22M2.DBF' to group 2;
SQL> ALTER DATABASE ADD LOGFILE MEMBER 'H:\ORACLE\SID\MIRRLOGB\LOG_G24M2.DBF' to group 4;
Edited by: Gautam Poddar on Jul 9, 2009 8:58 AM
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
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.