Administration Tools - ooqueryset

Printer-friendly version
Displays information about one or more full backups, along with any incremental and subincremental backups based on them.
[-time dateTime | ‑set setName]
-time dateTime
Time of the full backup whose information is to be displayed. You can omit dateTime value to specify the current time, which displays information about the most recent full backup. If no full backup corresponds exactly to the specified time, ooqueryset selects the latest full backup that was started prior to the specified time.
You specify dateTime as you would for oorestore—as an integer YYYYMMDDHHmm containing up to 12 digits representing component times. For example, 2001051502 specifies May 15, 2001 at 2:00 A.M.
If you specify this option, you may not also specify the -set option.
-set setName
Name of the backup set whose information is to be displayed.
If you specify this option, you may not also specify the -time option.
Suppresses all normal program output.
Nonconcurrent mode. Use this option if no lock server is running or to bypass a running lock server.
Warning: Corruption can occur if concurrent access to the federated database is attempted while any process is using this mode.
Suppresses the copyright notice and program title banner. Useful when invoking the tool from another tool or product.
Prints the tool syntax and definition to the screen.
Path to the boot file of the federated database whose backup set is to be queried. You can omit this argument if you set the OO_FD_BOOT environment variable to the correct path. (HA) You can specify the boot file of any autonomous partition.
To display information about basic backups (backups taken with options such as -full, -incremental, -subincremental, or -destination), you specify the the -time option. This causes ooqueryset to display information for the most recent full backup prior to the specified time, along with any incremental backups based on it.
To display information about customized backups (backups taken with the options -set, -backup, -device, and -volume), you specify the -set option. This causes ooqueryset to display information for the backups in the specified backup set.
If you omit both the -set and -time options, ooqueryset displays information about the backups in all backup sets, including any backup sets you created explicitly for customizable backups and any backup sets created implicitly for basic backups.
For each backup listed, ooqueryset displays the backup event name, the level, the backup volume capacity, the time stamp, the volume name prefix, and the path to the disk directory where the backup files were written.
The ooqueryset command displays information from the federated database’s backup diary. Restoring a federated database to an earlier backup reverts the backup diary to an earlier version. Consequently, the backups listed by ooqueryset for a restored federated database may be a subset of the backups that actually exist.
See also

Tuesday, October 30, 2012