Home » RDBMS Server » Backup & Recovery » BAckup issue (oracle ,9i,Linux)
BAckup issue [message #297886] Mon, 04 February 2008 02:50 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous message
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?
Previous Topic: Online or Device Back Up?
Next Topic: How to recover from .DAT file
Goto Forum:
  


Current Time: Fri Dec 09 05:41:07 CST 2016

Total time taken to generate the page: 0.11046 seconds