Forum Stats

  • 3,815,628 Users
  • 2,259,063 Discussions
  • 7,893,189 Comments

Discussions

stop rman duplicate from dropping offline tablespaces (oracle 12.2 patched Oct 2021)

User_1LBSD
User_1LBSD Member Posts: 1 Green Ribbon

I'm trying to duplicate a database using an rman backup.

I'm only connecting to the auxiliary database only and giving location of the backups.

the backups do contain copy of the read only tablespace.

command

duplicate database to mydb

spfile

backup location 'D:\Buckups'

nofilenamecheck;

Output shows ...

skip forever tablespace "PDB":"READONLYTBS" delete archivelog;

And at end

does

drop tablespace "READONLYTBS" including contents cascade constraints


Anyway of stopping this, I want the readonly tablespace that was backup up during the rman backup

Answers

  • AJ
    AJ Member Posts: 1,350 Silver Trophy
    edited Jan 20, 2022 2:39PM

    is readonlytbs offline on source ?

    edit: read the topic of your post and you say it's offline. Why so? Why not only keep it read only, but online. RMAN Duplicate will drop offline tablespaces.

    AJ