dumpoplog


Lists the contents of a replica’s operation log

Applicability

Product
Command type
MultiSite
multiutil subcommand

Platform
UNIX
Windows

Synopsis

dumpoplog [ –cl·an clan-name ] [ –site site-name ] –fam·ily family-name
–u·ser username [ –p·assword ] password
[ –l·ong | –s·hort ] [ –at replica ]
[ oplog-ID... | [ –from oplog-ID ] [ –to oplog-ID ] ]
[ –since date-time ] [ –reverse ]

Description

Use dumpoplog to list information in a replica’s operation log (oplog). The oplog tracks all database transactions, including record changes and schema modifications. Each oplog entry has an oplog ID.

Restrictions

You must have Super User privileges.

Options and Arguments

Specifying the Clan, Site, and Family

Default
Clan: First clan replicated at this site. If there is more than one clan at the site, –clan is required.
Site: Current site. If there is more than one site on this host, –site is required.
Family: No default; you must specify a family.

–cl·an clan-name
Name of the replica’s clan.

–site site-name
Name of the replica’s site.

–fam·ily family-name
User database family: Database name given to the user database when it was created.

Schema repository family: The family name is MASTR.

Specifying a User Name and Password

Default
You must specify a user name and password.

–u·ser user
Name of a user with Super User privileges.

–p·assword password
Password associated with the specified user.

Specifying the Information to Display

Default
If no format is specified, the –short format is used. All oplog entries are listed.

–l·ong | –s·hort
With –long, displays all columns of the oplog, including information about the schema revision that applies to the packet data. With –short, displays each database operation that took place.

–at replica
Lists the oplog entries that originated from the sites you specify.

oplog-ID...
Lists the oplog entries you specify.

–from oplog-ID
Lists a range of oplog entries starting with oplog-ID and ending with the latest one or the one specified with –to. Specify oplog IDs as integers.

–to oplog-ID
Lists a range of oplog entries ending with oplog-ID and starting with 1 or the one specified with –from. Specify oplog IDs as integers.

–since date-time
Lists all oplog entries after date-time. The date-time argument can have any of the following formats:

date.time | date | time | now
where:

date
:=
day-of-week | long-date
time
:=
h[h]:m[m][:s[s]] [UTC [ [ + | - ]h[h][:m[m] ] ] ]
day-of-week
:=
today |yesterday |Sunday | ... |Saturday |Sun | ... |Sat
long-date
:=
d[d]month[[yy]yy]
month
:=
January |... |December |Jan |... |Dec

Specify the time in 24-hour format, relative to the local time zone. If you omit the time, the default value is 00:00:00. If you omit the date, the default value is today. If you omit the century, year, or a specific date, the most recent one is used. Specify UTC if you want the time to be resolved to the same moment in time regardless of time zone. Use the plus (+) or minus (-) operator to specify a positive or negative offset to the UTC time. If you specify UTC without hour or minute offsets, the default setting is Greenwich Mean Time (GMT). (Dates before January 1, 1970 Universal Coordinated Time (UTC) are invalid.)

Examples:

22-November-2002
sunday
yesterday.16:00
8-jun
13:00
today
9-Aug.10:00UTC

–reverse
Reverse the order of the list of oplog entries.

Examples

In these examples, the lines are broken for readability. You must enter each command on a single physical line.

See Also

lsepoch, scruboplog