Home » Other » General » Oracle Virtualization (10g Release 10.1.0.3.0)
Oracle Virtualization [message #507441] Sun, 15 May 2011 05:59 Go to next message
Paules
Messages: 128
Registered: March 2011
Location: United Arab Emirates
Senior Member
Dear Friends,

Can u explain me Oracle virtualization and it's use?

Regards,
Paules
Re: Oracle Virtualization [message #507442 is a reply to message #507441] Sun, 15 May 2011 06:16 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Can you tell us to what you reference when you talk about "Oracle virtualization"?

Regards
Michel
Re: Oracle Virtualization [message #507443 is a reply to message #507442] Sun, 15 May 2011 06:33 Go to previous messageGo to next message
Paules
Messages: 128
Registered: March 2011
Location: United Arab Emirates
Senior Member
Dear Mr.Michel,

I have one 10g Release 10.1.0.3.0 database server . What ever DML,DDL,DCL.....going on in this server should be backed in another database server.Can Virtualization help me to achieve this?

Regards,
Paules.
Re: Oracle Virtualization [message #507444 is a reply to message #507443] Sun, 15 May 2011 06:43 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
It is called Oracle Dataguard.
http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/toc.htm

And seems folks including John already suggested dataguard to you in your previous thread.

[Updated on: Sun, 15 May 2011 06:46]

Report message to a moderator

Re: Oracle Virtualization [message #507445 is a reply to message #507444] Sun, 15 May 2011 07:12 Go to previous messageGo to next message
Paules
Messages: 128
Registered: March 2011
Location: United Arab Emirates
Senior Member
Dear Friends,

Iam New to Oracle server administration. Is it require seperate installing installation software for oracle data guard?

Regards,
paules.
Re: Oracle Virtualization [message #507447 is a reply to message #507445] Sun, 15 May 2011 07:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
No.
Did you read the link Raj provided you?
You need Entreprise Edition to use Data Guard but a standard one is sufficient to use standby database.

Regards
Michel
Re: Oracle Virtualization [message #507652 is a reply to message #507447] Tue, 17 May 2011 07:57 Go to previous messageGo to next message
Paules
Messages: 128
Registered: March 2011
Location: United Arab Emirates
Senior Member
Dear Friends,

I have Oracle Standard Edition. My Enterprise Manager is not having the option "Add Stand by database". How can I get it?

Regards,
Paules.
Re: Oracle Virtualization [message #507667 is a reply to message #507652] Tue, 17 May 2011 08:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
quoting BlackSwan:
Those who live by the GUI, die by the GUI.


http://www.orafaq.com/forum/mv/msg/139482/490232/102589/#msg_490232

Regards
Michel
Re: Oracle Virtualization [message #507668 is a reply to message #507652] Tue, 17 May 2011 08:22 Go to previous messageGo to next message
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Which "Enterprise Manager?" There is no Enterprise Manager in the Standard Edition, there might be an Enterprise Manager-Console, though.

The thing you can do with Standard Edition is to create a Standby Database manually.
Re: Oracle Virtualization [message #508033 is a reply to message #507668] Thu, 19 May 2011 02:13 Go to previous messageGo to next message
Paules
Messages: 128
Registered: March 2011
Location: United Arab Emirates
Senior Member
Dear Friends,

Thanks for all the information. I started to work in this.
While trying to create spfile for primary database, Iam getting the following error.
LRM-00123:Invalid character 7 found in the input file
ORA-01078l:Failure in processing system parameters


My SPFILE CONTENT IS
[[binary text removed]test.__db_cache_size=557842432
test.__java_pool_size=4194304
test.__large_pool_size=4194304
test.__shared_pool_size=335544320
test.__streams_pool_size=0
*.audit_file_dest='E:\oracle\product\10.2.0\admin\test\adump'
*.background_dump_dest='E:\oracle\product\10.2.0\admin\test\bdump'
*.compatible='10.2.0.3.0'
*.control_file_record_keep_time=0
*.control_files='E:\oracle\product\10.2.0\oradata\test\control01.ctl',
'E:\oracle\product\10.2.0\oradata\test\control02.ctl',
'E:\oracle\product\10.2.0\oradata\test\control0
3.ctl'*.core_dump_dest='E:\oracle\product\10.2.0
admin\test\cdump'
*.db_block_size=8192
*.db_domain='world'
*.db_file_multiblock_read_count=16
*.db_name='test'
*.db_recovery_file_dest='E:\oracle\product\10.2.0\flash_recovery_area'
*.db_recovery_file_dest_size=10737418240
*.dispatchers='(PROTOCOL=TCP) (SERVICE=testXDB)'
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=300941312
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=904921088
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='E:\oracle\product\10.2.0\admin\test\udump'
LOG_ARCHIVE_CONFIG='DG_CONFIG=(TEST,STDB)'
LOG_ARCHIVE_DEST_1=
'LOCATION='E:\oracle\product\10.2.0\flash_recovery_area\test\ARCHIVELOG'
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=test'
 LOG_ARCHIVE_DEST_2=
'SERVICE=STAN LGWR ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=STDB'
 LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
LOG_ARCHIVE_MAX_PROCESSES=30 FAL_SERVER=STDB
FAL_CLIENT=TEST
STANDBY_FILE_MANAGEMENT=AUTO
# Specify the location of the standby DB datafiles followed by the primary location;
DB_FILE_NAME_CONVERT='E:\DATA','E:\DATA_STDB'         
# Specify the location of the standby DB online redo log files followed by the primary location 
LOG_FILE_NAME_CONVERT='E:\oracle\product\10.2.0\oradata\stdby','E:\oracle\product\10.2.0\oradata\test',
'E:\oracle\product\10.2.0\flash_recovery_area\STDB\
ONLINELOG','E:\oracle\product\10.2.0\flash_recovery_area\TEST'


Please can anyone help me to solve?

Reagrds,
Paules.

[Updated on: Sat, 21 May 2011 09:24] by Moderator

Report message to a moderator

Re: Oracle Virtualization [message #508042 is a reply to message #508033] Thu, 19 May 2011 02:51 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
A spfile is a BINARY file not a TEXT one.
Use CREATE PFILE FROM SPFILE statement if you want to modify some parameters (for another database, for the current one user ALTER SYSTEM).

Regards
Michel
Re: Oracle Virtualization [message #508447 is a reply to message #508042] Sat, 21 May 2011 06:07 Go to previous messageGo to next message
Paules
Messages: 128
Registered: March 2011
Location: United Arab Emirates
Senior Member
Dear Friends,

While trying to execute
alter database flashback on;


Iam getting the following error

Error at Line 1
ORA-00439: Feature not enabled:flashback database


Can anyone help me to solve?


Regards,
Paules
Re: Oracle Virtualization [message #508463 is a reply to message #508447] Sat, 21 May 2011 09:20 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
What does this have to do with "virtualization"?

Regards
Michel
Re: Oracle Virtualization [message #508487 is a reply to message #508463] Sun, 22 May 2011 01:59 Go to previous messageGo to next message
Paules
Messages: 128
Registered: March 2011
Location: United Arab Emirates
Senior Member
Dear Mr.Michel,

Iam working on the steps given in the following link to achieve Virtualization.

http://www.db-ora.nl/dataguard.html. Is it correct ?

Regards,
Paules.

Re: Oracle Virtualization [message #508491 is a reply to message #508487] Sun, 22 May 2011 02:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
And in the end I have the answer to my first question a week ago.
You do not need flashback feature to create a standby database.
Standby databases existed far before flashback does.
Hopefully for you as you can't have flashback in your edition.

Watch the following to build you standby database:
http://www.orafaq.com/forum/mv/msg/139482/490232/102589/#msg_490232

Regards
Michel


Re: Oracle Virtualization [message #508492 is a reply to message #508491] Sun, 22 May 2011 02:27 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
And in the end I have the answer to my first question a week ago

I stand corrected, the link do NOT mention "virtualization", so I still have not the answer to my question.

Regards
Michel
Re: Oracle Virtualization [message #509513 is a reply to message #508492] Sun, 29 May 2011 01:45 Go to previous messageGo to next message
Paules
Messages: 128
Registered: March 2011
Location: United Arab Emirates
Senior Member
To have Physical and Standby database in the same Machine, is it require to have two Oracle Homes?

Regards,
Paules.
Re: Oracle Virtualization [message #509517 is a reply to message #509513] Sun, 29 May 2011 02:17 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
What is your opinion?
Did you try with one home? What happened?

Regards
Michel

[Updated on: Sun, 29 May 2011 02:17]

Report message to a moderator

Re: Oracle Virtualization [message #509659 is a reply to message #509517] Tue, 31 May 2011 01:21 Go to previous messageGo to next message
Paules
Messages: 128
Registered: March 2011
Location: United Arab Emirates
Senior Member
Dear Mr.Micheal,

I tried with one home. Both the databases are not working.

Regards,
Paules
Re: Oracle Virtualization [message #509662 is a reply to message #509659] Tue, 31 May 2011 01:28 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
What does mean "Both the databases are not working"?

Regards
Michel
Previous Topic: i need help Oracle
Next Topic: Raise oracle tar (split from highjacked thread by CM)
Goto Forum:
  


Current Time: Tue Nov 26 04:18:59 CST 2024