Creating Redo Log Files 1

[C4IAaron]

Hi There,
I am new to the DBA world, so please forgive me simple question...
I would like to set up three redo log files and then of course set the database to archivelog mode.

I know how to put the database into archivelog mode and specify the directory for the redo files but don't know if I have to create the files myself or if not how to say how many I would like?

Can anyone help???

 

[karluk]

You can't have an Oracle database without at least two redo log files. They are created at the same time as the database. You can find information on what's currently there by querying v$log or v$logfile.

If you want to add a third redo log, the command to do so is ALTER DATABASE ADD LOGFILE ... Please check your documentation for the full syntax.

The redo logs that were created with the database may not be sized the way you want. If you want to modify them, you have to drop and recreate them. This requires that you have at least three redo log groups, so that you still have two after the drop. Do a logfile switch before the drop to make sure that the one you are trying to drop isn't the currently active log.

 

[uparna]

Hi ,
You can very easily do all these things using DBA studio . All these things are done in the proper format in just a few mouse clicks and i have saved a lot of valuable time in searching for the syntax by using this tool. It gets installed automatically when you install the later versions of Oracle.

Regards,
S. Jayaram Uparna .

If the need arises,you are welcome to mail me at oracguru@yahoo.com .I would be glad to help you out.