Re: Using backup files with new DB

On Nov 17, 9:13 am, Wolf Grossi <n..._at_magro-soft.com> wrote:
> joel garry wrote:
> > Wolf Grossi wrote:
> >> joel garry wrote:
> >>> Wolf Grossi wrote:
>
> >>>> No archived logs were saved and no oracle support.
> >>> Past time to reevaluate your priorities.
>
> >> What u mean?
>
> > You need to have support and a proper, tested, backup and restore
> > methodology in place before you need them. Very basic administrative
> > principles. We've seen a lot of posts here over the years where people
> > haven't adhered to those principles, and quite often it is a conscious
> > decision not to bother with them because of the perceived cost.
> > Sometimes it's even worse, a poor prioritization of the the types of
> > things that can (read: will) go wrong - like not realizing that
> > depending on a super-duper storage device means a single point of
> > failure, or thinking oracle database files are just flat things you can
> > access any way you please.
>
> > It is a management decision to prioritize how much their data is worth.
> > There are some amazingly bad decisions out there, by people who really
> > ought to know better. Don't be offended, you appear to be suffering
> > the results of such a situation. Just sayin', so maybe you can make
> > things better.lol :-)
> U do not understand the original question:
> I was askin 'how can I recover ...'
> and *not* 'how can I prevent...'
>
> cu
> Wolf- Hide quoted text -- Show quoted text -

Actually, Joel is completely right: you can't recover without archivelog
Sometimes Oracle support can help you out, but as you have no archivelogs and no support, someone going to explain something. This may be a painful situation, and you will soon see how right Joel was, and how stupid you and/or your management.

cu

-- 
Sybrand Bakker
Senior Oracle DBA