Database Backup and Recovery (MOSC)

MOSC Banner

hot backup and recovery with datafiles having previously been resized

edited May 31, 2012 5:22AM in Database Backup and Recovery (MOSC) 1 commentAnswered
I wanted to know what would happen in this scenario of databse recovery:

We have a 11.2.0.1 oracle EBS database that grows rapidly so we resize datafiles for the EBS schema modules weekly.

We normally add 2-3 gb to the ARD & ARD and INVD & INVX datafiles each week and some other smaller datafiles as well.

So, on any given week, we have run the alter database datafile '/u02/oracle/xxxxx/ard02.dbf' resize 15000m; command at least once.

So, my question is, if we run a hot backup on this database rather than a cold backup after having made this physical resize change to the datafiles, and we restore the database using the hot backup, the physical datafile will be restored as the larger resized version, but is that usable physical structure or is the recovery going to complain about it?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center