Home » RDBMS Server » Backup & Recovery » online backup
online backup [message #224971] Fri, 16 March 2007 03:54 Go to next message
sajut
Messages: 69
Registered: January 2007
Member
Till last week, I was doing offline backup of my database, which involves a downtime of around 45 minutes. I now started trying with online backup, after putting the tablespace in backup mode. Now, my confusion is, when the tablespace was put in backup mode, and users using the database, I found the timestamp of the associated datafiles changing to system time. Is this normal and is it safe for me to take backup of the datafiles of the tablespace when this happens

Oracle 9i R2 Standard Edition, Suse Linux 9.2

Thanks in advance
Re: online backup [message #224973 is a reply to message #224971] Fri, 16 March 2007 04:05 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Yes.
"Alter tablespace begin backup" method is old school.
Start using RMAN.
Re: online backup [message #224976 is a reply to message #224973] Fri, 16 March 2007 04:20 Go to previous messageGo to next message
sajut
Messages: 69
Registered: January 2007
Member
thanks for the reply.
Till the time I get familiar with RMAN, I would like to continue putting tablespaces in backup mode, then copy the datafiles to backup locations and end backup mode for the tablespaces. My doubt was, when a tablespace is put in backup mode, all the transactions happening in the tablespace will be in the online redo files and when the tablespace is released from backup mode, the transactions will be brought backup to datafiles. Am I correct? Then how come the timestamp of datafiles changes.
Re: online backup [message #224980 is a reply to message #224976] Fri, 16 March 2007 06:02 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://www.orafaq.com/forum/m/149622/42800/?srch=Tim+Gorman#msg_149622
Re: online backup [message #224985 is a reply to message #224980] Fri, 16 March 2007 06:37 Go to previous messageGo to next message
sajut
Messages: 69
Registered: January 2007
Member
Thanks Mahesh for the valuable link.
Which means, files backed by hot backups (using alter tablespace xxx begin/end backup) are not foolproof backups??
Re: online backup [message #224991 is a reply to message #224985] Fri, 16 March 2007 07:36 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Almost.
Thats why you need to backup archived logs before and after the hot backup.
Re: online backup [message #225097 is a reply to message #224985] Sat, 17 March 2007 07:06 Go to previous messageGo to next message
SQLAREA
Messages: 21
Registered: January 2006
Location: Belgium
Junior Member
Hi,

In addition ...

1.Before you put the first tablespace in backup mode start with

sql> alter system archive log current;

2.After you bring the last tablespace out of backup mode, after the last alter tablespace tablespace_name end backup, add an additional

sql> alter system archive log current;

3. Finally end with a backup of the current controlfile

sql> alter database backup controlfile to <destination>

Backup your archives and the control file copy as well

Try to become familiar with recovery by doing some tests and take a look in the Backup & Recovery guide.

Regards
Guy
Re: online backup [message #225191 is a reply to message #225097] Mon, 19 March 2007 01:05 Go to previous message
sajut
Messages: 69
Registered: January 2007
Member
Thank you very much for the tips and advice
Saju
Previous Topic: out to set the intialization of UTL_FILE in INIT.ORA in windows
Next Topic: Exp to NFS or remote server
Goto Forum:
  


Current Time: Thu Dec 08 08:27:08 CST 2016

Total time taken to generate the page: 0.11590 seconds