on 04-13-2009 3:52 PM
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
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.
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';
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.