Error in dbvisit_setup

[likema]

Hi

After validating datafile, logfile and tempfile, dbvisit_setup reported:

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

[Arjen Visser]

Thank you for posting.

We will investigate the error.

Regards,

[Arjen Visser]

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

[Arjen Visser]

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

[likema]

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


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


Have any solutions ?

Thanks.

[likema]

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.

[Arjen Visser]

Can you try:

SQL> RECOVER DATAFILE '/oracle/prod/proddata/pplsysx16.dbf';