Home » RDBMS Server » Backup & Recovery » Is it necessary to back up the whole database when moving a datafile (11.2.0.1)
Is it necessary to back up the whole database when moving a datafile [message #649336] Tue, 22 March 2016 17:56 Go to next message
juniordbanewbie
Messages: 250
Registered: April 2014
Senior Member
Dear all,

from https://docs.oracle.com/cd/E11882_01/server.112/e25494/dfiles.htm#ADMIN11431

Quote:


Procedure for Renaming Data Files in a Single Tablespace
.....
Back up the database. After making any structural changes to a database, always perform an immediate and complete backup.



as I've a 1.3 TB of database, the backup for the database is going to take about 6 and half hours, is it okay to backup just the tablespace involved.

if taking a backup of the database is required, then I presumed I should move the datafile just before a full backup is scheduled. right?
btw can it be a incremental level 1 database backup?

thanks a lot!
Re: Is it necessary to back up the whole database when moving a datafile [message #649337 is a reply to message #649336] Tue, 22 March 2016 18:04 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
What exactly is the reason for renaming data files for a single tablespace?

no backup is ever required.

It is your database & you are free to be as cavalier as you deem appropriate

>is it okay to backup just the tablespace involved.
assuming you only backup the the tablespace involved, what can you recover should the disk array melt down immediately after the rename completes?

Re: Is it necessary to back up the whole database when moving a datafile [message #649338 is a reply to message #649337] Tue, 22 March 2016 18:45 Go to previous messageGo to next message
juniordbanewbie
Messages: 250
Registered: April 2014
Senior Member
[oracle@berlin-db ~]$ df -h
Filesystem                         Size  Used Avail Use% Mounted on
/dev/mapper/rhel_berlin--db-root   22G   14G  8.2G  63% /
devtmpfs                            16G     0   16G   0% /dev
tmpfs                               16G  6.5G  9.3G  41% /dev/shm
tmpfs                               16G   65M   16G   1% /run
tmpfs                               16G     0   16G   0% /sys/fs/cgroup
/dev/sdg                           355G   90G  247G  27% /u05
/dev/sdb                           355G  303G   34G  90% /u04
/dev/sdf                           355G  310G   27G  93% /u03
/dev/sde                           355G  304G   33G  91% /u02
/dev/sdd                           355G  332G  4.3G  99% /u01
/dev/sdh                           837G  483G  312G  61% /import2
/dev/sdc                          1008G  4.1G  953G   1% /import
/dev/sda1                          497M  120M  378M  24% /boot
/dev/sdi1                          4.0T  415G  3.6T  11% /u06




I need to do an out of place upgrade and obviously there's no more space in /u01 that's why I need to move one datafile out to another location where there's more free space

>is it okay to backup just the tablespace involved.
assuming you only backup the the tablespace involved, what can you recover should the disk array melt down immediately after the rename completes?
=>I cannot recover anything since it's a hardware issue and we have to install server with new hardware first before even beginning recovery operation.


no backup is ever required.

It is your database & you are free to be as cavalier as you deem appropriate

so why is database documentation is saying

Quote:

Back up the database. After making any structural changes to a database, always perform an immediate and complete backup.



of course I believe we should do a controlfile trace backup before and after the renaming operation.

thanks a lot!
Re: Is it necessary to back up the whole database when moving a datafile [message #649342 is a reply to message #649336] Wed, 23 March 2016 02:01 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
I see no reason for an additional backup at that point. All previous backups are still valid after renaming a datafile.
Previous Topic: ORA-01152: file 1 was not restored from a sufficiently old backup
Next Topic: why we need redo log files when transaction is commited
Goto Forum:
  


Current Time: Thu Mar 28 08:27:24 CDT 2024