Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I want to make that change to the archive log mode to use the redo log files to use it to make replication to database to another server.

This is easy and possible when the server is single not multi-clustered as the current case. What are the procedures to make that when there are two clustered servers?

I am using Oracle fail safe manager.

I am trying to make streams replication to another server, I have two clustered servers with operating system Windows server 2003. Cluster service is being used. Also, Oracle fail safe manager is used.

share|improve this question
    
@user2423720 could you better explain your question? which kind of replication do you want to setup? –  Ste May 27 '13 at 11:30
    
is still not clear. What is Oracle level#2 archive? Do you just want to activate archivelog mode in your database? –  Ste May 29 '13 at 5:54
    
Yes, I want to change my Oracle 9i multiclusterd database from non-archiving mode to archiving mode. –  user2423720 Jun 8 '13 at 7:13
    
Our application is two clustered servers, one of them is running and the other is hot standby to take ove in case the frist one has failed. What I want is to change ORACLE DATABASE from non-archiving to archiving mode. –  user2423720 Jun 8 '13 at 7:16
add comment

migrated from stackoverflow.com May 27 '13 at 10:01

This question came from our site for professional and enthusiast programmers.

1 Answer

In order to activate archivelog mode in Oracle you have to do basically three steps:

  1. Clean database shutdown
  2. Activate archivelog mode
  3. Take a full back

Step 2 is performed in this way:

SQL> startup mount
SQL> alter database archivelog
SQL> alter database open

When database is opened again you can issue:

SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     7
Next log sequence to archive   9
Current log sequence           9

You notice that archive destination is set by default to the DB_RECOVERY_FILE_DEST area. You can change it with command:

SQL> alter system set log_archive_dest_1='location=yourpath' scope=both;

There is no need to restart the DB for this command. More information about archivelog mode and management can be found here Furthermore, you can read here for backup management with archivelog mode.

share|improve this answer
    
I have did the all mentioned above steps, the man problem which I am facing is during shutdown step. As mentioned above I have two servers, one is running and the other is how standby. Also, ORACLE fail safe manager and the two servers are clustered. Database is not accepting shutdown. –  user2423720 Jun 9 '13 at 7:03
    
When making shudown commmand from SQLPlus it gives command time out after nearly twenty minutes because when trying to shutdown it on one server, it starts on the other because of the multi clustering of the two servers. –  user2423720 Jun 9 '13 at 7:06
    
@user2423720 I think you have too many questions here. Based on you comments in the question I explained you how to put the DB in archivelog mode but you're still too unclear. I will closed your question. –  Ste Jun 9 '13 at 8:29
    
Why unclear?!!!!! I have two servers clustered together, one of the is running and the other is in standby mode. –  user2423720 Jun 10 '13 at 6:52
    
We have oracle database installed with the oracle fail safe manager utility. As you have mentioned, I must shutdown database frist and change from non-Archive to Archive mode. When trying to shutdown the database, if it is shutdown on one server (The running), it starts again due to multiclustring and Oracle fail safe manager. It does not accept shutdown. So, the whole process of changing from non-Archive to Archive fails. I can not shutdown database. How to do this? –  user2423720 Jun 10 '13 at 7:02
show 3 more comments

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.