WHAT IF I AM USING "_ALLOW_RESETLOGS_CORRUPTION"

It’s a Tricky question for Everyone , that has no technically correct answer . Question is ..?

Oracle suggest to rebuild your database after using parameter "_ALLOW_RESETLOGS_CORRUPTION" . Is it mandatory to do that when there is no error reported in alert log or nothing looks suspicious even plying around database .

Well , I thought to go on my way .. its long back my application team is using same GHOST ( Oracle View) Database . But still , I find it like a gentle man without any issue .

So I conclude here : You may feel free to use parameter _ALLOW_RESETLOGS_CORRUPTION , if left with no option .

Call with Metalink on same

August 26, 2009 11:26:05 PM GMT-08:00

Hi,

Thanks for Update .

Regards

Vivek

Oracle Support - August 26, 2009 7:59:07 PM GMT-08:00

(Update for record id(s): 374274329)

UPDATE

======

Hi,

The technical reason behind the suggestion is that , when we set the parameter for that matter any unsupported parameters we are asking the code (oracle code) to behave in a different manner diverging from the actual access path.

Hence when this happens the information in the data dictionary would not be updated properly and at a future point in time there could be some issues raised because of this and at that time we may land up in a situation where it cannot be recovered.

Hope this is helpful.

August 26, 2009 8:25:20 AM GMT-08:00

Hi,

Thanks for your answers . Shall I conclude it like using unsupported parameter Database may work normally but on users own Risk as Oracle won't support it .

As still I don't have any technical reason to rebuild my database .

Regards

Oracle Support - August 24, 2009 6:38:36 PM GMT-08:00

(Update for record id(s): 373995595)

UPDATE

======

Hi Vivek,

There is no way to determine the inconsistencies by querying any data dictionary views .

Even the health check on the data dictionary does not reveal the underlying the inconsistencies.

Hence you can inform the user that , the moment the unsupported methods are used , the database is no longer a supported one and hence this needs to be rebuild so that in future there are any errors they can be addressed.

Regards

August 24, 2009 6:30:16 AM GMT-08:00

Hi,

Thanks for response . As you commented "development team has strongly suggested that in case the parameters are used the data dictionary would not be consistent and not all the dependencies can be figured out manually."

-> Is there a way , I can figure out such inconsistency in database or even any way to produce error or warning .

Please advise me to explore and find out a single chunk of data or dictionary which may have specious status and convince an user to rebuild database .

Thanks in Advance .

Vivek

Oracle Support - August 24, 2009 1:44:38 AM GMT-08:00

(Update for record id(s): 373834603)

UPDATE

======

Hi,

Thank you for using My Oracle Support.

I noticed that you have logged this SR without uploading an OCM configuration. We strongly encourage you to provide the latest configuration. The information to create configuration can be accessed using the following hyperlink:

https://metalink.oracle.com/CSP/ui/flash.html#tab=Collector(page=Collector&id=fx9hk8fu())

Uploading configuration information can help users achieve problem avoidance and faster problem resolution. Associating configurations to service requests provides Oracle with accurate system configuration details that can help accelerate the problem resolution time.

We are currently reviewing/researching the situation and will update the Service Request (SR) or call you as soon as we have relevant information. Thank you for your patience.

Regards

Oracle Support - August 24, 2009 1:44:38 AM GMT-08:00

(Update for record id(s): 373834661)

QUESTION

========

1) In general oracle suggest to rebuild your database after using parameter "_ALLOW_RESETLOGS_CORRUPTION" . Is it mandatory to do that when there is no error reported in alert log or nothing looks suspicious even plying around database .

2) If I don't plan to rebuild DB as I don't see any reason , Can you please give me reason to do so .

3)Having Fuzzy column "Yes" , is an issue ?

ANSWER

======

Hi,

In general oracle suggests customers to rebuild the database in case any unsupported parameters are used because , development team has strongly suggested that in case the parameters are used the data dictionary would not be consistent and not all the dependencies can be figured out manually.

Hence even though there are no issues reported in the alert.log after the use of the unsupported parameters , the database needs to be rebuild using the export/import method.

Also when the database is up and running the status of the fuzzy column would always be YES. Hence we should not consider the o/p when the database is up and running.

Let me know in case you have any further queries.

Regards

August 23, 2009 9:51:08 PM GMT-08:00

Hi ,

While restoring a database from Prod to UAT, I found database backup was not consistent means performed hot backup happened when datafiles were not in begin backup mode . I wanted to deal with same backup set and started recovering database with resetlogs option . After getting tired with applying arch log , I used option "_ALLOW_RESETLOGS_CORRUPTION = TRUE" .

RESETLOGS is being done without consistancy checks. This may result

in a corrupted database. The database should be recreated. Message from alert log . After this no consistancy checks and database was opned . I checked the all files status lokked fine .

SQL> select * from v$recover_file;

no rows selected

I need your expert advice on ,

1) In genral oracle suggest to rebuild your database after using parameter "_ALLOW_RESETLOGS_CORRUPTION" . Is it mandotary to do that when there is no error reported in alert log or nothing looks suspecious even plying around database .

2) If i dont plan to rebuild DB as i dont see any reson , Can you please give me reason to do so .

3)Having Fuzzy column "Yes" , is an issue ?

FILE# STATUS FUZ

---------- ------- ---

1 ONLINE YES

2 ONLINE YES

3 ONLINE YES

4 ONLINE YES

5 ONLINE YES

6 ONLINE YES

7 ONLINE YES

8 ONLINE YES

9 ONLINE YES

10 ONLINE YES

11 ONLINE YES

Appreciate your suggestion on my queries

-------------------------------------------------------