查看: 3484|回复: 6

做物理standby一直找不到redo log

[复制链接]
论坛徽章:
16
2011新春纪念徽章
日期:2011-01-04 10:36:17优秀写手
日期:2014-03-12 06:00:13马上有对象
日期:2014-02-18 16:44:082014年新春福章
日期:2014-02-18 16:44:08茶鸡蛋
日期:2013-02-28 16:07:01复活蛋
日期:2013-02-27 18:28:01迷宫蛋
日期:2013-01-28 09:52:03奥运会纪念徽章:举重
日期:2012-06-28 11:26:23鲜花蛋
日期:2012-06-05 09:53:53双黄蛋
日期:2012-01-06 09:22:33
发表于 2014-3-6 21:27 | 显示全部楼层 |阅读模式
实验环境说明

1:primary server:

hostname:rac1
IP:192.168.55.119
ORACLE_SID=pdg
db_unique_name=pdg

已经安装完数据库软件,并用dbca创建了数据库实例

2、standby server:

hostname:rac2
IP:192.168.55.120
ORACLE_SID=sdg
db_unique_name=sdg

只安装了数据库软件,没有用dbca创建实例

以下是具体步骤:

1:在primary库上执行

[root@rac1 ~]# more /etc/sysconfig/network
NETWORKING=yes
HOSTNAME=rac1
GATEWAY=192.168.123.254
[root@rac1 ~]#
[root@rac1 ~]# more /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1  rac1 localhost.localdomain localhost


[oracle@rac1 ~]$ more .bash_profile
在文件最后添加如下行:
# Set env for oracle10g
export ORACLE_BASE=/home/oracle
export ORACLE_HOME=$ORACLE_BASE/10.2.0
export ORACLE_SID=pdg
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin

然后安装数据库软件,用dbca创建数据库


[oracle@rac1 pdg]$ mkdir -p /home/oracle/archivelog  //创建归档目录

SQL> select open_mode from v$database;
OPEN_MODE
--------------------
READ WRITE


SQL> alter database force logging;(不启用的命令是 alter database no force logging;)
Database altered.
SQL> alter system set db_unique_name=pdg scope=spfile;
System altered.
SQL> alter system set log_archive_config='dg_config=(pdg,sdg)' scope=both;
System altered.
SQL> alter system set log_archive_dest_1='location=/home/oracle/archivelog VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=pdg';
System altered.
SQL> alter system set LOG_ARCHIVE_DEST_STATE_1=ENABLE;
System altered.
SQL>  alter system set REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE scope=spfile;
System altered.
SQL> alter system set LOG_ARCHIVE_FORMAT='log%t_%s_%r.arc' scope=spfile;
System altered.
SQL>
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL> startup mount;
ORACLE instance started.
Total System Global Area  218103808 bytes
Fixed Size      1218604 bytes
Variable Size     67110868 bytes
Database Buffers   146800640 bytes
Redo Buffers      2973696 bytes
Database mounted.
SQL>
SQL> alter database archivelog;
Database altered.
SQL> alter database open;
Database altered.
SQL> archive log list;
Database log mode        Archive Mode
Automatic archival        Enabled
Archive destination        /home/oracle/archivelog
Oldest online log sequence     1
Next log sequence to archive   2
Current log sequence        2
SQL>
SQL> create pfile from spfile;
File created.

[root@rac1 ~]# su - oracle
[oracle@rac1 ~]$
[oracle@rac1 ~]$
[oracle@rac1 ~]$ cd $ORACLE_HOME/dbs
[oracle@rac1 dbs]$
[oracle@rac1 dbs]$ ls
hc_pdg.dat  init.ora  initdw.ora  initpdg.ora  lkPDG  orapwpdg  spfilepdg.ora
修改 initpdg.or 参数,在最下面加入如下行
++++++++++++++++++++++++++++++++++++++++
#--------配置standby角色的参数用于角色转换
FAL_SERVER='pdg'
FAL_CLIENT='sdg'
DB_FILE_NAME_CONVERT='/home/oracle/oradata/sdg','/home/oracle/oradata/pdg'
LOG_FILE_NAME_CONVERT='/home/oracle/oradata/sdg','/home/oracle/oradata/pdg'
alter system set STANDBY_FILE_MANAGEMENT='AUTO'


然后查看最后修改后的initpdg.ora文件

[oracle@rac1 dbs]$ more initpdg.ora
pdg.__db_cache_size=146800640
pdg.__java_pool_size=4194304
pdg.__large_pool_size=4194304
pdg.__shared_pool_size=58720256
pdg.__streams_pool_size=0
*.audit_file_dest='/home/oracle/admin/pdg/adump'
*.background_dump_dest='/home/oracle/admin/pdg/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/home/oracle/oradata/pdg/control01.ctl','/home/oracle/oradata/pdg/control02.ctl','/home/oracle/oradata/pdg/control03.ctl'
*.core_dump_dest='/home/oracle/admin/pdg/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='pdg'
*.db_unique_name='PDG'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=pdgXDB)'
*.job_queue_processes=10
*.log_archive_config='dg_config=(pdg,sdg)'
*.log_archive_dest_1='location=/home/oracle/archivelog VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=pdg'
*.log_archive_dest_2='SERVICE=sdg LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=sdg'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'

*.log_archive_format='log%t_%s_%r.arc'
*.open_cursors=300
*.pga_aggregate_target=71303168
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=216006656
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/home/oracle/admin/pdg/udump'
#-------- 配置standby角色的参数用于角色转换
FAL_SERVER='sdg'
FAL_CLIENT='pdg'
DB_FILE_NAME_CONVERT='/home/oracle/oradata/sdg','/home/oracle/oradata/pdg'
LOG_FILE_NAME_CONVERT='/home/oracle/oradata/sdg','/home/oracle/oradata/pdg'
STANDBY_FILE_MANAGEMENT='AUTO'


然后重建spfile文件
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL> create spfile from pfile;
File created.
可以用 show parameter xxx 来验证是否生效

重新创建监听文件
[oracle@rac1 pdg]$ cd $ORACLE_HOME/network/admin
[oracle@rac1 admin]$ ls
listener.ora  samples  shrept.lst  tnsnames.ora
[oracle@rac1 admin]$ more listener.ora
# listener.ora Network Configuration File: /home/oracle/10.2.0/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_PDG =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /home/oracle/10.2.0)
      (PROGRAM = extproc)
    )
  )
PDG =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.50.119)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
  )
[oracle@rac1 admin]$
[oracle@rac1 admin]$ more tnsnames.ora
# tnsnames.ora Network Configuration File: /home/oracle/10.2.0/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )
pdg =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.50.119)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = pdg)
    )
  )

sdg =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.50.120)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = sdg)
    )
  )

创建standby数据库控制文件
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
READ WRITE
SQL>
SQL> alter database create standby controlfile as '/home/oracle/sdg01.ctl';
Database altered.
SQL>

然后在primary库上做rman备份
[oracle@rac1 ~]$ mkdir -p /home/oracle/rmanbackup
[oracle@rac1 ~]$
[oracle@rac1 ~]$ rman target /
rman: can't open target
[oracle@rac1 ~]$ export PATH=$ORACLE_HOME/bin:$PATH
[oracle@rac1 ~]$ rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Wed Mar 5 21:46:46 2014
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
connected to target database: PDG (DBID=3413940343)
RMAN> configure controlfile autobackup on;
using target database control file instead of recovery catalog
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored
RMAN>
RMAN> backup database format='/home/oracle/rmanbackup/%d_%s.bak' plus archivelog;

Starting backup at 05-MAR-14
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=142 devtype=DISK
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=2 recid=1 stamp=841441754
channel ORA_DISK_1: starting piece 1 at 05-MAR-14
channel ORA_DISK_1: finished piece 1 at 05-MAR-14
piece handle=/home/oracle/10.2.0/dbs/01p2eoet_1_1 tag=TAG20140305T214916 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:08
Finished backup at 05-MAR-14
Starting backup at 05-MAR-14
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/home/oracle/oradata/pdg/system01.dbf
input datafile fno=00003 name=/home/oracle/oradata/pdg/sysaux01.dbf
input datafile fno=00005 name=/home/oracle/oradata/pdg/example01.dbf
input datafile fno=00002 name=/home/oracle/oradata/pdg/undotbs01.dbf
input datafile fno=00004 name=/home/oracle/oradata/pdg/users01.dbf
channel ORA_DISK_1: starting piece 1 at 05-MAR-14
channel ORA_DISK_1: finished piece 1 at 05-MAR-14
piece handle=/home/oracle/rmanbackup/PDG_2.bak tag=TAG20140305T214926 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:03:16
Finished backup at 05-MAR-14
Starting backup at 05-MAR-14
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=3 recid=2 stamp=841441963
channel ORA_DISK_1: starting piece 1 at 05-MAR-14
channel ORA_DISK_1: finished piece 1 at 05-MAR-14
piece handle=/home/oracle/10.2.0/dbs/03p2eolc_1_1 tag=TAG20140305T215244 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 05-MAR-14
Starting Control File and SPFILE Autobackup at 05-MAR-14
piece handle=/home/oracle/10.2.0/dbs/c-3413940343-20140305-00 comment=NONE
Finished Control File and SPFILE Autobackup at 05-MAR-14
RMAN>

然后将rman备份的文件、参数文件、密码文件、备份的控制文件、监听的配置文件都传到 standby 库上

[oracle@rac1 dbs]$ scp initpdg.ora [url=mailtoracle@192.168.50.120:/home/oracle/10.2.0/dbs]oracle@192.168.50.120:/home/oracle/10.2.0/dbs[/url]
[oracle@rac1 dbs]$ scp 01p2eoet_1_1 03p2eolc_1_1 c-3413940343-20140305-00 [url=mailtoracle@192.168.50.120:/home/oracle/10.2.0/dbs]oracle@192.168.50.120:/home/oracle/10.2.0/dbs[/url]
[oracle@rac1 admin]$ scp listener.ora [url=mailtoracle@192.168.50.120:/home/oracle/10.2.0/network/admin]oracle@192.168.50.120:/home/oracle/10.2.0/network/admin[/url]
[oracle@rac1 admin]$ scp tnsnames.ora [url=mailtoracle@192.168.50.120:/home/oracle/10.2.0/network/admin]oracle@192.168.50.120:/home/oracle/10.2.0/network/admin[/url]
[oracle@rac1 admin]$ scp /home/oracle/rmanbackup/PDG_2.bak [url=mailtoracle@192.168.50.120:/home/oracle/rmanbackup]oracle@192.168.50.120:/home/oracle/rmanbackup[/url]
[oracle@rac1 dbs]$ scp orapwpdg [url=mailtoracle@192.168.50.120:/home/oracle/10.2.0/dbs]oracle@192.168.50.120:/home/oracle/10.2.0/dbs[/url]
[oracle@rac1 ~]$ scp /home/oracle/sdg01.ctl [url=mailtoracle@192.168.50.120:/home/oracle/oradata/sdg]oracle@192.168.50.120:/home/oracle/oradata/sdg[/url]


然后在 primary 数据库 tnsping sdg  和 tnsping pdg



2:以下步骤在 standby库上做
[oracle@rac2 ~]$ mkdir -p /home/oracle/admin/sdg/adump
[oracle@rac2 ~]$
[oracle@rac2 ~]$ mkdir -p /home/oracle/admin/sdg/bdump
[oracle@rac2 ~]$
[oracle@rac2 ~]$ mkdir -p /home/oracle/admin/sdg/cdump
[oracle@rac2 ~]$
[oracle@rac2 ~]$ mkdir -p /home/oracle/admin/sdg/udump
[oracle@rac2 ~]$
[oracle@rac2 ~]$ mkdir -p /home/oracle/oradata/sdg/
[oracle@rac2 ~]$
[oracle@rac2 ~]$ mkdir -p /home/oracle/archivelog
[oracle@rac2 ~]$
[oracle@rac2 dbs]$ mv initpdg.ora initsdg.ora
[oracle@rac2 dbs]$
[oracle@rac2 dbs]$ mv initpdg.ora initsdg.ora

[oracle@rac2 dbs]$ mv orapwpdg orapwsdg
[oracle@rac2 sdg]$ pwd
/home/oracle/oradata/sdg
[oracle@rac2 sdg]$ ls -l
total 6908
-rw-r-----  1 oracle dba 7061504 Mar  5 22:27 sdg01.ctl
[oracle@rac2 sdg]$ mv sdg01.ctl control01.ctl
[oracle@rac2 sdg]$ cp control01.ctl control02.ctl
[oracle@rac2 sdg]$ cp control01.ctl control03.ctl
[oracle@rac2 sdg]$


然后修改 standby 库的  initsdg.ora 文件


[oracle@rac2 dbs]$ more initsdg.ora
pdg.__db_cache_size=146800640
pdg.__java_pool_size=4194304
pdg.__large_pool_size=4194304
pdg.__shared_pool_size=58720256
pdg.__streams_pool_size=0
*.audit_file_dest='/home/oracle/admin/sdg/adump'
*.background_dump_dest='/home/oracle/admin/sdg/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/home/oracle/oradata/sdg/control01.ctl','/home/oracle/oradata/sdg/control02.ctl','/home/oracle/oradata/sdg/control03.ctl'
*.core_dump_dest='/home/oracle/admin/sdg/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='pdg'
*.db_unique_name='SDG'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=pdgXDB)'
*.job_queue_processes=10
*.log_archive_config='dg_config=(pdg,sdg)'
*.log_archive_dest_1='location=/home/oracle/archivelog VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=sdg'
*.log_archive_dest_2='SERVICE=pdg LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=pdg'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'

*.log_archive_format='log%t_%s_%r.arc'
*.open_cursors=300
*.pga_aggregate_target=71303168
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=216006656
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/home/oracle/admin/sdg/udump'

#-------- 配置standby角色的参数用于角色转换
FAL_SERVER='pdg'
FAL_CLIENT='sdg'
DB_FILE_NAME_CONVERT='/home/oracle/oradata/pdg','/home/oracle/oradata/sdg'
LOG_FILE_NAME_CONVERT='/home/oracle/oradata/pdg','/home/oracle/oradata/sdg'
STANDBY_FILE_MANAGEMENT='AUTO'



然后创建standby数据库

[oracle@rac2 dbs]$ sqlplus  / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Mar 5 22:58:51 2014
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Connected to an idle instance.
SQL> startup nomount pfile='/home/oracle/10.2.0/dbs/initsdg.ora';
ORACLE instance started.
Total System Global Area  218103808 bytes
Fixed Size      1218604 bytes
Variable Size     67110868 bytes
Database Buffers   146800640 bytes
Redo Buffers      2973696 bytes
SQL>
SQL> alter database mount standby database; //紧接着上一步执行
Database altered.
RMAN> catalog backuppiece '/home/oracle/rmanbackup/PDG_2.bak'; // 在rman中注册备份片
cataloged backuppiece
backup piece handle=/home/oracle/rmanbackup/PDG_2.bak recid=1 stamp=841485100
RMAN>
RMAN> restore database;
Starting restore at 06-MAR-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=152 devtype=DISK
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /home/oracle/oradata/sdg/system01.dbf
restoring datafile 00002 to /home/oracle/oradata/sdg/undotbs01.dbf
restoring datafile 00003 to /home/oracle/oradata/sdg/sysaux01.dbf
restoring datafile 00004 to /home/oracle/oradata/sdg/users01.dbf
restoring datafile 00005 to /home/oracle/oradata/sdg/example01.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/rmanbackup/PDG_2.bak
channel ORA_DISK_1: restored backup piece 1
piece handle=/home/oracle/rmanbackup/PDG_2.bak tag=TAG20140305T214926
channel ORA_DISK_1: restore complete, elapsed time: 00:02:07
Finished restore at 06-MAR-14
RMAN>

然后验证 standby库已经启动到了 mount状态
[oracle@rac2 sdg]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Mar 6 10:01:29 2014
Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
MOUNTED
SQL>

SQL> alter database recover managed standby database disconnect from session;
Database altered.


验证是否传输到了Standby database

在 Primary database 上
SQL> alter system switch logfile;
System altered.
SQL> SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;
SEQUENCE# FIRST_TIME NEXT_TIME
---------- ------------ ------------
  2 05-MAR-14 05-MAR-14
  3 05-MAR-14 05-MAR-14
  4 05-MAR-14 05-MAR-14
  5 05-MAR-14 06-MAR-14
  6 06-MAR-14 06-MAR-14
  7 06-MAR-14 06-MAR-14
  8 06-MAR-14 06-MAR-14
  9 06-MAR-14 06-MAR-14
10 06-MAR-14 06-MAR-14
11 06-MAR-14 06-MAR-14
12 06-MAR-14 06-MAR-14
SEQUENCE# FIRST_TIME NEXT_TIME
---------- ------------ ------------
13 06-MAR-14 06-MAR-14
14 06-MAR-14 06-MAR-14
15 06-MAR-14 06-MAR-14
16 06-MAR-14 06-MAR-14
17 06-MAR-14 06-MAR-14
16 rows selected.


在standby 库上

SQL> SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;
no rows selected

SQL> archive log list;
Database log mode        Archive Mode
Automatic archival        Enabled
Archive destination        /home/oracle/archivelog
Oldest online log sequence     0
Next log sequence to archive   0
Current log sequence        0
SQL>
SQL> show parameter log_arch;
NAME         TYPE      VALUE
------------------------------------ ---------------------- ------------------------------
log_archive_config       string      dg_config=(pdg,sdg)
log_archive_dest       string
log_archive_dest_1       string      location=/home/oracle/archivelog
log_archive_dest_10       string
log_archive_dest_2       string      SERVICE=pdg LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=pdg
log_archive_dest_3       string
log_archive_dest_4       string
log_archive_dest_5       string
NAME         TYPE      VALUE
------------------------------------ ---------------------- ------------------------------
log_archive_dest_6       string
log_archive_dest_7       string
log_archive_dest_8       string
log_archive_dest_9       string
log_archive_dest_state_1      string      ENABLE
log_archive_dest_state_10      string      enable
log_archive_dest_state_2      string      ENABLE
log_archive_dest_state_3      string      enable
log_archive_dest_state_4      string      enable
log_archive_dest_state_5      string      enable
log_archive_dest_state_6      string      enable
NAME         TYPE      VALUE
------------------------------------ ---------------------- ------------------------------
log_archive_dest_state_7      string      enable
log_archive_dest_state_8      string      enable
log_archive_dest_state_9      string      enable
log_archive_duplex_dest       string
log_archive_format       string      log%t_%s_%r.arc
log_archive_local_first       boolean      TRUE
log_archive_max_processes      integer      2
log_archive_min_succeed_dest      integer      1
log_archive_start       boolean      FALSE
log_archive_trace       integer      0



弄了一天了,standby上还是看不到redo log,搞过dg的puber们,帮忙看下。。。


论坛徽章:
16
2011新春纪念徽章
日期:2011-01-04 10:36:17优秀写手
日期:2014-03-12 06:00:13马上有对象
日期:2014-02-18 16:44:082014年新春福章
日期:2014-02-18 16:44:08茶鸡蛋
日期:2013-02-28 16:07:01复活蛋
日期:2013-02-27 18:28:01迷宫蛋
日期:2013-01-28 09:52:03奥运会纪念徽章:举重
日期:2012-06-28 11:26:23鲜花蛋
日期:2012-06-05 09:53:53双黄蛋
日期:2012-01-06 09:22:33
 楼主| 发表于 2014-3-6 22:59 | 显示全部楼层
试了好多次  不管怎么搞   standby 还是没有redo log

使用道具 举报

回复
论坛徽章:
51
ITPUB十周年纪念徽章
日期:2011-11-01 16:25:22铁扇公主
日期:2012-02-21 15:03:13最佳人气徽章
日期:2012-03-13 17:39:18ITPUB季度 技术新星
日期:2012-05-22 15:10:11ITPUB 11周年纪念徽章
日期:2012-10-09 18:13:332013年新春福章
日期:2013-02-25 14:51:24ITPUB社区12周年站庆徽章
日期:2013-08-12 09:34:36itpub13周年纪念徽章
日期:2014-09-28 10:55:55
发表于 2014-3-7 10:11 | 显示全部楼层
1. 看了你的操作~没有弄密码文件吧? 看看alter日志提示什么?是不是没法连接到备库?

使用道具 举报

回复
求职 : 数据库管理员
招聘 : 系统架构师
论坛徽章:
4
ITPUB十周年纪念徽章
日期:2011-11-01 16:25:22ITPUB社区千里马徽章
日期:2013-08-22 09:58:032014年新春福章
日期:2014-02-18 16:43:09马上有钱
日期:2014-02-18 16:43:09
发表于 2014-3-7 12:10 | 显示全部楼层
把log贴出来看下,看看是不是listener,tnsnames有没有配置正确,密码文件是否存在?

使用道具 举报

回复
论坛徽章:
30
红宝石
日期:2012-10-10 14:50:58技术图书徽章
日期:2017-08-17 11:00:25奥运会纪念徽章:举重
日期:2016-09-18 11:29:42马上有钱
日期:2014-04-17 16:12:27马上加薪
日期:2014-03-31 14:47:51技术图书徽章
日期:2014-03-31 10:52:30优秀写手
日期:2013-12-18 09:29:162013年新春福章
日期:2013-02-25 14:51:24蓝锆石
日期:2012-10-10 14:50:58萤石
日期:2012-10-10 14:50:58
发表于 2014-3-7 16:20 | 显示全部楼层
互相tnsping下服务名

使用道具 举报

回复
论坛徽章:
16
2011新春纪念徽章
日期:2011-01-04 10:36:17优秀写手
日期:2014-03-12 06:00:13马上有对象
日期:2014-02-18 16:44:082014年新春福章
日期:2014-02-18 16:44:08茶鸡蛋
日期:2013-02-28 16:07:01复活蛋
日期:2013-02-27 18:28:01迷宫蛋
日期:2013-01-28 09:52:03奥运会纪念徽章:举重
日期:2012-06-28 11:26:23鲜花蛋
日期:2012-06-05 09:53:53双黄蛋
日期:2012-01-06 09:22:33
 楼主| 发表于 2014-3-10 16:16 | 显示全部楼层
iori809 发表于 2014-3-7 10:11
1. 看了你的操作~没有弄密码文件吧? 看看alter日志提示什么?是不是没法连接到备库?

兄弟 多谢啦
我之前是把primary 上的密码文件 scp到 standby库上的
后来我重新在两个库上创建了密码文件
测试ok   

使用道具 举报

回复
论坛徽章:
16
2011新春纪念徽章
日期:2011-01-04 10:36:17优秀写手
日期:2014-03-12 06:00:13马上有对象
日期:2014-02-18 16:44:082014年新春福章
日期:2014-02-18 16:44:08茶鸡蛋
日期:2013-02-28 16:07:01复活蛋
日期:2013-02-27 18:28:01迷宫蛋
日期:2013-01-28 09:52:03奥运会纪念徽章:举重
日期:2012-06-28 11:26:23鲜花蛋
日期:2012-06-05 09:53:53双黄蛋
日期:2012-01-06 09:22:33
 楼主| 发表于 2014-3-10 16:16 | 显示全部楼层
快乐的大个子 发表于 2014-3-7 16:20
互相tnsping下服务名

密码文件重建了  
监听也重建了
ok了

使用道具 举报

回复

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

本版积分规则 发表回复

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