vxfs_checkpoint and database recovery

  • From: David Turner <dnt9000@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 19 Mar 2008 11:50:36 -0700 (PDT)

We're playing around with vxfs checkpoints, Netbackup checkpoints, and we were 
initially surprised to see that we could take backups of our live Oracle 
databases while transactions were running on them without putting the the 
tablespaces in backup mode. We thought that upon restore the database wouldn't 
come up. However, we were wrong. On starting the database it treated the 
situation as an instance recovery and the database opened fine.

Next we tried a database recovery, because we didn't want to just recover to 
the point in time of the backup. We wanted to apply archive logs to a point in 
time. This is where we've run into problems. No matter what we try we are 
unable to recover the database using recover database until cancel. We get:

ORA-00279: change 4358724 generated at 03/18/2008 15:49:11 needed for thread 1
ORA-00289: suggestion :
ORA-00280: change 4358724 for thread 1 is in sequence #147
ORA-00278: log file
'/u01/app/oracle/admin/db01/arch/T0001_S0000000146_R0646659117.arc' no longer 
needed for this recovery
ORA-00308: cannot open archived log
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory Additional information: 3
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/u01/oradata/db01/system01.dbf'

We're performing 

"alter system archivelog current;" 

before and after the backup, but not putting the tablespaces in backup mode. I 
assume this is the reason why we're having the problem, but can anyone explain 
to me the why this is required? With the snapshot/checkpoint as I understand it 
we are getting a consistent version of the datafiles, redo(which I remove 
before restore).

Also, is there a different option that I should be using with Netbackup for 
checkpoints to make this work? In this phase we do not want to incorporate RMAN 
or any Oracle scripts if possible. The SA's want as complete a separation as 

Thx, Dave

Other related posts: