RMAN would'n't work
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: RMAN would'n't work

  1. #1
    Join Date
    Feb 2001
    Posts
    22

    Angry

    I want to try out RMAN feature.

    I created RMAN user and RMAN_TS tablespace in remote database.

    I used RMAN to create catalog. However, I can't perform any action after catalog creation.

    Following error were generated.

    RMAN-03022: compiling command: catalog
    RMAN-03023: executing command: catalog
    RMAN-03026: error recovery releasing channel resources
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-07005: error during channel cleanup
    RMAN-07004: unhandled exception during command execution on channel default
    RMAN-10032: unhandled exception during execution of job step 1:
    RMAN-10031: ORA-65535 occurred during call to DBMS_BACKUP_RESTORE.DEVICESTATUS
    RMAN-03006: non-retryable error occurred during execution of command: catalog
    RMAN-07004: unhandled exception during command execution on channel default
    RMAN-10032: unhandled exception during execution of job step 1:
    RMAN-10031: ORA-65535 occurred during call to DBMS_BACKUP_RESTORE.INSPECTDATAFILECOPY

    I am using Oracle Enterprise 8.1.6 for Linux.

    anyone can help on it ?

    Regards,
    Edward.

  2. #2
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    This is Rohit Nirkhe,Oracle DBA,OCp from India.I will give u all the steps in preparing ur system to use RMAN for backup and recoveries.

    Step 1: Create a tablespace for RMAN data
    create tablespace RMAN_DATA
    add datafile '/disk1/data/rmandata1.dbf' size 60M;

    Step 2: Create a user in ur catalog database.
    create user rman identified by rman
    default tablespace RMAN_DATA
    temporary tablespace TEMP
    quota unlimited on RMAN_DATA;

    Step 3: Grant the rman user sysdba and sysoper role
    grant sysdba,sysoper to rman;
    Also grant him connect,resource roles
    grant connect,resource to rman;

    Step 4: connect as rman and run the catrman script(if using
    Oracle 8)
    catrman.sql - will create dbms_rcvcat and
    dbms_rcvman packages and
    other views and tables

    Step 5: Use the following command to run rman
    rman target="sys/sys@bscs521"
    rcvcat="rman/rman@test521"
    In this case ,bscs database is the target database
    (for whom we have to take the backup)
    test database is the catalog database

    Step 6: If u give the above command,it will display the foll
    BSCS:connected to the target database
    TEST:connected to recovery catalog

    Step 7: Give the following command
    RMAN> register database;
    This command will register ur target database
    information into the recovery catalog.The
    information contains all the
    tablespaces,datafiles etc inf
    coming from the controlfile of the target
    database.

    If u perform all the above steps correctly,u can use RMAN for ur backups and recovery.If u have only one database then u create the recovery catalog in the same database.
    In case of any doubts please be free to write to me at
    rohitsn@hotmail.com

    Regards,
    Rohit Nirkhe,Oracle DBA,OCP









    [QUOTE][i]Originally posted by edwtsang [/i]
    [B]I want to try out RMAN feature.

    I created RMAN user and RMAN_TS tablespace in remote database.

    I used RMAN to create catalog. However, I can't perform any action after catalog creation.

    Following error were generated.

    RMAN-03022: compiling command: catalog
    RMAN-03023: executing command: catalog
    RMAN-03026: error recovery releasing channel resources
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-07005: error during channel cleanup
    RMAN-07004: unhandled exception during command execution on channel default
    RMAN-10032: unhandled exception during execution of job step 1:
    RMAN-10031: ORA-65535 occurred during call to DBMS_BACKUP_RESTORE.DEVICESTATUS
    RMAN-03006: non-retryable error occurred during execution of command: catalog
    RMAN-07004: unhandled exception during command execution on channel default
    RMAN-10032: unhandled exception during execution of job step 1:
    RMAN-10031: ORA-65535 occurred during call to DBMS_BACKUP_RESTORE.INSPECTDATAFILECOPY

    I am using Oracle Enterprise 8.1.6 for Linux.

    anyone can help on it ?

    Regards,
    Edward. [/B][/QUOTE]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width