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 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

 

DISCLAIMER:
-----------
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:

RMAN> RECOVER TABLE <TABLE_NAME>
 UNTIL TIME "TO_DATE('01-JAN-2020 10:00', 'DD-MON-YYYY HH24:MI')"
 AUXILIARY DESTINATION '/exp/aux';

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:

NAME      OPEN_MODE            DATABASE_ROLE    DB_UNIQUE_NAME
---------    --------------------       ----------------    ------------------------------
ORCLDB    READ WRITE           PRIMARY                ORCLDB

 

Cause

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
Symptoms
Cause
Solution


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