Re: alarming experience with controlfile autobackup on

sorry I was not clear.
In step 2, a tablespace was either dropped or added. So the steps were:

step 1: do backup of database. This database consists of all "default tablespaces" plus one user-generated one, which has one datafile only. Backup is done filesperset 1, so there is one separate backupset for this tablespace.

step 2: drop this tablespace

step 3: wait till autobackup has been created

step 4: do a report obsolete. Not only the controlfile from the backup in step 1 will be reported obsolete, but the single backupset containing the now-removed tablespace, too.

step 5: delete all

And now when doing incomplete recovery until before step 2, the tablespace wdid not exist in the restored & recovered database.

Does this make it clear, or should I perform the steps again and post the logs?

Ciao
Sigrid

• Original-Nachricht --------
  > Datum: Sun, 28 Oct 2012 07:58:35 -0700
  > Von: Jared Still <jkstill_at_gmail.com>
  > An: keydana_at_gmx.de
  > CC: oracle-l_at_freelists.org
  > Betreff: Re: alarming experience with controlfile autobackup on
  

> On Thu, Oct 25, 2012 at 9:33 AM, Sigrid Keydana <keydana_at_gmx.de> wrote:
>
> >
> >
> > step 1: do backup
> > step 2: perform structural change, e.g., add tablespace
> > step 3: wait till autobackup has been created (this was another strange
> > thing, I've found no way to influence this myself, not even by a
> database
> > restart!)
> > step 4: someone does a DELETE OBSOLETE. The controlfile from the backup
> > will be deleted as obsolete, we have the more recent one now only ...
> > step 5: delete all DB files
> > ...
>
> But then in step 4 already, I was in for a shock: Not only was the
> > controlfile backup from step 1 obsolete, also the backupset containing
> the
> > new tablespace's datafile was (backups were performed with filesperset
> 1).
> >
> >
> Your steps do not match the explanation.
>
> In the steps listed, there is not a backup of the new tablespace, thought
> explanatory text mentions
> a backupset containing the new tablespace.
>
> It would probably be a good idea to present a well documented test case,
> one that lists all steps
> taken, and (readable) logs of the actual steps taken.
>
> Also, adding a tablespace should have triggered a backup of the
> controlfile
> if autoback was configured.
>
>
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
> Oracle Blog: http://jkstill.blogspot.com
> Home Page: http://jaredstill.com

--
http://www.freelists.org/webpage/oracle-l