hot backup confusion??
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: hot backup confusion??

  1. #1
    Join Date
    Jan 2001
    Posts
    157
    I have 2 AIX boxes. Everything is almost the same on on both boxes.
    The only difference is that one contains the production
    database and the other contains QA database. The one that
    contains the production box has 5 CPU's and the QA Box
    has 2 CPU's

    I have been using hot backup for the production database for the past 1 year.
    Yesterday, I decided to do hot backups in the QA database but I had problems.
    The same host copy syntax that I use in production for the hot backup does
    not work in QA

    BELOW IS WHAT HAPPENED

    IN THE PRODUCTION ENVIRONMENT
    =============================

    #1. SQL> select file_name, tablespace_name from dba_data_files where tablespace_name in ('SYSTEM');

    FILE_NAME TABLESPACE_NAME
    ------------------------------------------------- ----------------
    /PRDU1/oraPRD1/PRDDATA/system_PRDDATA01.dbf SYSTEM

    #2. SQL> alter tablespace system begin backup;

    Tablespace altered.

    SQL> host copy /PRDU1/oraPRD1/PRDDATA/system_PRDDATA01.dbf SYSTEM /PRDBACUP

    SQL> alter tablespace system end backup;

    Tablespace altered.



    FROM THE QA ENVIRONMENT
    =======================

    #1. SQL> select file_name, tablespace_name from dba_data_files where tablespace_name in ('SYSTEM');

    FILE_NAME TABLESPACE_NAME
    ---------------------------------------- ---------------
    /QAU1/oraQA1/QADATA/system_QADATA01.dbf SYSTEM

    #2. SQL> alter tablespace system begin backup;

    Tablespace altered.

    SQL> host copy /QAU1/oraQA1/QADATA/system_QADATA01.dbf /QAU1/testing
    /usr/bin/ksh: copy: not found.

    NOTE: Amazingly in QA when I changed the host copy command to host cp (based on the advice from the board), the hot backup worked


    #1. SQL> select file_name, tablespace_name from dba_data_files where tablespace_name in ('SYSTEM');

    FILE_NAME TABLESPACE_NAME
    ------------------------------------------------- ------------------------------
    /QAU1/oraQA1/QADATA/system_QADATA01.dbf SYSTEM

    #2. SQL> alter tablespace system begin backup;

    Tablespace altered.

    SQL> host cp /QAU1/oraQA1/QADATA/system_QADATA01.dbf /QAU1/testing

    SQL> alter tablespace system end backup;

    Tablespace altered.

    NOTE:

    O/S is IBM AIX
    DB is ORACLE 8.1.7.0.0

    CAN anyone explain?

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    On your production box, type:
    which copy

    My guess is that copy is an alias or a soft link to cp.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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