Oracle-L: Re[2]: RMAN: I don't trust it

From: <dgoulet_at_vicr.com>
Date: Tue, 11 Feb 2003 06:08:58 -0800
Message-ID: <F001.0054926A.20030211060858@fatcity.com>

Lyndon,

pg_dump equals export in Oracle. Actually "pg_dump all" = "export full=y". It's just a syntax difference. And if you have a full export all you need to to recreate the database is create the system tablespace. And yes it is easy with Oracle, if you keep it simple.

Dick Goulet

Database recovery is easy, the hard part is figuring out what broke & what you have to fix it.

____________________Reply Separator____________________
Author: Lyndon Tiu <ltiu_at_alumni.sfu.ca>
Date:       2/10/2003 3:03 PM

If only Oracle can come up with a Postgresql command such as:

pg_dump dbname | gzip > dbname_backup.gz

Then backups would be easy. I know, I know Oracle can do the same with export, and sqlplus but hell it ain't that easy with Oracle.

--

Lyndon Tiu

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Lyndon Tiu
INET: ltiu_at_alumni.sfu.ca

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author:
INET: dgoulet_at_vicr.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message