backup/recovery senarios

[mike2000]

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????

[stecal]

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?

[adewri]

Nothing to the database.

[stmontgo]

open files that get copied are marked as fuzzy by oracle and cannot be used for recovery.

steve

[mike2000]

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
Database mounted.
ORA-01113: file 4 needs media recovery
ORA-01110: data file 4: 'C:\ORADATA\MYTEST\DATA_TS_01.DBF'


any comments or advise???

[stecal]

Yeah, don't do that.

[mike2000]

if this is what happened, what do we need to do ????

[marist89]

recover your database.

[jeram2001]

Yeah...

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....

TIA
Jeram
Oracle DBA

[Dilippatel]

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.

Cheers