Datafiles: one more try

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Mon, 24 Jun 2002 12:00:23 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7024546BD@lnewton.leeds.lfs.co.uk>

Martijn,

if you are not allowed to use RMAN, then you have a limited choice left (regardless of how or why Windows does what it does!) :

export : use exp to take a logical backup of your data. Cold backup : shut down the instance, copy all datafiles, all control files, initSID.ora, (password file) and redo log files. If you are running in Archivelog mode, there is no need to backup the archived log files, UNLESS, you have a need to restore further back that the dump you are taking, and will need to roll forward to a position prior to this current dump.

hot backup : ONLY in running in archivelog mode. This option allows you to take a backup of a running system while preserving any updates made to the tablespace(s) while the datafiles are being copied by some operating system command. You will need to keep the archived log files as well.

Beware of trying to fiddle some form of backup situation whereby you look at datafile dates and such like. It is a perfect way to trash your database - especially if you try to copy datafiles from a running database without using RMAN or a hot backup.

Cheers,
Norman.

PS. If you are not allowed to 'use RMAN or any other device to safely backup an Oracle datbase.' as you posted, then I'm afraid you won't be safely backing up your data - which is probably a bad thing (tm).

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


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

-----Original Message-----
From: opal_at_xs4all.nl (Martijn Rutte) [mailto:opal_at_xs4all.nl] Posted At: Monday, June 24, 2002 10:38 AM Posted To: server
Conversation: Datafiles: one more try
Subject: Datafiles: one more try

Gentlemen,

I seem to have caused a lot of upheavel with my queston about backing up oracle files not using the oracle backup facilities.

I fully understand your concern (you are, of course, absolutely right).

The thing is, I am trying to save what can be saved. Of course I'd like to use RMAN or any other device to safely backup an Oracle datbase.

But i can't, because I am simply not allowed to do so.

So, if anyone in here happens to know more about Windows caching/writing mutations to files, I would be very thankful to hear about it.

Kind regards,

Martijn Rutte Received on Mon Jun 24 2002 - 06:00:23 CDT