Similarly to show cluster, show instance displays configuration, status, and log information about an instance.
To show configuration information, including the name of the host node, primary and secondary network information, and the path to the log file, enter:
show instance instance_name config
To display status information, enter:
show instance instance_name status
This command displays status information for the named instance:
Up
Down
Undefined
Invalid
Start
Init
Quiesce
To show all log information, enter:
show instance instance_name log
You can limit the output by specifying:
The error severity level, for example:
show instance instance_name log minseverity 5
A date range for log entries:
show instance instance_name log startdate 03:31:08 enddate 04:30:08
A number of lines to display from the error log, working backwards from the most recent:
show instance instance_name log last 25