Home » RDBMS Server » Backup & Recovery » Restore database Error when restoring database to a new server (Oracle 10.2.0.4 AIX 5.3)
Restore database Error when restoring database to a new server [message #460838] Tue, 15 June 2010 03:37 Go to next message
efachim
Messages: 42
Registered: July 2008
Member
Hi folks,

I created an rman backup of a database. I then copied it over to a new server where I am trying to restore it (I just created the backup today). However, I am getting the error below.

Essentially, I used an initdb.ora file to create an instance of the database, and mounted it, on the new server. And then I ran a simple "restore database" command from rman, the end of which is displayed below, with a "Restore complete. ..."

I have looked up this error (ora-01152) online and I cannot find a scenario which best provides me with a fix to my problem, about the file not being restored from a sufficiently old backup. Could any one help please?

 
piece handle=/ora_backup/prev_0/qconfig/dbf/QCONFIG_18_1_721669501_2010_06_14_15:44_Mon_full tag=2010_06_14_15:44_MON_FULL
channel ORA_DISK_4: restore complete, elapsed time: 00:03:30
channel ORA_DISK_2: restored backup piece 1
piece handle=/ora_backup/prev_0/qconfig/dbf/QCONFIG_15_1_721669501_2010_06_14_15:44_Mon_full tag=2010_06_14_15:44_MON_FULL
channel ORA_DISK_2: restore complete, elapsed time: 00:05:00
Finished restore at 14-JUN-10
 
RMAN> alter database open resetlogs;
 
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 06/14/2010 17:48:12
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '+DGROUP1/testdb/datafile/system.751.721679898'

[Updated on: Tue, 15 June 2010 03:54]

Report message to a moderator

Re: Restore database Error when restoring database to a new server [message #460914 is a reply to message #460838] Tue, 15 June 2010 09:09 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10630
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
It could be useful if you post the whole backup/restore log.
Did you try recovering the database to a point prior?
recover database
or
recover database until cancel
followed by
alter database open resetlogs;



Re: Restore database Error when restoring database to a new server [message #460968 is a reply to message #460914] Tue, 15 June 2010 15:23 Go to previous message
efachim
Messages: 42
Registered: July 2008
Member
Mahesh,

Here is the log below. I only used "restore database" ...

RMAN> restore database;

Starting restore at 14-JUN-10
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=651 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=650 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=649 devtype=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: sid=648 devtype=DISK

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00002 to +DGROUP1/testdb/datafile/undots1.667.721227421
channel ORA_DISK_1: reading from backup piece /ora_backup/prev_0/testdb/db/testdb_16_1_721669501_2010_06_14_15:44_Mon_full
channel ORA_DISK_2: starting datafile backupset restore
channel ORA_DISK_2: specifying datafile(s) to restore from backup set
restoring datafile 00007 to +DGROUP1/testdb/datafile/a1_x.641.721227553
restoring datafile 00009 to +DGROUP1/testdb/datafile/ent_sm01_x.659.721227557
restoring datafile 00013 to +DGROUP1/testdb/datafile/in01_x.657.721227569
restoring datafile 00015 to +DGROUP1/testdb/datafile/cs01_x.656.721227571
restoring datafile 00016 to +DGROUP1/testdb/datafile/cs01_d.650.721227559
restoring datafile 00021 to +DGROUP1/testdb/datafile/h01_x.644.721227575
restoring datafile 00023 to +DGROUP1/testdb/datafile/doc01_x.647.721227575
restoring datafile 00025 to +DGROUP1/testdb/datafile/og01_x.645.721227577
channel ORA_DISK_2: reading from backup piece /ora_backup/prev_0/testdb/db/testdb_19_1_721669509_2010_06_14_15:44_Mon_full
channel ORA_DISK_3: starting datafile backupset restore
channel ORA_DISK_3: specifying datafile(s) to restore from backup set
restoring datafile 00003 to +DGROUP1/testdb/datafile/sysaux.662.721227423
restoring datafile 00006 to +DGROUP1/testdb/datafile/a01_d.639.721227549
restoring datafile 00010 to +DGROUP1/testdb/datafile/ent_lg01_d.666.721227423
restoring datafile 00012 to +DGROUP1/testdb/datafile/in01_d.658.721227511
restoring datafile 00014 to +DGROUP1/testdb/datafile/cs01_d.661.721227521
restoring datafile 00019 to +DGROUP1/testdb/datafile/ndata_x.654.721227423
restoring datafile 00022 to +DGROUP1/testdb/datafile/doc_01_d.660.721227531
restoring datafile 00029 to +DGROUP1/testdb/datafile/in01_x.642.721227471
channel ORA_DISK_3: reading from backup piece /ora_backup/prev_0/testdb/db/testdb_17_1_721669501_2010_06_14_15:44_Mon_full
channel ORA_DISK_4: starting datafile backupset restore
channel ORA_DISK_4: specifying datafile(s) to restore from backup set
restoring datafile 00001 to +DGROUP1/testdb/datafile/system.655.721227423
restoring datafile 00004 to +DGROUP1/testdb/datafile/users.653.721227453
restoring datafile 00005 to +DGROUP1/testdb/datafile/tools.663.721227423
restoring datafile 00008 to +DGROUP1/testdb/datafile/en_sm01_d.665.721227473
restoring datafile 00018 to +DGROUP1/testdb/datafile/n_data_d.664.721227423
restoring datafile 00020 to +DGROUP1/testdb/datafile/hfig01_d.652.721227527
restoring datafile 00024 to +DGROUP1/testdb/datafile/og01_d.651.721227535
restoring datafile 00028 to +DGROUP1/testdb/datafile/in1_d.646.721227469
channel ORA_DISK_4: reading from backup piece /ora_backup/prev_0/testdb/db/testdb_18_1_721669501_2010_06_14_15:44_Mon_full
channel ORA_DISK_2: restored backup piece 1
piece handle=/ora_backup/prev_0/testdb/db/testdb_19_1_721669509_2010_06_14_15:44_Mon_full tag=2010_06_14_15:44_MON_FULL
channel ORA_DISK_2: restore complete, elapsed time: 00:00:27
channel ORA_DISK_2: starting datafile backupset restore
channel ORA_DISK_2: specifying datafile(s) to restore from backup set
restoring datafile 00017 to +DGROUP1/testdb/datafile/cs_lg01_x.640.721227579
restoring datafile 00026 to +DGROUP1/testdb/datafile/am1_d.643.721227581
restoring datafile 00027 to +DGROUP1/testdb/datafile/am1_x.671.721227581
channel ORA_DISK_2: reading from backup piece /ora_backup/prev_0/testdb/db/testdb_20_1_721669624_2010_06_14_15:44_Mon_full
channel ORA_DISK_2: restored backup piece 1
piece handle=/ora_backup/prev_0/testdb/db/testdb_20_1_721669624_2010_06_14_15:44_Mon_full tag=2010_06_14_15:44_MON_FULL
channel ORA_DISK_2: restore complete, elapsed time: 00:00:07
channel ORA_DISK_2: starting datafile backupset restore
channel ORA_DISK_2: specifying datafile(s) to restore from backup set
restoring datafile 00011 to +DGROUP1/testdb/datafile/ent_lg01_x.648.721227421
channel ORA_DISK_2: reading from backup piece /ora_backup/prev_0/testdb/db/testdb_15_1_721669501_2010_06_14_15:44_Mon_full
channel ORA_DISK_1: restored backup piece 1
piece handle=/ora_backup/prev_0/testdb/db/testdb_16_1_721669501_2010_06_14_15:44_Mon_full tag=2010_06_14_15:44_MON_FULL
channel ORA_DISK_1: restore complete, elapsed time: 00:02:30
channel ORA_DISK_3: restored backup piece 1
piece handle=/ora_backup/prev_0/testdb/db/testdb_17_1_721669501_2010_06_14_15:44_Mon_full tag=2010_06_14_15:44_MON_FULL
channel ORA_DISK_3: restore complete, elapsed time: 00:03:15
channel ORA_DISK_4: restored backup piece 1
piece handle=/ora_backup/prev_0/testdb/db/testdb_18_1_721669501_2010_06_14_15:44_Mon_full tag=2010_06_14_15:44_MON_FULL
channel ORA_DISK_4: restore complete, elapsed time: 00:03:30
channel ORA_DISK_2: restored backup piece 1
piece handle=/ora_backup/prev_0/testdb/db/testdb_15_1_721669501_2010_06_14_15:44_Mon_full tag=2010_06_14_15:44_MON_FULL
channel ORA_DISK_2: restore complete, elapsed time: 00:05:00
Finished restore at 14-JUN-10


RMAN>  alter database open resetlogs;
Previous Topic: RMAN 11gr2
Next Topic: cold backup recovery fails for database in noarchivelog mode
Goto Forum:
  


Current Time: Sun Dec 21 18:54:29 CST 2014

Total time taken to generate the page: 0.08214 seconds