oracle重做日志改为归档模式
1：查看数据库的当前模式archive log list;
注意用sqlplus 黑屏登录，pl developer好像有问题
用户名：sys
密码：zqs520 as sysdba
2:关闭数据库
shutdown immediate
3:以加载方式启动数据库
startup mount
4:查看数据库运行的状态
archive log list
5:写个备份脚本basedbak.sql放在 d:\oracle\mgt\
connect system /oracle as sysdba
shutdown immediate
host copy f:\oracle\product \10.2.0\oradate\moon\*.* f:\hostbackup\
host copy f:\oracle\product\10.2.0\db_1\dbs\spfilemoon.ora f:\hotbackup\dbs
host copy f:\oracle\product\10.2.0\db_1\database\pwdmoon.ora f:\hotbackup\database
host copy f:\disk\moon\pioneer_data.dbf f:\hotback\disk3\
host copy f:\disk\moon\pioneer_indx.dbf f:\hotbackup\disk4\
startup
6:运行脚本 @f:\oracle\mnt\basedbak
页:
[1]