This procedure does not return until the underlying RMAN command completes executing (either successfully, or returning an error). So, if it completed in less than a second, it sounds like it didn't run at all. When executing PL/SQL procedures in SQLPlus, make sure server output is enabled (e.g. "set serverout on size 10000" ), and make sure a PL/SQL block is always followed by a slash character , which instructs SQLPlus to execute the block (just a semicolon isn't sufficient for PL/SQL).
You can also use the AWS console or the RDS_FILE_UTIL package to list and view RMAN output files in the BDUMP directory to see if the job completed with an error. If no file was generated, then the procedure probably wasn't executed.
SELECT * FROM table(rdsadmin.rds_file_util.listdir('BDUMP')) where filename like '%rman%' order by mtime;
SELECT text FROM table(rdsadmin.rds_file_util.read_text_file('BDUMP','rds-rman-validate-nnn.txt'));
Hope that helps. Thanks!
Thanks for your reply with lots of valuable information.
We are dealing with a vendor that support our AWS services. After discussing with the support staff a few times, I suddenly can backup my DB today. The vendor didn't mention they fixed anything but I believe there must be something.
But the information that you provided really gives me enough information to diagnose the backup issues. I will mark it as "Answered".
RDS DB Instance Backupasked 2 months ago
Single DB backup/restore for RDSAccepted Answerasked 5 years ago
Unable to backup AWS RDS Oracle DB using rdsadmin.rdsadmin_rman_utilasked 2 years ago
Restoring an rdsadmin_rman_util tablespace backup for OracleAccepted Answerasked 3 years ago
S3 Integration Oracle RDS and DMSAccepted Answerasked 2 years ago
Can I use RMAN Backup for RDS restore ?Accepted Answerasked 2 years ago
Using AWS backup service for DB backupasked 4 months ago
DB Instance restarting due to " MySQL induced log backup issues"asked 8 months ago
AWS Backup of RDS managed Oracle or MS-SQL databaseasked 5 months ago
Oracle DB Migration - Azure to AWS RDSAccepted Answerasked 5 months ago