OraFAQ Forum: Backup & Recovery » UserManaged HOT Backup

Home » RDBMS Server » Backup & Recovery » UserManaged HOT Backup (9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

UserManaged HOT Backup [message #325764]

Sun, 08 June 2008 08:22

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

Report message to a moderator

Re: UserManaged HOT Backup [message #325766 is a reply to message #325764]

Sun, 08 June 2008 08:50

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

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.

Report message to a moderator

Re: UserManaged HOT Backup [message #325780 is a reply to message #325777]

Sun, 08 June 2008 12:16

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

Report message to a moderator

Re: UserManaged HOT Backup [message #325784 is a reply to message #325780]

Sun, 08 June 2008 12:35

ebrian
Messages: 2794
Registered: April 2006

Senior Member

That is correct.

Report message to a moderator

Previous Topic:	Backup strategy
Next Topic:	Why to use indexfile option in IMPORT/EXPORT

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 12 06:15:21 CDT 2024