DBrestore with out controlfile

[Former Member]

hi All,

One of our server was crashed ..

i has restored with online backup ...

but the thing is i dont have controlfile ....

when iam starting the SQL iam getting this error ....

sql>startup

"ORACLE instance started.

Total System Global Area 1010827264 bytes

Fixed Size 2169040 bytes

Variable Size 521037616 bytes

Database Buffers 486539264 bytes

Redo Buffers 1081344 bytes

ORA-00205: error in identifying control file, check alert log for more info"

plz help me out ....

babu

[Former Member]

Hi

Check ur init<sid>.ora file under $ORACLE_HOME/dbs there is a parameter control_files if u have any control file (multiplexed copy ) available on any disks.

Regards

Kausik

[Former Member]

hi kaushik,

the thing is our SAP system was crashed ....

then i did sapinstallation and i restore the sap with old online backup ......

restore is successfull...

but i dont have controlfile..

This is the ISSUE ...

Regards

babiu

[Former Member]

If u r sure u don't have any copy of ur control (not even an output of alter database backup controlfile to trace;) then u need to create one .

First U need to find out details of ur database which includes datafiles along with its location (as u have restored them),log files with their locations,etc and need to create a script like the following

CREATE CONTROLFILE REUSE DATABASE "ORCL10G" RESETLOGS NOARCHIVELOG

MAXLOGFILES 16

MAXLOGMEMBERS 3

MAXDATAFILES 100

MAXINSTANCES 8

MAXLOGHISTORY 292

LOGFILE

GROUP 1 'K:\ORCL10G\LOG\REDO01.LOG' SIZE 50M,

GROUP 2 'K:\ORCL10G\LOG\REDO02.LOG' SIZE 50M,

GROUP 3 'K:\ORCL10G\LOG\REDO03.LOG' SIZE 50M

DATAFILE

'K:\ORCL10G\DATA\SYSTEM01.DBF',

'K:\ORCL10G\DATA\UNDOTBS01.DBF',

'K:\ORCL10G\DATA\SYSAUX01.DBF',

'K:\ORCL10G\DATA\USERS01.DBF',

'K:\ORCL10G\DATA\EXAMPLE01.DBF',

'K:\ORCL10G\DATA\UNDOTBS02.DBF'

CHARACTER SET WE8MSWIN1252;

The above is just a sample one u need to modify them as per ur requirement.

Then issue the following commands

startup nomount

Run the above modified script

(Note the RESETLOGS option in the create control file script. This will reset the logs and synchronizes the SCN between the database files, control files and redo log file. )

Once u get the following

Control file created

Issue the following commands

alter database mount;

alter database open resetlogs;

U need to keep in mind the following

The database opened successfully. The only point to consider is that of the data loss. The data in the redo log files, as it existed before the loss, will be lost. Hence the data loss here could be minimum.

Regards

Kausik

[Former Member]

Are you really not have the control file? The online backup buckups the control file try to check all restored files you have, and on the recovery point you need to use the "using backup controlfile" try to read more in -->

http://help.sap.com/erp2005_ehp_04/helpdata/EN/0d/d300154a0c11d182b80000e829fbfe/frameset.htm

If you do not have the controlfile try to read

http://help.sap.com/erp2005_ehp_04/helpdata/EN/0d/d2ffba4a0c11d182b80000e829fbfe/content.htm

P.S. post your log's and how you doing restore. Regards.

Edited by: Sergo Beradze on Aug 18, 2010 2:33 PM

[Former Member]

hi SERGO,

un expected ly our system has crashed ...

so i dont have control file but we have resent online backup ...

with that i restore it ..

just typing BRRESTORE

it was successful and ..

but contriol file has not yet generated ????

can u tell me wat to do

and i did but its giving error

"recover database using backup controlfile;"

Regards

babu

[Former Member]

just typing BRRESTORE
it was successful

Can you poste the log from this action ... I'm think the control file are restored but not located in needed directory.

For example

try to execute -- >

brrestore -m 0

Regards.

[Former Member]

hi sergo,

thanks for ur reply...

and i restore the control file with that command .. THNKS A TON FOR QUICK REPLY

and i started the D/b in mounted .

i was strucked here ....

"startup mount

database mounted ...

but i executed the command ..

alter database open resetlogs;

*

ERROR at line 1:

ORA-01195: online backup of file 1 needs more recovery to be consistent

ORA-01110: data file 1: 'F:\ORACLE\IDE\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'

.......

i am getting this Error...

if i executed this command .. i dont have oraarch files ..

*RECOVER DATABASE USING BACKUP CONTROLFILE*

..CAn i open the database up to the backup level

babu

[Former Member]

i dont have oraarch files ..

You not backed up it, or you not restore it ?

You can restore it if you have backup using -->

brrestore u2013a nn-zz where nn and zz are log sequence numbers. This command restores logs from nn(example 21) to zz (example 89). You can check this numbers in log (like archSID.log) in saparch directory .

P.S. what do you see if execute the

recover database until cancel using backup controlfile

P.P.S try to read this main guide , may be you find other solution in your situation (other method for recovering) -->

http://help.sap.com/erp2005_ehp_04/helpdata/EN/65/cade3bd0c8545ee10000000a114084/frameset.htm

Regards.

[Former Member]

hi sergo,

i am not finding any log in orach dir..

As iam saying u again .. this is new system ( new inst ) and restoring with old online backup ..

i am expecting the old system only ( we dont want point of time recovery)

so any one help me out....

till now i had completed these tasks..

BRRESTORE...

and

BRRESTRE -M 0 ( FOR CNTRL FILE )

REGARDS

BABU

[Former Member]

i am not finding any log in orach dir..

Can you explain how you do the online backup ?

On Tape ? on Disk? or using tool's like DATA Protector ?

Can you check what you backed up?

Are this online+redolog ? or online consistent backup ? Or only online ?

Are you doing redolog backup ever ?

[Former Member]

hi sorry for not replying ..

using brtools iam doing online bakup .....

i want to perform disaster recovert for our server ....

that server has crashed ...

i installed new sap and with online backup i restore ed ,,,

so i want to recover system till backup time...

at present i dont have cntrl file adn oraarch files/...

[former_member204746]

for an online backup, without offline redologs, your backup is worthless.

this is why you should at least do online backup with option online_cons when using brbackup.