Re: HELP: Recover from inconsistent backups

In a nutshell 'No'. You can't take hot backups if you're in noarchivelog mode. What you have are inconsistent data files that need archive log information applied to them to bring the files to a consistent state and since you're not in archivelog mode, you have not saved the archive information.

More specifically, the SCN number in you're datafile headers are out of synch with your current control file SCN. The only way to open up the database in this case is if you have taken a cold backup (with the database shutdown) and restore those and then open up your database.

For really good reading on backups get the Oracle Backup and Recovery (Valupuri) book from Oracle Press and also make use of the real gurus in this group (no, I'm not one of them, but I've learnt a hell of a lot from these folks).

hth

mkb

In article <88jol9$3d5$1_at_nnrp1.deja.com>, schud_at_pegasystems.com wrote:
>Anyone know of a trick to recover from an inconsistent hot
backup taken
>of a NOARCHIVELOG DB (Ora8 on Sun Solaris).
>
>Every time I try to restore I get messages saying that certain
files
>still need media recovery. Can I force my way around this and
just
>open the db to get at the data.
>
>Don Schuerman
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
>
>

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!