Home » RDBMS Server » Backup & Recovery » ORA-01152: file 1 was not restored from a sufficiently old backup (oracle11G, Solaris sparc)
ORA-01152: file 1 was not restored from a sufficiently old backup [message #649142] Mon, 14 March 2016 22:04 Go to next message
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
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 Go to previous messageGo to next message
Michel Cadot
Messages: 65970
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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.
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 Go to previous messageGo to next message
John Watson
Messages: 7669
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?
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
John Watson
Messages: 7669
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.
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
gazzag
Messages: 1043
Registered: November 2010
Location: Bristol, UK
Senior Member
BACKUP DATABASE.
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
gazzag
Messages: 1043
Registered: November 2010
Location: Bristol, 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:
SELECT name FROM v$datafile
UNION
SELECT name FROM v$tempfile
UNION
SELECT name FROM v$controlfile
UNION
SELECT member FROM v$logfile;
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 Go to previous messageGo to next message
John Watson
Messages: 7669
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?
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 Go to previous messageGo to next message
ady_the495
Messages: 5
Registered: March 2016
Location: indonesia
Junior Member
Michel Cadot wrote on Tue, 15 March 2016 06:19

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 ?
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 Go to previous message
gazzag
Messages: 1043
Registered: November 2010
Location: Bristol, UK
Senior Member
Instance recovery.
Previous Topic: Cross Platform migration, ORA-27048
Next Topic: Is it necessary to back up the whole database when moving a datafile
Goto Forum:
  


Current Time: Sun Nov 18 08:03:04 CST 2018