|
 |
| Recent blog posts: | |
|
| They have birthday today: | |
|
| Forums: | | |
|
| Discuss: | |
|
| Recent forum topics: | |
|
| Recent forum comments: | |
|
| Модератор: | |
|
Thursday, 3 August 2006
|
| RMAN / controlfile / TDPO issue Evan Ehrenhalt 01:58:58 |
| | HELP!!!
We are seeing an intermittent error when using RMAN to backup our
archive logs.
The archive logs are moved to tape and deleted, but there are errors on
the controlfile backup. Whenever this happens, the logs themselves seem
fine. Just the controlfile fails to backup.
Can anyone tell me why the controlfile backup would cause this error,
when the archivelog backup goes fine?
Here is the background:
Oracle 9.2.0.6 + security patches.
RMAN is 9.2.0.6.0 (same ORACLE_HOME)
Tivoli Data Protection for Oracle (TDPO) 5.2.0.0
----------------- RMAN Logfile ------------------
Starting backup at 28-JUL-06
channel c1: starting archive log backupset
channel c1: specifying archive log(s) in backup set
input archive log thread=1 sequence=103986 recid=102783 stamp=578189102
channel c1: starting piece 1 at 28-JUL-06
channel c2: starting archive log backupset
channel c2: specifying archive log(s) in backup set
input archive log thread=1 sequence=103987 recid=102784 stamp=578189702
channel c2: starting piece 1 at 28-JUL-06
released channel: c1
released channel: c2
released channel: c3
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on c1 channel at 07/28/2006 00:20:02
ORA-19506: failed to create sequential file,
name="DB1P_ARCHIVE_20060728_578190000_s19709_p1", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
ANS1017E (RC-50) Session rejected: TCP/IP connection failure
RMAN>
----------------- RMAN SCRIPT ------------------
RMAN script and settings:
connect target /
connect catalog $logn
configure backup optimization on;
configure default device type to 'sbt_tape';
configure channel device type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
configure controlfile autobackup on;
run {
allocate channel c1 type 'sbt_tape' parms
'ENV=(DSMI_ORC_CONFIG=/opt/tivoli/tsm/client/oracle/bin64/dsm.opt)';
backup filesperset 10
format '%d_ARCHIVE_%T_%t_s%s_p%p' tag '$ORACLE_SID Archive'
(archivelog like '/u01/app/oracle/admin/${ORACLE_SID}/arch/%' delete input);
release channel c1;
}
----------------- Typical Tivoli Log ------------------
***** Each backup has a start, a number of bytes send, and an end.
***** In this example, 205017,
***** It starts,
***** backs up R25PROD_ARCHIVE_20060731_597246624_s29484_p1
***** Size 33554432 bytes,
***** then ends.
07/31/06 13:50:25 ANR0406I Session 205017 started for node URANIAORA
TDP Oracle SUN) (Tcp/Ip 170.140.13.75(41834)). (SESSION: 2050
07/31/06 13:50:35 ANE4991I (Session: 205017, Node: URANIAORA) TDP
Oracle SUN ANU0599 ANU2535I File
/adsmorc//R25PROD_ARCHIVE_20060731_597246624_s29484_p1 = 33554432 bytes
sent (SESSION: 205017)
07/31/06 13:50:35 ANR0403I Session 205017 ended for node URANIAORA
(TDP Oracle SUN). (SESSION: 205017)
***** Controlfile success
***** Start backup controlfile by deleting the old copy (never exists).
07/31/06 14:20:23 ANR0406I Session 205103 started for node URANIAORA
(TDP Oracle SUN) (Tcp/Ip 170.140.13.75(42121)). (SESSION: 205103)
07/31/06 14:20:23 ANE4994S (Session: 205103, Node: URANIAORA) TDP
Oracle SUN ANU0599 ANU2602E The object
/adsmorc//c-2375565327-20060731-00 was not found on the TSM
Server(SESSION: 205103)
07/31/06 14:20:23 ANR0403I Session 205103 ended for node URANIAORA
(TDP Oracle SUN). (SESSION: 205103)
***** Now do the actual controlfile backup:
07/31/06 14:20:23 ANR0406I Session 205104 started for node URANIAORA
(TDP Oracle SUN) (Tcp/Ip 170.140.13.75(42122)). (SESSION: 205104)
07/31/06 14:20:24 ANE4991I (Session: 205104, Node: URANIAORA) TDP
Oracle SUN ANU0599 ANU2535I File /adsmorc//c-2375565327-20060731-00 =
1835008 bytes sent (SESSION: 205104)
07/31/06 14:20:24 ANR0403I Session 205104 ended for node URANIAORA
(TDP Oracle SUN). (SESSION: 205104)
***** Control file failure, it looks like this for a failure
07/31/06 13:50:35 ANR0406I Session 205020 started for node URANIAORA
(TDP Oracle SUN) (Tcp/Ip 170.140.13.75(41837)). (SESSION: 205020)
07/31/06 13:50:35 ANR0403I Session 205020 ended for node URANIAORA
(TDP Oracle SUN). (SESSION: 205020)
No action, just a start, then an end. While on the RMAN side I get the
error above.
Any thoughts?
Thanks
|
| |  6 answers | Add comment |
|
| Oracle Apps Requirement Luckystarduke 01:35:58 |
| | Hello All,
We have the following requirement.
Please send matching Profiles along with the Rate Expectations,
Availability and Contact Details of the Candidate for the same.
Strong Oracle Developer with experience in Oracle applications
financials modules (Accounts payable, Purchasing, iprocurement,
iexpense, and general ledger). Primary responsibilities will be doing
production support for all financial modules fixing day to day issues.
Should be strong in following skills:
Oracle work flow, PL/SQL, Oracle Reports and Oracle forms.
Java, Oracle Applications framework (OAF) are plus.
Location:- Chicago,IL
Duration:- 5 months
Rate:- Open
Let me know if you need more information on the same.
Many Thanks,
Renuka
Technical Recruiter
KLM Software Services Inc.
1111 N. Plaza Dr
Suite 101
Schaumburg, IL 60173
Tel : 847-995-9556 Ext 212
Fax : 847-995-9557
NOTE : This email is not intended to be a solicitation. It is targeted
to recruiting and consulting professionals. If you have received this
in error, please accept our apologies and to be removed from our
mailing list reply to renuka@klmss.com with "REMOVE" in the subject
heading and your email address in the body. If you have already asked
to be removed, and are currently continuing to receive our emails,
please send us the any older or alias email address/es. This sometimes
are forwarded to the new email address and we must delete these older
or alias address/es from our list in order to stop mail from reaching
your current address. We regret any inconvenience caused to you and
sincerely appreciate your continued patience and cooperation.
|
| | Add comment |
|
| STREAMS capture and propagate to different schema Dr 01:01:51 |
| | thanks in advance!
can anyone say definitively if i can or can't capture and propagate an
object owned by one schema and apply that to a different schema on the
destination database?
as in a.dept (source database) changes captured and propagated to
b.dept (target database).
if this cannot be done 'out of the box,' any information pertaining to
apply handlers to resolve this requirement (different schema names)
would be much appreciated.
-r
|
| | 6 answers | Add comment |
|
| how to release system tablespace space? Wyys.Cn@Gmail.Com 00:57:37 |
| | cause advance replication doesn't work. a lot of data segment locate
in sytem tablespace, so system tablespace space is much beeter than
before, any ways to release system tablespace space? thanks in advance!
|
| | 4 answer | Add comment |
Wednesday, 2 August 2006
|
| table name Guest 23:55:28 |
| | I'd like to make a PL/SQL function called copytable that essentially
takes in a table name and copies it to a remote site.
However, I don't know how to pass a table name into an Oracle
procedure.
Anyone know how to do this?
|
| | 4 answer | Add comment |
|
| HELP: Inconsistent results from SQL query run on different servers Catch_22 23:02:24 |
| | Hi,
I am running a simple query (select count(*) from xxx.table_A) on two
different servers.
ServerA : Windows 2000 server running Oracle SQL Plus 9.2.0.1.0
ServerB : Windows 2000 server running Oracle SQL Plus 8.0.5.0.0
(My PC client is also running Oracle SQL Plus 9.2.0.1.0)
These two servers connect to an Oracle DB (Oracle 9i (9.2.0.6.0))
located on a different server (Unix) to extract data. These extracts
have been running without trouble until we recently had an Oracle
Production system upgrade to Oracle 11.
I've checked that the tnsnames files on both servers point to the
correct DB server.
The connection string (username/password@alias) used to connect to the
Oracle database were both the same.
Permissions on the Oracle DB are strict and the username/password has
read access to a couple of tables and views only.
The one select statement I am running that is giving me problems joins
1 table and 2 views.
TableA, View1, View2. So I decided to run a simple select on each table
to see if I could spot any problems.
When I run a simple select count(*) from TableA or (View1), the results
of the statements from the two servers are identical.
When I run the select statment View2, ServerB returns a count of
15,000. while on Server A it returns a count of zero (No records
returned).
We have tried everything that we can think of and cannot seem to work
out what is happening here. To validate the results I have run the same
statements on my PC and get the same results as ServerB (every
table/view is populated). A seperate source has run the same query on
his PC and returned the same results as Server B both using the same
username/password and a DBA username/password.
How can this one server (ServerA) not be returning any count from one
view only when 3 other different attempts from different PCs/Servers
(using the same username password) succesfully return the correct
count. Yet ServerA, returns the correct count for the other view and
table queries.
If anyone has any suggestions please let me know.
|
| | 3 answer | Add comment |
|
| populating years in a drop down menu in PL/SQL Guest 22:56:12 |
| | Guys,
I am new to PL/SQL. I am trying to have a drop down menu with years
from 1980-2006 etc. How do I write this? So far I have the following..
CURSOR inst_years IS
SELECT EXTRACT(YEAR FROM SYSDATE) 'year'
FROM DUAL;
// This cursur just returns 2006. What I am looking for is actually all
years from 1980
// to 2006 in my drop down menu. I'll need to modify the cursor. Please
let me know how I
// can do this. But that is just the part of my problem, What I dont
know is how do I get the
// value into my loop below since I dont know the actual name of the
field.
htp.p('<TD>');
htp.formSelectOpen('p_inst',NULL,'1');
htp.formSelectOption('Not listed',NULL,'VALUE=XX');
FOR year_rec IN inst_years LOOP
htp.formSelectOption(year_rec.<What do I put here?>,NULL,
'VALUE=' || year_rec.<What do I put
here>);
END LOOP;
htp.p('</TD>');
thanks
- RD
|
| | 7 answers | Add comment |
|
| exact replica Guest 22:50:49 |
| | Let's say you want to create a site that has an exact replica of
another site, and it is to be continuously updated. What is the
simplest way to do this?
I have considered options involving materialized views. However, I
want the table structure and names to be exactly the same on both
sites. With materialized views, I don't see how this is possible.
Any ideas?
Thank you.
|
| | 3 answer | Add comment |
|
| Whats the bcp (SQL Server) substitute in Oracle?? Guest 22:13:14 |
| | Hi friends,
In my project right now we are creating flat files from tables on one
secured UNIX server using the bcp utility of SQL Server.
But now this database will be migrated to Oracle 10g. Can i achieve the
same functionality of bcp in Oracle?? I already have one procedure
which can create one flat file on a fixed server location which will be
specified in init.ora file.
But I want to create the three files that are created using the bcp
i.e. Error File, Flat File and Out File. Also, I am not very clear
about the difference between the Flat file and Out file generated by
bcp. I also want to pass the secured server location as a parameter to
this procedure.
Can anyone help me on this?? Please provide the code snippet as i am
very new to Oracle.
This is really urgent friends, please help me.
|
| | 9 answers | Add comment |
|
| What privilege needed to use Oracle Enterprise Manager Guest 22:07:45 |
| | A lot of our developers want to use Enterprise Manager, they do not
like sqlplus.
But I do not like to give them DBA privilege or "select any
table","select any dictionary" privilege, do I have any other options?
Thanks for your help.
|
| | 3 answer | Add comment |
|
| OracleВ® Database Express Edition Guest 19:33:19 |
| | I installed OracleВ® Database Express Edition.
Then I clicked "Go To Database Home Page".
It tried to go to http://127.0.0.1:8080/apex.
However, Internet Explorer said, "The page cannot be displayed".
Any ideas as to what is wrong?
|
| | 2 answer | Add comment |
|
| Creating View with WITH clause Guest 18:52:20 |
| | Hi all,
I'd like to create a view based on some code that I was helped out with
yesterday, and I'm having some trouble with it. What I have so far is
(with some complexity removed and names changed to protect the
innocent):
with table_flattener as (
select j1.batch_id, b.batch_name,
...
from jobs.action j1, jobs.action j2, jobs.batch b
where j2.batch_id (+)= j1.batch_id and
b.batch_id=j1.batch_id )
select a.batch_id, max(a.sent) sent, a.batch_name, max(a.received)
received
from table_flattener a
group by a.batch_id, a.batch_name
order by 1
what I'd like to do is create a view of this exact data. Of course:
create view myview
with table_flattener as (
etc
doesn't work. Am I missng a really obvious way to do this?
Thanks so much in advance!
m
|
| | 6 answers | Add comment |
|
| Update Oracle table to remove whitespace using trim function Guest 18:15:09 |
| | I want to update one column in a table using the trim function. I
tried to write an update with a subselect but it failed. Does anyone
have code to do this or can you point me to an article about this?
thanks,
Don
|
| | 4 answer | Add comment |
|
| Oracle XMLType Sk 13:26:32 |
| | We use Oracle XMLType for our metadata to support scientific metadata
(some of items can be repeatable). However, everytime we get the data
it takes time to parse the xml from database. Is there any way to serialize
xml to objects in Oracle quick. Or there is a way to improve our structure?
SK
|
| | 3 answer | Add comment |
|
| multiple tables Guest 11:59:45 |
| | Anyone know how to put multiple tables in a single materialized view?
|
| | 1 answer | Add comment |
|
| anyone follow the cuddletech blog? Hpuxrac 10:33:37 |
| | It's over at http://www.cuddletech.com/blog/
It's a somewhat sun centric perspective but lots of good info. Some of
you posters out in cdos might get some usage.
I guess I missed out. If you look at the entry from July 27th ... it
was evidently System Administrator Appreciation Day last friday.
Hmmm are we missing a DBA Appreciation Day somewhere?
|
| | 1 answer | Add comment |
|
| Avoid a subselect "where not equal to"? Andrew Fabbro 10:20:44 |
| | A colleague asked for help with this query...I got it working for him,
but someone else mentioned that it would perform horribly at scale.
So here's the problem:
CREATE TABLE table1 (id integer, name varchar2(10));
CREATE TABLE table2 (id integer, table1id integer, name status(10));
He wants to join on table1.id = table2.table1id and status = 'new' -
that part is easy - but does not want any rows from table1 that also
have table2.status = 'open'.
For example:
INSERT INTO table1 (id, name) VALUES ( 1, 'x' );
INSERT INTO table1 (id, name) VALUES ( 2, 'y' );
INSERT INTO table1 (id, name) VALUES ( 3, 'z' );
INSERT INTO table2 (id, table1id, name) VALUES ( 10, 1, 'new');
INSERT INTO table2 (id, table1id, name) VALUES ( 11, 1, 'open');
INSERT INTO table2 (id, table1id, name) VALUES ( 12, 2, 'new');
...and the query he wants would return only the second row of table1
(not row 1 because it has an 'open' in table2, and not row 3 because it
does not have a 'new' in table2).
So my solution was:
SELECT Table1.id,Table1.name,Table2.id,Table2.Table1id,Table2.Status
FROM Table1,Table2
WHERE Table1.id = Table2.Table1id AND
Table2.Status = 'new' AND
Table1.id != (SELECT table1id FROM table2 WHERE status =
'open');
And that worked fine. However, someone else referred to this as a
"nasty" query, opining that "where not in (select...) queries are some
of the worst" in a performance sense.
Oracle's plan is not pretty (this is for the sample database just
shown, not the production data set)...
------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)|
Time |
------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 2 | 214 | 10 (10)|
00:00:01 |
|* 1 | HASH JOIN | | 2 | 214 | 7 (15)|
00:00:01 |
|* 2 | TABLE ACCESS FULL | TABLE1 | 2 | 94 | 3 (0)|
00:00:01 |
|* 3 | TABLE ACCESS FULL| TABLE2 | 1 | 47 | 3 (0)|
00:00:01 |
|* 4 | TABLE ACCESS FULL | TABLE2 | 2 | 120 | 3 (0)|
00:00:01 |
------------------------------------------------------------------------------
...but I can't think of any other way to get the desired
result...anyone? (For 10g).
Thx.
|
| | 7 answers | Add comment |
|
| Gather IO stats Guest 04:07:07 |
| | Would like to gather physical reads/writes from a semi hourly
statspack run.
Any one already done this and want to share the scripts that were used
that
will be appreciated.
TIA
MB
|
| | 11 answers | Add comment |
|
| XMLType design implications Guest 03:18:15 |
| | I'm designing a new database using Oracle 9i Release 2 (which we will
later migrate to 10g). For the solution I chose to design an XML
Schema for my data collection and store all my data as XML.
Using XML solves a couple of problems related to repeating fields (ex:
Address lines, related web links, etc). XML has allowed me to have a
vertically scalable solution. However, I'm confused on how I should
integrate this design into the database.
Originally, with straight relational tables we were going to have two
tables - one to hold top level items (Buildings) and another to hold
Items (ie. departments, dining facilities, etc). My design migrated
those two tables into one that looks like:
ID Number PK,
ParentID Number FK ID Constraint,
ItemName varchar2(50),
ItemXML XMLType,
isActive Boolean
I was also planning to put these Items into categories using a
Categories table (ID, ParentID, CategoryName, isActive) and link them
using an ItemCategories link table (CatID, ItemID).
-----------------
My question is this: Are there any guides to designing with XML? For
example, the ItemName column could be removed becuase there is also a
<Name> element in the <Item> Schema. I could theoretically use XQuery
against that element to derive the Name instead of having a seperate
column. The Items describe a variety of entities including buildings,
departments, parking facilities, and other entities.
I'm later planning to be able to use XQuery to query specific parts of
the XML Doc in the XMLType field (ex: GPS information and Name only),
and use XSLT to transform an Item entry into an html page with detailed
information.
Should I go with an ALL XML design or a hybrid XML/Relational model?
The XML does not describe a transaction, request, or full document.
Any help would be appreciated, and you can contact me off list!
|
| | 1 answer | Add comment |
|
| How to arrange this query ??? Guest 03:18:09 |
| | Good Morning,
I need to extract some records from a table,
another column have to be a boolean that tells me if the key of that
record is present also in another table.
It is possible to do all this with just one query ??
Thanks,
Antonio D'Ottavio
www.etantonio.it/en/
|
| | 11 answers | Add comment |
|
| AWR and SQL Tuning - 10gR1 Akimeu 03:09:04 |
| | Hello everyone,
I am in a situation where I cannot get the Enterprise manager installed
to use the new ADDM feature. I can however use sqlplus for any queries,
reports (ie, awrrpt), etc. Are there any api's or scripts that I can
use to utilize the addm functionality from a sqlplus session? I've got
some nasty queries to deal with - and I'll take any advice I can get 
Thanks,
JustMe
|
| | 3 answer | Add comment |
|
| Workspace Manager Question Wrgptfan 01:58:15 |
| | I have a schema of about 200 version enabled tables. What I would like
to do is to modify one of the tables using DBMS_WM.BEGINDDL, however
the table name is 25 characters in length. Although the documentation
states that a table name cannot exceed 25 characters (because of adding
_HIST and the like) it seems as if the limit is fewer than 25 if you
ever would like to alter the table.
Am I doing something wrong or is there a workaround to my problem.
TIA...Dave Kent
permit@devdb> create table WCP_ISSUING_LOCATION_CODE (pk number(5));
Table created.
permit@devdb> alter table WCP_ISSUING_LOCATION_CODE add constraint
WCP_ISSUING_LOCATION_CODE_pk
2 primary key(pk);
Table altered.
permit@devdb> exec
dbms_wm.enableversioning('WCP_ISSUING_LOCATION_CODE');
PL/SQL procedure successfully completed.
permit@devdb> exec dbms_wm.beginddl('WCP_ISSUING_LOCATION_CODE')
BEGIN dbms_wm.beginddl('WCP_ISSUING_LOCATION_CODE'); END;
*
ERROR at line 1:
ORA-00972: identifier is too long
ORA-06512: at "SYS.OWM_DDL_PKG", line 1878
ORA-06512: at "SYS.LT", line 10257
ORA-06512: at line 1
permit@devdb> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production
permit@devdb>
|
| | 6 answers | Add comment |
|
| Can a query reuse data??? Oraboy 00:29:37 |
| | I understand that data blocks are kept in the buffer cache but can
someone clarify the following
If i issue a query thats run before as well as avoiding a parse can
Oracle make use of the previous result set or does it always go back
and fetch the data from either the buffer cache or disk??
Thanks
|
| | 3 answer | Add comment |
|
|
