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;