Data Guard - Difference Between 2 Commands?
Mar 6, 2012
Before I am going to implement data guard in my company i am experimenting it in a test server. I want to know the difference between these 2 commands mentioned below which i found from various websites.
[ START REDO APPLY ]
SQL> alter database recover managed standby database disconnect;
[ START REDO APPLY USING REAL-TIME APPLY ]
SQL> alter database recover managed standby database using current logfile disconnect;
Which of the two commands should i use in my production database.
View 1 Replies
ADVERTISEMENT
Dec 7, 2011
Is there a difference between the first set of commands and the second? Typically, I just use the first set?
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS;
DELETE NOPROMPT OBSOLETE;
and
CROSSCHECK ARCHIVELOG ALL completed before 'sysdate -30';
DELETE NOPROMPT OBSOLETE;
View 2 Replies
View Related
Nov 2, 2012
what could be the reason that following 2 (RMAN) commands return different results?
RMAN> list archivelog all completed before 'sysdate-2';
RMAN> list archivelog until time 'SYSDATE-2';
View 1 Replies
View Related
Jun 29, 2010
Difference between standby and dataguard. I assume standby and dataguard are same?
View 4 Replies
View Related
Jul 5, 2011
We have physical data guard configured version (10.2.0.4). We are in need to upgrade primary & standby database to 11G R2. Can we perform rolling upgrade.
View 3 Replies
View Related
Oct 17, 2012
Controlling User Access to Tables in a Logical Standby Database can be controlled using the following command:
ALTER DATABASE GUARD STANDBY;
My simple question is: how can I know the current active Guard setting in the standby database?
Oracle 11g R2.
View 1 Replies
View Related
Jan 16, 2013
i have configured physical standby in my local system, to check logshipping i created a table at primary db, wen i tried to check in standby, it says table does not exist..below are primary & standby alert entries..
Primary alert log
Fatal NI connect error 12514, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.16.0.98)(PORT=1522))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=STAND)(SERVER=dedicat ed)(CID=(PROGRAM=d:oracle11gappadministratorproduct11.1.0db_1inORACLE.EXE)(HOST=A960M)(USER=SYSTEM))(SERVER=dedicated)))
VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.1.0.6.0 - Production
[code]....
View 1 Replies
View Related
Nov 5, 2010
I want to change dbname,sid,data/control file locations in operational dataguard setup i plan to follow as below
1)shutdown primary and standby (stop managed recovery)
2)change db name in init.ora of primary and standby change database name control file location
3)create control file for primary from trace(script) make changes for db name and file locations
4)mount and open primary database
5)create standby control file
6) transfer standby control file to standby
7) mount stand by database and start manage recovery
If this steps will error free do i need to follow any thing additional to this or what is other best way for this or its not possible at all
View 1 Replies
View Related
Feb 24, 2013
Oracle Version: 11.1.0.7.0
Active Dataguard
Statspack has been configured for Active Dataguard on Primary database.We got an spike of Buffer busy waits for about 5 min in Active Dataguard, this was causing worse Application SQL's response time during this 5 min window.Below is what i got from statspack report for one hour
Snapshot Snap Id Snap Time Sessions Curs/Sess Comment
~~~~~~~~ ---------- ------------------ -------- --------- -------------------
Begin Snap: 18611 21-Feb-13 22:00:02 236 2.2
End Snap: 18613 21-Feb-13 23:00:02 237 2.1
Elapsed: 60.00 (mins)
[code]...
Why there could sudden spike of demand on UNDO data in Active Data Guard ?
View 2 Replies
View Related
Mar 29, 2011
I am working in a bank as an system consultant, i have a SAN Storage Area and oracle as below.
SAN 1
This interface includes the DATA FILES of the oracle tablespace
SAN 2
SAN1 Mirrors the DATA FILES of the oracle tablespace to SAN 2
1. Can i rely on real time data recovery from SAN2 ?
2. if SAN1 (Data Files are currupted) will the SAN2 Data Files will be currupted as well.
3. If the SAN2 is currupted then what Oracle Features can be used to have uncurrupted data.
View 5 Replies
View Related
Jul 23, 2010
i did everything writen but when i do *SQL>alter database recover managed standby database disconnect from session;*
i go and look in the standby database AlertLog file ,and thats whats writen
*ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: 'F:ORACLEPRODUCT10.2.0ORADATADBSYSTEM01.DBF'
ORA-27041: unable to open file
OSD-04002: غير قادر على فتح الملف
O/S-Error: (OS 3) The system cannot find the path specified.
[code]....
strange thing that it realises the primary database in drive F and it goes to it but i dont understand what could be the reason of this ,although im doing this command while primary database is shutdown!
View 2 Replies
View Related
May 2, 2012
I configure logical standby online .when I execute dbms_logstdby.buid,first
SQL> EXECUTE DBMS_LOGSTDBY.BUILD;
it was blcoked by other sesson,then i kill the holding session,but no work.then i cancel this step and execute it again . the error is
SQL> EXECUTE DBMS_LOGSTDBY.BUILD;
BEGIN DBMS_LOGSTDBY.BUILD; END;
*
ERROR at line 1:
ORA-01354: Supplemental log data must be added to run this command
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 3669
ORA-06512: at "SYS.DBMS_LOGMNR_INTERNAL", line 3755
ORA-06512: at "SYS.DBMS_LOGMNR_D", line 12
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_INTERNAL_LOGSTDBY", line 370
ORA-06512: at "SYS.DBMS_LOGSTDBY", line 157
[code]....
View 3 Replies
View Related
Jun 15, 2012
I have set up a cross platform (Microsoft Windows IA (32-bit) -> Linux x86 64-bit) data guard and it worked fine.Then I did a switch over (which again worked) and found out the data is not getting replicated at all.. checked the data files available from the new primary database and found out they are in the windows format as below..
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
D:ORACLEAPPADMINISTRATORORADATAMFSSYSTEM01.DBF
D:ORACLEAPPADMINISTRATORORADATAMFSSYSAUX01.DBF
D:ORACLEAPPADMINISTRATORORADATAMFSUNDOTBS01.DBF
D:ORACLEAPPADMINISTRATORORADATAMFSUSERS01.DBF
D:ORACLEAPPADMINISTRATORORADATAMFSRMANRMAN_TS01.DBF
and physically they were created at '/home/app/oracle/product/11.2.0/db_1/dbs/' and as
D:ORACLEAPPADMINISTRATORORADATAMFSREDO02.LOG
D:ORACLEAPPADMINISTRATORORADATAMFSREDO03.LOG
D:ORACLEAPPADMINISTRATORORADATAMFSRMANRMAN_TS01.DBF
View 5 Replies
View Related
Jan 16, 2013
I configured dataguard in my local system.
1) scn differs wrt primary in standby (i checked, 1day difference), how to make scn same?
2)i created a table in primary, its not refelecting in standby, (below i ve pasted alertlog entries)
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
Errors in file d:oracle11gappadministratordiag
dbmsstandstand racestand_dbw0_6916.trc:
ORA-01157: cannot identify/lock data file 2 - see DBWR trace file
ORA-01110: data file 2: 'D:ORACLE11GAPPADMINISTRATORORADATASTANDSYSAUX01.DBF'
[code]....
3)wen i try to open standby database in read only mode gives below error..
ERROR at line 1:
ORA-16004: backup database requires recovery
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1:
'D:ORACLE11GAPPADMINISTRATORORADATASTANDSYSTEM01.DBF'
View 31 Replies
View Related
Oct 21, 2012
Our organization has recently decided to go for storage metro cluster solution for disaster recovery. In a Data guard environment, we normally calculate how much archive log is generating and based on that value we calculate the required bandwidth.
For storage metro cluster, we need to find how much block is changing in our primary database, and the same rate of change would apply on DR cluster. Now, i need to give the assumption how much changing is happening in my system. How to calculate the change.
View 4 Replies
View Related
Jun 8, 2010
I bought Selftestsoftware for 1z0-147 for 9i and 10g. Selftestsoftware is endorsed by Oracle, should be high quality. But its below sample question and answer seem to be wrong, or I could not understand it properly. It says "Network traffic is not decreased by bundling commands. Executing procedures and functions stored in an Oracle Developer application will process each PL/SQL statement and pass each SQL statement across the network to the database to be processed, dramatically increasing network roundtrips."
But PLSQL online reference manual says "However, with PL/SQL, an entire block of statements (bundling commands?) can be sent to Oracle at one time."
Selftestsoftware says pass each sql statement, but PLSQL online manual says send an entire block of statements like below diagram. Now which one is right, or I misunderstood something?
(I cant post the diagram from PLSQL online manual because of my quota)
Procedures and functions can be created and stored in the database or in an Oracle Developer application. How is performance improved when storing procedures and functions in the database?
Network roundtrips are reduced.The object code is created during execution.Network traffic is decreased by bundling commands.The source code is stored externally, and the object code is stored internally.
Explanation:Network roundtrips are reduced when storing procedures and functions in the database. The source and object code of database stored procedures and functions are stored like other objects, in physical files assigned to the appropriate tablespace. When executed from a client application, they require only one call. Because the object code is stored on the database side, there is no need to send it across the network.The object code is not created during execution. The object code is created when creating the procedure or function and is stored in the database.Network traffic is not decreased by bundling commands. Executing procedures and functions stored in an Oracle Developer application will process each PL/SQL statement and pass each SQL statement across the network to the database to be processed, dramatically increasing network roundtrips.The source code is not stored externally. The source code and object code are stored in the database.
View 3 Replies
View Related
Feb 8, 2013
Can we perform DDL & DML Commands on dual table????
If yes then how??
View 11 Replies
View Related
Aug 8, 2007
In SQL plus
<SQL>
i need to repeat last six or seven commands instead of typeing
is there any command to using arrow keys o backward and forward last typing comamnds
i know / to execute last command
how to do that in SQL plus.
View 5 Replies
View Related
Jul 6, 2010
i was trying to use the host command to run the commands from linux. however, it doesnt work.
PROCEDURE compile_procedure IS
c_success boolean;
c_bare_filename varchar2(50);
command_string varchar2(1000) ;
BEGIN
c_bare_filename := substr(:B_DEV.B_DEV_ITEM_FILENAME,instr(:B_DEV.B_DEV_ITEM_FILENAME,'',-1)+1);
[code]....
View 4 Replies
View Related
Nov 4, 2011
I am trying to trouleshoot an issue with Oracle and want to see what commands are being sent by by process. By reading the documentation it appears there is client logging to do this but I can not get it to work. I added the following commands to my SQLNET.ORA file but no log file is created:
tnsping.trace_directory = C:appproduct11.2.0client_4
etwork race
tnsping.trace_level = admin
trace_level_client = user
trace_directory_client = C:log
log_directory_client = C:log
trace_unique_client = on
trace_timestamp_client = on
Ths TNSPING works just fine it logs the information I expect. The client logging, however, never creates a file .
View 2 Replies
View Related
May 27, 2011
I create table in session1:
create table marco_tmp_270511
as
select 5 as t from dual
Then I log in session2 and perform query to
select * from marco_tmp_270511 and receive 5 in column t.
Then I return to session1 and perform:
delete marco_tmp_270511;
insert into marco_tmp_270511
select 99 as t from dual ;
select * from marco_tmp_270511;
Then I go again to session2 and perform query to
select * from marco_tmp_270511
and still receive 5 in column t. How do I synchronize data between sessions?
View 3 Replies
View Related
Jan 3, 2011
I have a PLSQL script.
sqlplus
$DB_ACCT << EOSQL
set heading off
set termout off
set pagesize 0
[code]....
My output in FILE.txt looks like this
SQL>
SQL> Select col_with_a||col_with_b||col_with_c from
2 alphabet_table;
abc
[code]....
I tried several options by putting set echo off, etc.What do I include in the sql script to get the output as :
abc
abc
abc
without the SQL prompt and the statement, and the spool off command?
View 2 Replies
View Related
May 3, 2011
which commands only we can use in database mount mode?
View 7 Replies
View Related
Aug 21, 2013
I'm trying to apply a patch using opatch but I'm getting this error:
"OPatch was not able to find OUI jars to load them runtime. Please provide valid oui location using 'oui_loc' option. OPatch failed with error code 255".
Oracle is 11.2.0.3 x64 on Windows Server 2008R2 x64. The PATH variable have
%ORACLE_HOME%OPatch, %ORACLE_HOME%OPatchjlib, %ORACLE_HOME%in in it.
The only OPatch command that is working and not throwing the error is the "opatch version" command.
OPatch Version: 11.2.0.3.5 OPatch succeeded.
No luck on finding issue resolution or documentation on MOS. I cannot find any documentation about the "oui_loc" option.
View 10 Replies
View Related
May 13, 2011
i'm using a mixture of Oracle� Data Guard Concepts and Administration11g Release 1 (11.1) And Bulletin : MAA - Creating a RAC Physical Standby for a RAC Primary 10g ( on oracle support) But neither is comprehensive for what i'm trying to do.
setting up Data Guard Broker on a RAC Data Guard environment?
View 1 Replies
View Related
Mar 28, 2007
I am using Oracle 10g Express Edition on Fedora core 5 32+ bit os. The problem is when I use the SQL Plus command line to make SQL statements I can not get the previously typed command back at the prompt when I use the up and down arrow keys on my keyboard. This is quite easy when I am using a shell, but here with this Oracle command line interface it is not working at all. Here is the example as what actually is happening whe I press the up or down arrow keys.
SQL> drop table mailorders;
Table dropped.
SQL> ^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A^[[A
View 2 Replies
View Related
Dec 17, 2012
I have a RUN file within a script to duplicate a database. As part of this RUN file I also run the command configure controlfile autobackup off; as part of this RUN file. However, this command has turned off backup of the control file on the AUXILLARY database (i.e. production) as well as the TARGET database (test). Is this supposed to happen?
My run file is:
rman TARGET sys/XXXX@${DB}-SOURCE AUXILIARY /
RUN {
allocate AUXILIARY channel a1 type disk;
allocate AUXILIARY channel a2 type disk;
allocate AUXILIARY channel a3 type disk;
allocate AUXILIARY channel a4 type disk;
[Code]....
View 7 Replies
View Related
Jan 7, 2011
I am very new to data guard...I have a primary and a physical standby database...If the primary got crashed, are the users directly switched to physical standyby (is it automated) or the DBA has to manually do the fail over or switch over....is it the same concept as in RAC like TAF....How can the DBA know that the users are disconnected from the database.....explain with some steps...
the version is 10.2.0...
View 2 Replies
View Related
Feb 16, 2012
Log shipping stopped logging/shipping into the Standby Database in one of our Oracle Data Guard Servers about two month ago and there was no change carried out as at that time. The Data Guard has only one Standby database. I have been managing the log shipping and recovery manually.
View 1 Replies
View Related
Apr 5, 2010
I want to implement data guard on same PC.
View 1 Replies
View Related
