Re: disaster recovery

On May 17, 12:55 pm, sybra..._at_hccnet.nl wrote:
> On Fri, 16 May 2008 13:02:36 -0700 (PDT), Ben <benal..._at_yahoo.com>
> wrote:
>
>
>
>
>
>
>
> >This is getting aggravating, I've tried almost all options other than
> >pl/sql route.
>
> >Here is how our backup was taken:
>
> >56> connect catalog *
> >57>
> >58> connect target *
> >59>
> >60> run {
> >61> # Hot database level 0 whole backup
> >62> allocate channel t1 type 'SBT_TAPE';
> >63> allocate channel t2 type 'SBT_TAPE';
> >64> backup
> >65>   incremental level 0
> >66>   skip inaccessible
> >67>   tag jde_hot_level0
> >68>   filesperset 10
> >69>   # recommended format
> >70>   format 'bk_%s_%p_%T'
> >71>     (database);
> >72> }
>
> >now that we've lost the catalog, spfile, controlfiles, and everything
> >else. Is there a way to get the controlfile and spfile out of that
> >backup?
>
> If you didn't have controlfile autobackup on, which you didn't
> specify, shortly : NO.
>
> Also it looks to me like the person who 'designed' the script likes to
> gamble or is looking for a career move.
> Not backing up the archivelogs and using 'skip inacessible' for a
> database backup is not contributing to a consistent backup.
>
> --
> Sybrand Bakker
> Senior Oracle DBA- Hide quoted text -
>
> - Show quoted text -

I figured sybrand the holy would weigh in on this, Good job, way to go, your awesome! Received on Sun May 18 2008 - 08:37:08 CDT