Wednesday, June 3, 2009

Switch log file manually:

ALTER DATABASE ADD LOGFILE group 1 ('/U02/CAFOS/cafosredo/log01a.dbf') SIZE 512M;
ALTER DATABASE ADD LOGFILE group 2 ('/U02/CAFOS/cafosredo/log02a.dbf') SIZE 512M;
ALTER DATABASE ADD LOGFILE group 3 ('/U02/CAFOS/cafosredo/log03a.dbf') SIZE 512M;
ALTER DATABASE ADD LOGFILE group 4 ('/U02/CAFOS/cafosredo/log04a.dbf') SIZE 512M;
ALTER DATABASE ADD LOGFILE group 5 ('/U02/CAFOS/cafosredo/log05a.dbf') SIZE 512M;
alter system switch logfile;
alter system switch logfile;
alter system switch logfile;
alter system switch logfile;
alter system switch logfile;
## Now wait until logfile groups 6-10 have ALL become INACTIVE, and have been archived off to /hot_bkup/CAFOS/archive !!
ALTER DATABASE DROP LOGFILE GROUP 6;
ALTER DATABASE DROP LOGFILE GROUP 7;
ALTER DATABASE DROP LOGFILE GROUP 8;
ALTER DATABASE DROP LOGFILE GROUP 9;
ALTER DATABASE DROP LOGFILE GROUP 10;
Now: /U04/CAFOS/cafosredo/log01*.dbf can be removed.
Mohammed Riyaz Ahmed Khan
“The PATHAN Boy”

0 comments: