Hi everyone, I want to back up my database using log files. 1. Is it possible to backup database using rsync? 2. Can it copy redo log file which are open? 3. It has any special feature to handle redo log files of database while copying? Urgent help needed..... regards Harish Naik
I wish it could... rsync-bounces+cyrille.bollu=fedasil.be@lists.samba.org a ?crit sur 29/11/2005 06:11:00 :> Hi everyone, > > I want to back up my database using log files. > > 1. Is it possible to backup database using rsync? > 2. Can it copy redo log file which are open? > 3. It has any special feature to handle redo log files of database while > copying? > > Urgent help needed..... > > regards > Harish Naik > > -- > To unsubscribe or change options: https://lists.samba. > org/mailman/listinfo/rsync > Before posting, read: http://www.catb.org/~esr/faqs/smart-questions.html-------------- next part -------------- HTML attachment scrubbed and removed
> I want to back up my database using log files. > > 1. Is it possible to backup database using rsync?Sure. In Windows I perform a series of NET STOP <service> commands prior to issuing a Rsync command. This stops the database and allows me to back up its files. Then afterwards I simply reverse the stop commands with NET START Works for me. You can do a similar thing in any OS you may be using.> 2. Can it copy redo log file which are open?Rsync can't copy open files. So you need to temporary stop the service that keeps the file open. Not difficult.> 3. It has any special feature to handle redo log files of database > while copying?What do you mean by 'handle'? And why would it be special? If you can't stop the services then you'll need to find a Copy program that does 'shadow copy' of open files. Assuming you're running Windows. I don't know what term Unix, Linux or Macs use. But you're talking about having to spend money. Look up 'Shadow copy' on Google. -- Stuart Halliday ECS Technology ltd Registered in Scotland - #212513
Harish wrote:> Hi everyone, > > I want to back up my database using log files. > > 1. Is it possible to backup database using rsync? > 2. Can it copy redo log file which are open? > 3. It has any special feature to handle redo log files of database while > copying?If you are talking about for instance, an Oracle database, you have options for backing up either cold or hot. If the database is shut down, you don't have to do anything special. If it is open, then you will need to put a tablespace into hot backup mode before you start copying it, then take it out of hot backup mode when it is done. If you don't have any experience with this, then it is probably a good idea to talk with a DBA that has done it before, or it might take a lot of experimentation to get it right. Linus