Results 1 to 5 of 5

Thread: Problems with Recovery Manager (RAMN) configuration

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

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

  3. #3
    Join Date
    May 2008
    Posts
    2,012

    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 .

  4. #4
    Join Date
    Apr 2008
    Posts
    2,005

    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;

  5. #5
    Join Date
    May 2008
    Posts
    2,297

    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;

Similar Threads

  1. Disable Microsoft wireless configuration manager
    By Tamas in forum Networking & Security
    Replies: 5
    Last Post: 20-10-2010, 11:53 PM
  2. Problem writing creating recovery disc in Recovery Manager
    By SajalSOFT in forum Windows Software
    Replies: 6
    Last Post: 11-09-2010, 02:24 AM
  3. Replies: 3
    Last Post: 05-05-2009, 03:41 PM
  4. Realtek Audio Configuration Manager Settings
    By Aagman in forum Hardware Peripherals
    Replies: 3
    Last Post: 25-04-2009, 06:17 PM
  5. SQL Server Configuration Manager Snap-in error
    By Aiko in forum Small Business Server
    Replies: 2
    Last Post: 08-02-2007, 09:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,750,344,860.27760 seconds with 16 queries