Re: HELP!! Can NOT add third member to REDO LOG file ..

In article <50p7a2$kce_at_nyx10.cs.du.edu>,

        mkodama_at_nyx10.cs.du.edu (mary kodama) writes:
>farsider_at_postoffice.ptd.net (Bob Leonard) writes:
>
>>In article <50l2q8$hku_at_news2.cais.com>, duffy_at_cais.cais.com says...
>>->
>>->I has Oracle 7.2.3 on SUN SOLARIS 2.5. I tried to add third member to
>>->REDO LOG file, it don't allow me to do it. The message is "max 2 member
>>->..". Can anyone help me on it? Thank you for help.-
>
>I don't think it is in the config.ora. It is a parameter
>when you create the database. You will need to export,
>then recreate the database and import.
Actually, you don't need to recreate the database ... actually you have to do even more work ...

1. from sqldba, backup the controlfile to trace.
2. rename the control file as something like 'recreate.sql'
3. edit the log-group and log-members parameters in the sql.
4. shutdown the database ... you must NOT use shutdown abort.
5. Take a cold backup of the entire database.
6. remove the existing control file(s) from the system.
7. Go into sqldba, and connect internal. Don't start the DB
8. execute the recreate script.
9. startup the database to ensure that the control file create worked. If you screwed up, restore the database from step 5.
10. shutdown the database.
11. Take a cold backup ... all history of the archive logs has been lost.
12. Startup the database normally, and you're (hopefully) back in business.

Bill

        4.          Received on Sat Sep 07 1996 - 00:00:00 CEST