| adding/dropping redolog [message #62820] |
Tue, 17 August 2004 11:36  |
jimbob
Messages: 20
Registered: April 2004
|
Junior Member |
|
|
I have added new redo logfiles to my db. (8i)
I have dropped the old redo logfiles. Do I need to backup my control files to trace now? Or is there anything else that I need to configure? Tia..
jb
|
|
|
|
| Re: adding/dropping redolog [message #62825 is a reply to message #62820] |
Tue, 17 August 2004 20:39  |
satyajit das
Messages: 12
Registered: August 2004
|
Junior Member |
|
|
hi
is the new redolog files has the same name as the older one ????. again tell me is u'r databse in noarchivelog mode ??? see in event of crash since u have drop the old redologs and created new ones and u 'r database is in archivelog u will not be able to do complete recovery... but if it is in noarchivelog then there is no question of complete recovery at all in event of crash.. now what u have to do is to reset the logs after u startup the databse in mount mode..
sql> startup mount
sql > alter database open resetlogs;
this command will reset the logs.. so u will not get any previous information if there is any ....
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
