同事对ora11g很感兴趣,把俺的vmware环境copy了过去,可他不小心把spfile给删除了--说是清除空间
和其他版本一样,不能启动,俺好奇就打算看看11g有没这方面的增强功能,果然找到
create spfile from memory;
成功打开ora11g
*******20071110****add********
杂志上没有
不通过ctl实现
***********************************
RMAN> backup spfile;
Starting backup at 06-NOV-07
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 06-NOV-07
channel ORA_DISK_1: finished piece 1 at 06-NOV-07
piece handle=/u01/app/oracle/flash_recovery_area/ORA11G/backupset/2007_11_06/o1_mf_nnsnf_TAG20071106T152637_3m05sjxx_.bkp tag=TAG20071106T152637 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 06-NOV-07
Starting Control File and SPFILE Autobackup at 06-NOV-07
piece handle=/u01/app/oracle/flash_recovery_area/ORA11G/autobackup/2007_11_06/o1_mf_s_637946803_3m05spg5_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 06-NOV-07
欢迎补充和指正(spfile)
