RMAN--spool log command

在RMAN中，不管你用那一個command來顯示我們想查看的信息都有可能超出我們的screen顯示的區域在oracle 9i 用spool log來生成一個文件，這樣更方便我們查看

相關的命令如下:

RMAN> spool log to '/cfs01/tmp/rep.log';
RMAN> report obsolete;
RMAN> spool log off;

RMAN> host 'more /cfs01/tmp/rep.log';

實例

RMAN> spool log to '/cfs01/tmp/rep.log';
RMAN> report obsolete;
RMAN> spool log off;

Spooling for log turned off

Recovery Manager: Release 9.2.0.5.0 - Production

RMAN> host 'more /cfs01/tmp/rep.log';

Spooling started in log file: /cfs01/tmp/rep.log

Recovery Manager: Release 9.2.0.5.0 - Production

RMAN>
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 3
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           6      12-DEC-04
  Backup Piece       42     12-DEC-04          /cfs01/rman/cf/c-2555106477-20041212-02
Backup Set           8      13-DEC-04
  Backup Piece       44     13-DEC-04          /cfs01/rman/cf/c-2555106477-20041213-00
Backup Set           10     13-DEC-04
  Backup Piece       47     13-DEC-04          /cfs01/rman/cf/c-2555106477-20041213-01
Backup Set           12     14-DEC-04
  Backup Piece       50     14-DEC-04          /cfs01/rman/cf/c-2555106477-20041214-00
Backup Set           14     14-DEC-04
  Backup Piece       55     14-DEC-04          /cfs01/rman/cf/c-2555106477-20041214-01
Backup Set           16     15-DEC-04
  Backup Piece       58     15-DEC-04          /cfs01/rman/cf/c-2555106477-20041215-00
Backup Set           18     15-DEC-04
  Backup Piece       63     15-DEC-04          /cfs01/rman/cf/c-2555106477-20041215-01
Backup Set           20     16-DEC-04
  Backup Piece       67     16-DEC-04          /cfs01/rman/cf/c-2555106477-20041216-00
Backup Set           22     16-DEC-04
  Backup Piece       71     16-DEC-04          /cfs01/rman/cf/c-2555106477-20041216-01
Backup Set           24     17-DEC-04
  Backup Piece       73     17-DEC-04          /cfs01/rman/cf/c-2555106477-20041217-00
Backup Set           26     17-DEC-04
  Backup Piece       77     17-DEC-04          /cfs01/rman/cf/c-2555106477-20041217-01
Backup Set           28     18-DEC-04
  Backup Piece       79     18-DEC-04          /cfs01/rman/cf/c-2555106477-20041218-00
Backup Set           30     18-DEC-04
  Backup Piece       83     18-DEC-04          /cfs01/rman/cf/c-2555106477-20041218-01
Backup Set           32     19-DEC-04
  Backup Piece       86     19-DEC-04          /cfs01/rman/cf/c-2555106477-20041219-00
Backup Set           34     19-DEC-04
  Backup Piece       123    19-DEC-04          /cfs01/rman/cf/c-2555106477-20041219-01
Controlfile Copy     1      06-OCT-04          /tmp/control.bak
Controlfile Copy     39     13-DEC-04          /cfs01/rman/cf/control.1213

RMAN>
host command complete

RMAN＞

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29987/viewspace-51628/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29987/viewspace-51628/