standby - Page 3
DBAsupport.com Forums - Powered by vBulletin
Page 3 of 6 FirstFirst 12345 ... LastLast
Results 21 to 30 of 55

Thread: standby

  1. #21
    Join Date
    Jan 2007
    Posts
    231
    Hi Rey, I used as

    SQL> alter database create datafile '/mnt/db/oracle/oradata/ISDB/isdata11.dbf'
    2 as '/mnt/db/oracle/oradata/ISDB/ishdata10.dbf';
    alter database create datafile '/mnt/db/oracle/oradata/ISDB/isdata11.dbf'
    *
    ERROR at line 1:
    ORA-01516: nonexistent log file, datafile, or tempfile
    "/mnt/db/oracle/oradata/ISDB/isdata11.dbf"

    I have checked status in v$datafile and rechecked the path everything is correct.What to do further?

  2. #22
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    you need to copy the file from prod, before executing the sql.
    ---------------

  3. #23
    Join Date
    Jan 2007
    Posts
    231
    I did as you said(copied from prod to stdby),but same err.


    SQL> alter database create datafile '/mnt/db/oracle/oradata/ISDB/isdata11.dbf'
    2 as '/mnt/db/oracle/oradata/ISDB/ishdata10.dbf';
    alter database create datafile '/mnt/db/oracle/oradata/ISDB/isdata11.dbf'
    *
    ERROR at line 1:
    ORA-01516: nonexistent log file, datafile, or tempfile
    "/mnt/db/oracle/oradata/ISDB/isdata11.dbf"

  4. #24
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    TRY TO DOUBLECHECK the filename:
    alter database create datafile '/mnt/db/oracle/oradata/ISDB/isdata11.dbf'
    as '/mnt/db/oracle/oradata/ISDB/ishdata10.dbf';
    ---------------

  5. #25
    Join Date
    Oct 2006
    Location
    Mumbai
    Posts
    184
    I guess check parameter standby_file_management parameter in init/spfile of standby instance.

    When you set the STANDBY_FILE_MANAGEMENT initialization parameter to AUTO, use of the following SQL statements is not allowed:
    ALTER DATABASE RENAME
    ALTER DATABASE ADD/DROP LOGFILE
    ALTER DATABASE ADD/DROP STANDBY LOGFILE MEMBER
    ALTER DATABASE CREATE DATAFILE AS

    SO, if it is AUTO, change it MANUAL and then retry the command.

    Thanks

  6. #26
    Join Date
    Jan 2007
    Posts
    231
    Yes..,File management is set in AUTO mode.
    So,I will change in pfile,then i will use this command.

  7. #27
    Join Date
    Jan 2007
    Posts
    231
    rey.. i have corrected my mistake but results in same err.

    alter database create datafile '/mnt/db/oracle/oradata/ISDB/isdata11.dbf'
    as '/mnt/db/oracle/oradata/ISDB/isdata10.dbf'
    alter database create datafile '/mnt/db/oracle/oradata/ISDB/isdata11.dbf'
    *
    ERROR at line 1:
    ORA-01516: nonexistent log file, datafile, or tempfile
    "/mnt/db/oracle/oradata/ISDB/isdata11.dbf"

    then used
    alter system set standby_file_management='manual'
    then
    show parameter standby
    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    standby_archive_dest string /mnt/backup/arch
    standby_file_management string manual

    then i did the above process...
    but same error.

  8. #28
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    Do me a favour:

    $ cd /mnt/db/oracle/oradata/ISDB

    $ ls -ltr isdata11.dbf
    Assistance is Futile...

  9. #29
    Join Date
    Oct 2006
    Location
    Mumbai
    Posts
    184
    Quote Originally Posted by waitecj
    Do me a favour:

    $ cd /mnt/db/oracle/oradata/ISDB

    $ ls -ltr isdata11.dbf
    I bet its not there, that is what the error states ...

  10. #30
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    Quote Originally Posted by pareshjavkar
    I bet its not there, that is what the error states ...
    Indeed.
    Assistance is Futile...

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