Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: File Restoration/Recovery

Re: File Restoration/Recovery

From: Rachel Carmichael <>
Date: Fri, 14 Mar 2003 08:54:16 -0800
Message-ID: <>

no no no no no no

If he is REALLY lucky, and no one is using the database at the instant he does all the copies (and I mean the OS as well), then MAYBE, POSSIBLY, if the Tooth Fairy and Easter Bunny are present and bless the copy, he might have a valid backup.

But I wouldn't bet my job on it.

He needs to have either a noarchivelog "cold" backup (database shutdown) done, which will restore to that point in time, or an archivelog "cold" backup (database shutdown) which will allow you to roll forward providing you also have the archived logs or an archivelog "hot" backup (database up, tablespaces in "begin backup" mode) which will allow you to let anyone keep working while you do the backup and then allow you to roll forward providing you have the archived logs.

Prove it to him: bet him something that will hurt him to lose, then do the copy the way he wants and try to start up the database. Just to ensure sure you prove your point, have some transaction that modifies data running in the database. If you can, make sure that that transaction is active enough to cycle through ALL your online logs and loop back to the first one.

Do you Yahoo!?
Yahoo! Web Hosting - establish your business online
Please see the official ORACLE-L FAQ:
Author: Rachel Carmichael

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message
to: (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).
Received on Fri Mar 14 2003 - 10:54:16 CST

Original text of this message