Error on Alter database begin backup

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

    alter database begin backup;

    only available on oracle 10g

    please use

    alter tablespace begin backup

    for 9i
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    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 34

    Accepted Solution

    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.
    LVL 2

    Author Comment


    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 34

    Expert Comment

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

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Able to SELECT but not DELETE 4 37
    Formatting varchar to numeric 8 58
    oracle 10G 5 37
    Export BLOB data from Oracle 10g 4 9
    Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
    From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

    745 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now