RMAN Backup of Pluggable Database Returns Error ORA-65250 (Doc ID 2596048.1)

In this Document

APPLIES TO:

Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and later
Information in this document applies to any platform.

GOAL

NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the
Oracle sample schema(s), Public Documentation delivered with an Oracle database product or other training material. Any similarity to actual
environments, actual persons, living or dead, is purely coincidental and not intended in any manner.

For the purposes of this document, the following fictitious environment is used as an example to describe the procedure:

Pluggable Database Name: TEST
Directory Name: /oradata1/test, /orabackup/test, and all sub-directories

****************

A backup of a pluggable database (PDB) which was created using the 'CREATE_FILE_DEST' clause will return the ORA-65250 error.

For example, assume the creation of a PDB using the following command:

CREATE PLUGGABLE DATABASE TEST ADMIN USER sys IDENTIFIED BY <password> CREATE_FILE_DEST='/oradata1/test/test_CLONED/';

Backup this pluggable database created by the above command fails with following errors:

starting piece 1 at 20-SEP-2019 11:36:05

			RMAN-03009: failure of backup command on BACKUP1 channel at 09/20/2019 11:36:06

			ORA-65250: invalid path specified for file - /orabackup/test/test_20-09-2019_1uuc7td5_1_1

			continuing other job steps, job failed will not be re-run

			RMAN-03009: failure of backup command on BACKUP1 channel at 09/20/2019 11:36:06

			ORA-65250: invalid path specified for file - /orabackup/test/test_20-09-2019_1uuc7td5_1_1

			RMAN-03009: failure of backup command on BACKUP1 channel at 09/20/2019 11:36:05

			ORA-65250: invalid path specified for file - /orabackup/test_20-09-2019_1tuc7td4_1_1

SOLUTION

This issue has been reported as unpublished Bug 30419450: 'BACKUP DATABASE FORMAT ...' DOES NOT BACKUP A PDB THAT WAS CREATED WITH 'CREATE_FILE_DEST' CLAUSE.

To resolve the issue, check for and apply a fix for bug 30419450.

The workaround to resolve the backup issue is to null the db_create_file_dest parameter. I.e.:

1. Clear out the db_create_file_dest parameter:

SQL> alter session set container = <CDB NAME>;

			SQL> alter system set db_create_file_dest ='' scope=both;

			SQL> show parameter db_create_file_dest

Confirm the db_create_file_dest parameter is empty.

2. Re execute the RMAN backup.

REFERENCES

BUG:29845375 - RMAN BACKUP RESULTS IN ORA-65250: INVALID PATH SPECIFIED FOR FILE

BUG:29817997 - ORA-65250 DURING RMAN PLUGGABLE DATABASE BACKUP