OraFAQ Forum: Backup & Recovery » ORA-01152: file 1 was not restored from a sufficiently old backup

Home » RDBMS Server » Backup & Recovery » ORA-01152: file 1 was not restored from a sufficiently old backup (oracle11G, Solaris sparc)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01152: file 1 was not restored from a sufficiently old backup [message #649142]

Mon, 14 March 2016 22:04

ady_the495
Messages: 5
Registered: March 2016
Location: indonesia

Junior Member

HI,

I have problem with create backup server use cold backup.
With error i get when process backup like :
++++
Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to an idle instance.
ORACLE instance shut down.
Connected to an idle instance.
ORACLE instance started.

Total System Global Area 1.1762E+11 bytes
Fixed Size 2173536 bytes
Variable Size 1.1274E+10 bytes
Database Buffers 1.0630E+11 bytes
Redo Buffers 42549248 bytes

Control file created.

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: '/d01/devadis01/system01.dbf'

alter tablespace TEMP1 add tempfile '/d01/devadis01/temp01.dbf' REUSE
*
ERROR at line 1:
ORA-01109: database not open

alter tablespace TEMP1 add tempfile '/d01/devadis01/temp04.dbf' REUSE
*
ERROR at line 1:
ORA-01109: database not open

alter tablespace TEMP1 add tempfile '/d01/devadis01/temp03.dbf' REUSE
*
ERROR at line 1:
ORA-01109: database not open

alter tablespace TEMP1 add tempfile '/d01/devadis01/temp07.dbf' REUSE
*
ERROR at line 1:
ORA-01109: database not open

alter tablespace TEMP1 add tempfile '/d01/devadis01/temp08.dbf' REUSE
*
ERROR at line 1:
ORA-01109: database not open

alter tablespace TEMP1 add tempfile '/d01/devadis01/temp09.dbf' REUSE
*
ERROR at line 1:
ORA-01109: database not open

alter tablespace TEMP1 add tempfile '/d01/devadis01/temp10.dbf' REUSE
*
ERROR at line 1:
ORA-01109: database not open

alter tablespace TEMP1 add tempfile '/d01/devadis01/temp05.dbf' REUSE
*
ERROR at line 1:
ORA-01109: database not open

alter tablespace TEMP1 add tempfile '/d01/devadis01/temp06.dbf' REUSE
*
ERROR at line 1:
ORA-01109: database not open

alter tablespace TEMP1 add tempfile '/d01/devadis01/temp02.dbf' REUSE
*
ERROR at line 1:
ORA-01109: database not open

ALTER DATABASE RENAME GLOBAL_NAME TO "DEVEADIS.adis.co.id"
*
ERROR at line 1:
ORA-01109: database not open

ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
Connected to an idle instance.
ORACLE instance started.
+++++

Script backup i use to create backup server is perl adcfgclone.pl dbTier
What I do wrong? Sad Im new on Oracel DB.

Sorry for my english

Report message to a moderator

Re: ORA-01152: file 1 was not restored from a sufficiently old backup [message #649144 is a reply to message #649142]

Tue, 15 March 2016 01:19

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Code: [Select all] [Show/ hide]

ORA-01152: file %s was not restored from a sufficiently old backup
 *Cause:  An incomplete recovery session was started, but an insufficient
           number of logs were applied to make the database consistent. This
         file is still in the future of the last log applied. The most
         likely cause of this error is forgetting to restore the file
         from a backup before doing incomplete recovery.
 *Action: Either apply more logs until the database is consistent or
           restore the database file from an older backup and repeat recovery.

Report message to a moderator

Re: ORA-01152: file 1 was not restored from a sufficiently old backup [message #649146 is a reply to message #649142]

Tue, 15 March 2016 02:11

John Watson
Messages: 8984
Registered: January 2010
Location: Global Village

Senior Member

It looks as though you are trying to clone an EBS database. What document are you following?

Report message to a moderator

Re: ORA-01152: file 1 was not restored from a sufficiently old backup [message #649148 is a reply to message #649146]

Tue, 15 March 2016 03:04

ady_the495
Messages: 5
Registered: March 2016
Location: indonesia

Junior Member

Hi john,

That true, i try to create the development instant.
I use document from vendor.
How to repair that error , do yuo have a solusion ?

Thanks,
Ady

Report message to a moderator

Re: ORA-01152: file 1 was not restored from a sufficiently old backup [message #649149 is a reply to message #649148]

Tue, 15 March 2016 03:34

John Watson
Messages: 8984
Registered: January 2010
Location: Global Village

Senior Member

I cannot debug a document that I cannot see. You had better discuss it with the author.

Report message to a moderator

Re: ORA-01152: file 1 was not restored from a sufficiently old backup [message #649150 is a reply to message #649149]

Tue, 15 March 2016 04:13

ady_the495
Messages: 5
Registered: March 2016
Location: indonesia

Junior Member

Hi john,

Do you have a document for cold backup ?, if i want create development ebs instan.
Because i need the development instan for pacth.

Thanks,
Andri

Report message to a moderator

Re: ORA-01152: file 1 was not restored from a sufficiently old backup [message #649151 is a reply to message #649150]

Tue, 15 March 2016 04:25

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

BACKUP DATABASE.

Report message to a moderator

Re: ORA-01152: file 1 was not restored from a sufficiently old backup [message #649153 is a reply to message #649151]

Tue, 15 March 2016 04:30

ady_the495
Messages: 5
Registered: March 2016
Location: indonesia

Junior Member

Hi gazzag,

That use the rman backup, i want the cold backup.

Thanks,
Andri

Report message to a moderator

Re: ORA-01152: file 1 was not restored from a sufficiently old backup [message #649154 is a reply to message #649153]

Tue, 15 March 2016 04:36

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

RMAN can perform a cold (consistent) backup but if you want an O/S backup of the database, you will need to shut the database down and take copies of the files that are listed when you run the following query:

Code: [Select all] [Show/ hide]

SELECT name FROM v$datafile
UNION
SELECT name FROM v$tempfile
UNION
SELECT name FROM v$controlfile
UNION
SELECT member FROM v$logfile;

Report message to a moderator

Re: ORA-01152: file 1 was not restored from a sufficiently old backup [message #649156 is a reply to message #649150]

Tue, 15 March 2016 04:44

John Watson
Messages: 8984
Registered: January 2010
Location: Global Village

Senior Member

ady_the495 wrote on Tue, 15 March 2016 09:13

Hi john,

Do you have a document for cold backup ?, if i want create development ebs instan.
Because i need the development instan for pacth.

Thanks,
Andri

Cloning an EBS environment is more complicated than copying the database, you know. I can only repeat: what document are you following? Is it this,

Cloning Oracle E-Business Suite Release 12.2 with Rapid Clone (Doc ID 1383621.1)

and if not, why not?

Report message to a moderator

Re: ORA-01152: file 1 was not restored from a sufficiently old backup [message #649174 is a reply to message #649144]

Tue, 15 March 2016 20:31

ady_the495
Messages: 5
Registered: March 2016
Location: indonesia

Junior Member

Michel Cadot wrote on Tue, 15 March 2016 06:19

Code: [Select all] [Show/ hide]

ORA-01152: file %s was not restored from a sufficiently old backup
 *Cause:  An incomplete recovery session was started, but an insufficient
           number of logs were applied to make the database consistent. This
         file is still in the future of the last log applied. The most
         likely cause of this error is forgetting to restore the file
         from a backup before doing incomplete recovery.
 *Action: Either apply more logs until the database is consistent or
           restore the database file from an older backup and repeat recovery.

For action "until the database is consistent" what is mean ?

Report message to a moderator

Re: ORA-01152: file 1 was not restored from a sufficiently old backup [message #649182 is a reply to message #649174]

Wed, 16 March 2016 04:18

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Instance recovery.

Report message to a moderator

Previous Topic:	Cross Platform migration, ORA-27048
Next Topic:	Is it necessary to back up the whole database when moving a datafile

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Aug 17 19:23:46 CDT 2025