| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: changing archive from noarchive
thanx a lot for the suggestion and help guys. I have done it various times
but all those I had done in non-clustered environment but not the cluster
one. I was planning the same step but I thought there might be some more
things I may need to take care of. So I thought to discuss this in forum
just to clarify my doubts which is now more or less clear. Since its
active-passive so do i need to shutdown both the nodes before doing this ?
because the binary is on nodes but database is on san and spfile is existing
in the $ORACLE_HOME/dbs folder on both the nodes. so if anyone can tell me
the steps in this situation. I am thinking of doing the activity as :
1) SHUTDOWN IMMEDIATE;
2)Modify both spfile on both the nodes as the spfile location has been
left in the binary home
3)STARTUP MOUNT 4)ALTER DATABASE ARCHIVELOG 5)ALTER DATABASE OPEN 6) ARCHIVE LOG LIST 7)Will check V$ARCHIVE% data dictionary for the archive log information 8) SHUTDOWN IMMEDIATE 9) taking cold backup.
thanx once again. and plz. do suggest
On 12/23/05, Tanel Põder wrote:
>
> You're missing "startup mount"; "alter database archivelog" and "alter
> database open" after shutdown immediate.
>
> But if you're doing it the first time, make sure you understand the
> concepts of archivelogging and online backups (if you're gonna do those)
> first. docs.oracle.com will help (backup & recovery guide).
>
> Tanel.
>
> ----- Original Message -----
> *From:* Onkar N Tiwary
> *To:* oracle-l_at_freelists.org
> *Sent:* Friday, December 23, 2005 6:26 AM
> *Subject:* changing archive from noarchive
>
>
> hi all,
>
> This is the first time, I am going to put one production server, which is
> running in Active-Passive cluster, in archivelog mode from noarchive log
> mode. As I said since this is the first time , I am going to do this , so I
> don know what are the changes required. My plan is as :
>
> 1) setting log_archive_dest,log_archive_format & log_archive_start
> parameters in init.ora/spfile.ora on both the nodes
> 2) connecting to oracle server with sys/pass_at_string as sysdba
> 3) shutting down the database using SHUTDOWN IMMEDIATE
> 4) starting the database normally using STARTUP
>
> Do I need to do something else??? Plz. sugges.
>
> --
> Thanks & Regards,
> T. Onkar Nath
> OneAPPS Enterprise Technology Pvt. Ltd.
> to_onkar_at_yahoo.com
> onkarnath.tiwary_at_gmail.com
>
>
>
--
Thanks & Regards,
T. Onkar Nath
OneAPPS Enterprise Technology Pvt. Ltd.
to_onkar_at_yahoo.com
onkarnath.tiwary_at_gmail.com
Received on Sat Dec 24 2005 - 06:24:27 CST
 |
 |