Forum Stats

  • 3,757,130 Users
  • 2,251,200 Discussions
  • 7,869,736 Comments

Discussions

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

Tagged: