vxfs_checkpoint and database recovery

From: David Turner <dnt9000_at_yahoo.com>
Date: Wed, 19 Mar 2008 11:50:36 -0700 (PDT)
Message-ID: <198380.55797.qm@web36310.mail.mud.yahoo.com>

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 :
/u01/app/oracle/admin/db01/arch/T0001_S0000000147_R0646659117.arc 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 possible.

Thx, Dave  

Received on Wed Mar 19 2008 - 13:50:36 CDT

Original text of this message