Home » RDBMS Server » Performance Tuning » not able to take online backup
not able to take online backup [message #50031] Sun, 24 February 2002 23:25 Go to next message
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.
Re: not able to take online backup [message #50040 is a reply to message #50031] Mon, 25 February 2002 06:37 Go to previous message
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


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
Previous Topic: Order of tables in the query..
Next Topic: performace tunning/backup &recovery
Goto Forum:

Current Time: Wed Jun 19 12:57:38 CDT 2024