We help IT Professionals succeed at work.

Error on Alter database begin backup

patmoli
patmoli asked
on
1,560 Views
Last Modified: 2013-12-19
Hi,

I have

Oracle9i Release 9.2.0.7.0 - Production
PL/SQL Release 9.2.0.7.0 - Production
CORE    9.2.0.7.0       Production
TNS for 32-bit Windows: Version 9.2.0.7.0 - Production
NLSRTL Version 9.2.0.7.0 - 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


Bye

Comment
Watch Question

Commented:
alter database begin backup;

only available on oracle 10g

please use

alter tablespace begin backup

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

Commented:
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
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Hi,

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

bye




Mark GeerlingsDatabase Administrator
CERTIFIED EXPERT

Commented:
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.

OR

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.