Home » RDBMS Server » Backup & Recovery » how to create auxiliary instance
how to create auxiliary instance [message #319885] Tue, 13 May 2008 06:04 Go to next message
malvika
Messages: 55
Registered: May 2008
Location: india
Member

i want to create auxiliary instance for remote database.

tell me how i will create .

and also tell me how many instance can be open at a time and what is actually instance.
Re: how to create auxiliary instance [message #320022 is a reply to message #319885] Tue, 13 May 2008 13:52 Go to previous messageGo to next message
pokhraj_das
Messages: 64
Registered: February 2008
Member

Hi,

To create the aux instance perform the followe ing steps:-


1. create the directory bdump, udump, cdump, pfile.

2.copy the prod database init.ora file to the location where u want to craete the aux instance.

3.If u want to create the aux instance at the same host change the db_name parameter value to different name for example aux1 or if u want to create the aux instance at the different host then u can continue at the same db_name.

4. Change the bdump, cdump, udump path at the init.ora file.

5. Change the controlfile path where u want to create the control file.

6. Create the ora password file by using orapwd.

7. configure the tnsnames.ora file at the aux instance and the listener.ora file at the target database.

8.connect through sql prompt using pfile parameter.
sql> startup force nomount pfile='<full path>';

9. create spfile.
sql> create spfile from pfile;

pokhraj
Re: how to create auxiliary instance [message #320061 is a reply to message #320022] Tue, 13 May 2008 23:42 Go to previous messageGo to next message
malvika
Messages: 55
Registered: May 2008
Location: india
Member

thanks


but are you sure for change db_name instead of instance_name or lock_name_space.
Re: how to create auxiliary instance [message #320148 is a reply to message #319885] Wed, 14 May 2008 03:16 Go to previous messageGo to next message
pokhraj_das
Messages: 64
Registered: February 2008
Member

"lock_name_space" is the parameter if u want to create your aux instance at the same host. if it is for different host no need to space the "lock_name_space" parameter.

Pokhraj
Re: how to create auxiliary instance [message #320151 is a reply to message #320148] Wed, 14 May 2008 03:19 Go to previous messageGo to next message
malvika
Messages: 55
Registered: May 2008
Location: india
Member

on same host i want to create auxiliary instance.

and not want to change db_name what i should do?
Re: how to create auxiliary instance [message #581753 is a reply to message #320022] Wed, 10 April 2013 06:33 Go to previous messageGo to next message
mueen_aq
Messages: 2
Registered: March 2013
Location: karachi
Junior Member
i facing following error during starting Auxilary Instance Guide

SQL> startup nomount pfile='initSTDYDB.ora';
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER'
Re: how to create auxiliary instance [message #583856 is a reply to message #320022] Mon, 06 May 2013 02:08 Go to previous messageGo to next message
mueen_aq
Messages: 2
Registered: March 2013
Location: karachi
Junior Member
I followed all steps but prompt following message, how to resole this error. I have two virtual machine one has Primary DB named "orcl" and on second PC i want to create stand by DB but Auxiliary instance is unable to start.

SQL> startup nomount pfile='init.ora';
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00130: invalid listener address '(ADDRESS=(PROTOCOL=TCP)(HOST=server2)(PORT=1521))'
SQL>

Following is listener.ora configuration.(Stand By DB Machine)
"
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orclstby)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = orclstby)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = ORCL)
)
)

LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.17.13)(PORT = 1521))
)

ADR_BASE_LISTENER = /u01/app/oracle
"

Following is listener.ora configuration.(Primary DB Machine)


SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = orcl)
)
(SID_DESC =
(GLOBAL_DBNAME = orclstby)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = orclstby)
)
)

LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.17.12)(PORT = 1521))
)

ADR_BASE_LISTENER = /u01/app/oracle
Re: how to create auxiliary instance [message #584028 is a reply to message #583856] Wed, 08 May 2013 01:36 Go to previous message
forkausar
Messages: 4
Registered: May 2013
Junior Member
STEP1 Install oracle database software auxiliary host.

STEP2 Create an Oracle Password File for the Auxiliary Instance
Orapwd file=C:\oracle\product\10.2.0\db_1\DATABASE\PWDLHDUP.ora password=DUP

STEP3 Create an Initialization Parameter File for the Auxiliary Instance
Use following list of commands to create parameters file using existing/target DB. This file will be used in creation of new auxiliary
instance.

Login to Target DB
-------------------
SQL>SYS/****@LHR AS SYSDB
SQL>Create pfile='C:\initLHDUP.ora' from spfile;

The file will be created on existing/target host copy or move newly created file to Auxiliary host
C:\oracle\product\10.2.0\db_1\DATABASE\initLHDUP.ora

Modify parameters. All path parameter should be accessible on Auxiliary host.

db_name='LHDUP'
db_file_name_convert=
('d:\oracle_data_files\oradata\LHDB',
'c:\oracle_data_files\LHDUP\oradata')

log_file_name_convert=
('d:\oracle_data_files\oradata\LHDB',
'c:\oracle_data_files\LHDUP\oradata')

control_files=
'C:\oracle_data_files\LHDUP\oradata\control01.ctl',
'C:\oracle_data_files\LHDUP\oradata\control02.ctl',
'C:\oracle_data_files\LHDUP\oradata\control03.ctl'

compatible='10.2.0.1.0'
db_block_size=8192 #The block size for the auxiliary database must match that of the target DB
db_cache_size=50331648
java_pool_size=25165824
large_pool_size=4194304
shared_pool_size=33554432
streams_pool_size=0
pga_aggregate_target=16777216
sga_max_size=113246208
sga_target=167772160

audit_file_dest='C:\oracle_data_files\LHDUP\admin\adump'
background_dump_dest='C:\oracle_data_files\LHDUP\admin\bdump'
core_dump_dest='C:\oracle_data_files\LHDUP\admin\cdump'
user_dump_dest='C:\oracle_data_files\LHDUP\admin\udump'

STEP4 Create directory structure on duplicate host

C:\flash_recovery_area\LHDB\BACKUPSET
C:\oracle_data_files\LHDUP\oradata
C:\oracle_data_files\LHDUP\admin
C:\oracle_data_files\LHDUP\flash_recovery_area\ARCHIVELOG
C:\oracle_data_files\LHDUP\admin\adump
C:\oracle_data_files\LHDUP\admin\bdump
C:\oracle_data_files\LHDUP\admin\cdump
C:\oracle_data_files\LHDUP\admin\udump
C:\oracle_data_files\LHDUP\admin\dpdump
C:\oracle_data_files\LHDUP\admin\pfile
C:\oracle_data_files\LHDUP\admin\scripts

STEP-4 Create Auxiliary Instance

ORADIM -NEW -SID LHDUP -intpwd change_on_install -startmode auto
-pfile 'c:\oracle\product\10.2.0\db_1\database\initLHDUP.ora'

ORADIM -NEW -SID LHDUP -startmode auto -pfile
'c:\oracle\product\10.2.0\db_1\database\initLHDUP.ora'

ORADIM -DELETE -SID LHDUP # to delete existing instance
SET ORACLE_SID=LHDUP

http://www.learnoracledatabase.com/rman/duplicating-database-using-rman-duplicate-command

[Updated on: Wed, 08 May 2013 02:05]

Report message to a moderator

Previous Topic: Duplicating a Database with RMAN
Next Topic: Duplicate target RMAN cloning
Goto Forum:
  


Current Time: Fri Aug 01 03:15:36 CDT 2014

Total time taken to generate the page: 0.12486 seconds