Re: Replace System01.dbf

On Fri, 31 Mar 2006 11:23:24 -0800, G-Diddy wrote:

> 1. To backup MS SQL you don't need to setup anything. You just say
> BACKUP. Restoring is just as easy.

In Oracle, enter the RMAN command, type 'backup database' and it's backed up, enter 'restore database' and it's restored.

Yes, you do have to specify the granularity (database, tablespace, data file).

And unfortunately, you do have to TYPE it, not just SAY it. <g>

> 2. Nope, the SYSTEM01.DBF file is corrupt. To what extent I could not
> tell you because Oracle does not supply tools and does not allow 3rd
> parties to develop them.

The tool is called DB Verify. Automatically invoked by RMAN. Or manually invoked using dbv or dbverify (depending on platform). Free of charge. Included with the database. Takes some effort to look for and find it, though - it's hidden in the $ORACLE_HOME/bin directory and not on a start menu.

>
> The great thing about MS SQL is that you don't need to be a DBA to
> install, setup or maintain. It is also much more inexpensive and user

Based on my analysis, using list prices from both web sites, and using an average of 6 1-hour support calls a year, Oracle is slightly less expensive than MS SQL Server.

(Publishing the detailed information, would, unfortunately cause Microsoft to hit me with a lawsuit. I've noticed that big vendors are eager to control the way information is presented. 'Independant' evaluations are tightly monitored and need permission to release.)

> friendly. Information about also is immensely more available and FREE.
> Oracle makes you sign-up and open a ticket for eveything and charges
> you like crazy.

LOL. All docco is available free of charge. Same signup requirements as MSDN and same price. Tutorials, samples, free downloads of ALL products, user help forums available free of charge.

And one price for unlimited support for a whole year, not a per-call charge. Oracle is much cheaper than the per call costs I've had in the past with Microsoft.

Funny thing - if you have and understand Microsoft agreements, you become a Microsoft bigot. If you have and understand Oracle agreements, you become an Oracle bigot.

Ain't religion wonderful .. closed minded-ness is bliss.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** Top posting [replies] guarantees I won't respond. ***