本文章是给自己做工具手册用的,所以写的不是很详细。
基本名词:
ARCH、LGWR、LNS(10G)、MRP、LSP、AFFIRM、NOAFFIRM、SYNC、ASYNC、DELAY、REOPEN
相关视图:
v$standby_log、v$archive_dest、v$archive_gap、v$managed_standby
相关SQL:
recover automatic standby database;
recover managed standby database disconnect from session;
select max(a.sequence#), max(b.sequence#) from v$archived_log a, v$log b where a.dest_id=2 and b.archived='YES';
alter database recover managed standby database parallel 8 disconnect from session;
alter database recover managed standby database finish;
alter database recover managed standby database finish skip standby logfile;
alter database activate standby database;
alter database activate standby database skip standby logfile;
alter database create datafile file# as 'filepath';
其他:
rac中standby log数量:(每线程的日志组数+1)*最大线程数
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/339291/viewspace-442855/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/339291/viewspace-442855/