OraFAQ Forum: Backup & Recovery » losting redo log files

Home » RDBMS Server » Backup & Recovery » losting redo log files

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

losting redo log files [message #206990]

Sun, 03 December 2006 02:22

khosravi
Messages: 68
Registered: April 2006

Member

hello
please guide me

how i can backup database redo log files (NO Archived Redo Log Files)?
if i lost redo log files what i must do?

thanks

Report message to a moderator

Re: losting redo log files [message #206995 is a reply to message #206990]

Sun, 03 December 2006 06:46

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi i think you meaning is when you lost ur redo log files in no archive log mode how can recovery database >without backup of ur redo log files.

then used

recover database until cancel;and
alter database open resetlogs;

hope this helps
Taj

Report message to a moderator

Re: losting redo log files [message #206996 is a reply to message #206990]

Sun, 03 December 2006 06:58

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>> how i can backup database redo log files
You do not need to.
Redologs are not supposed to be backed up with any hotbackup strategy.
If you are doing a cold backup / want to copy the database with cold backup, then you backup the redolog.

Report message to a moderator

Previous Topic:	Please vote- 1z0-032 question
Next Topic:	Using RMAN, first and foremost, how?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 02 19:28:30 CDT 2024