Re: Can datafile be resized while instance is open?
From: Dean <dh6864_at_gmail.com>
Date: Mon, 25 Apr 2011 14:48:50 -0700 (PDT)
Message-ID: <f062bb95-4d88-4664-a7fa-a2c72e1fce5c_at_e25g2000prf.googlegroups.com>
On Apr 15, 4:30 pm, John Hurley <hurleyjo..._at_yahoo.com> wrote:
> Dean:
>
> # Hi, I am a newbie administrator.
>
> Hey Dean I am an old grumpy DBA.
>
> Sure you can "probably" safely grow and resize datafiles while the
> database is up especially with more recent versions of Oracle.
>
> # If not, what would be the proper procedures to take before executing
> the alter sqls?
>
> Do you have backups in place? Do you have a tried and proven recovery
> strategy?
>
> While you are learning and trying things first point is to do your
> learning and experimenting on a test system.
Date: Mon, 25 Apr 2011 14:48:50 -0700 (PDT)
Message-ID: <f062bb95-4d88-4664-a7fa-a2c72e1fce5c_at_e25g2000prf.googlegroups.com>
On Apr 15, 4:30 pm, John Hurley <hurleyjo..._at_yahoo.com> wrote:
> Dean:
>
> # Hi, I am a newbie administrator.
>
> Hey Dean I am an old grumpy DBA.
>
> Sure you can "probably" safely grow and resize datafiles while the
> database is up especially with more recent versions of Oracle.
>
> # If not, what would be the proper procedures to take before executing
> the alter sqls?
>
> Do you have backups in place? Do you have a tried and proven recovery
> strategy?
>
> While you are learning and trying things first point is to do your
> learning and experimenting on a test system.
Thanks John for the advices.
I had tried to resize datafile on a test instance before I posted the
question.
It seemed to work fine to me because there was no error.
But as a newbie, I was just too nervous to conclude it works
Because I didn't know how to verify it thoroughly and have the
confidence to say it works.
Dean
Received on Mon Apr 25 2011 - 16:48:50 CDT