Unable To Find Redo Log Files Specified?

Jul 15, 2011

I am creating database instance from template. I have specified the location of redo log files. When I run the dbca utility it does creates the redo log files in specified directory. But the installation fails . When I checked the trace file. it says unable to locate the specified file(redo.log). But when i check in directory they are created.

I am using windows 32 bit oracle 11g

View 1 Replies


ADVERTISEMENT

DataGuard - Standby Redo Log Files

Sep 3, 2012

What is the purpose of Standby Redo Log Files in Data Guard configuration? When it is utilized by the database?

View 4 Replies View Related

Add Changed Rows To Redo Log Files

Aug 29, 2012

I learned that Oracle uses supplemental logging mechanısm to add the changed rows to redo log files and identify the changed rows on target replication database? Is that mechanism mandatory to handle the replication of data between updated and back up databases?

View 1 Replies View Related

Server Administration :: Contents Of Redo Log Files

Feb 1, 2011

I have some doubts about redo log files,

1) Can we fetch 'select statements' from redo log files through the use of log miner utility or any other?
(I think redo log file contains only insert,update,delete and DDL/DCL commands only)

2) If "No" to the above answer then how can i fetch all select statements fired on the system for a day or particular time.
(setting of sql_trace may be the one of them, but can it be possible for system level)

View 4 Replies View Related

Backup And Recovery Session - Redo Log Files

Jul 2, 2012

In the backup and recovery session i have miss my online redolog files. why the datafiles are recovered.it's possible to recovered to online redo logs?

View 3 Replies View Related

Multiplexing Redo Logs And Control Files To Separate Diskgroup In ASM

Mar 1, 2011

I've been using ASM for a few years now and have always installed a new system with 3 diskgroups

+DATA - for datafiles, control files, redo logs
+FRA - for achive logs, flash recovery. RMAN backup

Those I guess are the standards, but I've always created an extra (very small) diskgroup, called +ONLINE where I keep multiplexed copies of the redo logs and control files.

My reasoning behind this is that if there are any issues with the +DATA diskgroup, the redo logs and control files can still be accessed.

In the olden days (all those 5 years ago!), on local storage, this was important, but is it still important now? With all the striping and mirroring going on (both at ASM and RAID level), am I just being overtly paranoid? Does this additional +ONLINE diskgroup actually hamper performance? (with dual write overheads that are not necessary)

View 4 Replies View Related

Data Guard :: How To Transfer Redo Log Files To Standby Database

May 29, 2010

How to transfer redo log files to standby database..

View 1 Replies View Related

Data Guard :: How To Add Both Online And Redo Log Files To Standby Database

Sep 13, 2011

I've only successfully duplicate a standby database.

from the alert log

ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'D:ORA102CTAREDO01.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

[code].....

when I tried to add the online and standby redo log, it error out

SYS@CTA>select logdetail.member, loggroup.group#, loggroup.sequence#, loggroup.archived, loggroup.status lg_status, logdetail.status ld_detail, logdetail.type
2 from v$log loggroup join v$logfile logdetail
3 on loggroup.group# = logdetail.group#;
MEMBER
--------------------------------------------------------------------------------
GROUP# SEQUENCE# ARC LG_STATUS LD_DETA TYPE
---------- ---------- --- ---------------- ------- -------

[code].....

based on my understanding from [URL] ....

Quote:

As part of the duplicating operation, RMAN automates the following steps:

Creates a control file for the duplicate database

Restores the target datafiles to the duplicate database and performs incomplete recovery by using all available incremental backups and archived redo logs

Shuts down and starts the auxiliary instance (refer to "Task 4: Start the Auxiliary Instance" for issues relating to client-side versus server-side initialization parameter files)

Opens the duplicate database with the RESETLOGS option after incomplete recovery to create the online redo logs (except when running DUPLICATE ... FOR STANDBY, in which case RMAN does not open the database) when duplicating for standby database it does not create online redo logs. Duplicating a standby database does not creates online redo logs.

how should I add the online and standby redo logs. If I transfer the redo logs from primary to standby, it always encountered the the following error

Dump file d:ora102ctadumpcta_arc0_3624.trc
Tue Sep 13 19:21:53 2011
ORACLE V10.2.0.4.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the OLAP, Data Mining and Real Application Testing options
Windows XP Version V5.1 Service Pack 2

[code].....

View 1 Replies View Related

Backup & Recovery :: Restore From Newer Control File And Archived Redo Log Files?

Mar 29, 2011

I've got a legacy SAP system with oracle 8i on Tru64. No changes at all are made but for legal reasons we have to keep it up and running.

we currently do a full backup monthly by shutting down oracle and doing a backup of all the files to tape and that takes around 12 hours.

If I stop doing the full backup and I only backup the control file and the archived redo log files every month and I had to restore the full database years from now, would I be able to restore the database using the last full monthly backup and use the latest control file and archived redo log files?

View 5 Replies View Related

Server Administration :: Unable To Delete Archive Files Through ASMCMD

Apr 13, 2011

we are getting below error:

ora-00257 archiver error. connect internal only until freed

when we tried to remove the unwanted arc files thro ASMCMD,we are getting below error:

ASMCMD> rm -ef 2011_04_05/
Unknown option: e
usage: rm [-rf] <name1 name2 . . .>
ASMCMD> rm -rf 2011_04_05/
ORA-15032: not all alterations performed
ORA-15028: ASM file '+XCOM_BACKUP_DG/TXCOM/ARCHIVELOG/2011_04_05/thread_2_seq_27215.1143.747641143' not dropped; currently being accessed (DBD ERROR: OCIStmtExecute)
ORA-15032: not all alterations performed
ORA-15028: ASM file '+XCOM_BACKUP_DG/TXCOM/ARCHIVELOG/2011_04_05/thread_3_seq_21762.826.747641143' not dropped; currently being accessed (DBD ERROR: OCIStmtExecute)
ORA-15032: not all alterations performed
ORA-15177: cannot operate on system aliases (DBD ERROR: OCIStmtExecute)

further we checked FRA size:

SQL> select * from v$flash_recovery_area_usage;

FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------

CONTROLFILE 0 0 0
ONLINELOG 0 0 0
ARCHIVELOG 3.19 0 38
BACKUPPIECE 0 0 0
IMAGECOPY 0 0 0
FLASHBACKLOG 0 0 0

and checked any arc processing holding lock on arc files:

> ps -ef | grep -i ora_arc*

oracle 6989 1 0 15:07 ? 00:00:00 ora_arc0_TXCOM1
oracle 6991 1 0 15:07 ? 00:00:00 ora_arc1_TXCOM1
oracle 12246 12164 0 15:17 pts/4 00:00:00 grep -i ora_arc*
oracle 13452 1 0 Mar23 ? 00:01:07 ora_arc0_TWEBAPPS1
oracle 13454 1 0 Mar23 ? 00:00:30 ora_arc1_TWEBAPPS1
oracle 15402 1 0 Mar23 ? 00:00:50 ora_arc0_SXCOM1

[Code] ........

but we were not able to remove those .arc files from that folder. finally we have down all the instances and deleted those files manually.

View 1 Replies View Related

Unable To Find A Table?

Mar 22, 2011

why am i getting this?

SQL> SELECT TABLE_NAME,owner from dba_TABLES where TABLE_NAME in ('BSNL_ACCOUNT_DATA','BSNL_SERVICE_DATA','BSNL_PKG_DETAILS');

TABLE_NAME OWNER
------------------------------ ------------------------------
BSNL_ACCOUNT_DATA BPREAD
BSNL_SERVICE_DATA BPREAD

but the table exists

SQL> select count(*) from BPREAD.BSNL_PKG_DETAILS;

COUNT(*)
----------
3704

SQL> select TABLE_NAME,owner from dba_TABLES where TABLE_NAME='BSNL_PKG_DETAILS';

no rows selected

why is it showing no rows even if the table exists

View 3 Replies View Related

Unable To Find SQL Statement Of Blocker?

Jan 31, 2013

Oracle 10g. I want to find which sql statement was blocking others.

I know the sid of the blocker but I am unable to find the sql statement of the blocker.Also, when I check enterprise manager top activity only shows the waiter.

I tried to run the queries from below link, but it only shows the information about the waiting session.

[URL]

How can I find the sql statement of the particular sid from history ?

View 3 Replies View Related

Windows :: Unable To Find DLL Library File

Nov 21, 2012

We are getting below error....Our one package called orawpcom.dll library file.

ERROR at line 1:
ORA-06520: PL/SQL: Error loading external library
ORA-06522: Unable to find library
'/oracle9i/app/product/11.1.0.7.0inorawpcom.dll'.
ORA-06512: at "GFSAM.OAINVOKEDOUBLE", line 1
ORA-06512: at "GFSAM.ORDCOM", line 229
ORA-06512: at "GFSAM.ORDEXCELSB", line 450
ORA-06512: at line 43
ORA-06520: PL/SQL: Error loading external library
ORA-06522: Unable to find library

Attach this orawpcom.dll file?

View 1 Replies View Related

Server Administration :: ORA-01555 / Unable To Find Sql_id

Jan 25, 2012

I am getting below ORA-01555 error in alert log everyday.

ORA-01555 caused by SQL statement below (SCN: 0x09ad.86a4562a):
Sat Jan 21 08:39:45 2012
SELECT (NVL(MAX(BLOCK_ID + BLOCKS ),0) * :b1 ) / 1024
FROM DBA_EXTENTS WHERE TABLESPACE_NAME = :b2 AND FILE_ID = :b3

I cannot able to find the sql_id here. So how can I find from which process or session this query is firing? before increasing the undo size, I need to analyze as why it is occuring?

undo_management string MANUAL
undo_retention integer 900
undo_suppress_errors boolean FALSE
undo_tablespace string

View 9 Replies View Related

Application Express :: Bug Report 4.2 (.1) - Unable To Find Item ID For P3500

Feb 28, 2013

1. On the Home Page, click the "Settings" wheel in the header of the Team Development region on the right side.
2. On the Home Page Preferences popup set "Show" to something else as "All" and click [Apply Changes]
3. Back on the Home Page, in the Team Development region on the right side, click the number next to "Bugs"
4. ERR-1002 Unable to find item ID for item "P3500_RELEASE" in application "4800".

View 0 Replies View Related

Server Administration :: Unable To Find Server Process In Oracle Database For Specific Application / Client

Feb 13, 2013

I am trying to find the unix process for one of my application in the database but I am unable to view the same. To simulate, I did the following.

1. My database runs on different server.
2. I invoked "sqlplus" from another unix box to login to the database.
3. I found that the process id (ps -ef |grep sqlplus).
4. When I execute the below mentioned query it does not display the process id that I am looking for. But the osuser, username, program and machine details are correct. How can I know the process details from the database?

SELECT SYS.GV_$SESSION.OSUSER, SYS.GV_$SESSION.USERNAME, SYS.GV_$PROCESS.SPID,
SYS.GV_$SESSION.MACHINE, SYS.GV_$SESSION.PROGRAM,
SYS.GV_$PROCESS.PROGRAM ,SYS.GV_$SESSION.SQL_ID
FROM
SYS.GV_$PROCESS, SYS.GV_$SESSION
WHERE
SYS.GV_$PROCESS.ADDR=SYS.GV_$SESSION.PADDR and SYS.GV_$SESSION.USERNAME='TEST'
and SYS.GV_$SESSION.MACHINE like '%hostname%'

View 3 Replies View Related

Precompilers, OCI & OCCI :: Make Files That Compile PC Files In Unix

Jul 31, 2008

I have written make files that compile .pc files in unix. This was for several projects that use an oralib source code directory.Just running proc on one target .pc file works fine on unix. I am trying to use proc - Oracle 10.2.0 - in windows and I keep getting:

Quote:unable to open include file
#include <stdio.h>
and other C library headers.

I am doing all development under cygwin, this way I can write a makefile just like under unix instead of using nmake.All C library headers are in /usr/include When I run proc on Solaris as that:

proc program.pc
No problems, and I do get program.c.

However in windows I get the previous error message. I have tried to do proc include=/user/include program.pc and proc include=/user/include parse=full program.pc but I still get the same error message.

View 3 Replies View Related

Know If Database Files Are On File System Or Raw Files?

Oct 11, 2012

How can I know if database files are on file system or raw files?

View 4 Replies View Related

Compare Two Dump Files And Their Respective Log Files

Jun 20, 2012

I want to compare two dump files and their respective log files, to see the difference. Is there any way.

View 8 Replies View Related

What Exactly Redo Log File Contains

Oct 1, 2011

what exactly redo log file contains.? whether they contained the ddl or dml statements or more than that.........?

View 1 Replies View Related

Redo Log Sizing

Dec 28, 2012

I look after a database that contains GIS mapping data. We do not use Oracle Spatial - it's just a plain Oracle Standard DB. It is running in Noarchivelog mode (I know - it's not a good idea, but will be sorted when our new Sun T4-1 arrives).

There are only a couple of users who actually edit data in the database, but about 100 simultaneous users who access it. In day to day use we have no performance issues. The DB has 3 50Mb redo log groups, and these switch about every hour or so during normal use.

Every few weeks we do a bulk update of our underlying map data. This involves putting about 4Gb of data into the database (which is about 15Gb in total). This takes about 5 hours and whilst I'm sure our old Sun v240 server lacking power is a substantial cause, I think the lack of redo space makes matters worse. Last time we did this, the system clocked just over 200 redo log switches in 5 hours. There were lots of "Checkpoint Incomplete" messages in the log file too.

The software we use to load the map data doesn't allow the data to be loaded with a nologging switch.

I could resize the redo logs, but if I size them for the update workload - 3x 500Mb - we'll have some days where we don't get a redo log switch at all. Is this necessarily a problem?

The alternative I'm thinking of is prior to performing this update, we add an extra redo log group with a 1Gb file, run the update, then remove the redo log group and delete the file afterwards. Is there anything wrong with this approach?

View 1 Replies View Related

Get Redo-log Group Sizing?

Aug 22, 2012

What is the optimal redo log size for the database and how many log files required if desired to enable archive log mode.what can be the value for fast_start_mttr_target..?i think if it this parameter set we can have redo log advisor for optimal redolog size.we have 2 redolog groups with 2 members each size of 1 GB. Will it degrade db performance..?

Database version 11.1.0.7
Oracle apps R12
OS : Linux Redhat 5.5

View 1 Replies View Related

How To Calculate Redo Rate

Nov 14, 2006

how would I be able to calculate the Redo rate for using in the Required bandwidth Formula as seen below :

Required bandwidth Formula ((Redo rate in bytes per second / 0.7) * 8) / 1,000,000 = bandwidth in Mbps

Example: 385 KB/sec peak rate would require an available network bandwidth of at least

((394253 / 0.7) * 8) / 1,000,000 = 4.5 Mbps.

SOURCE OF FORMULA Network Bandwidth Implications of Oracle Data Guard...I'm using Oracle 10g

View 3 Replies View Related

Advantages Of Redo Log Threads

Sep 16, 2010

tell me the advantages of using more than one redo log thread? Currently i am setup with 3 logfile groups and 3 members in each group.Ie

logfile group 1 ('/u01/oradata/pri/redo01a.dbf',
'/u02/oradata/pri/redo01b.dbf',
'/u03/oradata/pri/redo01c.dbf') size 30M,
group 2 ('/u01/oradata/pri/redo02a.dbf',
'/u02/oradata/pri/redo02b.dbf',
'/u03/oradata/pri/redo02c.dbf' ) size 30M,
group 3 ('/u01/oradata/pri/redo03a.dbf',
'/u02/oradata/pri/redo03b.dbf',
'/u03/oradata/pri/redo03c.dbf' ) size 30M

View 4 Replies View Related

REDO Log Member Multiplex

Jun 13, 2012

I wanna know if the redo log members are mirror copies.All member files from a same redo group have the same data?Are there any different in mirror or multiplex a file?

View 4 Replies View Related

Redo Log Group Resize

Mar 20, 2012

I want to re-size redo log group on my production database .i have 10 redo log groups of 50mb each having 2 members.i want 4 redo groups to be of 250 mb each having 2 members and then i will drop that old 10 redo log group(50 mb ) , so that i will have only 4 redo log group of 250MB each having 2 members.But i have physical standby and logical standby configured on production database .

find attached file for redo log configuration of production database(CBSPROD),Logical standby database(CBSMIS), Physical standby database(CBSDR).

View 1 Replies View Related

Resizing Redo Logs

Aug 8, 2012

I'm using Oracle 10gR2 (10.2.0.4.0) 64 bits.

I got many times oracle ORA-00494 error and the database went down but since 29th of july the database have not been killed.
The error message is below :

ORA-00494: mise en file d'attente [CF] d�tenue pendant trop longtemps ( (more than 900 seconds)) par inst 1, osid 176484
ORA-00028: votre session a �t� ferm�e

My database is used for datawarehouse of many terabytes.

Initially the redo log size was 500Mbytes and I've set it to 3Gbytes. The maximum log switch is after 5 minutes. I want log to be switched every 20 minutes or every 30 minutes.

To obtain the size of redo logs I've executed this query :

SQL> select OPTIMAL_LOGFILE_SIZE from v$instance_recovery;

OPTIMAL_LOGFILE_SIZE
--------------------
54763

53,5 Gbytes is it not very big as redo log size? What's the maximum size of redo log? To set very big redo log size what are the requirements? Which precautions should I take before? What are the risks? Are any other ways to change the log switch frequency?

View 1 Replies View Related

Performance Tuning :: No Redo For DML?

Mar 17, 2006

How can I disable redo generation for DML statements.

View 25 Replies View Related

Redo Generated In Last 2 Hour

Feb 7, 2013

Is there any way to get the amount of redo generated in last 2 hour. which has below chareteistic

1. redo generated by currently connected session from last 2 hour.
2. redo generated by session disconnected during last 2 hour.

total_redo = disconnected sessoin during last 2 hour + connected session generating redo during last 2 hour.

View 7 Replies View Related

Redo Logs Size

May 28, 2013

is it Any way I can put the size of my redo log (During Install Oracle DB 11.1.0.7 )

I mean during installtion .??? becouse its by default 50 MB I need to be 200MB

View 10 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved