梦想有多远

备库的启动和关闭

启动：

startup nomount

alter database mount standby database

alter database recover managed standby database disconnect from session;

关闭

alter database recover managed standby database cancel

shutdown immediate;

(全文…)

• 先介绍下managed_standby和日志应用有关

desc v$managed_standby;
 Name                                      Null?    Type
 —————————————– ——– —————————-
 PROCESS                                            VARCHAR2(9)
 PID                                                NUMBER
 STATUS                                             VARCHAR2(12)
 CLIENT_PROCESS                                     VARCHAR2(8)
 CLIENT_PID                                         VARCHAR2(40)
 CLIENT_DBID                                        VARCHAR2(40)
 GROUP#                                             VARCHAR2(40)
 RESETLOG_ID                                        NUMBER
 THREAD#                                            NUMBER
 SEQUENCE#                                          NUMBER
 BLOCK#                                             NUMBER
 BLOCKS                                             NUMBER
 DELAY_MINS                                         NUMBER
 KNOWN_AGENTS                                       NUMBER
 ACTIVE_AGENTS                                      NUMBER通过我们都会查看PROCESS,STATUSSQL> select process,status from v$managed_standby; PROCESS   STATUS——— ————ARCH      CLOSINGARCH      CLOSINGRFS       IDLEMRP0      WAIT_FOR_LOGRFS       IDLERFS       IDLE

其中process列如下选项：

(全文…)

经过几天的折腾，自己的备库终于算搞好了，以前很模糊的概念，经过这次折腾也理解的差不多了。

系统环境和数据库版本

VM+CENT OS 4.4+ORACLE 10.2 FOR LINUX 32

先说下创建步骤吧

一，首先把备库的系统和ORACLE软件安装好，并建好相关目录。比如说

/u01/app/admin/orcl/bdump

/u01/app/admin/orcl/adump

/u01/app/admin/orcl/cdump

‘/u01/app/admin/orcl/bdump

/u01/app/oradata/orcl

/u01/app/flash_recovery_area/

/u01/app/flash_recovery_area/ORCL/archivelog 我的日志存储位置

二、在主库创建数据全备和备库控制文件

注意在备库创建的备份位置，和要主库备份位置一样

登陆rman做全库备份和STANDBY控制文件

backup full database format=‘/u01/app/backup/fulldatabase_%U.dbf‘ include current controlfile for standby;

(全文…)