oracle9 备份,Oracle9i新特点-从自动备份中恢复spfile和控制文件

RMAN> configure controlfile autobackup on;

old RMAN configuration parameters:

CONFIGURE CONTROLFILE AUTOBACKUP OFF;

new RMAN configuration parameters:

CONFIGURE CONTROLFILE AUTOBACKUP ON;

new RMAN configuration parameters are successfully stored

RMAN> run

2> {

3> allocate channel ch1 type disk format='e:\oracle\orabak\penny%t.arc';

4> backup archivelog all delete all input;

5> release channel ch1;

6> }

allocated channel: ch1

channel ch1: sid=13 devtype=DISK

Starting backup at 02-DEC-03

current log archived

channel ch1: starting archive log backupset

channel ch1: specifying archive log(s) in backup set

input archive log thread=1 sequence=63 recid=168 stamp=511712617

input archive log thread=1 sequence=64 recid=169 stamp=511712620

input archive log thread=1 sequence=65 recid=170 stamp=511712626

input archive log thread=1 sequence=66 recid=171 stamp=511712690

channel ch1: starting piece 1 at 02-DEC-03

channel ch1: finished piece 1 at 02-DEC-03

piece handle=E:\ORACLE\ORABAK\PENNY511712693.ARC comment=NONE

channel ch1: backup set complete, elapsed time: 00:00:03

channel ch1: deleting archive log(s)

archive log filename=E:\ORACLE\ORADATA\PENNY\ARCHIVE\1_63.DBF recid=168 stamp=511712617

archive log filename=E:\ORACLE\ORADATA\PENNY\ARCHIVE\1_64.DBF recid=169 stamp=511712620

archive log filename=E:\ORACLE\ORADATA\PENNY\ARCHIVE\1_65.DBF recid=170 stamp=511712626

archive log filename=E:\ORACLE\ORADATA\PENNY\ARCHIVE\1_66.DBF recid=171 stamp=511712690

Finished backup at 02-DEC-03

Starting Control File and SPFILE Autobackup at 02-DEC-03

piece handle=E:\ORACLE\ORA92\DATABASE\C-3627775766-20031202-01 comment=NONE

Finished Control File and SPFILE Autobackup at 02-DEC-03

released channel: ch1