31 lines
708 B
MySQL
31 lines
708 B
MySQL
|
@@header
|
||
|
|
|
||
|
|
/*
|
||
|
|
*
|
||
|
|
* Author : Vishal Gupta
|
||
|
|
* Purpose : Display RMAN configuration, ie. non-default settings
|
||
|
|
* Parameters :
|
||
|
|
*
|
||
|
|
* Revision History:
|
||
|
|
* ===================
|
||
|
|
* Date Author Description
|
||
|
|
* --------- ------------ -----------------------------------------
|
||
|
|
* 07-Feb-14 Vishal Gupta Created
|
||
|
|
*
|
||
|
|
*/
|
||
|
|
|
||
|
|
|
||
|
|
PROMPT ****************************************
|
||
|
|
PROMPT * RMAN Non-Default Configuration
|
||
|
|
PROMPT ****************************************
|
||
|
|
|
||
|
|
COLUMN conf# FORMAT 99999
|
||
|
|
COLUMN name FORMAT a45
|
||
|
|
COLUMN value FORMAT a80
|
||
|
|
|
||
|
|
SELECT *
|
||
|
|
FROM v$rman_configuration
|
||
|
|
;
|
||
|
|
|
||
|
|
|
||
|
|
@@footer
|