No, but I think I figured it out. Conspicuously missing from the query are
the control files!!! I feel like such an idiot.
-- Chuck
"Kevin Brand" <kevin.brandx_at_tel.gte.com> wrote in message
news:afcmtf$6o0$1_at_news.gte.com...
> >tar cvf - `cat files.dat` | gzip > coldbackup.tgz
>
> Are any of your datafiles/redo/undo/control files raw? Just a shot in the
> dark.
>
> Try this tar command instead:
>
> tar cvf - `cat files.dat` 2>/tmp/tar_output.log |gzip 2>/tmp/gzip.log
> >coldbackup.tgz
>
> When your backup is complete, check the two logfiles for any errors.
>
> -Kevin
>
> "Chuck" <chuckh_at_softhome.net> wrote in message
> news:afcm2q$dfs5c$1_at_ID-85580.news.dfncis.de...
> > There was a type-o in the script. The first line of the union query
should
> > say "select name from v\$datafile". The real script uses the correct
> query.
> > The problem appears to be with tar either not saving or restoring the
> files
> > correctly. Have you seen this before.
> >
> >
> > "Kevin Brand" <kevin.brandx_at_tel.gte.com> wrote in message
> > news:afclii$6nj$1_at_news.gte.com...
> > >
> > >
> > > Your script returns something like this into the "files.dat" tar input
> > > file...
> > >
> > > SID_NAME_IN_ALL_CAPS
> > > logfile1_file_name
> > > ...
> > > logfileN_file_name
> > >
> > > You must be starting the tar command ( the script ) from the
> > > .../oradata/<you start your script in this dir>/SID_NAME_IN_ALL_CAPS
> > >
> > > otherwise all you are backing up and restoring is the redo. What
about
> > > controlfiles and configuration files?
> > >
> > > -Kevin
> > >
> > > "Chuck" <chuckh_at_softhome.net> wrote in message
> > > news:afcho1$dcho8$1_at_ID-85580.news.dfncis.de...
> > > > I am having a problem restoring cold backups on AIX. The procedure I
> use
> > > to
> > > > create the backup is to build a flat file containing the names of
all
> > the
> > > > datafiles and logfile members by querying the database. I then shut
> the
> > > > database down normally and use that file to tar (and gzip) the
> database.
> > > > I've done this hundreds of times on Solaris and SGI and have never
had
> a
> > > > problem restoring. When I try to restore an AIX backup however I get
> the
> > > > following...
> > > >
> > > > Database mounted.
> > > > ORA-01113: file 1 needs media recovery
> > > > ORA-01110: data file 1: '/u500/oradata/HRUA/system01.dbf'
> > > >
> > > > If I do "recover database" (which I should NOT have to do since the
> > backup
> > > > was a clean cold backup) it starts prompting me for archive logs but
> the
> > > > database is not in archive log mode.
> > > >
> > > > Is there some problem with TARing oracle data files on AIX, or
> gzipping
> > > the
> > > > tar file? What's the workaround?
> > > >
> > > > Here is my backup procedure (korn shell)
> > > >
> > > > sqlplus -s "/ as sysdba" <<! > files.dat
> > > > set pages 0 feedback off
> > > > select name from v\$database
> > > > union all
> > > > select member from v\$logfile;
> > > > !
> > > > sqlplus -s "/ as sysdba" <<!
> > > > shutdown immediate
> > > > !
> > > > tar cvf - `cat files.dat` | gzip > coldbackup.tgz
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
Received on Wed Jun 26 2002 - 11:01:40 CDT
