Re: Tar cold backups on AIX

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 - 10:12:01 CDT