首先
shutdown;
修改init.ora 文件
archive_log_start=true
archive_log_dest_1='oracle\backup\arc1'
archive_log_dest_2='oracle\backup\arc2'
再次
start mount;
alter database archivelog;
alter database open;
shutdown;
修改init.ora 文件
archive_log_start=true
archive_log_dest_1='oracle\backup\arc1'
archive_log_dest_2='oracle\backup\arc2'
再次
start mount;
alter database archivelog;
alter database open;
setp2.startup mount
setp3.alter database archielog/noarchivelog
setp4.alter databse archivelog;
setp5.alter system archive log start(启动自动存档)[archive log start/alter system archive log all]
setp6.alter database open;
setp7.full db backup
shutdown;
http://community.csdn.net/Expert/topic/3868/3868990.xml?temp=.6198999