How to fix the Oracle error RMAN-06138: control file not mounted – must specify AT clause with REPORT command?

In this post, you’ll learn more about the Oracle ErrorRMAN-06138: control file not mounted – must specify AT clause with REPORT command with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

RMAN-06138: control file not mounted – must specify AT clause with REPORT command

Reason for the Error RMAN-06138: control file not mounted – must specify AT clause with REPORT command

A ‘REPORT SCHEMA’ with no at_clause was issued, and there is no recovery catalog, and there is also no control file mounted at the target database, so there is no place to get the information about the current list of files comprising the database.

How to fix the Error RMAN-06138: control file not mounted – must specify AT clause with REPORT command ?

You can fix this error in Oracle by following the below steps

Use a recovery catalog or mount a control file at the target database.