Re: Hot Backup referenced external data

> I mentioned earlier. Unless you are talking huge amounts of data, the
> incremental backup feature is not the first one that springs to mind as a
> reason for moving to RMAN, however.

Howard, what is your first reason for moving to RMAN, or are you saying you prefer not to use RMAN?

--
Jake
"Howard J. Rogers" <howardjr_at_www.com> wrote in message
news:3a111d39$1_at_news.iprimus.com.au...


> I'm slightly confused about what you are after, but here goes for

> nothing....

>

> 1. How can we best backup data associated with a hot backup?

>

> I *really* don't understand this question.  A hot backup is a backup of

 the


> data files associated with a database.  You want to backup a backup?  If

 you


> mean, 'how do you do hot backups', the short answer is: do it a tablespace

> at a time, issue the command 'alter tablespace blah begin backup; take a

> host copy of the data files associated with that tablespace; when the copy

> has finished, issue the command 'alter tablespace blah end backup'.  You

> then move on to the next tablespace and so on, until all tablespaces have

> been processed.  Full instructions are contained (amongst other places) in

> my backup and recovery document, available on my website.

>

> 2. I think you then ask how (or whether) you can just backup the extra

> column that has been added to a table.  Short answer is, you can't.  Even

> using RMAN's incremental backup feature, since that is row-level sensitive

> to data changes, not column-sensitive.

>

> 3.  Yes, you can 'parse the data' from your archives, provided you have

> 8.1.5 or above -the feature is called Log Miner (also 'parses data' from

> on-line archive logs).  Anything earlier than 8.1.5, and you'll have to

 find


> a third-party product that does the deed (and I don't know of any off

 hand).


>

> 4. 'Can we read incremental RMAN data'?  No, but (rather fortunately) RMAN

> can.  If you mean, 'can RMAN do incremental backups', the answer is yes,

 as


> I mentioned earlier.  Unless you are talking huge amounts of data, the

> incremental backup feature is not the first one that springs to mind as a

> reason for moving to RMAN, however.

>

> Not sure whether you are entirely familiar with backup and recovery

 concepts


> and techniques.  L=ike Isay, go to my site, find the Backup and Recovery

> course page, and download my small document there -and then get back to me

> with any questions you may have.

>

> Regards

> HJR

> --

> --------------------------------------------------------------------------

 -


> Opinions expressed are my own, and not those of Oracle Corporation

> Oracle DBA Resources:               http://www.geocities.com/howardjr2000

> --------------------------------------------------------------------------

 -


>

>

> <dickweisinger_at_my-deja.com> wrote in message

> news:8uqq5f$e1p$1_at_nnrp1.deja.com...

> > Hi,

> > Can you please help me?

> > How can we best backup data associated with a hot

> > backup?

> > We have a table that references volume and file

> > data.  As part of the hot backup, we want to do

> > an incremental backup of all files that are newly

> > referenced in the incremental hot database backup.

> > (Someone added a column to the table with path to

> > a file.)

> > How can we best do this?  If we keep an

> > ARCHIVELOG, can we parse the data from that

> > file?  We may move to RMan in the near future --

> > can we read incremental RMan data?

> > Thanks

> >

> >

> >

> >

> > Sent via Deja.com http://www.deja.com/

> > Before you buy.

>

>

>