oracle 辅助实例,RMAN创建辅助实例

//查看目标实例的初始化参数文件(SPFILE)和口令文件的名称和格式

[oracle@OraLinux dbs]$ cd

[oracle@OraLinux ~]$ cd $ORACLE_HOME/dbs

[oracle@OraLinux dbs]$ ll

total 7016

……

-rw-r----- 1 oracle oinstall2048 Jun4 08:53 orapwdb

-rw-r----- 1 oracle oinstall2560 Jul 11 00:00 spfiledb.ora

……

//效仿目标实例的口令文件格式创建辅助实例的口令格式，(辅助实例的sid为：dbbkup)

//如果此处口令文件内容或格式创建不当，将直接影响到后面的操作，慎重

[oracle@OraLinux dbs]$ orapwd file=$ORACLE_HOME/dbs/orapwdbbkup

password=sys entries=30 force=y

//效仿目标实例，创建辅助实例相关

[oracle@OraLinux oracle]$ cd /oracle/app/oracle/admin

[oracle@OraLinux admin]$ mkdir dbbkup

[oracle@OraLinux admin]$ cd dbbkup

[oracle@OraLinux dbbkup]$ mkdir adump bdump

cdump dpdump pfile udump

[oracle@OraLinux admin]$ chmod -R 750

dbbkup

[oracle@OraLinux admin]$ ll dbbkup

total 24

drwxr-x--- 2 oracle oinstall 4096 Jul 10

22:47 adump

drwxr-x--- 2 oracle oinstall 4096 Jul 10

22:47 bdump

drwxr-x--- 2 oracle oinstall 4096 Jul 10

22:47 cdump

drwxr-x--- 2 oracle oinstall 4096 Jul 10

22:47 dpdump

drwxr-x--- 2 oracle oinstall 4096 Jul 10

22:47 pfile

drwxr-x--- 2 oracle oinstall 4096 Jul 10

22:47 udump

[oracle@OraLinux admin]$ cd

/oracle/app/oracle/oradata/

[oracle@OraLinux oradata]$ mkdir dbbkup

[oracle@OraLinux oradata]$ chmod -R 750

dbbkup

//以目标实例连接，并创建辅助实例的文本格式的初始化参数文件

[oracle@OraLinux dbs]$ sqlplus sys/sys@db

as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production

on Sun Jul 10 22:39:59 2011

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> create pfile =

'$ORACLE_HOME/dbs/initdbbkup.ora' from spfile;

File created.

//根据情况修改文本格式初始化参数文件部分内容，注：黑体部分内容为新加

[oracle@OraLinux dbs]$ cd $ORACLE_HOME/dbs

[oracle@OraLinux dbs]$ vi initdbbkup.ora

db.__shared_pool_size=587202560

*.audit_file_dest='/oracle/app/oracle/admin/dbbkup/adump'

*.background_dump_dest='/oracle/app/oracle/admin/dbbkup/bdump'

*.control_files='/oracle/app/oracle/oradata/dbbkup/control01.ctl','/oracle/app/oracle/oradata/dbbkup/control02.ctl','/oracle/app/oracle/oradata/dbbkup/control03.ctl'

*.core_dump_dest='/oracle/app/oracle/admin/dbbkup/cdump'

*.user_dump_dest='/oracle/app/oracle/admin/dbbkup/udump'

db_file_name_convert=('/oracle/app/oracle/oradata/db','/oracle/app/oracle/oradata/dbbkup')

log_file_name_convert=('/oracle/app/oracle/oradata/db','/oracle/app/oracle/oradata/dbbkup')

//创建辅助实例的SPFILE

[oracle@OraLinux dbs]$ export

ORACLE_SID=dbbkup

[oracle@OraLinux dbs]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production

on Sun Jul 10 23:05:18 2011

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

Connected to an idle instance.

SQL> startup nomount

pfile='$ORACLE_HOME/dbs/initdbbkup.ora';

ORACLE instance started.

Total System Global Area239075328 bytes

Fixed Size1218724 bytes

Variable Size79693660 bytes

Database Buffers155189248 bytes

Redo Buffers2973696 bytes

SQL> startup force nomount;

ORACLE instance started.

Total System Global Area239075328 bytes

Fixed Size1218724 bytes

Variable Size79693660 bytes

Database Buffers155189248 bytes

Redo Buffers2973696 bytes

SQL>

//在TNSNAMES.ora中添加辅助实例信息，并重启监听服务

SQL>exit

[oracle@OraLinux dbs]$ export ORACLE_SID=db

[oracle@OraLinux dbs]$ vi

$ORACLE_HOME/network/admin/tnsnames.ora

//添加以下内容

DBBKUP =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = OraLinux)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = dbbkup)

(UR=A)

)

)

[oracle@OraLinux dbs]$ lsnrctl stop

[oracle@OraLinux dbs]$ lsnrctl start

//同时连接到目标实例和辅助实例

[oracle@OraLinux dbs]$ rman target /

auxiliary sys/sys@dbbkup

Recovery Manager: Release 10.2.0.1.0 -

Production on Mon Jul 11 00:21:11 2011

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

connected to target database: DB

(DBID=1511596828)

connected to auxiliary database: DBBKUP

(not mounted)

RMAN>

//辅助实例创建完成？[@more@]