Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 02-02-2010
Member
 
Join Date: Jan 2010
Posts: 63
Problems with Recovery Manager (RAMN) configuration

I am currently attending classes for Oracle DBA, and we are currently working with RMAN. I have a question in which my instructor was unable to give me an answer.
When I do a "show all" which shows my configuration settings, I configured according to me and I would like to remove the "dish" statement.

The statements are :

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISH TO '%F'; # default


The second line has "DEVICE TYPE DISH" instead of "DEVICE TYPE DISK". How do I delete the second line?Is there any problem with the RMAN or configuration settings
Reply With Quote
  #2  
Old 02-02-2010
Member
 
Join Date: Apr 2008
Posts: 1,948
Problems with Recovery Manager (RAMN) configuration

RMAN :

RMAN (Recovery Manager) is an command line tool provided by oracle database.
Using this tools,you can take an efficient backup of database and restore without any interruption of operating system.

You need to enter some configuration setting for backup process and whenever you need any backup for recovery operation after any failure of database.Just enter "backup [option]" command with sufficient option and "restore database" for restoration of the file for recovery operation,this command collect the sufficient backup contents and apply when you enter the "Recover database" command for recovery.
Reply With Quote
  #3  
Old 02-02-2010
Member
 
Join Date: May 2008
Posts: 2,008
Accessing Recovery Manager (RAMN)

If you are working with some database and need to access the RMAN (Recovery Manager). To access the RMAN tool,the sysdba privilege need to have.

If you are running with the database and willing to access the RMAN tool,Enter the following guidelines :

1. Exit from the SQL prompt Using "EXIT" command without shutting down the database
2. Enter the "RMAN target /"
3. Now you are ready to use the RMAN tool and configure your storage for backup .
Reply With Quote
  #4  
Old 02-02-2010
Member
 
Join Date: Apr 2008
Posts: 2,001
Controlfile backup with Recovery Manager (RAMN)

Change the parameter of configuration setting and provide existing location to store the backup of control file.

Using "RMAN target / " tool, enter into the RMAN .When you will be prompted for "RMAN>" prompt enter the following command to configure the settings of storage for control file.

Code:
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK;
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
Reply With Quote
  #5  
Old 02-02-2010
Member
 
Join Date: May 2008
Posts: 2,293
Problems with Recovery Manager (RAMN) configuration

If you are getting some duplicate line for after investigating the configuration of RMAN for backup of controlfie.

The lines are as follows :

Code:
 CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
     CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISH TO '%F'; # default
The second line of this statement should be deleted from configuration list,Just execute the below statement to delete the second line.

Code:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISH CLEAR;
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Problems with Recovery Manager (RAMN) configuration"
Thread Thread Starter Forum Replies Last Post
Disable Microsoft wireless configuration manager Tamas Networking & Security 5 20-10-2010 11:53 PM
Problem writing creating recovery disc in Recovery Manager SajalSOFT Windows Software 6 11-09-2010 02:24 AM
Problems with setting up CRM 4 Email Configuration Manager Kanan Windows Software 3 05-05-2009 03:41 PM
Realtek Audio Configuration Manager Settings Aagman Hardware Peripherals 3 25-04-2009 06:17 PM
SQL Server Configuration Manager Snap-in error Aiko Small Business Server 2 08-02-2007 09:05 PM


All times are GMT +5.5. The time now is 07:42 PM.