It's certainly true that Oracle doesn't support it, but, with the right storage subsystem solution in place, it can be implemented. It's the one and only case where taking a backup of your online redo is a requirement. -Mark From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Guillermo Alan Bort Sent: Thursday, July 01, 2010 7:46 AM To: niall.litchfield@xxxxxxxxx Cc: dbvision@xxxxxxxxxxxx; ORACLE-L Subject: Re: wish list Another nice feature SQLServer has and Oracle doesn't is Online Backups with the DB in NOARCHIVELOG mode. I know that would make PiTR impossible, but sometimes having snapshots of the DB is enough. cheers. Alan.- On Thu, Jul 1, 2010 at 7:44 AM, Niall Litchfield <niall.litchfield@xxxxxxxxx<mailto:niall.litchfield@xxxxxxxxx>> wrote: On Thu, Jul 1, 2010 at 11:34 AM, Nuno Souto <dbvision@xxxxxxxxxxxx<mailto:dbvision@xxxxxxxxxxxx>> wrote: It also shows how much more we pay in EE for what essentially amounts to a software toggle switch. But what I really like is being able to have a database working in 2000-emulation mode, another in 2005-emulation and another in native 2008, all in the same instance and all sharing the same server. Works wonders when consolidating apps into single servers. Also extremely valuable for customers who want to run a supported database and where the software vendor hasn't yet certified against a current release. NB There was of course prep work to make sure the database wasn't using any EE only features (but as it was a shrink wrap app I wasn't surprised when it wasn't). -- Niall Litchfield Oracle DBA http://www.orawin.info