No parent backup or copy of datafile 1 found
RMAN> BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG WEEKLY DATABASE Ĭhannel ORA_DISK_1: SID=36 device type=DISK RECOVER COPY OF DATABASE WITH TAG WEEKLY.BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG WEEKLY DATABASE.To identify the keys that are missing from the index we ran the following queries.įollowing query will give the keys which are there in the table but not in the index. > select name from obj$ where obj# = 155099 (14): XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXĬlearly the delete staement was not able to identify a key which was there in the table but not in the index.Next find the offending index using the object id reported in the trace file I had seen the following issue in the trace files while it was core dumping every few secs.The offending statement was a delete statement with where clause.On examining the trace files it looked like an issue of key mismatch.Note that this is key mismatch issue not a corrupt index issue so all the tools used for finding the corrupt blocks will not return anything.eg-database Validate,dbverify and analyze on index will come clean since the logical structure of the index is valid.To identify the key mismatch issue proceed as follwing. Piece handle=/u01/app/oracle/flash_recovery_area/MIGRATE/autobackup/2013_02_07/o1_mf_s_806753705_8k7r8xln_.bkp comment=NONEįinished Control File and SPFILE Autobackup at 07-FEB-13 Starting Control File and SPFILE Autobackup at 07-FEB-13
Input datafile file number=00002 name=+DATA/migrate/datafile/sysaux.259.793193181 Using target database control file instead of recovery catalogĬhannel ORA_DISK_1: SID=63 device type=DISKĬhannel ORA_DISK_1: starting datafile copy I used the following option (allow_root) this staging_area]$ nohup dbfs_client -o allow_other,direct_io /mnt/dbfs backup as copy datafile 2 format '/mnt/dbfs/staging_area/file2.bkp' I had mounted the FS again with the allow_root option and it worked !!!!!!!! This option requires setting the user_allow_other parameter in the /etc/nfconfiguration file. allow_other allows other users to access the filesystem.allow_root allows the root user to access the filesystem.
0 kommentar(er)
