Home » RDBMS Server » Server Administration » Question????? (10g)
Question????? [message #420993] Thu, 03 September 2009 10:33 Go to next message
it_me24
Messages: 167
Registered: March 2006
Location: delhi
Senior Member
Hi All,

I have certain questions, can you please clearify.

1) The backup was started using alter database begin backup at 6pm and alter database end backup at 10pm, but the archives generated in between were deleted at 9:59pm , what will happen with the database, changes made in between 6pm - 9pm, do we loose them, could not test this coz dont have the access to the system.

2) Cold backup was taken for the database having size 15TB which took 30hrs to complete the backup.

Now the 90% of the datafiles of the database are corrupted , is there any way to recover the entire database 6 times less time than the backup time.

3) which background process is responsible for generating awr stats.

Pls put some light on the above questions.
Re: Question????? [message #420994 is a reply to message #420993] Thu, 03 September 2009 10:41 Go to previous messageGo to next message
Michel Cadot
Messages: 63808
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Answer!!!!!

Regards
Michel
Re: Question????? [message #421003 is a reply to message #420993] Thu, 03 September 2009 11:16 Go to previous messageGo to next message
it_me24
Messages: 167
Registered: March 2006
Location: delhi
Senior Member
what was that?
Re: Question????? [message #421004 is a reply to message #420993] Thu, 03 September 2009 11:17 Go to previous messageGo to next message
it_me24
Messages: 167
Registered: March 2006
Location: delhi
Senior Member
Can we please do what we are expected to do on this forum.
Re: Question????? [message #421005 is a reply to message #420993] Thu, 03 September 2009 11:20 Go to previous messageGo to next message
BlackSwan
Messages: 24912
Registered: January 2009
Senior Member
>Can we please do what we are expected to do on this forum.
Who is we?
If you are dissatisfied with any response, you are entitled to a full & complete refund.

Feel free to direct any complaint to /dev/null.
Re: Question????? [message #421007 is a reply to message #420993] Thu, 03 September 2009 11:28 Go to previous messageGo to next message
it_me24
Messages: 167
Registered: March 2006
Location: delhi
Senior Member
IS THIS BEHAVIOUR MAKING YOU FEEL YOU ARE SOMETHING SPECIAL, YOU JUST WASTE YOUR AND OTHERS TIME HERE, YOU COULD NOT SUGEST ANYTHING BETTER, BUT I WOULD DO THAT SURELY, YOU BETTER LOGON TO SOME FUNNY SITES WHERE YOU GUYS CAN POST YOUR REALLY SILLY AND POOR JOKES...

GUD LUCK,

HOPE PEOPLE WILL ENJOY YOUR SILLY JOKES THERE AND WILL ACCOMPANY YOU.
Re: Question????? [message #421011 is a reply to message #421003] Thu, 03 September 2009 11:45 Go to previous messageGo to next message
Michel Cadot
Messages: 63808
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
it_me24 wrote on Thu, 03 September 2009 18:16
what was that?

A reply to stupid title.

Regards
Michel

Re: Question????? [message #421451 is a reply to message #420993] Tue, 08 September 2009 06:44 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Many apologies for the qualities of the replies you've recieved - your best bet is to ignore them.

1) If you deleted the logs files before you backed them up, then the changes are gone. If you've backed up the log files, and have the log file from 9:59 onwards then you should be ok.

2) I'd anticipate restoring the datafiles would take about as long as the backup took.
Previous Topic: Upgrade Oracle client from 10.2.0.1 to 10.2.0.4
Next Topic: De-commission Oracle server
Goto Forum:
  


Current Time: Thu Sep 29 00:30:32 CDT 2016

Total time taken to generate the page: 0.12764 seconds