-
backup/recovery senarios
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.
Amar
"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.
steve
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
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???
-
-
if this is what happened, what do we need to do ????
-
-
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
-
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
Dilip Patel
OCP 8i
Catch me online at Yahoo: ddpatel256
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|