Home » RDBMS Server » Backup & Recovery » UserManaged HOT Backup (9i)
UserManaged HOT Backup [message #325764] Sun, 08 June 2008 08:22 Go to next message
samira_kk
Messages: 2
Registered: June 2008
Junior Member
Dear Friends,
When I was trying to do hot backup using user managed teq.
by following the steps as per the below link

http://amjadalidba.blogspot.com/2008/06/user-managed-backups.html

I got the error...
My database is open and in archive log mode...

SQL>alter database begin backup;
ORA-00905 : missing keyword..
please can some one explain the problem
Thanks and Regards...
Re: UserManaged HOT Backup [message #325766 is a reply to message #325764] Sun, 08 June 2008 08:50 Go to previous messageGo to next message
oraj.chhetri
Messages: 1
Registered: June 2008
Location: presently earth for some ...
Junior Member
hi
would you please tell which database version you are working on?

i think in 9i "alter database begin backup" is not supported, only from 10g it is there.

correct me if i am wrong!

regards..

oraj

[Updated on: Sun, 08 June 2008 08:51]

Report message to a moderator

Re: UserManaged HOT Backup [message #325777 is a reply to message #325764] Sun, 08 June 2008 11:41 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
oraj is correct, this is a 10g+ feature. For 9i, if you want to do a hot backup without RMAN, then you'll have to place each tablespace into BACKUP mode.
Re: UserManaged HOT Backup [message #325780 is a reply to message #325777] Sun, 08 June 2008 12:16 Go to previous messageGo to next message
samira_kk
Messages: 2
Registered: June 2008
Junior Member
Great, Thanks
What I have understood is we can do whole backup using usermanaged is through in 10g and not in 9i and if I have to do whole backup in 9i using user managed than I have to put all the tablespace individually....am i Correct...
Thanks a Lot... correct me If I am wrong.....
Re: UserManaged HOT Backup [message #325784 is a reply to message #325780] Sun, 08 June 2008 12:35 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
That is correct.
Previous Topic: Backup strategy
Next Topic: Why to use indexfile option in IMPORT/EXPORT
Goto Forum:
  


Current Time: Sat Dec 10 03:29:58 CST 2016

Total time taken to generate the page: 0.16520 seconds