Rename, Recreate or Move REDO Logs

July 30, 2012 admin Uncategorized

Basic concept behind steps shown below:
alter database add logfile.
alter database switch logfile.
Query v$log, and if it shows ‘notactive’, then:
alter database delete logfile.
(remove the file at os level).
REPEAT.

Set new schema Using the shared pool advisor in 9.2+. The v$shared_pool_advice view.