Home » RDBMS Server » Backup & Recovery » Hot backup (Unix 10.2.0.3)
Hot backup [message #468120] Thu, 29 July 2010 00:08 Go to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
I have dsome doubts regarding hot backup

1.Is there any need to backup online redo log files in hot backup?

2.After copying the files I archive the current log manually.

3.Is it must to back up the control file in hot backup?

4.When should we take backup of the control file after copying datafiles,Archive the log and then so that the latest change in log file is reflected in control file...Am I Right?
Re: Hot backup [message #468125 is a reply to message #468120] Thu, 29 July 2010 00:33 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
Oracle database Backup and Recovery FAQ
Re: Hot backup [message #468128 is a reply to message #468125] Thu, 29 July 2010 00:41 Go to previous messageGo to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
Fine wat about backing up online redo log files.Its not required am i right?
Re: Hot backup [message #468132 is a reply to message #468128] Thu, 29 July 2010 00:52 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
You are correct - you do not backup the online logfiles, because they are protected by multiplexing. In fact, it is impossible to backup open online redolog files, and you wouldn't want to (note that RMAN doesn't back them up). And yes, you must backup your controlfile with ALTER DATABASE BACKUP CONTROLFILE.
Re: Hot backup [message #468264 is a reply to message #468132] Thu, 29 July 2010 07:09 Go to previous message
Yasir Hashmi
Messages: 304
Registered: April 2006
Senior Member
You do not backup redo logs not because they are multiplexed but because they are archived. So RMAN backsup the archived logs.
Previous Topic: What is the best restore scenario
Next Topic: Restore table fails
Goto Forum:
  


Current Time: Thu Mar 28 15:05:50 CDT 2024