Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Tar cold backups on AIX
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 - 09:05:52 CDT