Re: Want to check my steps for enabling auto archive log

On Fri, 27 Jan 2006 18:27:59 GMT, "L C" <lccronin_at_hotmail.com> wrote:

>Hello,
>
>Not an Oracle DBA by any means, but I have an Oracle 9i database I need to
>back up and want to use rman. So I need to enable auto archive log. I want
>to make sure my steps are correct.
>
>I will use the Enterprise Manager Console to enable Auto Archive, following
>this link http://seer.support.veritas.com/docs/266835.htm.
>
>Here are my planned steps
>Stop my database and make a cold backup.
>Perform the auto archive enable from the above doc. This includes the
>immediate shutdown I have read about.
>Reboot the Server.
>
>Seems rather simple, that concerns me - so another question is what can go
>wrong and how will I know it went bad.
>
>Thanks
>
>Larry C
>
>

Actually log_archive_start = true is not a prerequisite for archivelog at all. Log_archive_start just means your logs are archived automatically instead of manual.
And obviously, in the time you need to display all those GUI screens you can switch your database to archivelog a dozen times.

Here is the sql*plus method (You may notice I leave out the backup)

alter system set log_archive_start=true scope=spfile;

shutdown immediate;

rem your backup goes here

startup mount;

alter database archivelog;

alter database open;

And that's all there is to it.

If anything goes wrong, the last step will fail. But I have never seen that.

Hth

--
Sybrand Bakker, Senior Oracle DBA