oracle archivelog 学习笔记

最新推荐文章于 2024-07-18 07:05:32 发布

cuixiao8282

最新推荐文章于 2024-07-18 07:05:32 发布

阅读量121

点赞数

文章标签：数据库

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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29622945/viewspace-1377492/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29622945/viewspace-1377492/