OraFAQ Forum: Backup & Recovery » Is it necessary to back up the whole database when moving a datafile

Home » RDBMS Server » Backup & Recovery » Is it necessary to back up the whole database when moving a datafile (11.2.0.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Is it necessary to back up the whole database when moving a datafile [message #649336]

Tue, 22 March 2016 17:56

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!

Report message to a moderator

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

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?

Report message to a moderator

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

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!

Report message to a moderator

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

John Watson
Messages: 8738
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.

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Aug 18 08:34:25 CDT 2022