查看: 26216|回复: 51

[精华] Oracle 11g在Windows与Linux异构平台下的DATA GURAD配置

[复制链接]
论坛徽章:
151
2014年新春福章
日期:2014-04-17 11:38:13奥运会纪念徽章:皮划艇静水
日期:2012-07-31 15:42:58奥运会纪念徽章:田径
日期:2012-07-10 16:21:10奥运会纪念徽章:跆拳道
日期:2012-06-20 22:07:29奥运会纪念徽章:皮划艇静水
日期:2012-06-16 02:55:21奥运会纪念徽章:曲棍球
日期:2012-06-13 10:09:19蛋疼蛋
日期:2012-05-19 23:20:41迷宫蛋
日期:2012-05-16 17:35:25版主2段
日期:2012-05-15 15:24:11双黄蛋
日期:2012-03-19 19:34:04
发表于 2007-12-13 12:31 | 显示全部楼层 |阅读模式
从Oracle 11g开始,ORACLE支持在特定条件下WINDOWS与LINUX两个不同OS平台之间配置DATA GUARD,这样DATA GUARD再也不受原来需要同样OS平台的限制了。今天测试了一下这个配置,以下是配置过程:

主库:Windows 2003 +Oracle 11.1.0.6
SID : orcl
数据文件目录:D:\ORACLE\ORADATA\ORCL\
备用库:RHEL 4 U5+Oracle 11.1.0.6
SID:standby
数据文件目录:/home/oracle/opt/oradata/standby/

1、验证主库是归档模式,并将主库置于FORCE LOGGING模式:

SQL*Plus: Release 11.1.0.6.0 - Production on 星期三 12月 12 10:33:51 2007

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     229
Next log sequence to archive   231
Current log sequence           231

SQL> alter database force logging;

Database altered.

2、对主库做一个全库的RMAN备份,用于STANDBY配置:

C:\Documents and Settings\Administrator>rman target /

Recovery Manager: Release 11.1.0.6.0 - Production on 星期三 12月 12 10:40:12 2007

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: ORCL (DBID=1165203189)
RMAN> backup database format 'd:\db_%U.bak';

Starting backup at 12-12月-07
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=98 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00002 name=D:\ORACLE\ORADATA\ORCL\SYSAUX01.DBF
input datafile file number=00001 name=D:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF
input datafile file number=00004 name=D:\ORACLE\ORADATA\ORCL\USERS01.DBF
input datafile file number=00003 name=D:\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF
input datafile file number=00005 name=D:\ORACLE\ORADATA\ORCL\EXAMPLE01.DBF
channel ORA_DISK_1: starting piece 1 at 12-12月-07
channel ORA_DISK_1: finished piece 1 at 12-12月-07
piece handle=D:\DB_04J3DK0Q_1_1.BAK tag=TAG20071212T104026 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:02:55
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 12-12月-07
channel ORA_DISK_1: finished piece 1 at 12-12月-07
piece handle=D:\DB_05J3DK6N_1_1.BAK tag=TAG20071212T104026 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 12-12月-07

3、准备STANDBY数据文件路径和其他路径:
[oracle@test51 oradata]$ pwd  
/home/oracle/opt/oradata
[oracle@test51 oradata]$ mkdir standby
[oracle@test51 oradata]$ cd standby
[oracle@test51 oradata]$ mkdir archive
[oracle@test51 oradata]$ cd $ORACLE_BASE/admin
[oracle@test51 admin]$ mkdir standby
[oracle@test51 oradata]$ cd standby
[oracle@test51 standby]$mkdir adump
[oracle@test51 standby]$mkdir dpdump
[oracle@test51 standby]$mkdir pfile
[oracle@test51 standby]$ ls
adump  dpdump  pfile
论坛徽章:
151
2014年新春福章
日期:2014-04-17 11:38:13奥运会纪念徽章:皮划艇静水
日期:2012-07-31 15:42:58奥运会纪念徽章:田径
日期:2012-07-10 16:21:10奥运会纪念徽章:跆拳道
日期:2012-06-20 22:07:29奥运会纪念徽章:皮划艇静水
日期:2012-06-16 02:55:21奥运会纪念徽章:曲棍球
日期:2012-06-13 10:09:19蛋疼蛋
日期:2012-05-19 23:20:41迷宫蛋
日期:2012-05-16 17:35:25版主2段
日期:2012-05-15 15:24:11双黄蛋
日期:2012-03-19 19:34:04
 楼主| 发表于 2007-12-13 12:31 | 显示全部楼层
4、生成standby 初始化参数文件:
SQL> create pfile='d:/init.ora' from spfile;

File created.

添加以下几个STANDBY参数:

*.log_archive_config='DG_CONFIG=(orcl,standby)'
*.fal_client='standby'
*.fal_server='primary'
*.db_file_name_convert='D:\ORACLE\ORADATA\ORCL\','/home/oracle/opt/oradata/standby/'
*.log_file_name_convert='D:\ORACLE\ORADATA\ORCL\','/home/oracle/opt/oradata/standby/'
*.standby_file_management='auto'
*.log_archive_dest_1='location=/home/oracle/opt/oradata/standby/archive VALID_FOR=(STANDBY_LOGFILE,STANDBY_ROLE)'

完整的STANDBY端参数如下:

standby.__db_cache_size=234881024
standby.__java_pool_size=12582912
standby.__large_pool_size=4194304
standby.__oracle_base='/home/oracle/opt'#ORACLE_BASE set from environment
standby.__pga_aggregate_target=209715200
standby.__sga_target=629145600
standby.__shared_io_pool_size=0
standby.__shared_pool_size=369098752
standby.__streams_pool_size=0
*.audit_file_dest='/home/oracle/opt/admin/standby/adump'
*.audit_trail='db'
*.compatible='11.1.0.0.0'
*.control_files='/home/oracle/opt/oradata/standby/control01.ctl','/home/oracle/opt/oradata/standby/control02.ctl','/home/oracle/opt/oradata/standby/control03.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='orcl'
*.db_recovery_file_dest='/home/oracle/opt/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.db_unique_name='standby'
*.ddl_lock_timeout=10
*.diagnostic_dest='/home/oracle/opt'
*.dispatchers=''
*.job_queue_processes=0
*.memory_target=838860800
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'

*.log_archive_config='DG_CONFIG=(orcl,standby)'
*.fal_client='standby'
*.fal_server='primary'
*.db_file_name_convert='D:\ORACLE\ORADATA\ORCL\','/home/oracle/opt/oradata/standby/'
*.log_file_name_convert='D:\ORACLE\ORADATA\ORCL\','/home/oracle/opt/oradata/standby/'
*.standby_file_management='auto'
*.log_archive_dest_1='location=/home/oracle/opt/oradata/standby/archive VALID_FOR=(STANDBY_LOGFILE,STANDBY_ROLE)'


5、生成STANDBY控制文件:

SQL> alter database create standby controlfile as 'd:\ control01.ctl';

Database altered.

并将生成的STANDBY控制文件、初始化参数文件、备份集分别COPY至STANDBY端相应的目录,另外注意密码文件也需要COPY并在STANDBY端改名,因为主库和备库需要相同的密码文件,否则STANDBY无法配置成功:

[oracle@test51 standby]$ cp control01.ctl control02.ctl
[oracle@test51 standby]$ cp control01.ctl control03.ctl
[oracle@test51 standby]$ ls
archive control01.ctl  control02.ctl  control03.ctl  db_04j3dk0q_1_1.bak db_05j3dk6n_1_1.bak

6、在STANDBY端MOUNT STANDBY数据库,可以看到从WINDOWS COPY过来的备份控制文件可以直接在LINUX底下MOUNT成功:

idle> startup mount pfile='/home/oracle/opt/admin/standby/pfile/init_standby.ora';
ORACLE instance started.

Total System Global Area  836976640 bytes
Fixed Size                  1303132 bytes
Variable Size             595594660 bytes
Database Buffers          234881024 bytes
Redo Buffers                5197824 bytes
Database mounted.

使用道具 举报

回复
论坛徽章:
151
2014年新春福章
日期:2014-04-17 11:38:13奥运会纪念徽章:皮划艇静水
日期:2012-07-31 15:42:58奥运会纪念徽章:田径
日期:2012-07-10 16:21:10奥运会纪念徽章:跆拳道
日期:2012-06-20 22:07:29奥运会纪念徽章:皮划艇静水
日期:2012-06-16 02:55:21奥运会纪念徽章:曲棍球
日期:2012-06-13 10:09:19蛋疼蛋
日期:2012-05-19 23:20:41迷宫蛋
日期:2012-05-16 17:35:25版主2段
日期:2012-05-15 15:24:11双黄蛋
日期:2012-03-19 19:34:04
 楼主| 发表于 2007-12-13 12:32 | 显示全部楼层
7、RESTORE  STANDBY数据库:
[oracle@test51 bin]$ export ORACLE_SID=standby

由于控制文件里面记录的备份信息还是在WINDOWS上主库的备份信息,我们需要使用RMAN的catalog命令来使RMAN认出在STANDBY端从WINDOWS主库COPY过来的备份集:

[oracle@test51 bin]$ ./rman target /         

Recovery Manager: Release 11.1.0.6.0 - Production on Wed Dec 12 11:44:29 2007

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: ORCL (DBID=1165203189, not open)

RMAN> list backup;

using target database control file instead of recovery catalog

List of Backup Sets
===================
BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3       Full    1.75G      DISK        00:03:03     12-DEC-07      
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: TAG20071212T104026
        Piece Name: D:\DB_04J3DK0Q_1_1.BAK
  List of Datafiles in backup set 3
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 8852434    12-DEC-07 D:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF
  2       Full 8852434    12-DEC-07 D:\ORACLE\ORADATA\ORCL\SYSAUX01.DBF
  3       Full 8852434    12-DEC-07 D:\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF
  4       Full 8852434    12-DEC-07 D:\ORACLE\ORADATA\ORCL\USERS01.DBF
  5       Full 8852434    12-DEC-07 D:\ORACLE\ORADATA\ORCL\EXAMPLE01.DBF

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4       Full    9.64M      DISK        00:00:17     12-DEC-07      
        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: TAG20071212T104026
        Piece Name: D:\DB_05J3DK6N_1_1.BAK
  SPFILE Included: Modification time: 30-NOV-07
  SPFILE db_unique_name: ORCL
  Control File Included: Ckp SCN: 8852584      Ckp time: 12-DEC-07

RMAN> catalog start with '/home/oracle/opt/oradata/standby';

using target database control file instead of recovery catalog
searching for all files that match the pattern /home/oracle/opt/oradata/standby

List of Files Unknown to the Database
=====================================
File Name: /home/oracle/opt/oradata/standby/db_05j3dk6n_1_1.bak
File Name: /home/oracle/opt/oradata/standby/db_04j3dk0q_1_1.bak

Do you really want to catalog the above files (enter YES or NO)? yes
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: /home/oracle/opt/oradata/standby/db_05j3dk6n_1_1.bak
File Name: /home/oracle/opt/oradata/standby/db_04j3dk0q_1_1.bak

RMAN> crosscheck backup;

allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=146 device type=DISK
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=D:\01J16E8N_1_1.BAK RECID=1 STAMP=638794021
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=D:\DB_&U.BAK RECID=2 STAMP=641126128
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=D:\DB_04J3DK0Q_1_1.BAK RECID=3 STAMP=641126440
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/home/oracle/opt/oradata/standby/db_04j3dk0q_1_1.bak RECID=6 STAMP=641137919
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=D:\DB_05J3DK6N_1_1.BAK RECID=4 STAMP=641126632
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/home/oracle/opt/oradata/standby/db_05j3dk6n_1_1.bak RECID=5 STAMP=641137919
Crosschecked 6 objects

RMAN> delete expired backup;

using channel ORA_DISK_1

List of Backup Pieces
BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
1       1       1   1   EXPIRED     DISK        D:\01J16E8N_1_1.BAK
2       2       1   1   EXPIRED     DISK        D:\DB_&U.BAK
3       3       1   1   EXPIRED     DISK        D:\DB_04J3DK0Q_1_1.BAK
4       4       1   1   EXPIRED     DISK        D:\DB_05J3DK6N_1_1.BAK

Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=D:\01J16E8N_1_1.BAK RECID=1 STAMP=638794021
deleted backup piece
backup piece handle=D:\DB_&U.BAK RECID=2 STAMP=641126128
deleted backup piece
backup piece handle=D:\DB_04J3DK0Q_1_1.BAK RECID=3 STAMP=641126440
deleted backup piece
backup piece handle=D:\DB_05J3DK6N_1_1.BAK RECID=4 STAMP=641126632
Deleted 4 EXPIRED objects

等到RMAN能够正切认出STANDBY端的备份集后,我们就可以对数据库进行RESTORE了:

RMAN> list backup;

List of Backup Sets

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3       Full    1.75G      DISK        00:03:03     12-DEC-07      
        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20071212T104026
        Piece Name: /home/oracle/opt/oradata/standby/db_04j3dk0q_1_1.bak
  List of Datafiles in backup set 3
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 8852434    12-DEC-07 /home/oracle/opt/oradata/standby/SYSTEM01.DBF
  2       Full 8852434    12-DEC-07 /home/oracle/opt/oradata/standby/SYSAUX01.DBF
  3       Full 8852434    12-DEC-07 /home/oracle/opt/oradata/standby/UNDOTBS01.DBF
  4       Full 8852434    12-DEC-07 /home/oracle/opt/oradata/standby/USERS01.DBF
  5       Full 8852434    12-DEC-07 /home/oracle/opt/oradata/standby/EXAMPLE01.DBF

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4       Full    9.64M      DISK        00:00:17     12-DEC-07      
        BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: TAG20071212T104026
        Piece Name: /home/oracle/opt/oradata/standby/db_05j3dk6n_1_1.bak
  SPFILE Included: Modification time: 30-NOV-07
  SPFILE db_unique_name: ORCL
  Control File Included: Ckp SCN: 8852584      Ckp time: 12-DEC-07

RMAN> restore database;

Starting restore at 12-DEC-07
using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /home/oracle/opt/oradata/standby/SYSTEM01.DBF
channel ORA_DISK_1: restoring datafile 00002 to /home/oracle/opt/oradata/standby/SYSAUX01.DBF
channel ORA_DISK_1: restoring datafile 00003 to /home/oracle/opt/oradata/standby/UNDOTBS01.DBF
channel ORA_DISK_1: restoring datafile 00004 to /home/oracle/opt/oradata/standby/USERS01.DBF
channel ORA_DISK_1: restoring datafile 00005 to /home/oracle/opt/oradata/standby/EXAMPLE01.DBF
channel ORA_DISK_1: reading from backup piece /home/oracle/opt/oradata/standby/db_04j3dk0q_1_1.bak
channel ORA_DISK_1: piece handle=/home/oracle/opt/oradata/standby/db_04j3dk0q_1_1.bak tag=TAG20071212T104026
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:05
Finished restore at 12-DEC-07

使用道具 举报

回复
论坛徽章:
151
2014年新春福章
日期:2014-04-17 11:38:13奥运会纪念徽章:皮划艇静水
日期:2012-07-31 15:42:58奥运会纪念徽章:田径
日期:2012-07-10 16:21:10奥运会纪念徽章:跆拳道
日期:2012-06-20 22:07:29奥运会纪念徽章:皮划艇静水
日期:2012-06-16 02:55:21奥运会纪念徽章:曲棍球
日期:2012-06-13 10:09:19蛋疼蛋
日期:2012-05-19 23:20:41迷宫蛋
日期:2012-05-16 17:35:25版主2段
日期:2012-05-15 15:24:11双黄蛋
日期:2012-03-19 19:34:04
 楼主| 发表于 2007-12-13 12:32 | 显示全部楼层
8、在主库和备用库端分别更改tnsnames配置,添加主库和备用库的TNS连接字,并确保在主库和STANDBY都能够连接上对方:

primary =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.200.168)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

standby =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.200.169)(PORT = 1522))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = standby)
    )
  )

9、添加STANDBY LOGFILE,启动STANDBY至恢复管理模式:

idle> alter database add standby logfile '/home/oracle/opt/oradata/standby/redo04.log' size 50M;

Database altered.

idle>  alter database add standby logfile '/home/oracle/opt/oradata/standby/redo05.log' size 50M;

Database altered.

idle>  alter database add standby logfile '/home/oracle/opt/oradata/standby/redo06.log' size 50M;

Database altered.

idle> recover managed standby database disconnect from session;
Media recovery complete.


10、主库配置到STANDBY的归档,另外注意主库需要设置log_archive_config这个参数,否则归档将不会从主库传至STANDBY端:

Sys@orcl> alter system set log_archive_dest_2='service=standby ASYNC VALID_FOR=(
ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=standby';

System altered.

Sys@orcl> alter system set log_archive_dest_state_2=enable;

System altered.

Sys@orcl> alter system set log_archive_config='DG_CONFIG=(orcl,standby)';

System altered.

这样异构STANDBY就配置成功了:

Wed Dec 12 14:42:34 2007
Using STANDBY_ARCHIVE_DEST parameter default value as /home/oracle/opt/oradata/standby/archive
Wed Dec 12 15:28:17 2007
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[1]: Assigned to RFS process 3774
RFS[1]: Identified database type as 'physical standby'
Primary database is in MAXIMUM PERFORMANCE mode
RFS LogMiner: Client disabled from further notification
Primary database is in MAXIMUM PERFORMANCE mode
RFS[1]: Successfully opened standby log 4: '/home/oracle/opt/oradata/standby/redo04.log'
Wed Dec 12 15:28:18 2007
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[2]: Assigned to RFS process 3780
RFS[2]: Identified database type as 'physical standby'
kcrrvslf: active RFS archival for log 4 thread 1 sequence 249
RFS[2]: Successfully opened standby log 5: '/home/oracle/opt/oradata/standby/redo05.log'
Wed Dec 12 15:28:21 2007
Fetching gap sequence in thread 1, gap sequence 231-247
Wed Dec 12 15:28:22 2007
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[3]: Assigned to RFS process 3786
RFS[3]: Identified database type as 'physical standby'
Wed Dec 12 15:28:22 2007
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[4]: Assigned to RFS process 3792
RFS[4]: Identified database type as 'physical standby'
RFS[2]: Archived Log: '/home/oracle/opt/oradata/standby/archive/1_232_637422457.dbf'
RFS[4]: Archived Log: '/home/oracle/opt/oradata/standby/archive/1_231_637422457.dbf'
RFS[3]: Archived Log: '/home/oracle/opt/oradata/standby/archive/1_233_637422457.dbf'
RFS[4]: Archived Log: '/home/oracle/opt/oradata/standby/archive/1_235_637422457.dbf'
RFS[2]: Archived Log: '/home/oracle/opt/oradata/standby/archive/1_234_637422457.dbf'
RFS[3]: Archived Log: '/home/oracle/opt/oradata/standby/archive/1_236_637422457.dbf'
RFS[4]: Archived Log: '/home/oracle/opt/oradata/standby/archive/1_237_637422457.dbf'
RFS[2]: Archived Log: '/home/oracle/opt/oradata/standby/archive/1_238_637422457.dbf'
RFS[3]: Archived Log: '/home/oracle/opt/oradata/standby/archive/1_239_637422457.dbf'
RFS[2]: Archived Log: '/home/oracle/opt/oradata/standby/archive/1_240_637422457.dbf'
RFS[4]: Archived Log: '/home/oracle/opt/oradata/standby/archive/1_241_637422457.dbf'
FS[3]: Archived Log: '/home/oracle/opt/oradata/standby/archive/1_242_637422457.dbf'
RFS[4]: Archived Log: '/home/oracle/opt/oradata/standby/archive/1_243_637422457.dbf'
RFS[2]: Archived Log: '/home/oracle/opt/oradata/standby/archive/1_244_637422457.dbf'
RFS[3]: Archived Log: '/home/oracle/opt/oradata/standby/archive/1_245_637422457.dbf'
Wed Dec 12 15:28:29 2007
Primary database is in MAXIMUM PERFORMANCE mode
RFS[1]: Successfully opened standby log 5: '/home/oracle/opt/oradata/standby/redo05.log'
RFS[4]: Archived Log: '/home/oracle/opt/oradata/standby/archive/1_246_637422457.dbf'
Wed Dec 12 15:28:30 2007
RFS[2]: Archived Log: '/home/oracle/opt/oradata/standby/archive/1_247_637422457.dbf'
Wed Dec 12 15:28:52 2007
Media Recovery Log /home/oracle/opt/oradata/standby/archive/1_231_637422457.dbf
Media Recovery Log /home/oracle/opt/oradata/standby/archive/1_232_637422457.dbf
Media Recovery Log /home/oracle/opt/oradata/standby/archive/1_233_637422457.dbf
Media Recovery Log /home/oracle/opt/oradata/standby/archive/1_234_637422457.dbf
Media Recovery Log /home/oracle/opt/oradata/standby/archive/1_235_637422457.dbf
Media Recovery Log /home/oracle/opt/oradata/standby/archive/1_236_637422457.dbf
Media Recovery Log /home/oracle/opt/oradata/standby/archive/1_237_637422457.dbf
Media Recovery Log /home/oracle/opt/oradata/standby/archive/1_238_637422457.dbf
Media Recovery Log /home/oracle/opt/oradata/standby/archive/1_239_637422457.dbf
Media Recovery Log /home/oracle/opt/oradata/standby/archive/1_240_637422457.dbf
Media Recovery Log /home/oracle/opt/oradata/standby/archive/1_241_637422457.dbf
Media Recovery Log /home/oracle/opt/oradata/standby/archive/1_242_637422457.dbf
Media Recovery Log /home/oracle/opt/oradata/standby/archive/1_243_637422457.dbf
Media Recovery Log /home/oracle/opt/oradata/standby/archive/1_244_637422457.dbf
Media Recovery Log /home/oracle/opt/oradata/standby/archive/1_245_637422457.dbf
Media Recovery Log /home/oracle/opt/oradata/standby/archive/1_246_637422457.dbf
Media Recovery Log /home/oracle/opt/oradata/standby/archive/1_247_637422457.dbf
Media Recovery Log /home/oracle/opt/oradata/standby/archive/1_248_637422457.dbf
Media Recovery Log /home/oracle/opt/oradata/standby/archive/1_249_637422457.dbf
Media Recovery Waiting for thread 1 sequence 250 (in transit)

使用道具 举报

回复
论坛徽章:
59
狮子座
日期:2016-03-26 13:35:402013年新春福章
日期:2013-02-25 14:51:24双黄蛋
日期:2013-02-25 11:06:15ITPUB 11周年纪念徽章
日期:2012-10-09 18:06:20灰彻蛋
日期:2012-04-25 13:19:33紫蛋头
日期:2012-03-14 11:16:09最佳人气徽章
日期:2012-03-13 17:39:18玉石琵琶
日期:2012-02-21 15:04:38鲜花蛋
日期:2011-11-30 14:13:01ITPUB十周年纪念徽章
日期:2011-11-01 16:21:15
发表于 2007-12-13 12:59 | 显示全部楼层
我觉得最主要原因还是两个平台的ENDIAN_FORMAT都是little吧,不然传过来的日志都认不出来的

使用道具 举报

回复
论坛徽章:
10
每日论坛发贴之星
日期:2007-09-10 01:02:15金色在线徽章
日期:2007-10-03 04:03:16ITPUB新首页上线纪念徽章
日期:2007-10-20 08:38:44数据库板块每日发贴之星
日期:2007-12-20 01:04:15生肖徽章2007版:猴
日期:2008-01-02 17:35:53生肖徽章2007版:鼠
日期:2008-01-02 17:35:53奥运会纪念徽章:摔跤
日期:2008-09-04 09:51:27生肖徽章2007版:狗
日期:2009-03-10 21:24:29ITPUB社区12周年站庆徽章
日期:2013-10-08 17:44:42
发表于 2007-12-18 23:44 | 显示全部楼层
已经COPY下来。有时间试验下

使用道具 举报

回复
论坛徽章:
46
凯迪拉克
日期:2013-08-22 10:00:10Jeep
日期:2013-08-10 07:21:13ITPUB社区12周年站庆徽章
日期:2013-10-08 14:57:28ITPUB十周年纪念徽章
日期:2011-11-01 16:20:282012新春纪念徽章
日期:2012-01-04 11:49:54ITPUB 11周年纪念徽章
日期:2012-10-09 18:05:07奥运会纪念徽章:体操
日期:2008-10-24 13:08:31会员2007贡献徽章
日期:2007-09-26 18:42:10马上加薪
日期:2014-04-11 09:34:11秀才
日期:2015-09-06 10:19:32
发表于 2007-12-19 09:00 | 显示全部楼层
Thank very mach.

使用道具 举报

回复
论坛徽章:
0
发表于 2007-12-19 21:34 | 显示全部楼层
有时间测试一下,感谢楼主

使用道具 举报

回复
论坛徽章:
81
青年奥林匹克运动会-马术
日期:2014-09-10 21:37:07奥运会纪念徽章:跳水
日期:2012-09-22 18:27:58奥运会纪念徽章:现代五项
日期:2012-09-07 17:33:44奥运会纪念徽章:铁人三项
日期:2012-06-15 21:27:24版主1段
日期:2012-05-15 15:24:11蜘蛛蛋
日期:2012-05-14 10:50:40灰彻蛋
日期:2012-03-06 19:24:222012新春纪念徽章
日期:2012-02-13 15:12:092012新春纪念徽章
日期:2012-02-13 15:12:09ITPUB 11周年纪念徽章
日期:2012-10-09 18:05:37
发表于 2007-12-19 21:53 | 显示全部楼层
不错不错
oracle的standby做得越来越实用了

使用道具 举报

回复
认证徽章
论坛徽章:
106
2008新春纪念徽章
日期:2008-02-13 12:43:03ITPUB十周年纪念徽章
日期:2011-11-01 16:21:152012新春纪念徽章
日期:2012-01-04 11:51:222012新春纪念徽章
日期:2012-02-13 15:12:252012新春纪念徽章
日期:2012-02-13 15:12:252012新春纪念徽章
日期:2012-02-13 15:12:252012新春纪念徽章
日期:2012-02-13 15:12:252012新春纪念徽章
日期:2012-02-13 15:12:25版主4段
日期:2012-05-15 15:24:11ITPUB 11周年纪念徽章
日期:2012-10-09 18:07:31
发表于 2007-12-20 09:24 | 显示全部楼层
支持原创,给个精华

使用道具 举报

回复

您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

PostgreSQL中国大会,参会票抢购!

由 PostgreSQL中文社区与ITPUB联合主办的第九届《PostgreSQL 中国技术大会》将在北京隆重召开。PostgreSQL 作为功能最强的的开源关系型数据库之一,得到了越来越多企业的推广和运用,也越来越受到广大技术爱好者的欢迎和重视。这将是 PostgreSQL 的又一次交流盛会。
----------------------------------------
时间:2019年11月29~11月30日

点击报名>>
TOP技术积分榜 社区积分榜 徽章 团队 统计 知识索引树 积分竞拍 文本模式 帮助
  ITPUB首页 | ITPUB论坛 | 数据库技术 | 企业信息化 | 开发技术 | 微软技术 | 软件工程与项目管理 | IBM技术园地 | 行业纵向讨论 | IT招聘 | IT文档
  ChinaUnix | ChinaUnix博客 | ChinaUnix论坛
CopyRight 1999-2011 itpub.net All Right Reserved. 北京盛拓优讯信息技术有限公司版权所有 联系我们 
京ICP备09055130号-4  北京市公安局海淀分局网监中心备案编号:11010802021510 广播电视节目制作经营许可证:编号(京)字第1149号
  
快速回复 返回顶部 返回列表