setp1. shutdown clearly
setp2.startup mount
setp3.alter database archielog/noarchivelog
setp4.alter system archive log start(启动自动存档)[archive log start/ter system archive log all]
setp5.alter database open;
setp2.startup mount
setp3.alter database archielog/noarchivelog
setp4.alter system archive log start(启动自动存档)[archive log start/ter system archive log all]
setp5.alter database open;
1.关闭数据库
2.在初始化参数文件中设置相关参数,包括是否启用自动归档,归档目标,归档文件格式,归档进程数
如:
# Archive parameters
log_archive_start = true
# log_archive_start = false
log_archive_dest_1 = 'location=f:\oracle\oradata\backup\arc1'
log_archive_dest_2 = 'location=f:\oracle\oradata\backup\arc2'
log_archive_format = arch_%t_%s.arc
# log_archive_max_processes = 33.startup mount;
4.alter database archivelog;
5.alter database open;
但在 startup mount和startup时提示:未初始化服务句柄,内部错误,hostdef扩展名不存在。
这是什么原因?该怎么处理???
SQL>conn sys as sysdba;修改初始化参数,设置自动归档:
SQL>alter system set log_archive_start=true scope=spfile;
也可以设置归档格式与路径:
SQL>alter system set log_archive_format='%t_%s.log' scope=spfile--归档格式
SQL>alter system set log_archive_dest='your path' --指定归档路径重启动数据库至装载状态:
SQL>shutdown immediate
SQL>startup mount将数据库置为归档模式:
SQL>alter database archivelog;查看是否归档:
SQL>archive log list;打开数据库:
SQL>alter database open;