Re: Hot Backups
Date: 1996/01/07
Message-ID: <30F010A6.3D59_at_ccm.tdsnet.com>#1/1
Neil Greene wrote:
> Neil Greene
> Senior Oracle DBA / Unix System Administrator
> SHL Systemhouse, Inc. LA Outsourcing Center
> <HREF=mailto:ngreene_at_shl.com>THe working is like this.
Whenever a tablespace is taken into backup mode, all updates and insertes to the underlying datafiles are effected into the datafile, but file header is not updated to that effect. This is the reason, after an aborted shutdown or crash, Oracle instance needs to be recovered. It will require all archive logs from the start of hot backup.
Thankfully, there is method available in 7.2 or in 7.3 which will ease this job by giving
'alter database datafile 'xxx' end backup'.
Until that time, you need to work with this solution.
Vijay Nair Received on Sun Jan 07 1996 - 00:00:00 CET