Networker

Re: [Networker] Help with Oracle restore.

2005-01-20 16:49:34
Subject: Re: [Networker] Help with Oracle restore.
From: Daniel Bass <daniel AT MBI.CO DOT IL>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Thu, 20 Jan 2005 23:45:14 +0200
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 DOT EDU] 
On Behalf Of Novello, Guy
Sent: ה 20 ינואר 2005 21:14
To: NETWORKER AT LISTSERV.TEMPLE DOT 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

--
Note: To sign off this list, send a "signoff networker" command via email to 
listserv AT listserv.temple DOT edu or visit the list's Web site at 
http://listserv.temple.edu/archives/networker.html where you can also view and 
post messages to the list. Questions regarding this list should be sent to stan 
AT temple DOT edu 
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=

**************************************************************************************************
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 DOT edu or visit the list's Web site at
http://listserv.temple.edu/archives/networker.html where you can
also view and post messages to the list. Questions regarding this list
should be sent to stan AT temple DOT edu
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=

<Prev in Thread] Current Thread [Next in Thread>