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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Processing

Post Details

Added on Oct 9 2023
4 comments
271 views