Backup Central

Greetings,
I need some assistance from you Oracle guru's out there.
I recently moved a database from one server to another using Networker and the Oracle database was shutdown.
The DBA gets the error message show below:
ORA-01152: file 85 was not restored from a sufficiently old backup
ORA-01110: data file 85: '/dev/vx/rdsk/prerac_undo/inp_vundo01_n1'

The dba said the backup was "bad" requested that I do it over again. The research that I did on that error says that it is an Oracle error and
it is caused by an insufficient amount of redo logs were applied.

What is the probability that this was caused by a "bad" backup? I later found out that the DBA had moved the files to another location before
starting the rebuild. Any input is appreciated.

Thanks!
Guy Novello
Storage Management
PHCS
781-895-3117

Note: To sign off this list, send a "signoff networker" command via email
to listserv < at > listserv.temple.edu or visit the list's Web site at
http://listserv.temple.edu/archives/networker.html where you can
should be sent to stan < at > temple.edu

Guy
ORA-01152 error is a result of wrong Oracle incomplete recovery procedure, that applied by your DBA . It is a pure oracle issue (related to mismatch between SCN numbers in recovered files), that has nothing to do with the bad backup...
Your DBA have to contact Oracle support for the resolution.

Regards,
Daniel.

-----Original Message-----
From: Legato NetWorker discussion [mailto:NETWORKER < at > LISTSERV.TEMPLE.EDU] On Behalf Of Novello, Guy
Sent: ä 20 éðåàø 2005 21:14
To: NETWORKER < at > LISTSERV.TEMPLE.EDU
Subject: [Networker] Help with Oracle restore.


Greetings,
I need some assistance from you Oracle guru's out there.
I recently moved a database from one server to another using Networker and the Oracle database was shutdown. The DBA gets the error message show below:
ORA-01152: file 85 was not restored from a sufficiently old backup
ORA-01110: data file 85: '/dev/vx/rdsk/prerac_undo/inp_vundo01_n1'

The dba said the backup was "bad" requested that I do it over again. The research that I did on that error says that it is an Oracle error and it is caused by an insufficient amount of redo logs were applied.

What is the probability that this was caused by a "bad" backup? I later found out that the DBA had moved the files to another location before starting the rebuild. Any input is appreciated.

Thanks!
Guy Novello
Storage Management
PHCS
781-895-3117


**************************************************************************************************
The contents of this email and any attachments are confidential.
It is intended for the named recipient(s) only.
If you have received this email in error please notify the system manager or the
sender immediately and do not disclose the contents to any one or make copies.

MBI - System Team
**************************************************************************************************

Note: To sign off this list, send a "signoff networker" command via email
to listserv < at > listserv.temple.edu or visit the list's Web site at
http://listserv.temple.edu/archives/networker.html where you can
should be sent to stan < at > temple.edu