I have oracle 11g express in machine & i want to change archive destination.
Step 1 Before Execute below script i have below screen output
SQL>
archive log list;
Database log mode
Archive Mode
Automatic archival
Enabled
Archive destination
USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence
1
Next log sequence to archive
2
Current log sequence
2
Step 2 After execute script to change archive destination, i have below screen output
SQL>
ALTER SYSTEM SET log_archive_dest_1='LOCATION=c:\arch\arch\';
System altered.
SQL>
archive log list;
Database log mode
Archive Mode
Automatic archival
Enabled
Archive destination
c:\arch\arch\
Oldest online log sequence
1
Next log sequence to archive
2
Current log sequence
2
Now i have again shutdown and start my database instance then why my settings has been re change as previous stage as on first screen.
Overall i'm not able to change archive destination.
Step 3 Getting back below archive destination location
SQL>
shutdown immediate;
ORA-01109:
database not open
Database dismounted.
ORACLE instance shut down.
SQL>
startup mount;
ORACLE instance started.
Total System Global Area
1068937216 bytes
Fixed Size
2260048 bytes
Variable Size
616563632 bytes
Database Buffers
444596224 bytes
Redo Buffers
5517312 bytes
Database mounted.
SQL>
archive log list;
Database log mode
Archive Mode
Automatic archival
Enabled
Archive destination
USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence
1
Next log sequence to archive
2
Current log sequence
2