RMAN-03002, ORA-01180, ORA-01110 Errors

Today I’m doing a restore of a database from one production environment to a test environment. When I run  RESTORE DATABASE command from RMAN’s prompt, I get the following error;

 

 Iniciando restore en 11/08/14
usando el canal ORA_DISK_1

creando archivo de datos fno=1 nombre=I:\BD\SYSTEM01_BBC1.DBF
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: fallo del comando restore en 11/08/2014 12:15:26
ORA-01180: no se puede crear el archivo de datos 1
ORA-01110: archivo de datos 1: 'I:\BD\SYSTEM01_BBC1.DBF'

 
After a few tests and research, it seems that the database (which is not in archivelog mode), in FRA has some files old, today is August 11, 2014, and the files are dated February. After deleting these files, it seems that is what confuses Oracle, I execute the RESTORE DATABASE command and work fine.

 

flashback_older

 

HTH – Antonio NAVARRO

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s