cancel
Showing results for 
Search instead for 
Did you mean: 

DB02 datafile error

Former Member
0 Kudos

Hi,

Due to some issues, I have to rename 2 datafile.

The rename was successful, but when I check DB02, it shows junk characters in one of the datafile.

I checked alert log, but could not see no error in the same.

Also, at file system level, it looks ok.

Kindly look into the same and guide me on the same.

Regards,

Harikrishna

Accepted Solutions (0)

Answers (3)

Answers (3)

Reagan
Advisor
Advisor
0 Kudos

Hello

I don't think the above links to rename the datafile can do any help now as he has already renamed the datafiles.

Secondly the problem is with the strange characters in the datafile names.

I suggest you to query the datafiles from the SQL level and see whether those characters appear there.

If not, also consider what Andrea suggested you. You need to refresh the DB02 to get the data updated.

Regards

RB

Former Member
0 Kudos

Dear Reagan

Can you please check the datafile name by using BRtools.

Thanks

Mahipal

Former Member
0 Kudos

Hi Reagan,

I have seen from the SQL prompt using display dba_data_files, I could not see the junk characters, but I think there was some blank space (lot space vacant between that datafile and the other).

I have refreshed DB02 many times, but still the same.

Hi Mahipal,

I checked in brtools, I could not see any junk characters or any blank space (normal like any other datafile).

Regards,

Harikrishna

Former Member
0 Kudos

Hi Harikrishna,

Maybe you can try to rename again that datafile and to ensure no extra characters behind.

Regards,

Yohanes

AtulKumarJain
Active Contributor
0 Kudos
Former Member
0 Kudos

Hi Harikrishna

even if it's for ora, did you do your checks as stated in this http://scn.sap.com/thread/3163885

?

meanwhile i seek for something more accurate

a

Former Member
0 Kudos

Hi Andrea,

Hope you have gone through the screen shot.

I have seen the link, but no help.

Actually, that file which shows junk characters is the original file (the other of which got repeated by the same name, and I have renamed it).

Regards,

Harikrishna