Hi,
First of all, thanks for all the help. I am not an Oracle expert, but I am teaching a course for secondary students, and what I am experiencing is crazy.
I am working with Oracle database 23 Free. Archivelog is ON. And I am using SYS as SYSDBA.
I have created a PDB called “tienda” with one table called “usrimport.usuarios” with 131 rows.
I go to RMAN and run a backup with: BACKUP PLUGGABLE DATABASE tienda PLUS ARCHIVELOG;
The backup goes fine. The only comment is “using target database control file instead of recovery catalog”
After the backup is done I connect to the PDB with SQLPLUS. I delete 22 rows of the table (so the table keeps 109 rows) and COMMIT;
I go back to RMAN and run the restore with: RESTORE PLUGGABLE DATABASE tienda;
and RECOVER PLUGGABLE DATABASE tienda;
The only comment is again “using target database control file instead of recovery catalog”
When I go to SQLPLUS and check the number of rows in the table it ONLY HAS 109 ROWS.
Any explanation? Suggestions to solve it? Please!!!