Re: backup versus export of db
From: Alan Bozof <g596101_at_lg3vm.lasc.lockheed.com>
Date: 1995/11/30
Message-ID: <49l55l$puo_at_pong.lasc.lockheed.com>#1/1
Date: 1995/11/30
Message-ID: <49l55l$puo_at_pong.lasc.lockheed.com>#1/1
The reason you do not get a COMPLETE backup by just backing up the operating system files is because some of the data is stored in the SGA in memory. The contents of the SGA is written down to the operating system files by the background processes. If the data in the Data Buffer Cache and the Redo Log Buffer Cache has not been written to the data files then when you run your backup of the data files it does not have the data from the SGA buffers; therefore the backup is not complete.
You can read about backups in the Oracle7 Server Adminstrator Guide.
I hope this answers your question.
Scott Downey
Lockheed-Martin
Database Administrator
Received on Thu Nov 30 1995 - 00:00:00 CET