Home » RDBMS Server » Backup & Recovery » What do you do with NOARCHIVE DB?
What do you do with NOARCHIVE DB? [message #290912] Wed, 02 January 2008 02:46 Go to next message
trantuananh24hg
Messages: 668
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Hi all!

I have one DB which is not in ARCHIVELOG mode, because of its nature operation. I often backup it with recovery window of 7 days strategy with RMAN. However, it's not a safely backing up method, and I have not though about the other backup till now.

Would you like to give me some advice?

OS: HP-UX(PARISC) BE 11
DB: Oracle 10.2.0.2
Destination of backup file: Disk

Thank you!
Re: What do you do with NOARCHIVE DB? [message #290924 is a reply to message #290912] Wed, 02 January 2008 03:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you are in NOARCHIVELOG mode, the only available backup is offline one.
I don't know what you mean with "it's not a safely backing up method".

Regards
Michel
Re: What do you do with NOARCHIVE DB? [message #290930 is a reply to message #290924] Wed, 02 January 2008 03:47 Go to previous messageGo to next message
trantuananh24hg
Messages: 668
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Assuming I have got just one backup at Wednesday last week, but, at today - Tuesday, my Database hangs by media disaster or any reason. I think, data will be lost from the Wednesday to today.

Thank you, Michel!

[Updated on: Wed, 02 January 2008 03:48]

Report message to a moderator

Re: What do you do with NOARCHIVE DB? [message #290942 is a reply to message #290930] Wed, 02 January 2008 04:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

I think, data will be lost from the Wednesday to today.

Yes, this is what you chose to assume when you chose NOARCHIVELOG mode.

Regards
Michel
Re: What do you do with NOARCHIVE DB? [message #291628 is a reply to message #290912] Sat, 05 January 2008 09:35 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

>because of its nature operation.
you can daily export application user for better safety.
export / import is not backup method. but as you said you can operate your database in archivelog mode and not able to take offline backup daily then you use export option with offine backcup.
Previous Topic: RMAN error
Next Topic: datafile offline drop
Goto Forum:
  


Current Time: Sat Dec 10 14:32:52 CST 2016

Total time taken to generate the page: 0.04078 seconds