Home » Server Options » Data Guard » help implementation ORACLE DATA GUARD 10G
help implementation ORACLE DATA GUARD 10G [message #276213] Wed, 24 October 2007 06:50 Go to next message
pepernuk
Messages: 7
Registered: July 2007
Location: italy
Junior Member
Hi guys, i'm italian and i don't speak english very well. I have
2 pc notebook and i must implementing oracle data guard 10g, on each notebook has windwos Xp.
notebook 1: hostname angelo-asus ip: 192.168.1.46
notebook 2: hostname angelo-acer ip:192.168.1.96

I installing oracle enterprise manager 10g on each notebook???
Please Help!!! Sad

p.s. i read this document to link
http://www.orafaq.com/wiki/Data_Guard_implementation_for_Oracle_10gR2#PRIMARY_SITE:_.28Information.29
Re: help implementation ORACLE DATA GUARD 10G [message #276279 is a reply to message #276213] Wed, 24 October 2007 11:11 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Check this guide to implement REAL TIME DG.
You can raise question if you can't understand the document.
Re: help implementation ORACLE DATA GUARD 10G [message #276293 is a reply to message #276213] Wed, 24 October 2007 12:40 Go to previous messageGo to next message
pepernuk
Messages: 7
Registered: July 2007
Location: italy
Junior Member
Thank you DreamzZ for document, but

I don't understand same things:
1. Must I to intall oracle enterprise manager 10g on each notebook?

So
notebook a: Windows Xp with oracle enterprise manager and primary database

notebook b: Windows Xp with oracle enterprise manager whitout
standby database because i must before copy datafiles, logfiles and control files primary database.

Help me please
Re: help implementation ORACLE DATA GUARD 10G [message #276307 is a reply to message #276293] Wed, 24 October 2007 14:33 Go to previous messageGo to next message
ualual
Messages: 22
Registered: May 2005
Junior Member
pepernuk
it might help if you need it: http://www.google.com/language_tools

----
if you can remove oracle from both Notebooks
--
next
--
install oracle on Notebook A (notebook A=NA) make sure you know your FILE STRUCTURE
--
On Notebook B (notebook B=NB) install oracle the same way
--
now read the documentation from the previous note
--

Google Translation (not me)
--
Se potete
Rimuovere oracolo da entrambe Notebooks
--
Successivo
--
Oracolo installare su Notebook A (A = taccuino NA)
Assicuratevi di conoscere il vostro FILE STRUTTURA
--
Il Notebook B (B = taccuino NB)
Installare oracolo stesso modo
--
Ora di leggere la documentazione dalla nota precedente
--

[Updated on: Wed, 24 October 2007 14:35]

Report message to a moderator

Re: help implementation ORACLE DATA GUARD 10G [message #276317 is a reply to message #276213] Wed, 24 October 2007 16:00 Go to previous messageGo to next message
pepernuk
Messages: 7
Registered: July 2007
Location: italy
Junior Member
Ual, thanks for the information you gave me. Now I try and do you know how it went. Thank you very much! !

I wanted to ask you another thing:
Notebook A: install Oracle database and the primary
Notebook B: should install only Oracle without standby database?
Thanks for your availability
Re: help implementation ORACLE DATA GUARD 10G [message #276602 is a reply to message #276317] Thu, 25 October 2007 10:39 Go to previous messageGo to next message
ualual
Messages: 22
Registered: May 2005
Junior Member
pepernuk

On "both" notebooks ( A and B) install the full oracle enterprise database. Of course, there are a ton of ways to CLONE or RMAN..etc but to keep it simple:


If you are on windows

Step 1: on both Notebooks
uninstall oracle
Clean up the regedit stuff
clean up the directories,etc

Step 2:
Install ORACLE Enterprise on Notebook A
Make sure you pick a good SID name ( for ex oradg )
Make sure it works after the installation.

Step 3:
Install ORACLE Enterprise on Notebook B
Give it the SAME Sid name ( oradg )
Make sure it works after the installation.

Step 4:
Read the Documentation
Go slow in the doc. One step at a time.


Re: help implementation ORACLE DATA GUARD 10G [message #276639 is a reply to message #276602] Thu, 25 October 2007 13:07 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:

notebook b: Windows Xp with oracle enterprise manager whitout
standby database because i must before copy datafiles, logfiles and control files primary database.



You should clear your ideas about Standby Database.
Actually standby is the copy of your primary or you can production.
Which you can either make by rman hot backup or cold backup.

1:put database in force logging (to generate redo for every action approx)
2:change your parameters for primary and standby
3:recreate password file (optional)
4:take backup either by RMAN hot or COLD.
5:in mount stage make standby controlfile (optional mount)
6:scp or ftp the backup ,pfile,passwordfile and edit the pfile.
7:check your database by starting it
8:startup again it up to mount and pace it managed recovery mode.
Re: help implementation ORACLE DATA GUARD 10G [message #276648 is a reply to message #276213] Thu, 25 October 2007 16:35 Go to previous messageGo to next message
pepernuk
Messages: 7
Registered: July 2007
Location: italy
Junior Member
Boys many thanks for your assistance and your patience. Now I try and do you know.
Re: help implementation ORACLE DATA GUARD 10G [message #278949 is a reply to message #276213] Tue, 06 November 2007 07:23 Go to previous messageGo to next message
pepernuk
Messages: 7
Registered: July 2007
Location: italy
Junior Member
Hello boys, I have followed your advice but I had some problems. I place my configuration:

NOTEBOOK A: PRIMARY SITE | NOTEBOOK B: STANDBY SITE
HOSTNAME = angelo-acer | HOSTNAME = angelo-asus
STATIC IP = 192.168.0.2 | STATIC IP = 192.168.0.3
OS = WINDOWS XP SERVICE PACK 2 | OS= WINDOWS XP SERVICE PACK 2
SERVICE NAME = rhclu1p | SERVICE NAME= rhclu2p


-----------/////NOTEBOOK A////-----------

I installed Oracle Enterprise Manager 10g on notebook A with database global name = v102p and sid = v102p. Then I changed the parameters initialization:


PFILE in c:\oracle\product\10.2.0\db_1\database\pfilev102p.ora

v102p.__db_cache_size=297795584
v102p.__java_pool_size=4194304
v102p.__large_pool_size=4194304
v102p.__shared_pool_size=138412032
v102p.__streams_pool_size=0
*.audit_file_dest='C:\oracle\product\10.2.0/admin/rhclu1p/adump'
*.background_dump_dest='C:\oracle\product\10.2.0/admin/rhclu1p/bdump'
*.compatible='10.2.0.1.0'
*.control_files='C:\oracle\product\10.2.0/oradata/rhclu1p/\control01.ctl','C:\oracle\product\10.2.0/oradata/rhclu1p/\control02.ctl',' C:\oracle\product\10.2.0/oradata/rhclu1p/\control03.ctl'
*.core_dump_dest='C:\oracle\product\10.2.0/admin/rhclu1p/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='v102p'
*.db_recovery_file_dest='C:\oracle\product\10.2.0/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.db_unique_name='rhclu1p'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=v102pXDB)'
*.fal_client='rhclu1p'
*.fal_server='rhclu2p'
*.job_queue_processes=10
*.log_archive_config='DG_CONFIG=(rhclu1p','rhclu2p)'
*.log_archive_dest_1='LOCATION=C:\oracle\product\10.2.0\admin\v102p\arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=rhclu1p'
*.log_archive_dest_2='SERVICE=rhclu2p VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=rhclu2p'
*.open_cursors=300
*.pga_aggregate_target=149946368
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=450887680
*.standby_archive_dest='C:\oracle\product\10.2.0\admin\v102p\arch'
*.standby_file_management='AUTO'
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='C:\oracle\product\10.2.0/admin/rhclu1p/udump'


SPFILE in c:\oracle\product\10.2.0\db_1\dbs\spfilev102p.ora

v102p.__db_cache_size=297795584
v102p.__java_pool_size=4194304
v102p.__large_pool_size=4194304
v102p.__shared_pool_size=138412032
v102p.__streams_pool_size=0
*.audit_file_dest='C:\oracle\product\10.2.0/admin/rhclu1p/adump'
*.background_dump_dest='C:\oracle\product\10.2.0/admin/rhclu1p/bdump'
*.compatible='10.2.0.1.0'
*.control_files='C:\oracle\product\10.2.0/oradata/rhclu1p/\control01.ctl','C:\oracle\product\10.2.0/oradata/rhclu1p/\control02.ctl',' C:\oracle\product\10.2.0/oradata/rhclu1p/\control03.ctl'
*.core_dump_dest='C:\oracle\product\10.2.0/admin/rhclu1p/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='v102p'
*.db_recovery_file_dest='C:\oracle\product\10.2.0/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.db_unique_name='rhclu1p'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=v102pXDB)'
*.fal_client='rhclu1p'
*.fal_server='rhclu2p'
*.job_queue_processes=10
*.log_archive_config='DG_CONFIG=(rhclu1p','rhclu2p)'
*.log_archive_dest_1='LOCATION=C:\oracle\product\10.2.0\admin\v102p\arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=rhclu1p'
*.log_archive_dest_2='SERVICE=rhclu2p VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=rhclu2p'
*.open_cursors=300
*.pga_aggregate_target=149946368
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=450887680
*.standby_archive_dest='C:\oracle\product\10.2.0\admin\v102p\arch'
*.standby_file_management='AUTO'
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='C:\oracle\product\10.2.0/admin/rhclu1p/udump'


LISTENER in c:\oracle\product\10.2.0\db_1\network\admin\listener.ora

# listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ANGELO-ACER)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)

RESULT LINESTER IS OK!!


TNSNAMES in c:\oracle\product\10.2.0\db_1\network\admin\listener.ora

# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

RHCLU2P =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.3)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = rhclu2p)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)


----------------//////NOTEBOOK B//////-------------------

I installed Oracle Enterprise Manager 10g on notebook A with database global name = v102p and sid = v102p. Then I copied datafile, standby_control files, from c: \ oracle \ product \ 10.2.0 \ oradata \ rhclu1p containing

CONTROL01.ctl
CONTROL02.ctl
CONTROL03.ctl
REDO01.txt
REDO02.txt
REDO03.txt
STANDBY_CONTROL01.ctl
STANDBY_CONTROL02.ctl
STANDBY_CONTROL03.ctl
SYSAUX01.DBF
SYSTEM01.DBF
TEMP01.DBF
UNDOTBS01.DBF
USER01.DBF

And I put them in the folder notebook B
C: \ oracle \ product \ 10.2.0 \ oradata \ v102p

And
C: \ oracle \ product \ 10.2.0 \ oradata \ rhclu2p

I copied also pfilev102p.ora and orapwdv102p notebook A and I copied into their respective folders notebook B. Then I changed stadnby inizialization Parameters:


SPFILE in c:\oracle\product\10.2.0\db_1\dbs\spfilev102p.ora

v102p.__java_pool_size=4194304
v102p.__large_pool_size=4194304
v102p.__shared_pool_size=71303168
v102p.__streams_pool_size=0
*.audit_file_dest='C:\oracle\product\10.2.0/admin/rhclu2p/adump'
*.background_dump_dest='C:\oracle\product\10.2.0/admin/rhclu2p/bdump'
*.compatible='10.2.0.1.0'
*.control_files='C:\oracle\product\10.2.0/oradata/rhclu2p/\control01.ctl','C:\oracle\product\10.2.0/oradata/rhclu2p/\control02.ctl',' C:\oracle\product\10.2.0/oradata/rhclu2p/\control03.ctl'
*.core_dump_dest='C:\oracle\product\10.2.0/admin/rhclu2p/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='V102P'
*.db_recovery_file_dest='C:\oracle\product\10.2.0/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.db_unique_name='rhclu2p'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=V102PXDB)'
*.fal_client='rhclu2p'
*.fal_server='rhclu1p'
*.job_queue_processes=10
*.log_archive_config='DG_CONFIG=(rhclu1p','rhclu2p)'
*.log_archive_dest_1='LOCATION=C:\oracle\product\10.2.0\admin\v102p\arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=rhclu2p'
*.log_archive_dest_2='SERVICE=rhclu1p LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=rhclu1p'
*.open_cursors=300
*.pga_aggregate_target=16777216
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=167772160
*.standby_archive_dest='C:\oracle\product\10.2.0\admin\v102p\arch'
*.standby_file_management='AUTO'
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='C:\oracle\product\10.2.0/admin/rhclu2p/udump'

then always on notebook B:

sql> create pfile from spfile='c:\oracle\product\10.2.0\db_1\dbs\spfilev102p.ora';


LISTENER in C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora

# listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ANGELO-ASUS)(PORT = 1521))
)

RESULT LINESTER IS OK!!


TNSNAMES in C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora


# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

RHCLU1P =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = rhclu1p)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

RESULT TEST TNSNAMES ON NOTEBOOK A AND B IS OK!!!

Then I started the standby database with the following commands:
sql>startup mount;
sql>alter database recover managed standby database disconnect;

On primary site:
sql>alter system switch logfile;

So on standby database:
sql>select sequence#,first_time,next_time from v$archived_log order by sequence;

........................
........................
SEQUENCE# FISRT_TIME NEXT_TIME
--------- ---------- ---------
14 06-NOV-07 06-NOV-07
15 06-NOV-07 06-NOV-07
16 06-NOV-07 06-NOV-07
17 06-NOV-07 06-NOV-07

Up to this point everything is ok

But when I run the command on standby site:

sql>select sequence#,applied from v$archived_log order by sequence#;

I get the following screen:

SEQUENCE# APP
--------- ----
3 NO
4 NO
5 NO
6 NO
7 NO
8 NO
9 NO
10 NO
11 NO
12 NO
13 NO
14 NO
15 NO
16 NO
17 NO

select 15 lines

I do not know what to do, please help me
Re: help implementation ORACLE DATA GUARD 10G [message #279271 is a reply to message #278949] Wed, 07 November 2007 10:14 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Check the Status of log files whether the are copying on standby or not, and one more thing .
Run this command on primary.

•SQL> Select Status, Error 
from v$Archive_dest 
where dest_id=2;

The STATUS should return – VALID. If it returns Error, then check the connectivity between the Primary and Standby machines.
Re: help implementation ORACLE DATA GUARD 10G [message #282898 is a reply to message #276213] Sat, 24 November 2007 18:50 Go to previous messageGo to next message
pepernuk
Messages: 7
Registered: July 2007
Location: italy
Junior Member
Hello DreamzZ, excuse me unless I answered for a long time, I solved the problem with Configuring Oracle 10g.
I tried with Oracle 11g, and I had the same problem:
Executing the command:

Select Status, error from v $ archive_dest where dest_id = 2

Show me:

STATUS ERROR
----------------------------------------- --------- ----
VALID

What should I do?
When I solved this problem postero is my configuration.

Ps
Sorry if I was absent for all this time
Re: help implementation ORACLE DATA GUARD 10G [message #282930 is a reply to message #276213] Sun, 25 November 2007 03:23 Go to previous messageGo to next message
pepernuk
Messages: 7
Registered: July 2007
Location: italy
Junior Member
Hello boys, I solved the problem log apply running on standby database:


Sql> alter database recover managed standby database disconnect;

Applying the command on the primary database:

Sql> alter switch system logfile;

But I can not understand why the issue remains whether the first run the command on standby database:

Sql> alter database recover managed standby database using current logfile disconnect;
Re: help implementation ORACLE DATA GUARD 10G [message #283280 is a reply to message #282930] Mon, 26 November 2007 10:32 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Did you create REAL - Time Data Guard.?
Did you create standby redolog files?
Previous Topic: Automatic database startup issues after SWITCHOVER!
Next Topic: Real-time Redo Apply
Goto Forum:
  


Current Time: Thu Mar 28 03:25:21 CDT 2024