|
|
|
|
| Re: help implementation ORACLE DATA GUARD 10G [message #276293 is a reply to message #276213] |
Wed, 24 October 2007 12:40   |
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 |
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 |
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 |
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 |
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 #278949 is a reply to message #276213] |
Tue, 06 November 2007 07:23 |
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 |
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 |
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 |
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;
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
