Re: datafile_problem

Posted by Arsalan on Mar 08, 2017; 7:53am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/datafile-problem-tp2282p2300.html


C:\Users\Arsala>sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on Wed Mar 8 12:27:59 2017

Copyright (c) 1982, 2010, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select HXFIL File_num,substr(HXFNM,1,40) File_name, FHSCN SCN, FHSTA status ,FHRBA_SEQ Sequence from X$KCVFH;

  FILE_NUM FILE_NAME                                SCN                  STATUS
---------- ---------------------------------------- ---------------- ----------
  SEQUENCE
----------
         1 C:\APP\SIGTAS\ORADATA\DWHSIG\SYSTEM01.DB 25029547               8192
      1620

         2 C:\APP\SIGTAS\ORADATA\DWHSIG\SYSAUX01.DB 23957082                  0
      1559

         3 C:\APP\SIGTAS\ORADATA\DWHSIG\UNDOTBS01.D 23957082                  0
      1559


  FILE_NUM FILE_NAME                                SCN                  STATUS
---------- ---------------------------------------- ---------------- ----------
  SEQUENCE
----------
         4 C:\APP\SIGTAS\ORADATA\DWHSIG\USERS01.DBF 23957082                  0
      1559

         5 C:\APP\SIGTAS\ORADATA\DWHSIG\EXAMPLE01.D 23957082                  0
      1559

         6 C:\APP\SIGTAS\ORADATA\DWHSIG\IRD_DATA_LA 23957082                  0
      1559


  FILE_NUM FILE_NAME                                SCN                  STATUS
---------- ---------------------------------------- ---------------- ----------
  SEQUENCE
----------
         7 C:\APP\SIGTAS\ORADATA\DWHSIG\DB_AUDIT_TB 23957082                  0
      1559

         8 C:\APP\SIGTAS\ORADATA\DWHSIG\IRD_INDEXES 23957082                  0
      1559

         9 C:\APP\SIGTAS\ORADATA\DWHSIG\IRD_BASE.DB 23957082                  0
      1559


9 rows selected.