| About online Redo log file (merged) [message #470060] |
Sat, 07 August 2010 15:00  |
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  |
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 |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
