1. Shutdown the Database
shutdown immediate
2. start the Database in mount mode
startup mount
3. enable the Database in archive log mode
alter database archivelog;
4. open the Database
alter database open;
5. If need to change the log_archive_dest_1 path then
SQL> alter system set log_archive_dest_1='/home/oracle/archivelog' scope=spfile;
alter system set log_archive_dest_1='/home/oracle/archivelog' scope=spfile
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-16179: incremental changes to "log_archive_dest_1" not allowed with SPFIL
the solution
alter system set log_archive_dest_1='location=/u01/app/oracle/archivelog' scope=spfile;
System altered.
Cheer!!!!!!!!!!
No comments:
Post a Comment