ORA-01276: Cannot add file /u01/datafile/o1_mf_apps_ts__g601kz6x_.dbf. File has an Oracle Managed Files file name.

SQL> alter tablespace APPS_TS add datafile '/u01/datafile/o1_mf_apps_ts__g601kz6x_.dbf' size 500M autoextend on next 100M maxsize 15000M;
alter tablespace APPS_TS add datafile '/u01/datafile/o1_mf_apps_ts__g601kz6x_.dbf' size 500M autoextend on next 100M maxsize 15000M
*
ERROR at line 1:
ORA-01276: Cannot add file
/u01/datafile/o1_mf_apps_ts__g601kz6x_.dbf.  File has
an Oracle Managed Files file name.


alter tablespace APPS_TS add datafile size 500M autoextend on next 100M maxsize 15000M;

ORA-32771: cannot add file to bigfile tablespace

To check Bigdata status:

SQL> select Name,BIGFILE from v$tablespace  where name='APPS_TS_DATA';

NAME                           BIG
------------------------------ ---
APPS_TS_DATA                   YES

alter tablespace APPS_TS_DATA AUTOEXTEND ON MAXSIZE 62485M;

Value to add = Current value/ 0.75

 alter tablespace APPS_TS_DATA AUTOEXTEND ON MAXSIZE 2204533M;

12C question/answer

How to distinguish you are in CDB or PDB?
check show con_name or con_id

How to take a backup in Multitenant database? Shall i Take backup in rman does it take backup of all databases?

Yes, if you use backup database this will take all databases backup,

To take the backup of only one particular db, use backup pluggable database

Note: Archivelog backups will not be taken using pluggable database backup