dumpoplog

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 ]

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.

You must have Super User privileges.

Specifying the clan, site, and family

Default

Clan: First clan replicated at this site. If there is more than one dbset connection registered on this host, –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 you do not specify a format, 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 not valid.)

Examples:

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

–reverse

Reverse the order of the list of oplog entries.