SQL>DESC rates
Name Null? Type
----------------- -------- ------------
CURRENCY VARCHAR2(4)
RATE NUMBER(15,10)
and when i run
select versions_starttime, versions_endtime, versions_xid,
versions_operation, rate
from rates versions between timestamp minvalue and maxvalue
order by VERSIONS_STARTTIME
/
this query I'm not able to see pseudo columns value.
It is giving me error datatype not supported.
Any Idea?
-Bhaskar
> -----Original Message-----
> From: ext Michael Porter
> [mailto:oracledba-ezmlmshield-x51767284.[Email address protected]
> Sent: 28 May, 2004 15:27
> To: LazyDBA.com Discussion
> Subject: RE: ORA-01113: file 1 needs media recovery
>
>
> No this will NOT work. If you were in archive log mode, you
> will have to apply the archove logs it wants after issuing
> "recover database until cancel". If you were not in archive
> log mode and restoring all the files does NOT work from a
> cold backup, you will not be able to recover.
>
> Mike Porter
> Finance Support Services
> PGA of America
> 561-624-7646
> >>> "antonio" <oracledba-ezmlmshield-x9378976.[Email address
> protected] 05/28/04 04:44 AM >>>
> Hi. Try this, I don't warranty anythink. It' tricky
>
> SQL> I suppose you can mount the database
> 1) SQL>startup mount
> 2) SQL> select member,group# from v$logfile now
> you can see
> the redos
>
> MEMBER GROUP#
> -------------------------------------------------- ----------
> /u03/oradata/redo/cprepro/redo_clarify31.log 3
> /u04/oradata/redo/cprepro/redo_clarify32.log 3
> /u03/oradata/redo/cprepro/redo_clarify21.log 2
> /u04/oradata/redo/cprepro/redo_clarify22.log 2
> /u03/oradata/redo/cprepro/redo_clarify11.log 1
> /u04/oradata/redo/cprepro/redo_clarify12.log 1
>
> 6 rows selected.
>
>
> 3) Apply one redo from each GROUP, when you get the message Media
> Recover Completed, then ALTER DATABASE OPEN RESETLOGS
> Sql> recover database using backup controlfile;
> It will ask you for a not existent archive log, paste the name of the
> redo file
>
> /u03/oradata/redo/cprepro/redo_clarify11.log
>
> Apply only 1 member of each group, you don't need to apply
> all the group
> if you get "Media Recover Completed"
>
> After Media Recovery
> ALTER DATABASE OPEN RESETLOGS
>
>
>
> PLEASE, LET ME KNOW IF IT WORKS
>
> Regards.
>
>
> Antonio-Luis Rodriguez Duran
> AIP: BT Global Services Spain
> AIP: Database Support
> Tel : +34 91 270 61 47
> Fax: +34 91 270 61 14
> Calle Isabel de Colbrand, 8, 2 planta
> 28050 Madrid - Spain
> antonio.[Email address protected]
> www.bt.es
>
>
> -----Mensaje original-----
> De: Varsha Savyasachi
> [mailto:oracledba-ezmlmshield-x72305974.[Email address protected]
> Enviado el: viernes, 28 de mayo de 2004 8:45
> Para: LazyDBA.com Discussion
> Asunto: ORA-01113: file 1 needs media recovery
>
>
> Hi,
>
> When I try to restore and recreate the crashed db from an old backup,
> this
> is the message i get :
>
> ORA-01195: online backup of file 1 needs more recovery to be
> consistent
> ORA-01110: data file 1: 'F:\ORACLE\ORADATA\PACS\SYSTEM01.DBF'
>
> How can I recover this db ?
>
> tia,
> varsha
>
> _________________________________________________________________
> Contact brides & grooms FREE!
> http://www.shaadi.com/ptnr.php?ptnr=hmltag
>
> Only on www.shaadi.com. Register now!
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: send a blank email to oracledba-[Email
> address protected]
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: send a blank email to oracledba-[Email
> address protected]
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: send a blank email to oracledba-[Email address protected]
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>
Oracle LazyDBA home page