status backup
View the detailed state on the scheduled backup jobs in the specified shards.
Syntax
status backup [-start_time t1] [-end_time t2]
[-catpwd password]
[-shard shard_list]
[-READ_LOG rman_log]
[-OUTPUT_LOG output_log]
[-DELETE_LOG]
[-DELETE_LOG_ONLY]
Options
Table 2-105 GDSCTL status backup Options
| Option | Description |
|---|---|
-start_time time1 |
The command lists run details of the automated backup jobs that started on or after this time. It must be specified in the format YYYY-MM-DD HH:MM:SS[.FFF] where .FFF is a fraction of a second in the precision of milliseconds. |
-end_timetime2 |
If specified, only backups usable to restore database control files to a specific restore point are listed.. |
-catpwd
password |
Password for user GSMCATUSER. Prompted if not specified. This password only needs to be specified once for this command in an entire GDSCTL session. |
-shard shard_list |
shard_list specifies
a comma separated list of shard identifiers. They can be shard
space, shard group or shard names. The default is all
shards.
|
-delete_log |
Delete the specified RMAN output file on the shard server. |
-delete_log_only |
Delete the specified RMAN output file on the shard server without reading it. |
-output_log |
The specified file must not exist. If the file is not specified with an absolute path, it will be created in the current working directory. The RMAN log will be saved into this file without being displayed in the console. |
-read_log |
Read the specified RMAN log from the specified shard and display
it in the console or save it into the file specified with the
option |
Examples
The following example shows the job state and all job run details from the sharded
database (SDB) catalog and the primary shard rdbmsb_cdb2_pdb1.
GDSCTL> status backup -catpwd -shard catalog,rdbmsb_cdb2_pdb1;
"GSMCATUSER" password:***
Retrieving scheduler backup job status for database "rdbms" ...
Jobs:
Incremental Level 0 backup job is enabled
Job schedule start time: 2020-07-27 00:00:00.000 -0400
Job repeat interval: freq=daily;interval=1
Incremental Level 1 backup job is enabled
Job schedule start time: 2020-07-27 00:00:00.000 -0400
Job repeat interval: freq=minutely;interval=60
Global restore point create job is enabled
Job schedule start time: 2020-07-27 23:59:55.960 -0400
Job repeat interval: freq=hourly
Run Details:
Incremental Level 1 backup job status: SUCCEEDED
Job run actual start time: 2020-07-26 14:00:00.177 -0400
Job run slave process ID: 9023
Incremental Level 1 backup job status: SUCCEEDED
Job run actual start time: 2020-07-26 22:00:01.305 -0400
Job run slave process ID: 59526
…
Global restore point create job status: SUCCEEDED
Job run actual start time: 2020-07-27 15:28:37.603 -0400
Job run slave process ID: 44227
…
Global restore point create job status: SUCCEEDED
Job run actual start time: 2020-07-27 17:28:38.251 -0400
Job run slave process ID: 57611
Retrieving scheduler backup job status for database "rdbmsb_cdb2_pdb1" ...
Jobs:
Incremental Level 0 backup job is enabled
Job schedule start time: 2020-07-28 00:00:00.000 -0400
Job repeat interval: freq=daily;interval=1
Incremental Level 1 backup job is enabled
Job schedule start time: 2020-07-28 00:00:00.000 -0400
Job repeat interval: freq=minutely;interval=60
Run Details:
Incremental Level 1 backup job status: SUCCEEDED
Job run actual start time: 2020-07-26 14:00:00.485 -0400
Job run slave process ID: 9056
…
Incremental Level 1 backup job status: SUCCEEDED
Job run actual start time: 2020-07-27 14:33:42.702 -0400
Job run slave process ID: 9056
Incremental Level 0 backup job status: SUCCEEDED
Job run actual start time: 2020-07-27 00:00:01.469 -0400
Job run slave process ID: 75176