I want clear the concept of auxiliary database. What's the use/advantages of it. Is it the another oracle instance? What is the difference between Auxiliary Database and Target Database?
View 3 RepliesPreviously it is working fine but today when i am trying to duplicate a database using rman not getting exactly error but the o/p is as below
C:Usersdbadmin>rman target sys/tiger@na Recovery Manager: Release 11.2.0.1.0 - Production on Thu Jun 27 15:33:33 2013 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. connected to target database: NA (DBID=1572981579) RMAN> connect auxiliary sys/tiger@da connected to auxiliary database: NOIDA (DBID=1572981579, not open)
It is correct that the rman is connected to the db with name na but not with db da Previously i am able to connect both the instance.
How one should know whether RMAN is using target database control file or using separate catalog database. Also what one should do if he dont have catalog users credentials.
View 3 Replies View RelatedI have failed to duplicate target db for standby from active db using spfile with the following errors:
RMAN-03009: failure of backup command on prim1 channel at 08/11/2010 05:25:09
ORA-19558: error de-allocating device
ORA-19557: device error, device type: DISK, device name:
ORA-17627: ORA-01041: internal error. hostdef extension doesn't exist
[Code].....
The script has successfully created on standby db all controlfiles and also has copied 2 data files DATA01.DBF and DATA02.DBF into the correct location. Then the errors above kicked in and stopped the rman dup process.
i want to create auxiliary instance for remote database.how i will create .how many instance can be open at a time and what is actually instance.
View 7 Replies View RelatedI am getting ora-24010 error in the target database where I am configuring the apply process, DB is 10.2.0.1 on RHEL
SQL> conn strmadmin/strmadmin@db2
Connected.
SQL> begin dbms_streams_adm.add_table_rules
2 ( table_name => 'scott.test',
3 streams_type => 'apply',
4 streams_name => 'apply_stream',
[code]...
The capture process and the propogation rule and scn instantiation on the source were executed fine withut issue, I am having problem in the apply process.
We have two databases dev and prod in one server. I would like to connect to target database prod without a recovery catalog. Issued the below command and getting the following error message.
rman target sys/sys_password nocatalog.
Error we are getting is : Recovery Manager: Release 11.2.0.2.0 - Production on Fri Nov 18 11:31:59 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01031: insufficient privileges
I have also created the password files for both the databases and tried but facing the same issues.
I ran the script "Duplicate target database for standby" but it unable to open the database. Below are the rman scripts -
calhost dbs]$ rman target sys/oracle@PRODDB auxiliary sys/oracle
Recovery Manager: Release 10.2.0.1.0 - Production on Tue Jun 25 06:09:33 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: PRODDB (DBID=558988263)
connected to auxiliary database: PRODDB (not mounted)
[code]....
Though I have taken the same backup but it's suggesting about the system datafile.
I have a confusion with MEMORY_TARGET and MEMORY_MAX_TARGET parameter. if i set SGA_TARGET, SGA_MAX_SIZE along with MEMORY_TARGET and MEMORY_MAX_TARGET then how oracle will manage the memory? Because as per my understanding if we set MEM
View 3 Replies View Related1.what is the difference between install database and create database?
2. if i have connected with remote database(server) then it is an instance again?
Can the target database and the recovery catalog database be the same?
View 5 Replies View Relatedi want to know is there any difference between upgradation of SID and database. while upgrading my database from oracle 11.2.0.2 to 11.2.0.3 in DBUA it shows my SID is upgrading (ORCL) but i have few other databases ex (test and prod).
is it enough if we upgrade the SID or we must perform any other actions..
and
2nd QUERY :
i have 2 oracle homes in my server with different versions like (11.2.0.2 and 11.2.0.3)and i have few databases and there tablespaces. how to determine which database is created on which version and which database is upgraded from 11.2.0.2 to 11.2.0.3.
Tell me the difference between Oracle RAC and Non RAC database including commands and architecture?
View 4 Replies View RelatedWe are using the 11.1.0.7 database, we implemented the Memory_Max_Target and Memory_target in the database.Here is the value of the memory parameters:
SQL> show parameter memory_
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0
memory_max_target big integer 3G
memory_target big integer 2G
shared_memory_address integer 0
We want to increase the value of the Memory_target=3G, means, I want to increase the value of the memory_target upto Memory_max_target by using below command:alter system set MEMORY_TARGET=3G scope=both SID='OLTP1'; but I am getting below error:
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00846: could not shrink MEMORY_TARGET to specified value
I tried to give the memory_target value less than the memory_max_target value like:alter system set MEMORY_TARGET=2900M scope=both SID='OLTP1'; but get the same error:
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00846: could not shrink MEMORY_TARGET to specified value
What is the difference between Database Modelling and Database Designing ?
View 5 Replies View RelatedDifference of standby and clone,i know their uses but i want a detailed explanation.
View 2 Replies View RelatedCurrently I am doing one Oracle installation.But very much confused where to start from. Since I am installing oracle on my personaly Laptop,do I need to install Oracle database server and Oracle client both or only installing database server is sufficient.
What is the exact difference between oracle database server and client.Only knowledge I have is that client is used to access database server remotely.are Oracle database server and client installable to be downloaded separately?
I want to know what is the difference between the file catproc that we run after creation of the database in the Oracle 9i,10g and 11g r2. I have run that file in 11g R2 but it is taking more time and more over there are many new things that i saw in 11g R2 than what were there in 9i and 10g.
View 11 Replies View RelatedWhat is difference between the flashback database(10g later) and incomplete recover?
View 5 Replies View RelatedOracle database 11.2
What is the difference between
recover database until cancel using backup controlfile; and alter database recover automatic until cancel;
1. in user managed and server managed backups. What would be the location of the controlfile which is used in (recover database until cancel using backup controlfile;) .
2. why user first option and why use second option.
We are having major differences in performance when accessing an Oracle 11gR2 database from two different environments.
I won't sadden you with the gory details of the full application but I will use an indicative example of our problem.
We have SQL Developer in both environments. In each of these SQL Developer instances is a defined a connection to the same database on another machine. So there is the PC looking at a database and a virtual instance looking at the same database.
Selecting the '+' sign next to 'tables' for that connection, on the PC the list of four tables comes back in 4 seconds but on the virtual instance the list of the same four tables comes back in 1 minute and 50 seconds.
This sort of timing issue is repeatable for all accesses to the Oracle database on the third machine.
Detail table will look like below:
Product_id issue_date action_date Force_date
1 10/10/2012 10/10/2012 10/10/2012
2 10/10/2012 10/10/2012 10/10/2012
3 10/10/2012 13/10/2012 15/10/2012
[code]....
Need the data like
Issue_date count_action_date count_Force_date (diff(action_date,force_date) 1 2 3 4 5 6(days since over)
10/10/2012 3 4 1 4 2 1 0 0
How to get the data like this? automatically how to get 123.... and how to calculate the difference by which day the count of difference is going?
My question is; I've been reading the Oracle database 11g R2 documentation at this link [URL]...
I passed a couple of days learning about all installation configuration parts including the desktop class and server class.As I was learning, So I had already downloaded Oracle Database Express 11g R2 for win32.
So as i had finished the installation guide I thought it's time to install the oracle now. I did it, and what I found was that there was not any option during installation that i read in above documentation. While trying to find about this difference i reached on documentation[URL]...
That is for express version only.
My question here is, Express edition, we use for learning purpose, But it doesn't look like it has all the stuff that we should learn during installation And what documentation I should follow from my above given two links?
i am running 11.2.0.1 on HP-UX PA-RISC (64-bit). My Memory max target is defined as 34 GB and memory target is 32 GB on the database. The host has 256 GB physical memory. i see memory utlization is almost 90% used when seen from Grid Control on the host and wondering, what's going on? when i see into more details, i see the following 3 HP Processes consuming around 3.6 GB memory and rest very small is consumed by Oracle processes. Who's using the rest of the memory?
View 3 Replies View RelatedWhile i am trying to execute this proc,i am facing source does not have a runnable target issue.
CREATE OR REPLACE
PROCEDURE GET_CHILDS_SUB
( nid IN VARCHAR2
) AS
n varchar2;
CURSOR cur is SELECT node_id FROM test_tbl WHERE parent_id = nid;
BEGIN
[code]....
We are using oracle 10.2.0.3.0 version on HP-UX B.11.23 U ia64.
We are facing a lot of delay in TNS ping reply. It is taking 8000+ msec.
$ tnsping XXXXXX 20
TNS Ping Utility for HPUX: Version 10.2.0.3.0 - Production on 27-FEB-2013 12:37:15
Copyright (c) 1997, 2006, Oracle. All rights reserved.
Used parameter files:
$ORACLE_HOME/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = xxxxxx)(PORT = 1531))) (CONNECT_DATA = (SERVICE_NAME = xxxxxxx)))
OK (1250 msec)
OK (1150 msec)
OK (860 msec)
OK (860 msec)
OK (790 msec)
OK (810 msec)
OK (790 msec)
OK (570 msec)
OK (650 msec)
OK (630 msec)
OK (790 msec)
OK (1240 msec)
OK (1090 msec)
OK (1030 msec)
OK (870 msec)
OK (690 msec)
OK (740 msec)
OK (650 msec)
OK (490 msec)
OK (560 msec)
$
What would be the steps involved if I will change the IP address of my Oracle GoldenGate target database?
Below are the steps that I thought of:
1. OGG Target: Stop the running change capture replicat and GG manager
2. OGG Target: Implement change process of IP address up to database startup
3. OGG Source: Stop the running data pump extract
4. OGG Source: Update data pump extract parameter RMTHOST pointing to the new IP address of the target
5. OGG Source: Start the data pump extract
6. OGG Target: start GG manager and the change capture replicat
Will it work or I missed a critical step?
OGG Source (PROD): Oracle 10g; Oracle GoldenGate 11.1.1; OS HPUX
OGG Target (Datawarehouse): Oracle 11g; Oracle GoldenGate 11.2.1.0.1; OS Linux
I would like to have some inputs on RMAN backup that we are planning to perform for the database that has to be now discarded; and which may have have to be restored in distant future.
Current Env--
DB Ver: 10gR2
OS: Solaris
Backup mode: RMAN WITHOUT CATALOG(i.e. using controlfile for storing rman info)
From what I know(I might be wrong), that for duplicating the 10gR2 DB to another machine we have to have the target(original) database running and connected. In my case we need to take the rman backup and then use the target db for fresh installation and hence the db will be deleted.
How can i increase the sga_target in this case.Im unable to create a pfile.
SQL> startup
ORA-01078: failure in processing system parameters
ORA-00821: Specified value of sga_target 2048M is too small, needs to be at least 4112M
SQL> startup nomount
[code]...
The $ORACLE_HOME/dbs location has a spfile.
more initQR01MRA1.ora
SPFILE='+DB_DATA/QR01MRA/spfile'
I have a table named SOURCE with about 1.000.000 rows looking like this
date varchar2 varchar2 varchar2
DATE ID1 ID2 AMOUNT
---------- ----------- --------- --------
2010-07-03 1403 1403 1500
2010-07-13 2015438 etc 188608 6074
2010-08-28 1151927 410,4222 1750
2010-08-28 13622012 41026 178.99
2010-08-28 1600246 John 65
I want to insert the rows into a table TARGET
date integer integer number
DATE ID1 ID2 AMOUNT
There are about 10.000 rows where ID1, ID2 and/or AMOUNT contains characters. These rows I don't want to insert as the columns in the target table are INTEGER. I simply want to discard these.