| BAckup issue [message #297886] |
Mon, 04 February 2008 02:50  |
SRIVASUWIN
Messages: 45
Registered: October 2006
Location: TRICHY
|
Member |
|
|
Dear backup thinkers
I have one critical situation , we have enabled online backup or hot backup in daily basis with archived mode
our archived script is disconnected now we had some crashed issue
we want to recover our database but now we had only hot backup copy but no more archived files
There is any way to recover our database it is possible to recover full database recovery.
-Thanks in avance
|
|
|
|
| Re: BAckup issue [message #297891 is a reply to message #297886] |
Mon, 04 February 2008 03:18  |
mkbhati
Messages: 93
Registered: February 2007
Location: Mumbai
|
Member |
|
|
| Quote: | our archived script is disconnected now
|
Does it means database archiving was stopped/disabled at some point of time after last hot backup. Please furnish more details.
Regards
Manjit Kumar [mkbhati]
|
|
|
|
| Re: BAckup issue [message #298134 is a reply to message #297891] |
Tue, 05 February 2008 02:10 |
SRIVASUWIN
Messages: 45
Registered: October 2006
Location: TRICHY
|
Member |
|
|
Thank you Manjit Kumar [mkbhati]
Actually i need small suggestion wheather the recovery is possible or not in this situation
Only hot backup file is available
No archived files in the server
-Thanx
|
|
|
|
| Re: BAckup issue [message #298250 is a reply to message #297886] |
Tue, 05 February 2008 08:09 |
varu123
Messages: 754
Registered: October 2007
|
Senior Member |
|
|
If there is no archived files available,you could only restore the database and no recovery is possible.
That is to say,you will lose data.
|
|
|
|
| Re: BAckup issue [message #298365 is a reply to message #297886] |
Tue, 05 February 2008 23:15 |
mkbhati
Messages: 93
Registered: February 2007
Location: Mumbai
|
Member |
|
|
| Quote: | Actually i need small suggestion wheather the recovery is possible or not in this situation
|
SRIVASU,
If your situation is just hypothetical only than what ever Varu123 said is correct. But if, you have a real practical situation than you can recover up your last archive log file. Practically there must be some time gap between your last hot backup & disabling of archiving. This time gap will be fully recoverable up to last archive log available.
It appears your situation is just hypothetical only.
Regards
Manjit Kumar
|
|
|
|
| Re: BAckup issue [message #298371 is a reply to message #297886] |
Tue, 05 February 2008 23:32 |
varu123
Messages: 754
Registered: October 2007
|
Senior Member |
|
|
| Quote: | our archived script is disconnected now we had some crashed issue
|
what is that "some" issue?
| Quote: | No archived files in the server
|
When OP is so sure about it,how much recovery could be possible practically?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
