Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 535.8K On-Premises Infrastructure
- 138.1K Analytics Software
- 38.6K Application Development Software
- 5.6K Cloud Platform
- 109.3K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
RMAN-06019: could not translate tablespace name "SYSTEM"

Dear All.
Please help me to fix an error message occur while I'm trying to recover a table to Point In Time Recovery in RMAN.
**** Method
Table Point In Time Recovery (PITR) in RMAN
*****
===> My procedure <=====
$ rman target=/
RMAN> run{
RECOVER TABLE "username"."tablename"
UNTIL TIME "TO_DATE('10-SEP-21 09:39:05', 'DD-MON-YYYY HH24:MI:SS')"
AUXILIARY DESTINATION '/u04'
DATAPUMP DESTINATION '/home/oracle/Tasks/dump'
DUMP FILE 'tablename.dmp'
NOTABLEIMPORT;
}
----------> Error Message <-------------
Removing automatic instance
shutting down automatic instance
Oracle instance shut down
Automatic instance removed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 09/10/2021 14:19:46
RMAN-20202: Tablespace not found in the recovery catalog
RMAN-06019: could not translate tablespace name "SYSTEM"
--------------------------------
DB Version: Oracle 19C.
OS: Red Hat Linux 8