Skip to Main Content

Oracle Database Free

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

RMAN backup and restore weird behavior

Eduardo MendezFeb 25 2024

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!!!

Comments
Post Details
Added on Feb 25 2024
2 comments
158 views