kckumar

 Profile Answers by kckumar 

• Jan 4th, 2007

 

answer is C
u have to start the database in mount stage.........

Mohammed Abdul Afroze

• Oct 31st, 2007

 

Enabling the database from Noarchivelog Mode to Archivelog Mode(Oracle 9i).

1.Before shutting the db check it no other user should access the database.
2.Shutdown the Database
3.Edit the init<prod>.ora file and enable all the three parameters.

(a)log_archive_start=true
(b)log_archive_dest=/u01/oradata/prod/arch
(c)log_archive_format="%S.arch"
(d)and create a directory of arch to generate all the archive log files.

4.Start the database in mount stage
sql>startup mount

5.And Bring the database into archivelog mode.
sql>alter database archivelog

6.Check it whether the database in archivelog mode.
sql>archive log list

7.Open the database.