1.主库
1.1Primary 设置force logging
SQL> alter database force logging;
Database altered.
SQL> select force_logging from v$database;
FOR
---
YES
1.2设置归档模式
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mountex
ORACLE instance started.

Total System Global Area 1.0656E+10 bytes
Fixed Size 2237648 bytes
Variable Size 838863664 bytes
Database Buffers 9797894144 bytes
Redo Buffers 17371136 bytes
Database mounted.
SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.
SQL> alter system set standby_file_management=auto;

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

SQL> alter system set dg_broker_start=true;

1.3修改监听
[root@bf_test_qd_119 ~]# cat /etc/hosts
[oracle@bf_test_qd_119 admin]$ cat $ORACLE_HOME/network/admin/listener.ora
# listener.ora Network Configuration File: /U01/app/oracle/product/11.2.3/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = bf_5001_nj_180.96.43.64_tel)(PORT = 1521))
)
)

ADR_BASE_LISTENER = /U01/app/oracle

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = bfodb)
(ORACLE_HOME = /U01/app/oracle/product/11.2.3/db_1)
(SID_NAME = bfodb)
)
)
LISTENER_1523 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = bf_5001_nj_180.96.43.64_tel)(PORT = 1523))
)
)
SID_LIST_LISTENER_1523 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = bfodb)
(ORACLE_HOME = /U01/app/oracle/product/11.2.3/db_1)
(SID_NAME = bfodb)
)
)
[oracle@bf_test_qd_119 admin]$ cat $ORACLE_HOME/network/admin/tnsnames.ora
# tnsnames.ora Network Configuration File: /U01/app/oracle/product/11.2.3/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

BFODB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = bf_1004_qd_119.167.137.13_cnc)(PORT = 1523))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = bfodb)
)
)

SBFODB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = bf_1004_qd_119.167.137.14_cnc)(PORT = 1523))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = bfodb)
)
)
1.4创建pfile
SQL> create pfile from spfile;

File created.

SQL>
1.5copy到bf_1004_qd_119.167.137.14_cnc
[oracle@bf_5001_nj_180 ~]$ cd $ORACLE_HOME/dbs/
[root@bf_test_qd_119 dbs]# scp orapwbfodb initbfodb.ora 10.55.8.158:/U01/app/oracle/product/11.2.3/db_1/dbs/
root@10.32.137.14's password:
Permission denied, please try again.
root@10.32.137.14's password:
orapwbfodb 100% 1536 1.5KB/s 00:00
initbfodb.ora 100% 1204 1.2KB/s 00:00
1.6

SQL> alter system set local_listener=bfodb;

System altered.
2.备库
2.1 建立相应目录
[oracle@bf_test_qd_119 oracle]$ mkdir -p /U01/app/oracle/oradata/bfodb
[oracle@bf_test_qd_119 oracle]$ mkdir -p /U01/app/oracle/fast_recovery_area/bfodb
[oracle@bf_test_qd_119 dbs]$ mkdir -p /U01/app/oracle/admin/bfodb/adump
[oracle@bf_test_qd_119 dbs]$ cd /U01/app/oracle/product/11.2.3/db_1/dbs/
[root@bf_5001_nj_180 dbs]# chown oracle:oinstall initbfodb.ora orapwbfodb
[root@bf_5001_nj_180 dbs]# vi initbfodb.ora
*.log_file_name_convert='/U01/app/oracle/oradata/bfodb','/U01/app/oracle/oradata/bfodb'
*.db_unique_name=sbfodb
2.4 tnsping测试
[oracle@bf_1004_qd_119 dbs]$ tnsping bfodb

TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 26-MAR-2012 14:45:09

Copyright (c) 1997, 2011, Oracle. All rights reserved.

Used parameter files:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = bf_1004_qd_119.167.137.13_cnc)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = bfodb)))
OK (0 msec)
[oracle@bf_1004_qd_119 dbs]$ tnsping sbfodb

TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 26-MAR-2012 14:48:34

Copyright (c) 1997, 2011, Oracle. All rights reserved.

Used parameter files:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = bf_1004_qd_119.167.137.14_cnc)(PORT = 1523)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = bfodb)))
OK (10 msec)
2.5duplicate
[oracle@bf_1004_qd_119 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Mon Mar 26 14:46:14 2012

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

Connected to an idle instance.

SQL> startup nomount
ORACLE instance started.

Total System Global Area 1.6602E+10 bytes
Fixed Size 2244872 bytes
Variable Size 6777999096 bytes
Database Buffers 9797894144 bytes
Redo Buffers 23953408 bytes
SQL> exit

[oracle@bf_1004_qd_119 dbs]$ rman target sys@bfodb auxiliary sys@sbfodb nocatalog

Recovery Manager: Release 11.2.0.3.0 - Production on Mon Mar 26 17:44:51 2012

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

target database Password:
connected to target database: BFODB (DBID=2835787729)
using target database control file instead of recovery catalog
auxiliary database Password:
connected to auxiliary database: BFODB (not mounted)

RMAN> duplicate target database for standby from active database nofilenamecheck;

Starting Duplicate Db at 2012-03-26 17:45:10
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=98 device type=DISK

contents of Memory Script:
{
backup as copy reuse
targetfile '/U01/app/oracle/product/11.2.3/db_1/dbs/orapwbfodb' auxiliary format
'/U01/app/oracle/product/11.2.3/db_1/dbs/orapwbfodb' ;
}
executing Memory Script

Starting backup at 2012-03-26 17:45:10
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=242 device type=DISK
Finished backup at 2012-03-26 17:45:12

contents of Memory Script:
{
backup as copy current controlfile for standby auxiliary format '/U01/app/oracle/oradata/bfodb/control01.ctl';
restore clone controlfile to '/U01/app/oracle/oradata/bfodb/control02.ctl' from
'/U01/app/oracle/oradata/bfodb/control01.ctl';
}
executing Memory Script

Starting backup at 2012-03-26 17:45:12
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
copying standby control file
output file name=/U01/app/oracle/product/11.2.3/db_1/dbs/snapcf_bfodb.f tag=TAG20120326T174512 RECID=3 STAMP=778959912
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 2012-03-26 17:45:13

Starting restore at 2012-03-26 17:45:13
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: copied control file copy
Finished restore at 2012-03-26 17:45:14

contents of Memory Script:
{
sql clone 'alter database mount standby database';
}
executing Memory Script

sql statement: alter database mount standby database

contents of Memory Script:
{
set newname for tempfile 1 to
"/U01/app/oracle/oradata/bfodb/temp01.dbf";
set newname for tempfile 2 to
"/U01/app/oracle/oradata/bfodb/temp02.dbf";
switch clone tempfile all;
set newname for datafile 1 to
"/U01/app/oracle/oradata/bfodb/system01.dbf";
set newname for datafile 2 to
"/U01/app/oracle/oradata/bfodb/sysaux01.dbf";
set newname for datafile 3 to
"/U01/app/oracle/oradata/bfodb/undotbs01.dbf";
set newname for datafile 4 to
"/U01/app/oracle/oradata/bfodb/users01.dbf";
set newname for datafile 5 to
"/U01/app/oracle/oradata/bfodb/saybfo01.dbf";
set newname for datafile 6 to
"/U01/app/oracle/oradata/bfodb/saybfo02.dbf";
set newname for datafile 7 to
"/U01/app/oracle/oradata/bfodb/saybfo03.dbf";
set newname for datafile 8 to
"/U01/app/oracle/oradata/bfodb/saybfo_ind01.dbf";
set newname for datafile 9 to
"/U01/app/oracle/oradata/bfodb/saybfo_ind.dbf";
backup as copy reuse
datafile 1 auxiliary format
"/U01/app/oracle/oradata/bfodb/system01.dbf" datafile
2 auxiliary format
"/U01/app/oracle/oradata/bfodb/sysaux01.dbf" datafile
3 auxiliary format
"/U01/app/oracle/oradata/bfodb/undotbs01.dbf" datafile
4 auxiliary format
"/U01/app/oracle/oradata/bfodb/users01.dbf" datafile
5 auxiliary format
"/U01/app/oracle/oradata/bfodb/saybfo01.dbf" datafile
6 auxiliary format
"/U01/app/oracle/oradata/bfodb/saybfo02.dbf" datafile
7 auxiliary format
"/U01/app/oracle/oradata/bfodb/saybfo03.dbf" datafile
8 auxiliary format
"/U01/app/oracle/oradata/bfodb/saybfo_ind01.dbf" datafile
9 auxiliary format
"/U01/app/oracle/oradata/bfodb/saybfo_ind.dbf" ;
sql 'alter system archive log current';
}
executing Memory Script

executing command: SET NEWNAME

executing command: SET NEWNAME

renamed tempfile 1 to /U01/app/oracle/oradata/bfodb/temp01.dbf in control file
renamed tempfile 2 to /U01/app/oracle/oradata/bfodb/temp02.dbf in control file

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting backup at 2012-03-26 17:45:20
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00005 name=/U01/app/oracle/oradata/bfodb/saybfo01.dbf
output file name=/U01/app/oracle/oradata/bfodb/saybfo01.dbf tag=TAG20120326T174520
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:15:16
channel ORA_DISK_1: starting datafile copy
input datafile file number=00006 name=/U01/app/oracle/oradata/bfodb/saybfo02.dbf
output file name=/U01/app/oracle/oradata/bfodb/saybfo02.dbf tag=TAG20120326T174520
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:15:16
channel ORA_DISK_1: starting datafile copy
input datafile file number=00007 name=/U01/app/oracle/oradata/bfodb/saybfo03.dbf
output file name=/U01/app/oracle/oradata/bfodb/saybfo03.dbf tag=TAG20120326T174520
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:15:18
channel ORA_DISK_1: starting datafile copy
input datafile file number=00008 name=/U01/app/oracle/oradata/bfodb/saybfo_ind01.dbf
output file name=/U01/app/oracle/oradata/bfodb/saybfo_ind01.dbf tag=TAG20120326T174520
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:07:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00009 name=/U01/app/oracle/oradata/bfodb/saybfo_ind.dbf
output file name=/U01/app/oracle/oradata/bfodb/saybfo_ind.dbf tag=TAG20120326T174520
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:07:56
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/U01/app/oracle/oradata/bfodb/system01.dbf
output file name=/U01/app/oracle/oradata/bfodb/system01.dbf tag=TAG20120326T174520
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:05
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=/U01/app/oracle/oradata/bfodb/sysaux01.dbf
output file name=/U01/app/oracle/oradata/bfodb/sysaux01.dbf tag=TAG20120326T174520
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:05
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=/U01/app/oracle/oradata/bfodb/undotbs01.dbf
output file name=/U01/app/oracle/oradata/bfodb/undotbs01.dbf tag=TAG20120326T174520
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=/U01/app/oracle/oradata/bfodb/users01.dbf
output file name=/U01/app/oracle/oradata/bfodb/users01.dbf tag=TAG20120326T174520
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 2012-03-26 18:49:09

sql statement: alter system archive log current

contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script

datafile 1 switched to datafile copy
input datafile copy RECID=3 STAMP=778963750 file name=/U01/app/oracle/oradata/bfodb/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=4 STAMP=778963750 file name=/U01/app/oracle/oradata/bfodb/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=5 STAMP=778963750 file name=/U01/app/oracle/oradata/bfodb/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=6 STAMP=778963750 file name=/U01/app/oracle/oradata/bfodb/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=7 STAMP=778963750 file name=/U01/app/oracle/oradata/bfodb/saybfo01.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=8 STAMP=778963750 file name=/U01/app/oracle/oradata/bfodb/saybfo02.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=9 STAMP=778963750 file name=/U01/app/oracle/oradata/bfodb/saybfo03.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=10 STAMP=778963750 file name=/U01/app/oracle/oradata/bfodb/saybfo_ind01.dbf
datafile 9 switched to datafile copy
input datafile copy RECID=11 STAMP=778963750 file name=/U01/app/oracle/oradata/bfodb/saybfo_ind.dbf
Finished Duplicate Db at 2012-03-26 18:49:16

SQL> create spfile from pfile;

File created.

SQL> shutdown immediate
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.

SQL> startup mount
ORACLE instance started.

Total System Global Area 1.6569E+10 bytes
Fixed Size 2244832 bytes
Variable Size 1.6274E+10 bytes
Database Buffers 268435456 bytes
Redo Buffers 24104960 bytes
Database mounted.

QL> alter system set local_listener=sbfodb;

System altered.

create configuration 'bfodb_dg' as
primary database is 'bfodb'
connect identifier is bfodb;

add database 'sbfodb' as
connect identifier is sbfodb
maintained as physical;

enable configuration;

ITPub博客

搭建物理DataGuard

最新文章