Translate this Page

 

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 on Tue Apr 13 13:54:43 2010 
Copyright (c) 1982, 2007, Oracle. All Rights Reserved. 
Connected to an idle instance. 
SQL> startup nomount pfile=initMYDB.ora
ORACLE instance started. 
Total System Global Area 5251268608 bytes
Fixed Size 2091368 bytes
Variable Size 1040189080 bytes
Database Buffers 4194304000 bytes
Redo Buffers 14684160 bytes 
 

Our company runs Oracle E Business Suite 11.5.9 and 11.5.10, mostly application and database server running 24×7 to support production. We have own development team to enhance our applications regarding the user needs. And sometime our development team needs to refresh development server with current data and applications from production server. But we don’t have enough time to cloning applications and database if we have to shut it down first. To solve this problem, we have a solution to “On-line” cloning application and database from production into development. Some of these steps can be found on Note: 230672.1. Continue reading »

© 2012 LevICORP's webnote Suffusion theme by Sayontan Sinha