Arun wrote:So the tablespace contains multiple data files and table data can be across the data files.
yes.. i get file_id for three datafiles.. How to find the exact one?
Arun wrote:It clears that do not have backup. Can you check what object it is?
Thanks a lot for all the correct answers... It all solved my question.. Before marking it answered i have few more quiestions.. Appreciate if you could answer..
I am experimenting few things. I have found the datafile and opened the file with vi editor. I found the record 'xx' and updated with yy on vi editor and saved it.
As expected it shows the block corruption while i query for that data. But now i am trying to recover using rman.
CISADM@MX210POC>elect * from test where owner_flg='XX';
select * from test where owner_flg='XX'
ERROR at line 1:
ORA-01578: ORACLE data block corrupted (file # 8, block # 869)
ORA-01110: data file 8: '/mwm_oradata_01/MX210POC/cists03.dbf'
I do not have any backups but the database is in archivelog mode. Is there anyway i can recover it? rman it shows the below error.
RMAN> blockrecover datafile 8 block 869;
Starting recover at 05-FEB-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=333 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=412 device type=DISK
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-03002: failure of recover command at 02/05/2013 02:29:44
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 8 found to restore
Arun wrote:Easy, if you have all the archive logfiles. In the Backup And Recovery Users Guide, look for "Re-Creating Data Files When Backups Are Unavailable".
No backup.. But i have a DR setup for this database. But anyway its a test table. I need to know if i can recover this table without using DR or any backup.
I have all the archivelogs i need to recover this record. is there anyway i can use this logfiles?