search

bseltz-cohesity / scripts

Cohesity REST API examples in PowerShell and Python
Apache License 2.0
102 stars 40 forks source link

oracle/python/restoreOracle-v2 issue will not restore the pluggable database #145

Closed amhaats1 closed 7 months ago

amhaats1 commented 7 months ago

Hi Brian we performed the below restores to overwrite original databases and it doesn't seem to be restoring the container/pluggable database(PDB), It restores the CDB but not the PDB

We are currently testing on 6.8.1_u7

We tried this option ./restoreOracle-v2.py -v mycluster \ -u myuser \ -d mydomain.net \ -ss oracleprod.mydomain.net \ -sd proddb \ -l -w

and this option and doesn't seem to be working

./restoreOracle-v2.py -v mycluster \ -u myuser \ -d mydomain.net \ -ss oracleprod.mydomain.net \ -sd CDB1/PDB1 \ -l -w

bseltz-cohesity commented 7 months ago

Try:

./restoreOracle-v2.py -v mycluster \
                      -u myuser \
                      -d mydomain.net \
                      -ss oracleprod.mydomain.net \
                      -sd CDB1 \
                      -pn PDB1 -pn PDB2 \
                      -l -o -w
amhaats1 commented 7 months ago

Unfortunately it didn't work,

I have attached some screen shots and comparing what the script looks performs and what it looks like if we perform the restore from the GUI. oracle_restore.docx

bseltz-cohesity commented 7 months ago

I have updated the script: https://github.com/bseltz-cohesity/scripts/tree/master/oracle/python/restoreOracle-v2 please try:

./restoreOracle-v2.py -v mycluster \
                      -u myuser \
                      -d mydomain.net \
                      -ss oracleprod.mydomain.net \
                      -sd CDB1 \
                      -l -o -w
amhaats1 commented 7 months ago

That worked!! Thank you so much for your fast response and help!!