注册 登录  
 加关注
   显示下一条  |  关闭
温馨提示!由于新浪微博认证机制调整,您的新浪微博帐号绑定已过期,请重新绑定!立即重新绑定新浪微博》  |  关闭

帅小伙的博客

希望能在这里交到更多的朋友

 
 
 

日志

 
 
 
 

创建物理standby过程(rman2)

2006-09-18 12:08:05|  分类: oracle |  标签: |举报 |字号 订阅

  下载LOFTER 我的照片书  |

五、在primary server对数据库进行全库备份:

 

[ora9i@ORA10G standby]$ rman

 

Recovery Manager: Release 9.2.0.4.0 - Production

 

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

 

RMAN> connect target

 

connected to target database: DBA9I (DBID=3025467786)

 

RMAN> run                                                                                        

 {

2> 3>  allocate channel ch1 type disk maxpiecesize =2G;

4>  allocate channel ch2 type disk maxpiecesize =2G;

5>  backup database filesperset 8 format '/u02/9i/standby/%d_DF_%T_%s_%p.bak';

 sql "alter system archive log current";

6> 7>  backup current controlfile for standby format '/u02/9i/standby/%d_CTL_%T_%s_%p.bak';

8>  backup archivelog all format '/u02/9i/standby/%d_ARC_%T_%s_%p.bak' delete all input;

9>  release channel ch1;

10>  release channel ch2;

11> }

 

using target database controlfile instead of recovery catalog

allocated channel: ch1

channel ch1: sid=13 devtype=DISK

 

allocated channel: ch2

channel ch2: sid=12 devtype=DISK

 ......

released channel: ch1

 

released channel: ch2

 

 

 

六、Restoring the database to the standby location

 

PRIMARY SERVER 产生的BACKUP PIECE COPY TO STANDBY SERVER的同一目录

 

 

 

 

[ora9i@ORA10G standby]$  rman target / auxiliary sys/sys@STANDBY

 

Recovery Manager: Release 9.2.0.4.0 - Production

 

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

 

connected to target database: DBA9I (DBID=3025467786)

connected to auxiliary database: dba9i (not mounted)

 

RMAN>  run

2>  {

3>    allocate auxiliary channel dup1 type disk;

   allocate auxiliary channel dup2 type disk;

4> 5>    duplicate target database for standby

6>    dorecover NOFILENAMECHECK;

7>    }

 

using target database controlfile instead of recovery catalog

allocated channel: dup1

channel dup1: sid=11 devtype=DISK

 

allocated channel: dup2

channel dup2: sid=12 devtype=DISK

 

Starting Duplicate Db at 07-MAY-04

 

printing stored script: Memory Script

{

   restore clone standby controlfile to clone_cf;

   replicate clone controlfile from clone_cf;

   sql clone 'alter database mount standby database';

}

executing script: Memory Script

 

。。。。。。

released channel: dup1

released channel: dup2

 

 

--注意期间不能有新的ARCHIVELOG 产生。

[ora9i@ORA10G standby]$ sqlplus /nolog

 

SQL*Plus: Release 9.2.0.4.0 - Production on Fri May 7 14:23:03 2004

 

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

 

SQL> conn / as sysdba;

Connected.

 

SQL> alter system set log_archive_dest_state_2=enable;

 

System altered.

 

SQL> alter system switch logfile;

 

System altered.

 

 

 

--确认archicelog 是否传送成功

 

 

 

SQL> recover standby database;

ORA-00279: change 124210 generated at 05/07/2004 14:03:17 needed for thread 1

ORA-00289: suggestion : /u02/9i/arc/1_76.dbf

ORA-00280: change 124210 for thread 1 is in sequence #76

 

 

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

auto

ORA-00279: change 124622 generated at 05/07/2004 14:24:06 needed for thread 1

ORA-00289: suggestion : /u02/9i/arc/1_77.dbf

ORA-00280: change 124622 for thread 1 is in sequence #77

ORA-00278: log file '/u02/9i/arc/1_76.dbf' no longer needed for this recovery

 

 

ORA-00279: change 124625 generated at 05/07/2004 14:24:09 needed for thread 1

ORA-00289: suggestion : /u02/9i/arc/1_78.dbf

ORA-00280: change 124625 for thread 1 is in sequence #78

ORA-00278: log file '/u02/9i/arc/1_77.dbf' no longer needed for this recovery

 

 

ORA-00279: change 124739 generated at 05/07/2004 14:29:54 needed for thread 1

ORA-00289: suggestion : /u02/9i/arc/1_79.dbf

ORA-00280: change 124739 for thread 1 is in sequence #79

ORA-00278: log file '/u02/9i/arc/1_78.dbf' no longer needed for this recovery

 

 

ORA-00279: change 124742 generated at 05/07/2004 14:29:56 needed for thread 1

ORA-00289: suggestion : /u02/9i/arc/1_80.dbf

\

 

 

 

[ora9i@ORA10G standby]$ sqlplus /nolog

 

SQL*Plus: Release 9.2.0.4.0 - Production on Fri May 7 14:33:42 2004

 

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

 

SQL> conn system/manager

Connected.

SQL> create table test(name char(20));

 

Table created.

 

SQL> insert into test values('test');

 

1 row created.

 

SQL> commit;

 

Commit complete.

 

SQL> alter system switch logfile;

 

System altered.

 

 

SQL> conn / as sysdba;

Connected.

SQL> recover standby database;

ORA-00279: change 124762 generated at 05/07/2004 14:30:42 needed for thread 1

ORA-00289: suggestion : /u02/9i/arc/1_83.dbf

ORA-00280: change 124762 for thread 1 is in sequence #83

 

 

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

auto

ORA-00279: change 124855 generated at 05/07/2004 14:34:19 needed for thread 1

ORA-00289: suggestion : /u02/9i/arc/1_84.dbf

ORA-00280: change 124855 for thread 1 is in sequence #84

ORA-00278: log file '/u02/9i/arc/1_83.dbf' no longer needed for this recovery

 

 

ORA-00279: change 124933 generated at 05/07/2004 14:38:12 needed for thread 1

ORA-00289: suggestion : /u02/9i/arc/1_85.dbf

ORA-00280: change 124933 for thread 1 is in sequence #85

ORA-00278: log file '/u02/9i/arc/1_84.dbf' no longer needed for this recovery

 

 

ORA-00308: cannot open archived log '/u02/9i/arc/1_85.dbf'

ORA-27037: unable to obtain file status

Linux Error: 2: No such file or directory

Additional information: 3

 

SQL> alter database open read only;

 

Database altered.

 

 

SQL> conn / as sysdba;

Connected.

SQL> alter database open read only;

 

Database altered.

 

SQL> select * from system.test;

 

NAME

--------------------

test

 

 

 

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup nomount;

ORACLE instance started.

 

Total System Global Area   55645264 bytes

Fixed Size                   451664 bytes

Variable Size              46137344 bytes

Database Buffers            8388608 bytes

Redo Buffers                 667648 bytes

SQL> alter database mount standby;

alter database mount standby

                           *

ERROR at line 1:

ORA-00905: missing keyword

 

 

SQL> alter database mount standby database;

 

Database altered.

 

 

SQL> recover standby database;

ORA-00279: change 124933 generated at 05/07/2004 14:38:12 needed for thread 1

ORA-00289: suggestion : /u02/9i/arc/1_85.dbf

ORA-00280: change 124933 for thread 1 is in sequence #85

 

 

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

auto

ORA-00279: change 124971 generated at 05/07/2004 14:40:05 needed for thread 1

ORA-00289: suggestion : /u02/9i/arc/1_86.dbf

ORA-00280: change 124971 for thread 1 is in sequence #86

ORA-00278: log file '/u02/9i/arc/1_85.dbf' no longer needed for this recovery

 

 

ORA-00279: change 124973 generated at 05/07/2004 14:40:07 needed for thread 1

ORA-00289: suggestion : /u02/9i/arc/1_87.dbf

ORA-00280: change 124973 for thread 1 is in sequence #87

ORA-00278: log file '/u02/9i/arc/1_86.dbf' no longer needed for this recovery

 

 

ORA-00279: change 124976 generated at 05/07/2004 14:40:12 needed for thread 1

ORA-00289: suggestion : /u02/9i/arc/1_88.dbf

ORA-00280: change 124976 for thread 1 is in sequence #88

ORA-00278: log file '/u02/9i/arc/1_87.dbf' no longer needed for this recovery

 

 

ORA-00279: change 124978 generated at 05/07/2004 14:40:14 needed for thread 1

ORA-00289: suggestion : /u02/9i/arc/1_89.dbf

ORA-00280: change 124978 for thread 1 is in sequence #89

ORA-00278: log file '/u02/9i/arc/1_88.dbf' no longer needed for this recovery

 

 

ORA-00308: cannot open archived log '/u02/9i/arc/1_89.dbf'

ORA-27037: unable to obtain file status

Linux Error: 2: No such file or directory

Additional information: 3

 

 

 

 

 

 

 

SQL> alter database activate standby database;

 

Database altered.

 

SQL> shutdown immediate;

ORA-01507: database not mounted

 

 

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

 

Total System Global Area   55645264 bytes

Fixed Size                   451664 bytes

Variable Size              46137344 bytes

Database Buffers            8388608 bytes

Redo Buffers                 667648 bytes

Database mounted.

Database opened.

 

 

  评论这张
 
阅读(162)| 评论(0)
推荐 转载

历史上的今天

评论

<#--最新日志,群博日志--> <#--推荐日志--> <#--引用记录--> <#--博主推荐--> <#--随机阅读--> <#--首页推荐--> <#--历史上的今天--> <#--被推荐日志--> <#--上一篇,下一篇--> <#-- 热度 --> <#-- 网易新闻广告 --> <#--右边模块结构--> <#--评论模块结构--> <#--引用模块结构--> <#--博主发起的投票-->
 
 
 
 
 
 
 
 
 
 
 
 
 
 

页脚

网易公司版权所有 ©1997-2018