OraFAQ Forum: Backup & Recovery » What do you do with NOARCHIVE DB?

Home » RDBMS Server » Backup & Recovery » What do you do with NOARCHIVE DB?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

What do you do with NOARCHIVE DB? [message #290912]

Wed, 02 January 2008 02:46

trantuananh24hg
Messages: 744
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!

Report message to a moderator

Re: What do you do with NOARCHIVE DB? [message #290924 is a reply to message #290912]

Wed, 02 January 2008 03:32

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: What do you do with NOARCHIVE DB? [message #290930 is a reply to message #290924]

Wed, 02 January 2008 03:47

trantuananh24hg
Messages: 744
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

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: What do you do with NOARCHIVE DB? [message #291628 is a reply to message #290912]

Sat, 05 January 2008 09:35

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.

Report message to a moderator

Previous Topic:	RMAN error
Next Topic:	datafile offline drop

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 11:29:14 CST 2024