oracle registers,有没有办法一次register 某个目录下全部logfile

本帖最后由 chensq 于 2012-7-6 15:55 编辑

[root@as51 arch]# ls -l $PWD/*dbf|grep -v ls|awk '{print "alter database register logfile  "$9"; "}'

alter database register logfile  /arch/1_353_777854430.dbf;

alter database register logfile  /arch/1_354_777854430.dbf;

alter database register logfile  /arch/1_355_777854430.dbf;

alter database register logfile  /arch/1_356_777854430.dbf;

alter database register logfile  /arch/1_357_777854430.dbf;

alter database register logfile  /arch/1_358_777854430.dbf;

alter database register logfile  /arch/1_359_777854430.dbf;

alter database register logfile  /arch/1_360_777854430.dbf;

alter database register logfile  /arch/1_361_777854430.dbf;

alter database register logfile  /arch/1_362_777854430.dbf;

alter database register logfile  /arch/1_363_777854430.dbf;

alter database register logfile  /arch/1_364_777854430.dbf;

alter database register logfile  /arch/1_365_777854430.dbf;

alter database register logfile  /arch/1_366_777854430.dbf;

alter database register logfile  /arch/1_367_777854430.dbf;

alter database register logfile  /arch/1_368_777854430.dbf;

alter database register logfile  /arch/1_369_777854430.dbf;

alter database register logfile  /arch/1_370_777854430.dbf;

alter database register logfile  /arch/1_371_777854430.dbf;

alter database register logfile  /arch/1_372_777854430.dbf;

alter database register logfile  /arch/2_212_777854430.dbf;

alter database register logfile  /arch/2_213_777854430.dbf;

alter database register logfile  /arch/2_214_777854430.dbf;

alter database register logfile  /arch/2_215_777854430.dbf;

alter database register logfile  /arch/2_216_777854430.dbf;

alter database register logfile  /arch/2_217_777854430.dbf;

alter database register logfile  /arch/2_218_777854430.dbf;

alter database register logfile  /arch/2_219_777854430.dbf;

alter database register logfile  /arch/2_220_777854430.dbf;