15 lines
666 B
Plaintext
Executable File
15 lines
666 B
Plaintext
Executable File
-- list Redologs / Standby redologs groups and members
|
|
select GROUP#,THREAD#,MEMBERS,STATUS, BYTES/(1024*1024) Mb from v$log;
|
|
select GROUP#,THREAD#,STATUS, BYTES/(1024*1024) Mb from v$standby_log;
|
|
|
|
col MEMBER for a60
|
|
select * from v$logfile;
|
|
|
|
-- create standby redologs
|
|
select 'ALTER DATABASE ADD STANDBY LOGFILE THREAD '||thread#||' size '||bytes||';' from v$log;
|
|
select distinct 'ALTER DATABASE ADD STANDBY LOGFILE THREAD '||thread#||' size '||bytes||';' from v$log;
|
|
|
|
-- clear / drop standby redologs
|
|
select 'ALTER DATABASE CLEAR LOGFILE GROUP '||GROUP#||';' from v$standby_log;
|
|
select 'ALTER DATABASE DROP STANDBY LOGFILE GROUP '||GROUP#||';' from v$standby_log;
|