Oracle Database Discussions

respected members,

i have oracle 9.2.0.1.0 on widows server 2003.

the database is in NOARCHIVELOG MODE . i want to convert it into ARCHIVELOG MODE

The steps to convert database to ARCHIVELOG MODE which i read in most of the books are as follows

1.shutdown immediate;
2.startup mount;
3.Alter database archivelog;
4.Alter database open.


but i have some confusion with these commands. With this archivelogs will be sent to default location dont know where.

What i think is our database is in NOARCHIVELOG MODE and it is in open in read write mode.

I run these commands
1.alter system set log_archive_dest_state_1 = 'enable' scope=spfile;
2.alter system set log_archive_dest_1 = 'location=p:\oracle\sid\archives\' scope=spfile;

after this (we repeat sama steps above 1-4)

1.shutdown immediate;
2.startup mount;
3.Alter database archivelog;
4.Alter database open.

i am writing dest_1 bcz in future i want to make a standby database for this.

plz verify that am i correct or plz guide me

regards rehan