follow the below steps:
step1 :shutdown immediate
step2: edit the pfile with the following
log_archive_start=true
log_archive_dest_1=’location=d:\archive_loc’
step3:startup mount
step4:alter database archivelog
step5: alter database open;
—————————————————-
shutdown immediate
edit the pfile
create spfile from pfile;
startup mount
alter database noarchivelog;
alter database open;
--that all
Tags:
Oracle Database