Home » RDBMS Server » Backup & Recovery » media recovery not enabled (11 g on solaris 10)
media recovery not enabled [message #424233] Thu, 01 October 2009 00:20 Go to next message
janakors
Messages: 232
Registered: September 2009
Senior Member
hi

i am trying to take tablespace hot backup in test enviornment but when i issue the command SLTER TABLESPACE MYTBSP BEGIN BACKUP; i goT the following error

can't backup.Media recovery not enabled


someone can advice please.

regards


janakors
Re: media recovery not enabled [message #424236 is a reply to message #424233] Thu, 01 October 2009 00:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-01123: "cannot start online backup; media recovery not enabled"
 *Cause: An attempt to start backup of an on-line tablespace failed because
          media recovery is not enabled.
 *Action: Enable media recovery and retry this operation.

You are in NOARCHIVELOG mode, you can't make a media recovery.

Database Concepts
Chapter 15 Backup and Recovery
Section Overview of Media Recovery

Regards
Michel
Re: media recovery not enabled [message #424392 is a reply to message #424236] Fri, 02 October 2009 01:25 Go to previous message
janakors
Messages: 232
Registered: September 2009
Senior Member
thank you sir. i got it
it worked
Previous Topic: Database recovery failure
Next Topic: ora-01110: data file 10
Goto Forum:
  


Current Time: Fri Mar 29 06:45:28 CDT 2024