Need to change /oracle_db/db1/db_igt/arch to /oracle_db/db2/db_igt/arch/
Steps
Steps
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oracle_db/db1/db_igt/arch
Oldest online log sequence 417
Next log sequence to archive 419
Current log sequence 419
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oracle_db/db1/db_igt/arch
Oldest online log sequence 417
Next log sequence to archive 419
Current log sequence 419
select destination,STATUS from v$archive_dest where statuS='VALID';
DESTINATION STATUS
------------------------------------- ------------
/oracle_db/db1/db_igt/arch VALID
DESTINATION STATUS
------------------------------------- ------------
/oracle_db/db1/db_igt/arch VALID
SQL> alter system set log_archive_dest_1='LOCATION=/oracle_db/db2/db_igt/arch/' scope=both;
System altered.
System altered.
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oracle_db/db2/db_igt/arch/
Oldest online log sequence 417
Next log sequence to archive 419
Current log sequence 419
SQL> alter system switch logfile;
System altered.
System altered.
SQL> !ls -ltr
total 253952
-rw-r----- 1 oracle dba 260046336 Mar 6 13:59 arch0001_421_1097758151.arc
SQL> !pwd
/oracle_db/db2/db_igt/arch
No comments:
Post a Comment