Home > Default > Is it possible to make db_recover more verbose?

Is it possible to make db_recover more verbose?

October 11Hits:0
Advertisement
If you use db_recover there seems to be never anything on the standard output. I'd like to get an info from db_recover what it has done (if anything).
db_recover -v results in nothing, if done again results in
Finding last valid log LSN: file: 1 offset 28
But I have no idea what this means.

Answers

Thanks for the additional explanation,
Normal recovery examines the contents of your environment's
log files, and uses this information to ensure that your
database files are consistent relative to the information
contained in the log files. This ensures that the changes
from each committed transaction appear in the database, and
that no changes from an unfinished (or aborted) transaction do.
Therefore if you are not using transactions/logging there is
no recovery. Hence, db_recover is not the right choice
in this case. The verbose flag is not showing anything, as
there is nothing to do. The recovery process will create a new log,
and that is what is being read on your 2nd pass.
The documentation in the Reference Guide on Berkeley DB recovery at:
http://www.oracle.com/technology/documentation/berkeley-db/db/ref/transapp/reclimit.html
details how Berkeley DB recovery is based on write-ahead logging.
From that documentation:
This means that when a change is made to a database page, a
description of the change is written into a log file. This
description in the log file is guaranteed to be written to
stable storage before the database pages that were changed
are written to stable storage. This is the fundamental feature
of the logging system that makes durability and rollback work.
If the application or system crashes, the log is reviewed during
recovery. Any database changes described in the log that were
part of committed transactions and that were never written to
the actual database itself are written to the database as part of recovery.
Any database changes described in the log that were never committed
and that were written to the actual database itself
are backed-out of the database as part of recovery. This design
allows the database to be written lazily, and only blocks from
the log file have to be forced to disk as part of transaction commit.
Thanks again,
Sandra

Read other 10 answers

Tags:

Related Articles

  • Is it possible to make db_recover more verbose?October 11

    If you use db_recover there seems to be never anything on the standard output. I'd like to get an info from db_recover what it has done (if anything). db_recover -v results in nothing, if done again results in Finding last valid log LSN: file: 1 offs

  • WLST, how do I suppress unwanted stack traces and make WLST less verbose?October 11

    Hi everyone, I've just started out with WLST but have ended up somewhat confused. My script works as intended but is very verbose. Suppose I want to log in: try:      connect(user, "wrong_password", url) except WLSTException, err:      print str

  • Is it possible to make db_verify more verbose?October 11

    db_verify has no verbose flag -v yet. If there are errors these are printed. I'd like db_verify to output something like "DB xy verified without errors" if all was fine. Thanks, gbkkaHi gbkka, Why would you add an unnecessary option/success mess

  • Make pacman more verbose?October 11

    Is there a way to make pacman more verbose in showing what packages are being installed or updated? For example, when doing a system update, you get a long list of packages that will be downloaded and installed. Most of them are packages you already

  • SSRS error - verbose modeOctober 11

    We have a SCCM and use SQL 2012 server for reporting. Recently we have started experiencing a problem where we can browse to the reports and once we do run the reports, it tries to run forever and eventually halts with the following error An error oc

  • HELP! MacMini starting up in Verbose ModeOctober 11

    Hi, My Mac Mini seems to be sarting up in Verbose Mode (black background with white type). Any ideas why this is happening? and how do I stop it? I've run Disk First Aid off the installion CD and its fixed all the problems that it found, but it still

  • Suddenly, Macbook doesn't boot up in single user mode or verbose modeOctober 11

    Hello, I use the single-user boot up quite often to check permissions and do a fsck after my mac crashes. I do this by pressing Apple(Command)-S at startup or cmd-V for the verbose mode. I do this all the time. But now my Mac won't take it anymore. I

  • PowerPC G5 will not boot (from CD, single-user, verbose...) - is it dead?October 11

    I had posted this in the OSX forum but had a suggestion to post here as well - any suggestions would be greatly appreciated! My PowerPC G5 (10.4.11) will not boot. It gets to the grey Apple screen, and then freezes there, no progress dial, and the fa

  • IMac won't boot up. Stuck in "verbose mode" ??October 11

    I've had this problem on and off for a few weeks now. I either restart my iMac after installing some new software-or for other reason- and my computer won't boot up. Sometimes it will stay at the white screen with the grey apple for hours if I leave

  • Freezing at startup - weird message when starting up in verbose modeOctober 11

    My macbook pro, only about 2 months old, freezes a lot while its starting up. i have to keep turning it off and on for it to work. It gets stuck at the grey screen with the apple and the loading icon. I decided to start up in verbose mode and maybe i

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.535 s.