1.select *from v$log;
2.select *from v$logfile;
3.alter database add logfile member 'D:\app\maxine\oradata\smart\log\redo01.log' to group 1;
alter database add logfile member 'D:\app\maxine\oradata\smart\log\redo02.log' to group 2;
alter database add logfile member 'D:\app\maxine\oradata\smart\log\redo03.log' to group 3;
select * from dba_hist_log order by sequence#;
4.alter system set log_archive_dest_1='location=D:\app\archlog';
alter system set log_archive_dest_10='location=USE_DB_RECOVERY_FILE_DEST';
5.show parameter log_arch
2.select *from v$logfile;
3.alter database add logfile member 'D:\app\maxine\oradata\smart\log\redo01.log' to group 1;
alter database add logfile member 'D:\app\maxine\oradata\smart\log\redo02.log' to group 2;
alter database add logfile member 'D:\app\maxine\oradata\smart\log\redo03.log' to group 3;
select * from dba_hist_log order by sequence#;
4.alter system set log_archive_dest_1='location=D:\app\archlog';
alter system set log_archive_dest_10='location=USE_DB_RECOVERY_FILE_DEST';
5.show parameter log_arch
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29622945/viewspace-1377492/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
oracle 锁 学习笔记
请登录后发表评论
登录
全部评论
