Re: Hot Backup referenced external data

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.