We help IT Professionals succeed at work.

Error on Alter database begin backup

patmoli asked
Last Modified: 2013-12-19

I have

Oracle9i Release - Production
PL/SQL Release - Production
CORE       Production
TNS for 32-bit Windows: Version - Production
NLSRTL Version - Production

when I use this command I face this error, this command is new in oracle9i/10g
what is missing or problem with Oracle9i Software Release ?

SQL> alter database begin backup;
alter database begin backup
ERROR at line 1:
ORA-00905: missing keyword


Watch Question

alter database begin backup;

only available on oracle 10g

please use

alter tablespace begin backup

for 9i
Guy Hengel [angelIII / a3]Billing Engineer
Most Valuable Expert 2014
Top Expert 2009

no points... just to be complete:

alter tablespace <tablespace name> begin backup;

you will have to put every tablespace individually into (and later out from) backup mode ...
Database Administrator
Unlock this solution and get a sample of our free trial.
(No credit card required)



I know alter tablespace begin backup; command
I have lots of Tablespaces and Datafiles
In this case It take time to use every time that command and then copy datafiles
I found Alter Database Begin Backup;
It work one time copy all datafiles and use Alter Database End Backup;
it save time
and I found this command in Oracle 9i as well
but I need to know which Oracle9i Release or I need to Update any    Patch

then I am able to use this command


Mark GeerlingsDatabase Administrator

I've never seen that command (alter database begin backup) in Oracle9, and it is *NOT* documented in the Oracle9.2 documentation that I have.

It is not difficult to use a *.SQL script to create all of the "alter tablespace..." and "host file copy" commands that you would need.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.