Validate an Spfile on AWS RDS
Table of Contents
|
Introduction
On AWS RDS, there is no access to the server and no access to RMAN. AWS RDS does not use RMAN to backup the database. However, validations can still run using the RMAN validate commands against the database using an AWS package called rdsadmin_rman_util
Parameters to rdsamin_rman_util validate spfile
Parameter Name | Data Type | Valid Values | Default | Required | Description |
---|---|---|---|---|---|
p_validation_type | varchar2 | 'PHYSICAL', 'PHYSICAL+LOGICAL' | 'PHYSICAL' | Optional | Specify 'PHYSICAL' to check for physical corruption. An example of physical corruption is a block with a mismatch in the header and footer. Specify 'PHYSICAL+LOGICAL' to check for logical inconsistencies in addition to physical corruption. An example of logical corruption is a corrupt block. |
p_rman_to_dbms_output | boolean | TRUE, FALSE | FALSE | Optional | When TRUE, the RMAN output is sent to the DBMS_OUTPUT package in addition to a file in the BDUMP directory. When using SQL*Plus, execute SET SERVEROUTPUT ON to see the output. When FALSE, the RMAN output is only sent to a file in the BDUMP directory. |
Validate an spfile
-- -- Validate an spfile on AWS RDS -- -- On AWS RDS you do not have access to the server or to a proper SYSDBA account. -- As a result you are defendant on lots of AWS RDS packages. -- Or in some instances, you need to find new ways of achieving the same thing -- exec rdsadmin.rdsadmin_rman_util.validate_spfile /