My Oracle Support Banner

RMAN Restore Table Returns ORA-01666 Error (Doc ID 2628625.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.



NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the Oracle sample schema(s), Public Documentation delivered with an Oracle database product or other training material. Any similarity to actual environments, actual persons, living or dead, is purely coincidental and not intended in any manner.

For the purposes of this document, the following fictitious environment is used as an example to describe the procedure:
Database Name: ORCLDB


Restore Table using:

 UNTIL TIME "TO_DATE('01-JAN-2020 10:00', 'DD-MON-YYYY HH24:MI')"

Fails with the following:
RMAN-03002: failure of recover command at 01/09/2020 10:30:43
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of sql command on clone_default channel at 01/01/2020 10:30:42
RMAN-11003: failure during parse/execution of SQL statement: alter database mount clone database
ORA-01666: control file is for a standby database

Output from V$database:

---------    --------------------       ----------------    ------------------------------
ORCLDB    READ WRITE           PRIMARY                ORCLDB



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.