RDS Oracle DB REDO dodanie, usuniecie itd.

— dodanie plikow

EXEC rdsadmin.rdsadmin_util.add_logfile(p_size => '500M');
EXEC rdsadmin.rdsadmin_util.add_logfile(p_size => '500M');
EXEC rdsadmin.rdsadmin_util.add_logfile(p_size => '500M');
EXEC rdsadmin.rdsadmin_util.add_logfile(p_size => '500M');

— switchlog-a

EXEC rdsadmin.rdsadmin_util.switch_logfile;

— checkpoint

EXEC rdsadmin.rdsadmin_util.checkpoint;

— drop starych

EXEC rdsadmin.rdsadmin_util.drop_logfile(grp => 1);
EXEC rdsadmin.rdsadmin_util.drop_logfile(grp => 2);
EXEC rdsadmin.rdsadmin_util.drop_logfile(grp => 3);
EXEC rdsadmin.rdsadmin_util.drop_logfile(grp => 4);

— weryfikacja

select * from v$logfile;
select log.group#,log.members,log.status,bytes/1024/1024 as mb, logfile.member, log.archived from v$log log left join v$logfile logfile on log.group# = logfile.group#;