Database Backup and Recovery (MOSC)

MOSC Banner

Error in cmd of restore Pdb with a TBS readonly and another TBS excluded from backup

Hi all,

I am testing on a scenario where I want to save time in backup and recovery of Pdb where a big tablespace HIS with historical data I put to READ ONLY and another big tablespace ABC I can't put in readonly but I skipped it in backup by 'configure exclude….'. So my backup command has 'skip readonly' and 'configure exclude…..' string inside.

When I do recovery of Pdb, I used the cmd:

run
{
set until time "to_date('2025-06-05 14:40:00','yyyy-mm-dd hh24:mi:ss')";
restore pluggable database FM80WFA skip tablespace ABC skip readonly preview summary;

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center