sql> startup open restrict;
sql> select group#, bytes, status from v$log;
sql> select group#, member from v$logfile;
sql> alter database add logfile group 4 '/usr/oracle/dbs/log4jinn.dbf' size 100m;
...
sql> alter system switch logfile;
sql> alter database drop logfile group 1;
...
sql> !rm /usr/oracle/dbs/log1jinn.dbf';
sql> alter ssytem disable restricted session; [@more@]
sql> select group#, bytes, status from v$log;
sql> select group#, member from v$logfile;
sql> alter database add logfile group 4 '/usr/oracle/dbs/log4jinn.dbf' size 100m;
...
sql> alter system switch logfile;
sql> alter database drop logfile group 1;
...
sql> !rm /usr/oracle/dbs/log1jinn.dbf';
sql> alter ssytem disable restricted session; [@more@]
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/205087/viewspace-786825/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
