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.