Use the show activate command to view the status of activation activity on a source system. Concurrent activations for different datasources are displayed in the order that they started.
The command displays:
The following are possible notice messages:
Message | Reason |
---|---|
No current activation process. Activation is already finished. Use the show config command to view the active configuration. | The activation is finished. |
No current activation process. Activation is already finished. | The activate config command was never issued |
No tables to activate. |
This message is generated when an active configuration is reactivated without being changed first. The show activate command generates output only when you activate the following:
|
The show activate command remains in control of the sp_ctrl prompt until the entire activation is finished. To issue other commands in sp_ctrl while activation is in process, open another session of sp_ctrl.
Supported targets: | All |
Authorization level: | Viewer (3) |
Issued for: | source system |
Related commands: | activate config, show config, view config |
Basic command | Command options | Remote options |
---|---|---|
show activate |
[for datasource] |
[ on host | on host:portnumber | on login/password@host | on login/password@host:portnumber ] |
Component | Description |
---|---|
show activate | Without options, shows all activation activity. |
for datasource |
Use this option to show activation for a specific data source when replication is active for multiple databases on a system. The default show activate behavior without this option is to show the activation processes for all active configurations. datasource is expressed as o.SID, where SID is an ORACLE_SID. Example: sp_ctrl(sysA)> show activate for o.oraA |
These options enable you to issue the command on a remote machine and to script commands that include a login name, password, port number, or combination of those items.
Option | Description |
---|---|
on host |
Execute the command on a remote system (one other than the one where the current sp_ctrl session is running). You are prompted for login credentials for the remote system. If used, must be the last component of the command syntax. Example: sp_ctrl(sysB)>status on SysA |
on host:portnumber |
Execute the command on a remote system when a remote login and port number must be provided. If used, must be the last component of the command syntax. Example: sp_ctrl(sysB)>status on SysA:8304 |
on login/password@host |
Execute the command on a remote system when a remote login, password, and host name must be provided. If used, must be the last component of the command syntax. Example: sp_ctrl(sysB)>status on john/spot5489@SysA |
on login/password@host:portnumber |
Execute the command on a remote system when a remote login, password, host name, and port number must be provided. If used, must be the last component of the command syntax. Example: sp_ctrl(sysB)>status on john/spot5489@SysA:8304 |
© 2022 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy