Help needed in setting up Auxiliary database in RMAN
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Help needed in setting up Auxiliary database in RMAN

  1. #1
    Join Date
    May 2001
    Posts
    17

    Thumbs up

    Iam trying to setup an Auxiliary database for my RMAN. Iam enclosing the command iam running and the Error message generated. Any ideas.....Please ?????????????

    ------------------------------------------------------------------------
    run {
    allocate auxiliary channel newdb1 type disk;
    allocate auxiliary channel newdb2 type disk;
    allocate auxiliary channel newdb3 type disk;
    allocate auxiliary channel newdb4 type disk;
    set newname for datafile 1 TO 'd:\oracle\oradata\dup\SYSTEM01.dbf';
    set newname for datafile 2 TO 'd:\oracle\oradata\dup\RBS01.dbf';
    set newname for datafile 3 TO 'd:\oracle\oradata\dup\USERS01.dbf';
    set newname for datafile 4 TO 'd:\oracle\oradata\dup\TEMP01.dbf';
    set newname for datafile 5 TO 'd:\oracle\oradata\dup\TOOLS01.dbf';
    set newname for datafile 6 TO 'd:\oracle\oradata\dup\INDX01.dbf';
    set newname for datafile 7 TO 'd:\oracle\oradata\dup\DR01.dbf';
    set newname for datafile 8 TO 'd:\oracle\oradata\dup\CATTBS.dbf';
    duplicate target database to dup LOGFILE
    GROUP 1 ('D:\ORACLE\ORADATA\DUP\REDO03.LOG') SIZE 200k REUSE,
    GROUP 2 ('D:\ORACLE\ORADATA\DUP\REDO02.LOG') SIZE 200k REUSE,
    GROUP 3 ('D:\ORACLE\ORADATA\DUP\REDO01.LOG') SIZE 200k REUSE;
    }

    ------------------------------------------------------------------------

    Iam getting the following error message...Any ideas ???
    ------------------------------------------------------------------------

    RMAN-03022: compiling command: sql
    RMAN-06162: sql statement: CREATE CONTROLFILE REUSE SET DATABASE "dup" RESETLOGS ARCHIVELOG MAXLOGFILES 32 MAXLOGMEMBERS 2 MAXDATAFILES 32 MAXINSTANCES 16 MAXLOGHISTORY 1815 LOGFILE GROUP 1 ( ''D:\ORACLE\ORADATA\DUP\REDO03.LOG'' ) SIZE 204800 REUSE, GROUP 2 ( ''D:\ORACLE\ORADATA\DUP\REDO02.LOG'' ) SIZE 204800 REUSE, GROUP 3 ( ''D:\ORACLE\ORADATA\DUP\REDO01.LOG'' ) SIZE 204800 REUSE DATAFILE ''D:\ORACLE\ORADATA\DUP\SYSTEM01.DBF'' CHARACTER SET WE8ISO8859P1
    RMAN-03023: executing command: sql
    RMAN-03026: error recovery releasing channel resources
    RMAN-08031: released channel: newdb1
    RMAN-08031: released channel: newdb2
    RMAN-08031: released channel: newdb3
    RMAN-08031: released channel: newdb4
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure during compilation of command
    RMAN-03013: command type: Duplicate Db
    RMAN-03015: error occurred in stored script Memory Script
    RMAN-03006: non-retryable error occurred during execution of command: sql
    RMAN-07004: unhandled exception during command execution on channel clone_default
    RMAN-20000: abnormal termination of job step
    RMAN-11003: failure during parse/execution of SQL statement: CREATE CONTROLFILE REUSE SET DATABASE "dup" RESETLOGS ARCHIVELOG MAXLOGFILES 32 MAXLOGMEMBERS 2 MAXDATAFILES 32 MAXINSTANCES 16 MAXLOGHISTORY 1815 LOGFILE GROUP 1 ( 'D:\ORACLE\ORADATA\DUP\REDO03.LOG' ) SIZE 204800 REUSE, GROUP 2 ( 'D:\ORACLE\ORADATA\DUP\REDO02.LOG' ) SIZE 204800 REUSE, GROUP 3 ( 'D:\ORACLE\ORADATA\DUP\REDO01.LOG' ) SIZE 204800 REUSE DATAFILE 'D:\ORACLE\ORADATA\DUP\SYSTEM01.DBF' CHARACTER SET WE8ISO8859P1
    RMAN-11001: Oracle Error: ORA-01503: CREATE CONTROLFILE failed
    ORA-01160: file is not a data file
    ORA-01110: data file : 'D:\ORACLE\ORADATA\DUP\SYSTEM01.DBF'

    Recovery Manager complete.

    ------------------------------------------------------------------------



  2. #2
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Hi..What is your requirement for the auxilary database? Is it for catalog?
    Thanks
    Thomas

  3. #3
    Join Date
    May 2001
    Posts
    17

    Thumbs up Help needed in setting up Auxiliary database in RMAN

    Yes...Iam setting up a recovery catalog and the Auxiliary DB is meant for recovering tablespaces in an Archivelog files...Is there an alternative to what Iam doing????

  4. #4
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727

    Creating Catalog for RMAN

    Hi..

    Database 1 = Database to be backed up
    Database 2 = Catalog Database. ( Newly created database)


    1. First create a new database in any system which is in the network where you are going to deposit your catalog.

    2. Create a new tablespace in the new database RMAN_TS

    CREATE TABLESPACE RMAN_TS DATFILE SIZE 30M AUTOEXTENT ON;

    3. Create a user RMAN.

    CREATE USER RMAN IDENTIFIED BY DEFAULT TABLESPACE RMAN_TS TEMPORARY TABLESPACE ;

    4. GRANT DBA TO RMAN;

    5. GRANT RECOVERY_CATALOG_OWNER TO RMAN;


    Start the Rman in the new database:
    C:\Rman

    rman> connect catalog rman/

    Rman> CREATE CATALOG

    The catalog tables will be created in the new database.

    Exit RMAN



    Go to the Database 1.
    1. Create a Net8 connection to the catalog databse (Database 2 ) say RMAN_CS.

    2. Start the database 1
    3. Start RMAN in Databse 1 system

    4. Rman> CONNECT TARGET INTERNAL/ - Connecting to the databse 1


    5. Rman> CONNECT CATALOG RMAN/ @RAMN_CS - Connecting to the Catalog Database.

    6. Rman> REGISTER DATABASE - Registering the database in the catalog.


    7. Create the RMAN Backup

    RUN {
    allocate channel ch1 type disk;
    backup database;
    release channel ch1;}

    Or you can use more advansed commands...

    8. Then use the command RESYNC CATALOG to sync. the catalog and the control file.


    Hope this will serve you..

    Thanks
    Thomas P S
    royxavier@yahoo.com





  5. #5
    Join Date
    May 2001
    Posts
    17

    How to do a TSPITR in RMAN

    Thanks Thomas,

    I followed your instructions...now how do I do a point-in-time tablespace recover thru' RMAN...could you help me with the script, as the oracle documentation is very vague on that...

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