Database Backup and Recovery (MOSC)

MOSC Banner

RMAN RECOVER TABLE SYNTAX ERROR

edited Aug 30, 2018 5:00AM in Database Backup and Recovery (MOSC) 6 commentsAnswered

Hi,

It's the first time i'm using 12c new feature RMAN recover table. So i'm running the following command:

run {recover table DBADM.TRACKAPPSLOCK

until time \"to_date('22/08/2018 10:30:00', 'DD/MM/YYYY HH24:MI:SS')\"

auxiliary destination '/backup/auxiliary/PCB1'

remap table 'DBADM'.'TRACKAPPSLOCK':'TRACKAPPSLOCK_RECO';}

But i'm getting this error:

RMAN> run {recover table DBADM.TRACKAPPSLOCK

until time \"to_date('22/08/2018 10:30:00', 'DD/MM/YYYY HH24:MI:SS')\"

auxiliary destination '/backup/auxiliary/PCB1'

remap table 'DBADM'.'TRACKAPPSLOCK':'TRACKAPPSLOCK_RECO';}2>

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-00558: error encountered while parsing input commands

RMAN-01006: error signaled during parse

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center