Oracle Corrupted Blocks .

[Former Member]

Hi ,

We using R/3 4.7 with Oracle 9.2 , Now i want to check any corrupted blocks are attected in our server , Can you tell me how can i check . Because i want to check the corrupted blocks in database is in online . Shall i use DBVERIFY .

Regards

Palani Selvan

[Former Member · Accepted solution]

Hi ,

Thanks noted .

Kindly tell answer for another one of my question .

Kindly tell me the step by step procedure for Database point-in-time recovery .

advice me what are the inputs i have to giver for Database point-in-time recovery in brtools.

Regards

PalaniSelvan

[Former Member · Accepted solution]

Palani,

Only 1 question per 1 thread. Please read Rules of Engagement

.

Anyway check below link to do Database point-in-time recovery in brtools

http://help.sap.com/erp2005_ehp_04/helpdata/DE/72/96d34c435c3c4ca5894749ef1435ac/frameset.htm

Thanks

Sushil

[markus_doehr2 · Accepted solution]

> Kindly tell me the step by step procedure for Database point-in-time recovery .

> advice me what are the inputs i have to giver for Database point-in-time recovery in brtools.

I suggest you take a class on Oracle database administration. Such a critical thing as recovers should not be done based on forum discussions if you have no clue of the database and how it works. No offense.

Markus

[Former Member]

This message was moderated.

[Former Member]

Palani,

Yes You can use DBVERIFY. You can run it from DB13-->Verify Database

Check below note for details

Note 23345 - Consistency check of ORACLE database

SAP Note 354293 - DBVerify reports corrupt block in freespace area

Note 365481 - Block corruptions

Note 923919 - Advanced Oracle block checking features

Just for your information, in BW system If you get warning like "DBV-00200: Block, dba 97446680, already marked corrupted", it occures because secondary indexes of InfoCube fact

tables are set up in mode NOLOGGING as a standard.

See below notes for more information

Note 442763 - Avoid NOLOGGING during the index structure (Oracle

Note 547464 - Nologging Option when creating indexes

Note 849485 - Reconstruction of the NOLOGGING indexes after recovery

Hope it help

Thanks,

Sushil

[Former Member]

Hi,

Use dbverify See the link for more detail

Thnx

SurendraJain

[Former Member]

Hi,

Additionally, you may also check for ORA-600 errors in the oracle alert-log.

regards,

Kiran