| online backup [message #224971] |
Fri, 16 March 2007 03:54  |
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 #224976 is a reply to message #224973] |
Fri, 16 March 2007 04:20  |
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 #224985 is a reply to message #224980] |
Fri, 16 March 2007 06:37 |
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 #225097 is a reply to message #224985] |
Sat, 17 March 2007 07:06 |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
