let's say the database was shutdown for cold backup and unfortunately the database was scheduled to startup while the datafiles are still being copied. What would happen to the database????
The pertinent question is this: how valid are the copies of files you made? Database startup, some SCN's get tossed around, some job starts that deletes data, what good are the already-copied files?
Last edited by adewri; 06-04-2003 at 12:15 PM.
"There is a difference between knowing the path and walking the path."
open files that get copied are marked as fuzzy by oracle and cannot be used for recovery.
I'm stmontgo and I approve of this message
by any mean I just tried this out and here what I get:
I open the database while the datafiles being copied and below is what I got:
SQL> startup pfile=c:\oracle\admin\mytest\pfile\initmytest.ora
ORACLE instance started.
Total System Global Area 58906652 bytes
Fixed Size 75804 bytes
Variable Size 32538624 bytes
Database Buffers 26214400 bytes
Redo Buffers 77824 bytes
ORA-01113: file 4 needs media recovery
ORA-01110: data file 4: 'C:\ORADATA\MYTEST\DATA_TS_01.DBF'
any comments or advise???
if this is what happened, what do we need to do ????
With "Recover Database" command, Oracle will try to find the Information needed to syncronize the database in the RedoLog Files, if the info is not available in Redolog, it will ask the Archive_files if your database in Archive Log Mode....
The database was closed (Hopefully clean shutdown ), so There is no problem with database, only your Backup will not be consistent. And there is no problem of fuzzy status of datafile, as it was cold backup.
Just do cold backup once again (by taking database shutdown), so your backup is proper.
Catch me online at Yahoo: ddpatel256
Click Here to Expand Forum to Full Width