Dbvisit Community Dbvisit home       

Go Back   Dbvisit Community > Dbvisit Standby - Technical > Dbvisit Standby - on Unix/Linux

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 09-18-2011, 06:28 AM
likema likema is offline
Junior Member
 
Join Date: Sep 2011
Posts: 6
Default Error in dbvisit_setup

Hi

After validating datafile, logfile and tempfile, dbvisit_setup reported:

Code:
201109180024 - ORA-00936: missing expression
                Dbvisit Standby terminated.
Return code = 433
The corresponding trace file is too large to upload the attachment. So please download it from my server:

http://69.197.183.184/15863_dbvisit_...9180024.trc.gz

The following is versions info
dbvisit: V6.0.10.7183
Solaris: SunOS ecserp 5.9 Generic_122300-15 sun4u sparc SUNW,Sun-Fire
Oracle: Oracle8i Enterprise Edition Release 8.1.7.1.0 - Production

Regards

Like Ma
Reply With Quote
  #2  
Old 09-18-2011, 08:45 AM
Arjen Visser Arjen Visser is offline
Dbvisit Team
 
Join Date: Jan 2008
Location: Auckland, New Zealand
Posts: 380
Default

Thank you for posting.

We will investigate the error.

Regards,
Reply With Quote
  #3  
Old 09-18-2011, 10:55 AM
Arjen Visser Arjen Visser is offline
Dbvisit Team
 
Join Date: Jan 2008
Location: Auckland, New Zealand
Posts: 380
Default

One of your datafiles (file_id 511) does not seem to have a a filesize associated with it from dba_data_files.
This is file name: /oracle/prod/proddata/pplsysx16.dbf

Can you run the following query:
SQL> select file_name, bytes tablespace_name from dba_data_files where file_id = 515;

Thanks
Reply With Quote
  #4  
Old 09-18-2011, 10:55 AM
Arjen Visser Arjen Visser is offline
Dbvisit Team
 
Join Date: Jan 2008
Location: Auckland, New Zealand
Posts: 380
Default

One of your datafiles (file_id 511) does not seem to have a a filesize associated with it from dba_data_files.
This is file name: /oracle/prod/proddata/pplsysx16.dbf

Can you run the following query:
SQL> select file_name, bytes tablespace_name from dba_data_files where file_id = 515;

Thanks
Reply With Quote
  #5  
Old 09-18-2011, 05:53 PM
likema likema is offline
Junior Member
 
Join Date: Sep 2011
Posts: 6
Default datafile #511 rather than #515 without bytes

select status, tablespace_name, bytes from dba_data_files where file_id = 511;


STATUS TABLESPACE_NAME BYTES
--------- ------------------------------ ----------
AVAILABLE INVX


Have any solutions ?

Thanks.
Reply With Quote
  #6  
Old 09-18-2011, 06:30 PM
likema likema is offline
Junior Member
 
Join Date: Sep 2011
Posts: 6
Default datafile #511 is in RECOVER state.

select status from v$datafile where file#=511;

STATUS
-------
RECOVER


datafile #511 is in RECOVER state but I don't have the corresponding archive logs to recover it.

Any good suggestions?

Thanks.
Reply With Quote
  #7  
Old 09-18-2011, 06:50 PM
Arjen Visser Arjen Visser is offline
Dbvisit Team
 
Join Date: Jan 2008
Location: Auckland, New Zealand
Posts: 380
Default

Can you try:

SQL> RECOVER DATAFILE '/oracle/prod/proddata/pplsysx16.dbf';
Reply With Quote
  #8  
Old 09-18-2011, 06:56 PM
Arjen Visser Arjen Visser is offline
Dbvisit Team
 
Join Date: Jan 2008
Location: Auckland, New Zealand
Posts: 380
Default

It looks like an index tablespace. You can drop and recreate the tablespace and then recreate the indexes if you have the DDL
Reply With Quote
  #9  
Old 09-18-2011, 07:59 PM
likema likema is offline
Junior Member
 
Join Date: Sep 2011
Posts: 6
Default

I tries to recover it but the archive logs were deleted long ago.

I am trying to export and import to recreate the tablespace.

Thanks a lot.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off

Forum Jump


All times are GMT +12. The time now is 04:57 AM.