Error on Alter database begin backup

Posted on 2007-10-10
Medium Priority
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


Question by:patmoli
LVL 18

Expert Comment

ID: 20053628
alter database begin backup;

only available on oracle 10g

please use

alter tablespace begin backup

for 9i
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 20054414
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 ...
LVL 35

Accepted Solution

Mark Geerlings earned 150 total points
ID: 20056681
Yes, angelIII is correct, you must use "alter tablespace..." and include the tablespace name, if you do your backups this way.

You do have two other options though for doing hot backups of Oracle9 databases on Windows that do not require you to put the tablespaces into "backup mode" manually first::
1. Use RMAN
2. Use Oracle's "ocopy" (instead of the standard Windows "copy" or "xcopy") command in a batch file to copy the datafiles to an alternate disk or directory.

And, you can use export an another way to backup the database.  This also does not require "backup mode".  An export though is not a substitute for a backup, it is a different type of backup that offers different advantages and disadvantages.  I recommend that you do both some type of backup plus a complete export regularly.

Author Comment

ID: 20061698

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


LVL 35

Expert Comment

by:Mark Geerlings
ID: 20066916
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.

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses
Course of the Month15 days, 16 hours left to enroll

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question