ORA-01152 ORA-01110

After restoration of database from old backup in a testing system , I tried to open the database. I got below errors.

[oracle@DWH_UAT_DB2:~]$ss

SQL*Plus: Release 11.2.0.3.0 Production on Fri Sep 5 12:54:58 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area  526110720 bytes
Fixed Size                  2223120 bytes
Variable Size             171967472 bytes
Database Buffers          343932928 bytes
Redo Buffers                7987200 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL> alter database open RESETLOGS;
alter database open RESETLOGS
*
ERROR at line 1:
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: ‘+DATA/rcat/datafile/system.1963.857332469’

SOLUTION :-

I have created the controlfile using the below command.

CREATE CONTROLFILE REUSE DATABASE “RCAT” NORESETLOGS  ARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 292
LOGFILE
  GROUP 1 ‘+DATA/rcat/onlinelog/group_1.1997.849286885’  SIZE 50M BLOCKSIZE 512,
  GROUP 2 ‘+DATA/rcat/onlinelog/group_2.1994.849286885’  SIZE 50M BLOCKSIZE 512,
  GROUP 3 ‘+DATA/rcat/onlinelog/group_3.1993.849286885’  SIZE 50M BLOCKSIZE 512
— STANDBY LOGFILE
DATAFILE
  ‘+DATA/rcat/datafile/system.1963.857332469’,
  ‘+DATA/rcat/datafile/sysaux.1961.849286763’,
  ‘+DATA/rcat/datafile/undotbs1.1959.849286763’,
  ‘+DATA/rcat/datafile/users.1998.849286763’,
  ‘+DATA/rcat/datafile/pratik_tbsp.1958.849286763’,
  ‘+DATA/rcat/datafile/pratik_tbsp.1964.849286761’,
  ‘/uatrmanbkp1/.oracle/TEST/t1.dbf’
CHARACTER SET WE8MSWIN1252
;

NOTE : Please do not follow this in production, I have performed this in a testing system.

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 )

Connecting to %s