not able to take online backup [message #50031] |
Sun, 24 February 2002 23:25 |
B.SUNIL KUMAR RAO
Messages: 5 Registered: February 2002
|
Junior Member |
|
|
when I am trying to put the tablespace in backup mode to take online backup it is giving message that media recovery is not enabled.cannot start online backup.
how to enable this media recovery.
I am using oracle 7.3 on SCO open server.
Thanks
Sunil.
|
|
|
Re: not able to take online backup [message #50040 is a reply to message #50031] |
Mon, 25 February 2002 06:37 |
Rajesh Aialavajjala
Messages: 15 Registered: January 2002
|
Junior Member |
|
|
Greetings Sunil !!!
It appears that your Oracle 7.3 server is running in "No Archive Log Mode", otherwise expressed as "Media Recovery Disabled" and more informally as "No Recovery Mode"
Check the Operatng mode of your database by one of the following methods:
SVRMGRL> archive log list
OR
SQL> conn sys/<password>
SQL> select log_mode from v$database;
You'll find that your Db is operting in No Archive Log Mode. Switch to Archive Log Mode by
1) Shutdown the Database using the Immediate (or Normal) option
SVRMGR> shutdown immediate
2) Specify the destination for Archived Log Files in the initialization file (init.ora)and enable automatic archiving
log_archive_dest = /mount_point/SID/Archives
log_archive_start = true (This is commonly commented
by the use of a "#". Remove the "#)
2) Mount the database
SVRMGRL>startup mount
3) Switch mode
SVRMGRL>alter database archivelog;
4) Open database
SVRMGR> alter database open
5> Verify
SVRMGR> archive log list
That's all !! You'll find that online backups can now be performed.
Hope this information helps !!!
Best Wishes,
Rajesh Aialavajjala
|
|
|