| Hot Backup [message #330510] |
Mon, 30 June 2008 06:20  |
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  |
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 |
 |
Michel Cadot
Messages: 68648
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
