Home » RDBMS Server » Backup & Recovery » Hot Backup (9.0.2.4)
Hot Backup [message #330510] Mon, 30 June 2008 06:20 Go to next message
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 #330512 is a reply to message #330510] Mon, 30 June 2008 06:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is useless to copy redo log files.

Regards
Michel
Re: Hot Backup [message #330517 is a reply to message #330512] Mon, 30 June 2008 06:33 Go to previous messageGo to next message
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
Michel Cadot
Messages: 64139
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
Previous Topic: Incremental backup fails
Next Topic: RMAN WITH SHARED MAP
Goto Forum:
  


Current Time: Thu Dec 08 20:34:05 CST 2016

Total time taken to generate the page: 0.12823 seconds