Databases Reference
In-Depth Information
SQL> SELECT :rman_error rman_error, :rman_msg rman_msg, :ora_error ora_error,
:wait_for_input wait_for_input
FROM dual;
Wait
RMAN ORA for
Error RMAN_MSG Error input
------ ------------------------------------------------------------ ------ ------
4004 RMAN-04004: error from recovery catalog database: ORA-12170: 0 0
TNS:Connect timeout occurred
The package extracted the error RMAN-04004 from the top of the error stack. There was no
separate ORA-
nnnnn
error on the error stack (it was included in the RMAN-04004 error message).
RMAN is not yet ready to receive the next command (
WAIT_FOR_INPUT=0
). Let's receive another
message.
SQL> EXEC :rv:=site_sys.rman_pipe_if.receive(:pipe_arg, :msg, :wait_for_input, -
> :rman_error, :rman_msg, :ora_error, :ora_msg)
PL/SQL procedure successfully completed.
SQL> SELECT :rv rv, :msg msg FROM dual;
RV MSG
--- --------------------------------------------------------------------------------
1 RMAN-00572: waiting for dbms_pipe input
Again, RMAN is ready to receive a command. Next, we send a
BACKUP
command, even
though RMAN failed to connect to the catalog.
SQL> BEGIN
:cmd:='run {
backup format "DB-%d-%u.bkp" tablespace appdata;
}';
-- send a message
:rv:=site_sys.rman_pipe_if.send(:pipe_arg, :cmd);
END;
/
PL/SQL procedure successfully completed.
SQL> PRINT rv
RV
---
0
