Home » RDBMS Server » Backup & Recovery » losting redo log files
losting redo log files [message #206990] Sun, 03 December 2006 02:22 Go to next message
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
Re: losting redo log files [message #206995 is a reply to message #206990] Sun, 03 December 2006 06:46 Go to previous messageGo to next message
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
Re: losting redo log files [message #206996 is a reply to message #206990] Sun, 03 December 2006 06:58 Go to previous message
Mahesh Rajendran
Messages: 10672
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.
Previous Topic: Please vote- 1z0-032 question
Next Topic: Using RMAN, first and foremost, how?
Goto Forum:
  


Current Time: Mon Dec 05 23:50:40 CST 2016

Total time taken to generate the page: 0.05653 seconds