Any chance to open a database which needs recovery in read-only mode? My attempts with dbeng -r lead to the error message that the database needs recovery and dbeng refuses to start. Recovery is no option as the database has a checksum problem in the checkpoint log :-(

asked 15 Jun, 05:05

Martin's gravatar image

Martin
8.8k123160248
accept rate: 14%

Recovery is no option

So if the current database file is damaged, can't you go back to the last full backup and the current transaction log (and possibly intermediate TLs), in case those files are not damaged?

(15 Jun, 05:20) Volker Barth
Replies hidden

yes that is our last option, before that I would liked to run a dbvalid -s to check all checksums and see how much damaged has occurred

(15 Jun, 06:01) Martin

AFAIK read-only mode requires a valid database file and will fail in your case. (I assume dbeng -f against a copy of the database file will fail, as well.)

If the current database file is damaged but the current TL is OK, and there is a clear backup path, I would

  1. use my recovery plan to bring the system up again to the point of the last committed transaction,
  2. and then might take the time to find out why the current database file has been damaged afterwards.

Of course I do not know your requirements and recovery times so treat this as just my 2 cents.

(In case you except the server hardware to be questionable, well, then that would require a different doing...)

(15 Jun, 06:44) Volker Barth
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×23
×9

question asked: 15 Jun, 05:05

question was seen: 107 times

last updated: 15 Jun, 06:46