Database Backup and Recovery (MOSC)

MOSC Banner

Standby PDB backup report

edited Dec 12, 2025 9:15AM in Database Backup and Recovery (MOSC) 5 commentsAnswered

Hello,

I'm running 2 X8-2 ODA's running oracle 19.17, RAC where 1 ODA is the primary and the other ODA is the standby. Everything works great from a DG standpoint. The rman backup process is to backup each PDB separately so if we need to restore 1 PDB, we don't have to restore the entire CDB. I'm looking for a report, via sqlplus, that will give me the start/end time, backup type (INCR or FULL), status (COMPLETED or FAILED), the elapsed time etc. I have one that works for standalone 12c databases but would like to have something similar for 19c PDB's.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center