Re: On-Archie or OnBar ??

Mark brings up one of many major reasons why no 1st tier DBMS vendors support table level backup/restore in their main backup/restore products. I'm sure there are certain products out there claim to do just this but unless it's an extremely simplistic scenario. i'm not sure DBAs want to use them either. Think integrity, dependencies (index ...). What if the table schema has been altered, i.e. column type changed, dropped, length expanded... It's not as easy nor simple as one might think. You can always do this with other provided utilities. MS SQL server did have table level support with tons of caveats but dropped it in 7.0 Oracle does have lower granularity PIT restore (tablespace) but the process is nothing but simple. As Mark pointed out, integrity is the key here, Oracle will need to re-sync everything to ensure that. Without OnBAR, i don't know how you can manage a VLDB environment where the typical size is getting close to 1 terabyte or larger and the backup window is shrinking. It will take a while for onbar to mature. pete