Re: Tar cold backups on AIX

Verify in alert log that database was shutdown cleanly. You have an inconsistent backup.

Anyway, try to manually provide online redo logs when you are prompted for the archive logs. Keep feeding them to Oracle until you get media recovery complete(hopefully!)

steve

"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 - 14:33:08 CDT