dataguard备机更改redo 位置

#mount 状态修改日志文件名称：

SQL> select open_mode,DATABASE_ROLE from v$database;

OPEN_MODE DATABASE_ROLE
-------------------- ----------------
MOUNTED PHYSICAL STANDBY


#redo文件状态
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------ ---------
1 1 115 52428800 512 1 NO CURRENT 3769973 28-JUL-22 2.8147E+14
3 1 114 52428800 512 1 NO INACTIVE 3744793 28-JUL-22 3769973 28-JUL-22
2 1 113 52428800 512 1 NO INACTIVE 3708300 27-JUL-22 3744793 28-JUL-22


select member from v$logfile;

MEMBER
--------------------------------------------------------------------------------
/home/oracle/app/oracle/oradata/helowin/redo03.log
/home/oracle/app/oracle/oradata/helowin/redo02.log
/home/oracle/app/oracle/oradata/helowin/redo01.log

#修改文件位置：
alter database rename file '/home/oracle/app/oracle/oradata/helowin/redo03.log' to '/home/oracle/test/redo03.log';
alter database rename file '/home/oracle/app/oracle/oradata/helowin/redo02.log' to '/home/oracle/test/redo02.log';
alter database rename file '/home/oracle/app/oracle/oradata/helowin/redo01.log' to '/home/oracle/test/redo01.log';

select member from v$logfile;

MEMBER
--------------------------------------------------------------------------------
/home/oracle/test/redo03.log
/home/oracle/test/redo02.log
/home/oracle/test/redo01.log



#生成redo日志文件，重新初始日志文件：
alter database clear logfile group 1;
alter database clear logfile group 2;
alter database clear logfile group ;