DBAsupport.com Forums - Oracle Database Administration http://www.dbasupport.com/forums/ Oracle Database Administration, Systems Management, Oracle Application Server, Oracle Portal and Advanced Topics related to Oracle en Wed, 22 May 2013 01:28:18 GMT vBulletin 60 http://www.dbasupport.com/forums/images/misc/rss.png DBAsupport.com Forums - Oracle Database Administration http://www.dbasupport.com/forums/ Just lost all of my data... http://www.dbasupport.com/forums/showthread.php?62989-Just-lost-all-of-my-data...&goto=newpost Tue, 21 May 2013 21:40:39 GMT I guess my database got corrupted and all of my data is showing as corrupted. Even the backup. I contacted Oracle about the situation but there was little they could do. Is there any way to save my information so it isn't all lost? ]]> Oracle Database Administration DBAtotheMAX http://www.dbasupport.com/forums/showthread.php?62989-Just-lost-all-of-my-data... Table scans from application http://www.dbasupport.com/forums/showthread.php?62983-Table-scans-from-application&goto=newpost Mon, 20 May 2013 18:21:19 GMT Hi,

We have an application where delete statement is taking a long time. When I see the v$session_longops the sql statement is doing a full table scan. But when I do an explain plan on the delete statement it uses the index. The statement is "delete tablename where column_name =:B1". I am new to Oracle any ideas how I should proceed.

Thanks,
SK ]]> Oracle Database Administration kanas http://www.dbasupport.com/forums/showthread.php?62983-Table-scans-from-application Emd_notification.queue_ready http://www.dbasupport.com/forums/showthread.php?62979-Emd_notification.queue_ready&goto=newpost Thu, 16 May 2013 19:21:49 GMT I have seen the DB activity spike occasionally, and when I look at the top sessions I see this running as sys man BEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, :3); END; The software using the database doesn't appear to be effected (Users are not complaining during the high activity, and this is a user base were they complain over performance for everything else). When it happens it will kick me out of OEM. I have to restart the web browser and log back in. But if I check the status of dbconsole on the UNIX box is states hat it is still running the entire time. netstat shows the OEM port still listening. I did some google searching and found one site say it had to do with sys man not having execute rights to url_smtp and url_tcp, so I granted the rights but it still happened. The database is 10g and it is on a UNIX server. Can anyone give me some advise on resolving this issue, please. Thank you. ]]> Oracle Database Administration jayjabour http://www.dbasupport.com/forums/showthread.php?62979-Emd_notification.queue_ready Sql script that compares two db,s and updates db and insert date of update http://www.dbasupport.com/forums/showthread.php?62977-Sql-script-that-compares-two-db-s-and-updates-db-and-insert-date-of-update&goto=newpost Thu, 16 May 2013 14:46:20 GMT Hi i need some help creating an sql script that can update info from one table in dbase1 to another table in dbase2 that has the same columns and if posible insert date and time in one column when the syncronized is done? Can anyone help mee whit this? Hi i need some help creating an sql script that can update info from one table in dbase1 to another table in dbase2 that has the same columns and if posible insert date and time in one column when the syncronized is done? Can anyone help mee whit this? ]]> Oracle Database Administration miguel_q http://www.dbasupport.com/forums/showthread.php?62977-Sql-script-that-compares-two-db-s-and-updates-db-and-insert-date-of-update Temp Usage http://www.dbasupport.com/forums/showthread.php?62975-Temp-Usage&goto=newpost Thu, 16 May 2013 11:26:31 GMT Hi, I am new to Database activities.Please advise how to check the temp usage and find the query causing that temp in oracle 9i Hi,

I am new to Database activities.Please advise how to check the temp usage and find the query causing that temp in oracle 9i ]]> Oracle Database Administration gargi http://www.dbasupport.com/forums/showthread.php?62975-Temp-Usage Re-create archive logs http://www.dbasupport.com/forums/showthread.php?62971-Re-create-archive-logs&goto=newpost Mon, 13 May 2013 18:40:52 GMT Hello,
10g Standard DB on RHEL 4. I'm wondering if there is a way to re-create or re-generate past archive logs?

Here's the story behind this question:
A few days ago one of my guys started the DB by manually specifying pfile (eg: startup open pfile=/u01/app/oracle/admin/dbs/pfile/init.ora). The problem with that is the pfile specified did not contain all the parameters that are in spfile, namely log_archive_dest_1. I noticed the problem about two hours later and got it restarted correctly, the problem I have now is a gap in archive logs, missing about 25 log files. This gap has caused a problem with applying the archive logs to my standby database. I tried replacing the standby with a newer backup that I assumed wouldn't care about the missing logs but it still is. So I'm wondering if there is a way to remake those arch logs that got skipped or do I need to do an OPEN RESETLOGS?

Thanks, ]]> Oracle Database Administration louie75 http://www.dbasupport.com/forums/showthread.php?62971-Re-create-archive-logs archives not shipping on standby http://www.dbasupport.com/forums/showthread.php?62969-archives-not-shipping-on-standby&goto=newpost Sun, 12 May 2013 07:33:52 GMT Hii all,

I am trying to configure physical standby. Everything was fine but at the end i found that archives from primary db are not shipping to standby..Networking is fine.

Here is the production p file.

db_name=manish
db_unique_name=manish1
#service_name=manish1
remote_login_passwordfile=exclusive
shared_pool_size=102341017
db_block_size=8192
diagnostic_dest=/disk1/oradata/manish
undo_tablespace=undotbs
undo_management=auto
control_files = /disk1/oradata/manish/control.ctl
compatible ='11.2.0'
###################Data guard PARAM's###################
log_archive_dest_1='location=/disk1/oradata/manish/arch
valid_for=(all_logfiles,all_roles)'
log_archive_dest_2='service=stand
valid_for=(online_logfiles,primary_role)
db_unique_name=stand1 lgwr sync affirm reopen=10'
standby_archive_dest=/dsik1/oradata/manish/arch
standby_file_management=auto
log_archive_dest_state_1=enable
log_archive_dest_state_2=enable
fal_server=stand
fal_client=manish

here is my standby's p file

db_name=manish
db_unique_name=stand1
remote_login_passwordfile=exclusive
shared_pool_size=102341017
db_block_size=8192
diagnostic_dest=/disk1/oradata/manish
undo_tablespace=undotbs
undo_management=auto
control_files = /disk1/oradata/manish/stand.ctl
compatible ='11.2.0'
###################Data guard PARAM's###################
log_archive_dest_1='location=/disk1/oradata/manish/arch
valid_for=(all_logfiles,all_roles)'
log_archive_dest_2='service=manish lgwr sync affirm reopen=10'
standby_archive_dest=/dsik1/oradata/manish/arch
standby_file_management=auto
log_archive_dest_state_1=enable
log_archive_dest_state_2=enable
fal_server=manish
fal_client=stand


archive log list (primary)

archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /disk1/oradata/manish/arch
Oldest online log sequence 198
Next log sequence to archive 199
Current log sequence 199


archive log list(standby)

archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /disk1/oradata/manish/arch
Oldest online log sequence 178
Next log sequence to archive 179
Current log sequence 179

Please help me to get through this ...
Thanks :cool: ]]> Oracle Database Administration manish.sharma http://www.dbasupport.com/forums/showthread.php?62969-archives-not-shipping-on-standby Recover Oracle datafile http://www.dbasupport.com/forums/showthread.php?62967-Recover-Oracle-datafile&goto=newpost Thu, 09 May 2013 13:33:55 GMT Hi all,
unfortunately my hard disk's server crashed, and I do not have any backup,
I recovered oradata folder in crashed hard disk, which is contains DBF, Ora and log files as attachment picture.
My Oracle database version is 10.2.
would you please guid me how can I recover my databse step by step?
Attached Images
]]> Oracle Database Administration saber_talas http://www.dbasupport.com/forums/showthread.php?62967-Recover-Oracle-datafile INSERT statement http://www.dbasupport.com/forums/showthread.php?62959-INSERT-statement&goto=newpost Fri, 03 May 2013 05:39:36 GMT I'm trying to insert a values in a table, that has 3 columns. But I'm getting "ora-00984 : column not allowed here" - error. I've taken a value in w_total = 20865000 and executing
insert into temp_latepos values ('USD',w_total,0) in VB 6.0. Please help me resolve this issue.
w_total is the figure got by various calculations and cannot be the same every time. USD is always constant and 0 is also constant. ]]> Oracle Database Administration K PRASANNA http://www.dbasupport.com/forums/showthread.php?62959-INSERT-statement Datafile extend or add new file http://www.dbasupport.com/forums/showthread.php?62957-Datafile-extend-or-add-new-file&goto=newpost Thu, 02 May 2013 18:51:21 GMT I am a new oracle dba. I am concerned that one of the files is getting low on space. Running oracle 8i on AIX. Does the file automatically extend or does it create a new file? I think I have to create a new file, just not sure. Thanks;) I am a new oracle dba. I am concerned that one of the files is getting low on space. Running oracle 8i on AIX. Does the file automatically extend or does it create a new file? I think I have to create a new file, just not sure.

Thanks;) ]]> Oracle Database Administration char http://www.dbasupport.com/forums/showthread.php?62957-Datafile-extend-or-add-new-file Sequences out of sync http://www.dbasupport.com/forums/showthread.php?62953-Sequences-out-of-sync&goto=newpost Thu, 25 Apr 2013 20:39:52 GMT Hello everyone, is there a scriptable way of figuring out if the database sequences are out of sync?

We have almost 200 sequences and over 900 databases. Every once in a blue moon we have an application problem that takes us a few hours of trouble shooting to figure out that a sequence is out of sync. I fix the offending sequence but it always makes me wonder about the other 199 and we don't have time to check every one of them.

I have googled this a lot of times and have always came up empty handed which makes me think the answer is no but I wanted to ask just to be 100% sure.

Thank you for your help in advanced!
:o ]]> Oracle Database Administration StoneCold http://www.dbasupport.com/forums/showthread.php?62953-Sequences-out-of-sync Stats collection for upgrade to 11G http://www.dbasupport.com/forums/showthread.php?62951-Stats-collection-for-upgrade-to-11G&goto=newpost Mon, 22 Apr 2013 13:04:09 GMT Hi, I have a 10.2.0.5 database running on Windows Server x64bit that I want to move to 11G Linux SUSE10. I will be using export / import. Should I export the database stats from 10G and import into 11G ? Or will export / import take care of this ? Hi, I have a 10.2.0.5 database running on Windows Server x64bit that I want to move to 11G Linux SUSE10. I will be using export / import. Should I export the database stats from 10G and import into 11G ? Or will export / import take care of this ? ]]> Oracle Database Administration pascal01 http://www.dbasupport.com/forums/showthread.php?62951-Stats-collection-for-upgrade-to-11G