Database Backup and Recovery (MOSC)

MOSC Banner

Can't ASM disk location be used as Auxiliary Destination for PDB PIT Restores?

edited Sep 23, 2014 5:03PM in Database Backup and Recovery (MOSC) 4 commentsAnswered ✓

Hello Experts,

I am running PDB PIT restore using destination as '+DATA/test' which I created using ASMCMD.

However, I am getting an error

" RMAN-04014: startup failed: ORA-01261: Parameter db_create_file_dest destination string cannot be translated"

Pasting the script below.

RUN {

CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS="ENV=(NBBSA_DB_DEVICE_NAME=Oracle-Win::\\RAC-CDBUS-3919258050\CDBUS)";

RESTORE PLUGGABLE DATABASE 'PDBHRO' UNTIL TIME "TO_DATE('09-17-2014:02:09:28', 'MM-DD-YYYY:HH24:MI:SS')";

RECOVER PLUGGABLE DATABASE 'PDBHRO' UNTIL TIME "TO_DATE('09-17-2014:02:09:28', 'MM-DD-YYYY:HH24:MI:SS')" auxiliary destination='+DATA/test';

ALTER PLUGGABLE DATABASE PDBHRO OPEN RESETLOGS;

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