How To Find Previous Path Location Of Archive Log

Apr 15, 2013

Practicing in VM. My question is, I deleted the physical files of the database on Sunday but I'm having physical files backup on Friday. firstly i done restore, Performing incomplete recovery , I'm getting error like "Cannot open Archive log"

On Saturday, I changed path of archive log but I'm not aware of archive previous path location. How can we find previous path location of archive log?

View 6 Replies


Moving Trace Files To Archive Location?

Aug 20, 2012

I am using Oracle RAC 11gR2.I am planing to move my old trace files to an archive location.

I have the below questions concerning the users and groups used by Oracle RAC when moving the trace files.It is related to the permissions but it is about oracle behavior.

The trace files of database (oracle user) are created as below:

284 -rw-r-----    1 oracle   asmadmin     283571 Aug 20 18:08 PPRD1_mmon_13893716.trc
   4 -rw-r-----    1 oracle   asmadmin        125 Aug 20 18:10 PPRD1_gcr0_11730998.trm
   4 -rw-r-----    1 oracle   asmadmin       2833 Aug 20 18:10 PPRD1_gcr0_11730998.trc
580 -rw-r-----    1 oracle   asmadmin     588489 Aug 20 18:12 PPRD1_lmhb_15859792.trm


when moving the files using the oracle user it will be created as oracle:oinstall and not oracle:asmadmin since asmadmin is not a group of the oracle user.

1. How oracle created my trace and log files with permission oracle:asmadmin?

2. How should I move these files? I moved it using the Oracle user and it was created as oracle:oinstall with Operating system error "unable to duplicate owner and mode after move"

View 5 Replies View Related

PL/SQL :: Previous Record Find?

Jun 25, 2013



if i pass 30 then it will return period id=16 data

View 3 Replies View Related

SQL & PL/SQL :: Find Previous Cursor Loop Value

Dec 15, 2011

I take a select into a cursor and process it record by record.I have to do sum based on a column and display row by row by using dbms_output.put_line .... So the sum has to happen based on a column. Based on the column value i need to display the cumulative sum as well.


col1 col2 amount

Sum value for DL ----- 50


Sum value for TX ----- 80

All the above data should be displayed using DBMS_OUTPUT.PUT_LINE in a pl/sql code. I use cursor to take the values from the table but the problem i face is .... I am not able to display the sum based in the col1 values.

Since i use the cursor .. i took the col1 values in to a variable and checked every time
old_variable = new_variable
if yes then continue the sum
display the sum value.

once i get the above check satisfied i am loosing a new col1 row in the check. The next loop only run for the new col1 values -1( which is used in the check loop).So is there any better way to get the solution or is there a facility to store the previous loop values in a cursor ? so that i dont have to loose that one row of data.

I am not able to come up with proper loop so which can identify that the col1 has changed and you have to display the sum value.

View 17 Replies View Related

PL/SQL :: Find Previous Value From Oracle Table

Jun 4, 2013

I have a stat table that got info like login_date,user_id etc.For a specific user, i have a requirement based on the no of days difference between the current login date and last login date.

For example, Tom logged in on June 4th 2013. His previous login was May 31. So no_of_days_difference is 5 days.How to programmatically get this for each user inside a pl-sql sub block.

View 2 Replies View Related

SQL & PL/SQL :: Find The Longest Path

Mar 25, 2013

create table test
insert into test values ('A', 'B');


We want to get the path from "A" to "E". In other words, if we start with any value of the column "a" we have to reach the "maximum" value of the column "b".

"maximum" in sense that we don't find the value of "b" in "a".

Example :
E is not found in the column a, so E is the maximum of A.
- N is the maximum of K
- Z is the maximum of Q and the maximum of S

select ...
from ...
where a = 'A' should return E.

View 11 Replies View Related

SQL & PL/SQL :: Find Shortest Path With Visits

Jul 3, 2013

I am find about an algorithm of shortest path with visits certain nodes.I have a table of Links with this fields: ID_Link, City1, City2 and distance...You have informations about shortest path with visits?

View 9 Replies View Related

Forms :: Find Path In Oracle 6i?

Nov 1, 2011

how can i get full path in oracle 6i???

View 2 Replies View Related

Forms :: Oracle 6i For Windows 7 64 Bit / Can't Find Exact Location From Google

Sep 20, 2012

i want to download form 6i and report 6i for window 7 64bit. from where i can download it. i can't find exact location from google.

View 6 Replies View Related

Forms :: How To Find File Path Dynamically

May 10, 2011

how we can find file path dynamically. In paramenter we can give only destination file name like EXCEL.EXE. and its give me full path of EXCEL.EXE file.

View 1 Replies View Related

Backup & Recovery :: Error / (OS 3) The System Cannot Find The Path Specified

Jul 22, 2011

when i am running this syntax in rman i got this error so can you suggust me a correct syntax


RMAN> run{
2> allocate channel c1 device type disk maxpiecesize 5m;
3> set backup copies = 2;
4> backup datafile 1 format 'E:
5> }

allocated channel: c1
channel c1: sid=142 devtype=DISK

executing command: SET BACKUP COPIES

Starting backup at 22-JUL-11
channel c1: starting full datafile backupset
channel c1: specifying datafile(s) in backupset
input datafile fno=00001 name=E:ORACLEPRODUCT10.2.0ORADATAORCLSYSTEM01.DBF


View 7 Replies View Related

Automatic Storage Management :: Where To Find Grid Path In 10g

Mar 6, 2013

i am adding luns to the asm diskgroups in 10g where to find the grid path in 10g .

in 11g i can find
/orainfra/ -diskstring '/dev/oracleasm/disks/DATCSLGGPA*' -dump 'DATCSLGGPA'

but i can't able to find in 10g .

View 1 Replies View Related

Server Administration :: Find Out Difference Of Data For Some Tables Between Current And Previous Day

May 26, 2011

We want to find out difference of data for some tables between current day & previous day. We can use query with minus operation but it will take lot of time since table size is in range from 200 to 500 GB. We have to do this exercise every day.

View 5 Replies View Related

How To Find Archive Log Destination

May 8, 2013

I am unable to find out the location of my archive logs. The VALUE field is null.

SQL> show parameter log_archive_dest;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest                     string
log_archive_dest_1                   string
log_archive_dest_10                  string
log_archive_dest_11                  string
log_archive_dest_12                  string
log_archive_dest_13                  string
log_archive_dest_14                  string
log_archive_dest_15                  string
log_archive_dest_16                  string
log_archive_dest_17                  string
log_archive_dest_18                  string

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_19                  string
log_archive_dest_2                   string
log_archive_dest_20                  string
log_archive_dest_21                  string
log_archive_dest_22                  string
log_archive_dest_23                  stringSQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     2907
Next log sequence to archive   2908
Current log sequence           2909

When I do SQL>show parameter USE_DB_RECOVERY_FILE_DEST,I am not getting any result.
when I do *SQL>show parameter DB_RECOVERY_FILE_DEST, I am getting the result.

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      +BKUP_TSD1
db_recovery_file_dest_size           big integer 500GSo +BKUP_TSD1,

is this where my archive logs are present?

View 5 Replies View Related

Data Guard :: Find Archive Log Gap From Primary Database Site?

Mar 23, 2013

I am new to Oracle and a beginner in Data Guard.

1) How to find archive log gap from Primary Database site?
2) Do I need the DB_UNIQUE_NAME when setting the LOG_ARCHIVE_DEST_2 ? What is the purpose of DB_UNIQUE_NAME in LOG_ARCHIVE_DEST parameter?
3) If archivelog gap happens standby db goes out of sync with the primary database. What does out of sync actually mean?
4) Primary DB knows where to transport redo data based on the location mentioned in LOG_ARCHIVE_DEST_n of Primary DB. Am I correct in my understanding?

View 3 Replies View Related

Impdp Speed Differ From Location To Location

Oct 4, 2013

We have taken export expdp backup from prod database (primary database- Data Guard).

1.) Import impdp is very slow 10GB/Hrs on staging database (Data Guard MAXIMUM AVAILBILITY)Since Server configuration, database version and configuration, operating system everything are same as production. No blocking, locking or waiting sessions

2.)import impdp is fast 90GB/Hrs on Test standalone database and this test database is running in NOARCHIVE LOG mode with oracle standard version after that no more difference.

CPU,Memory,network and disk I/O are look normal while importing on both databases.why that much difference on import.

View 1 Replies View Related

Difference Between (ocrconfig -export Location) And (ocrconfig -manualbackup Location)?

Aug 13, 2013

what is difference between "ocrconfig -export location" and "ocrconfig -manualbackup location"

View 1 Replies View Related

Bash_profile Location In IBM AIX?

Sep 30, 2010

Where will i find the bash_profile location in IBM AIX server.

View 2 Replies View Related

How To Add New Column At Specified Location In A Table

Dec 29, 2010

How can I add new column at the specified location in a oracle table? I am having a flat file from which data is inserted to the table..But initially I don't need that column so I m not having this column in the table but if further i need that column at the particular location then how can I do this..?

View 1 Replies View Related


Dec 14, 2011

I am trying to query a Oracle database table that contains sample records like the one below...

09/12/2011 L1 6 2
09/12/2011 L2 3 7
10/12/2011 L1 4 1
10/12/2011 L2 3 3
11/12/2011 L1 2 2
11/12/2011 L2 2 0
12/12/2011 L1 4 1
12/12/2011 L2 5 0

I am trying to use the Oracle Sum() to get a grouping by DATE, LOCATION, SUM(PROD1+PROD2) for DATE periods 10/12/2011 and 11/12/2011. Below is the desired end result.

10/12/2011 5 6
11/12/2011 4 2

View 1 Replies View Related

Datafile In Wrong Location

Jun 18, 2013

My production DB has a couple of datafiles that were created in the wrong place, plus they are tiny - 100mb each.  What is best way to get rid of them?

View 3 Replies View Related

RAC For Separate Node's Physical Location

Mar 21, 2012

I would like to implement Oracle RAC with 2 nodes for SE Licence. I did a lot when both this nodes with 3 NICs each were plugged at the same switch. Now I have a need to construct a RAC when two nodes will be in separate locations, abot 4 miles from each one. What should I explain to our network administrator he needs to do to implement this solution? I've been told that they can do a FO channel to each location. But don't have exact clear explicaton.

View 3 Replies View Related

SQL & PL/SQL :: Read CSV File From Shared Location?

Aug 30, 2013

I want to upload csv file from share location(another host) & store data in table

View 2 Replies View Related

Forms :: Location And Save Button

Apr 25, 2012

I have a master-detail form on which i have 2 buttons. save button and another location button in detail.on location button i am calling a form and updating location of the material entered in detail(tabular).

The thing is my form should not get save without updating location for each record entered in detail(tabular).if user try to save form without updating or pressing location button it should give message PLEASE UPDATE YOUR LOCATION.

View 23 Replies View Related

SQL & PL/SQL :: Passing Location To External File

Sep 16, 2013

I have a simple external table


I need to make the location parametrized so we don't have to hard code the file name file1. Can I do this in Oracle or do I need to do this in a shell script on the UNIX server?

View 4 Replies View Related

Server Administration :: Location Of A DB Block?

Feb 7, 2011

) How to find out, whether my Query return the output from the block of BUFFER CACHE or from DATAFILES?

2) How to calculate the no of data blocks were used to return a single output.

View 2 Replies View Related

Forms :: Copy Files From One Location To Another In 6i

Sep 9, 2008

I want to copy files from one location to another in forms6i on when button pressed.i m using the following code.

cpf_source VARCHAR2(500) := 'c: est.txt';
cpf_target VARCHAR2(500) := 'c:data';

But i press the button it generates FRM-40734,

internal Error : PL/SQL error occurred.

View 5 Replies View Related

SQL & PL/SQL :: Query For Previous Day And Day Before

Jan 15, 2013

The main condition in SQL is like this.

SUM (inv_amt) INV_TOTAL
FROM table_x

My Output from if run in JAN as of now 16 Jan.


I want an sql until previous day of that month for example 15 Jan and another sql until day before previous day of that month for example 14 Jan.

View 15 Replies View Related

SQL & PL/SQL :: Get Previous Value Of Rows?

Dec 29, 2010

How to get the previous value of row with calling function to add value in SELECT statement for the row value.

Consider the example Table A1 having column a with values 1,NULL,NULL,NULL

SELECT CASE WHEN a IS NULL THEN (prev_row_value+function_return_Value) ELSE a END as A from A1

And my result-set should be like

1+(Return Value Of Function)
Prev_Row_Value+(Return Value Of Function)
Prev_Row_Value+(Return Value Of Function)
Below is sample code but doesn't fulfill my criteria


Output is

A A2
1 1

View 8 Replies View Related

SQL & PL/SQL :: How To Know Previous Scn Number

Jun 4, 2012

i want to know the all scn number's that are generated yesterday or in any previous day? how can i achieve it?

View 5 Replies View Related

Copyrights 2005-15, All rights reserved