Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Flashback PDB failed using ssh tunnel on 19c : Error ORA-38750: FLASHBACK DATABASE may not be performed using a dispatcher

User_82KCCOct 9 2023 — edited Oct 9 2023

Hi Everyone,

I am performing a flashback database to a restore point using ssh tunnel from our Jenkins server. I have a shell script, which create a restore point and if job failed its rollback the PDB to a restore point.

I got the error when I try to Flashback database to a restore point. Could you help to resolve this issue? see the below code and error

ssh -o ControlMaster=auto -o ControlPath="${WORKSPACE}/tunnelCtl" -f -N -L "${JPPORT}:${db_host}:${db_port}" ${JPUSER}@${JPHOST}
nc -z localhost "${JPPORT}" || echo "no tunnel open"

sql -S "sys/${SYS_PWD}@${host}:${JPPORT}/${service} as sysdba" << EOF
ALTER PLUGGABLE DATABASE PDB5 CLOSE IMMEDIATE;
FLASHBACK PLUGGABLE DATABASE PDB5 TO RESTORE POINT BEFOR_UPDATE;
ALTER PLUGGABLE DATABASE PDB5 OPEN RESETLOGS;
exit;
EOF

Below error I am getting when running is shell script.

15:52:38  Error starting at line : 2 in command -
15:52:38  FLASHBACK PLUGGABLE DATABASE PDB5 TO RESTORE POINT BEFOR_UPDATE
15:52:38  Error report -
15:52:38  ORA-38750: FLASHBACK DATABASE may not be performed using a dispatcher.
15:52:38  38750. 00000 -  "FLASHBACK DATABASE may not be performed using a dispatcher."
15:52:38  *Cause:    An attempt was made to use a dispatcher process for FLASHBACK
15:52:38             DATABASE. Memory requirements disallow this recovery method.
15:52:38  *Action:   Connect to the instance via a dedicated server process to
15:52:38             perform FLASHBACK DATABASE.

Could anyone suggest what is the issue and how to fix it?

Thanks.

Comments
Post Details
Added on Oct 9 2023
4 comments
330 views