About online Redo log file (merged) [message #470060] |
Sat, 07 August 2010 15:00 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
muktha_22
Messages: 527 Registered: December 2009
|
Senior Member |
|
|
Hello,
Need a clarification on the below doubt.
If we do structural changes of online Redo Log, like Rename/Add/Drop. We need to take a backup.
Question 1:
Do we need to take a backup of online Redo also (case of Non - Archive), or only the control file is enough.
Question 2:
Do we need to do log switch before taking the backup of control file. And please tell me the procedures if anything has to perform more than this.
Thanks in prior.
|
|
|
|
About online Redo log file [message #470091 is a reply to message #470060] |
Sun, 08 August 2010 06:26 ![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) |
muktha_22
Messages: 527 Registered: December 2009
|
Senior Member |
|
|
Hello,
Need a clarification on the below doubt.
If we do structural changes of online Redo Log, like Rename/Add/Drop. We need to take a backup.
Question 1:
Do we need to take a backup of online Redo also (case of Non - Archive), or only the control file back up is enough.
Question 2:
Do we need to do log switch before taking the backup of control file. And please tell me the procedures if anything has to perform more than this.
Question 3:
I'm not able to get the control file backup trace file in UDUMP.
Question 4:
Logically we need only one Redo group, if we are not running in Archive log mode. Is it true?
Question 5:
How we can set Time-based manner in Logswitch.
Thanks in prior.
|
|
|
Re: About online Redo log file [message #470106 is a reply to message #470091] |
Sun, 08 August 2010 09:17 ![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) |
![](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 |
|
|
1/ See above
2/ See above
3/ Too bad for you
4/ No
5/ Database Reference contains the list of all parameters, try to find the appropriate one by yourself and come back with the answer.
A feedback is appreciated BEFORE you post the next topic above all if the next topic is the same as the previous one.
And in this case, DO NOT create a new topic continue on the same one.
Regards
Michel
[Updated on: Sun, 08 August 2010 09:17] Report message to a moderator
|
|
|
|
|
|
|
|