cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-01157: cannot identify/lock data file 1 - see DBWR trace file

Former Member
0 Kudos

Hi all,

the following is the error when im trying to start the database,

ORACLE instance started.

Total System Global Area 1.6677E+10 bytes

Fixed Size 2113280 bytes

Variable Size 1.5821E+10 bytes

Database Buffers 838860800 bytes

Redo Buffers 14663680 bytes

Database mounted.

ORA-01157: cannot identify/lock data file 1 - see DBWR trace file

ORA-01110: data file 1: '/oracle/RT1/sapdata1/system_1/system.data1'

How should i overcome through this errors , Please advice me.

Accepted Solutions (0)

Answers (1)

Answers (1)

debasissahoo
Active Contributor
0 Kudos

Rahul,

please see if this can help

;

Note 24169 talks about ORA 1157. check if applicable.

Also Note 546006 gives the list of checks for Problems with Oracle due to operating system errors

Regards,

Debasis.

Edited by: Debasis Sahoo on Apr 13, 2009 8:48 PM

Former Member
0 Kudos

hi bro,

Thanx for the reply

i have the path & appereantly the file was missing. /system.data1'

'/oracle/RT1/sapdata1/system_1/system.data1'

how should i restore , please advice me & i have wholeonline + log backup every day.

I mean a whole online backup was happened today morning 7 am.. & i could manage to see /system.data1' file from that log & how should i restore that which is connected to Tivoli storage manager.

Edited by: Rahul on Apr 13, 2009 9:05 PM

debasissahoo
Active Contributor
0 Kudos

Hi Rahul,

Please check from the online/offline backup log whether this file was backed up or not,

you should restore using that backup which has backed up this file.

if you've a offline/online-consistent backup which has this file, then you can restore it and bring the database up. I would suggest you use brtools for restoring the database.

Regards,

Debasis.

Former Member
0 Kudos

Hi Debasis,

Thanks for the quick response,

well,,, I have edited my previous message that today morning a whole online backup was happened at 7am . The following are the details.

BR0051I BRBACKUP 7.00 (34)

BR0055I Start of database backup: beairmaf.anf 2009-04-13 07.00.21

BR0484I BRBACKUP log file: /oracle/RT1/sapbackup/beairmaf.anf

BR0280I BRBACKUP time stamp: 2009-04-13 07.00.27

BR0319I Control file copy created: /oracle/RT1/sapbackup/cntrlRT1.dbf 14401536

BR0101I Parameters

Name Value

oracle_sid RT1

oracle_home /oracle/RT1/102_64

oracle_profile /oracle/RT1/102_64/dbs/initRT1.ora

sapdata_home /oracle/RT1

sap_profile /oracle/RT1/102_64/dbs/initRT1_tiv_onl.sap

backup_mode ALL

backup_type online

backup_dev_type util_file

util_par_file /oracle/RT1/102_64/dbs/initRT1_tiv_onl.utl

system_info rt1adm/orart1 athomedev AIX 3 5 00C66D6E4C00

oracle_info RT1 10.2.0.4.0 8192 29851 206443409 athomedev UTF8 UTF8

sap_info 700 SAPSR3 0002LK0003RT10011M13626969060013NetWeaver_ORA

make_info rs6000_64 OCI_102 May 31 2008

command_line brbackup -u / -jid ALLOG20080609070000 -c force -t online -m all -p initRT1_tiv_onl.sap -a -c force -p initRT1_tiv_onl.sap -cds

BR0116I ARCHIVE LOG LIST before backup for database instance RT1

SYSTEM ONLINE SYSTEM+ /oracle/RT1/sapdata1/system_1/system.data1 880812032 1 3080195 NOLINK FILE 10485760000 20971520 8192*

request to please provide me some quick steps & i am trying from my end as well.

Former Member
0 Kudos

refered to sap note

Note 491160 - Restore scenarios for lost files of oracle databases

Once the database is shut down

restore the datafile from a backup SQL>startup mount

SQL> 'recover database'

or SQL>'recover datafile '<path/filename>';

can i use this command,

recover database -b beahedmy.anf '/oracle/RT1/sapdata1/system_1/system.data1';

debasissahoo
Active Contributor
0 Kudos

Yes, rahul. you can use the command as described in the note. it should work.

Regards,

Debasis.