{DB変更}redoログの格納先変更

https://docs.oracle.com/cd/F19136_01/admin/managing-the-redo-log.html#GUID-F593023B-3071-4776-95F2-9B8B6C6E670B

select * from v$log;
select * from v$logfile;

 

shutdown immediate;

mkdir -p /fra/orcl

mv /oradata/orcl/redo03a.log /fra/orcl/redo03a.log
mv /oradata/orcl/redo03b.log /fra/orcl/redo03b.log
ls -l /oradata/orcl
ls -l /fra/orcl

startup mount
ALTER DATABASE 
  RENAME FILE '/oradata/orcl/redo03a.log', '/oradata/orcl/redo03b.log' 
           TO '/fra/orcl/redo03a.log', '/fra/orcl/redo03b.log';

alter database open;

select * from v$log;
select * from v$logfile;

alter system switch logfile;
alter system archive log current;