Monday, November 19, 2007

converting Noarchivelog to archive log mode in RAC

The Steps that we followed while enabling archivelog mode in a RAC database.

-1) Backup the database!
0) Shut down all instances of the database, except the one upon which
the changes will be made.
1) alter system set cluster_database=false scope=spfile;
-- verification
SQL> show parameter cluster_database

------------------------------------ -----------
cluster_database boolean TRUE
cluster_database_instances integer 2

2) shut down and startup the same instance in 'MOUNT EXCLUSIVE';
ORACLE instance started.

Total System Global Area 599785472 bytes
Fixed Size 780280 bytes
Variable Size 166729736 bytes
Database Buffers 432013312 bytes
Redo Buffers 262144 bytes
Database mounted.

-- verification
SQL> show parameter cluster_database

------------------------------------ -----------
cluster_database boolean FALSE
cluster_database_instances integer 1

3) Set the required parameters.
SQL> ALTER SYSTEM SET log_archive_start=TRUE scope=SPFILE;

System altered.

SQL> ALTER SYSTEM SET log_archive_format='arch_%t_%s_%r.arc' scope=SPFILE;

System altered.

SQL> ALTER SYSTEM SET log_archive_dest='/u01/app/oracle/oradata/bmc/arch/'

System altered.

4) shut the database and STARTUP MOUNT

SQL> SELECT name,open_mode FROM v$database;

--------- ----------

5) Enable ARCHIVELOG mode

SQL> alter database archivelog;

Database altered.

SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/app/oracle/oradata/bmc/arch/
Oldest online log sequence 16
Next log sequence to archive 17
Current log sequence 17
SQL> select name,open_mode from v$database;

--------- ----------

6) Set cluster_database=true again.
SQL> alter system set cluster_database=true scope=spfile;

System altered.

7) Shut down and restart all the instances.

Our database is now in ArchiveLog Mode.

The above process has been tried and tested on our database. If anyone out
there suggest a better way to do the same, please feel free to let me know.


Anonymous said...

In 10g R2, i don't thin you need to set cluster_database=false.

You can do without setting this to false....


Anonymous said...

Creating Archive Log Files in ASM

Disk groups can be specified as archive log destinations in the LOG_ARCHIVE_DEST and LOG_ARCHIVE_DEST_n initialization parameters. When destinations are specified in this manner, the archive log filename will be unique, even if archived twice. All partially created archive files, created as a result of a system error, are automatically deleted.
If LOG_ARCHIVE_DEST is set to a disk group name, LOG_ARCHIVE_FORMAT is ignored. Unique filenames for archived logs are automatically created by the Oracle database. If LOG_ARCHIVE_DEST is set to a directory in a disk group, LOG_ARCHIVE_FORMAT has its normal semantics.
The following sample archive log names might be generated with DB_RECOVERY_FILE_DEST set to +dgroup2. SAMPLE is the value of the DB_UNIQUE_NAME parameter:

Anonymous said...

Can anyone recommend the top performing Network Monitoring software for a small IT service company like mine? Does anyone use or How do they compare to these guys I found recently: [url=] N-able N-central software inventory management
[/url] ? What is your best take in cost vs performance among those three? I need a good advice please... Thanks in advance!

Anonymous said...

google law firm

Xia Zhang said...

dong dong23 said...

louis vuitton outlet stores
louis vuitton handbags
gucci outlet
ray ban sunglasses outlet
michael kors outlet
louis vuitton handbags
louis vuitton outlet
lebron james shoes 13
louis vuitton
coach factory outlet
kobe 9
coach factory outlet
cheap nfl jerseys
coach outlet
ralph lauren outlet
jordan 13
nike sb
christian louboutin shoes
cheap oakleys
coach outlet store online
toms shoes
louis vuitton handbags
jordan retro 3
hollister clothing
michael kors outlet
michael kors canada
asics running shoes
designer handbags
beats headphones
cheap jordan shoes
michael kors outlet online
christian louboutin outlet
oakley vault
oakley vault
louis vuitton bags
nike trainers
louis vuitton outlet
jordan shoes
nike air max
michael kors outlet

raybanoutlet001 said...

ray ban sunglasses
ugg outlet
polo ralph lauren
nike outlet
ralph lauren uk
ugg outlet
louis vuitton sacs
ray ban sunglasses outlet
ray ban sunglasses

aaa kitty20101122 said...

air yeezy
prada glasses
yeezy shoes
yeezy boost 350 v2
Kanye West shoes
chrome hearts online store
adidas ultra boost
adidas neo
longchamp bags
cheap jordans