Hot Backup [message #330510] |
Mon, 30 June 2008 06:20 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
saharookiedba
Messages: 56 Registered: September 2007 Location: PUNE
|
Member |
|
|
Hi,
I am taking the HOT BACKUP of the database.
I have a script through which i am copying data files, control files and archive files.
Is it necessary to copy redofiles also,
If so, can we directly copy the redofiles by keeping the tablespaces in BACKUP mode.
Is there any other way to copy redofiles.
Please let me know.
|
|
|
|
Re: Hot Backup [message #330517 is a reply to message #330512] |
Mon, 30 June 2008 06:33 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
saharookiedba
Messages: 56 Registered: September 2007 Location: PUNE
|
Member |
|
|
Thanks for the Quick response,
As per my understanding, the reason is as follows,
I have been making sure that the current redo file is also archived during backup, through the following
ALTER SYSTEM ARCHIVE LOG CURRENT;
ALTER SYSTEM ARCHIVE LOG ALL;
so that all the changes are reflected in ARCHIVE. Please correct me if i am wrong..
Thank you.
|
|
|
Re: Hot Backup [message #330534 is a reply to message #330517] |
Mon, 30 June 2008 06:57 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Yes it is safer to do this after saving the files and before saving the archive logs to have a complete backup.
Regards
Michel
|
|
|