How to find the Edition of your Oracle Database: [root@ProdDB01 ~]# su – oracle -bash-3.1$ sqlplus ‘/ as sysdba’ SQL*Plus: Release 8.1.6.0.0 – Production on Tue Mar 25 12:32:46 2014 (c) Copyright 1999 Oracle Corporation.  All rights reserved. Connected to: Oracle8i Enterprise Edition Release 8.1.6.1.0 – Production With the Partitioning option JServer Release 8.1.6.0.0 – Production SQL> select banner from v$version; BANNER —————————————————————- Oracle8i Enterprise Edition Release 8.1.6.1.0 – Production PL/SQL Release 8.1.6.0.0 – Production CORE    8.1.6.0.0       Production TNS for Linux: Version 8.1.6.0.0 – Production NLSRTL Version 3.4.0.0.0 – Production SQL> No. of Users and CPU/Processors: SQL> select * from […]

When we did a cloning/recover the database with noarchivelog mode, we got the problem that some datafile need to be recover. It will be difficulty since no archivelog that can help us to recover it. Otherwise we can copy all datafiles from offline backup of the source database. But it will takes time to copy/ftp/restore especially if the database size are hundreds GB or even TB. But there is a solution to recover the database with noarchivelog mode, please check this out :  When we did a cloning, startup nomount :           $ sqlplus ‘/as sysdba’ SQL*Plus: Release 10.2.0.4.0 – Production […]