DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: RMAN Backup Problem.

  1. #1
    Join Date
    Apr 2001
    Posts
    142
    Hello I am trying to create an online backup of a database using RMAN in archivelog mode but I get the following error.

    RMAN> RUN {
    2> ALLOCATE CHANNEL CH1 TYPE DISK;
    3> BACKUP DATABASE;
    4> SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
    5> }

    RMAN-03022: compiling command: allocate
    RMAN-03023: executing command: allocate
    RMAN-08030: allocated channel: CH1
    RMAN-08500: channel CH1: sid=10 devtype=DISK

    RMAN-03022: compiling command: backup
    RMAN-03023: executing command: backup
    RMAN-08008: channel CH1: starting full datafile backupset
    RMAN-08502: set_count=3 set_stamp=432749787 creation_time=18-JUN-01
    RMAN-08010: channel CH1: specifying datafile(s) in backupset
    RMAN-08522: input datafile fno=00007 name=D:\ORACLEDATA\PCS_RT_INDXS.DBF
    RMAN-08522: input datafile fno=00008 name=D:\ORACLEDATA\PCS_RT_DATA.DBF
    RMAN-08522: input datafile fno=00010 name=D:\ORACLEDATA\PCS_CARE_INDXS.DBF
    RMAN-08522: input datafile fno=00009 name=D:\ORACLEDATA\PCS_CARE_DATA.DBF
    RMAN-08522: input datafile fno=00012 name=D:\ORACLEDATA\PCS_COMMON_INDXS.DBF
    RMAN-08522: input datafile fno=00001 name=C:\ORACLE\ORA817\DATABASE\SYSPICIS.ORA
    RMAN-08011: including current controlfile in backupset
    RMAN-08522: input datafile fno=00002 name=C:\ORACLE\ORA817\DATABASE\PCS_TEMP01.DBF
    RMAN-08522: input datafile fno=00011 name=D:\ORACLEDATA\PCS_COMMON_DATA.DBF
    RMAN-08522: input datafile fno=00013 name=D:\ORACLEDATA\PCS_LABS_INDXS.DBF
    RMAN-08522: input datafile fno=00014 name=D:\ORACLEDATA\PCS_LABS_DATA.DBF
    RMAN-08522: input datafile fno=00015 name=D:\ORACLEDATA\PCS_PREOP_DATA.DBF
    RMAN-08522: input datafile fno=00016 name=D:\ORACLEDATA\PCS_PREOP_INDXS.DBF
    RMAN-08522: input datafile fno=00017 name=D:\ORACLEDATA\PCS_EXTERNAL_DATA.DBF
    RMAN-08522: input datafile fno=00018 name=D:\ORACLEDATA\PCS_EXTERNAL_INDXS.DBF
    RMAN-08522: input datafile fno=00019 name=D:\ORACLEDATA\RMANDATA01.DBF
    RMAN-08522: input datafile fno=00003 name=C:\ORACLE\ORA817\DATABASE\PCS_RBS_01.DBF
    RMAN-08522: input datafile fno=00004 name=C:\ORACLE\ORA817\DATABASE\PCS_RBS_02.DBF
    RMAN-08522: input datafile fno=00005 name=C:\ORACLE\ORA817\DATABASE\PCS_RBS_03.DBF
    RMAN-08522: input datafile fno=00006 name=C:\ORACLE\ORA817\DATABASE\PCS_RBS_04.DBF
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03007: retryable error occurred during execution of command: backup
    RMAN-07004: unhandled exception during command execution on channel CH1
    RMAN-10035: exception raised in RPC: ORA-19504: failed to create file "03csmf6r_1_1
    ORA-27044: unable to write the header block of file
    OSD-04008: WriteFile() failure, unable to write to file
    O/S-Error: (OS 112) There is not enough space on the disk.
    RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE

    Any ideas please?

  2. #2
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    At the bottom of your printout:

    O/S-Error: (OS 112) There is not enough space on the disk.

    David Knight
    OCP DBA 8i, 9i, 10g

  3. #3
    Join Date
    Apr 2001
    Posts
    142
    I see that but on drive c: I have 1.4 gig of free space and on d: I have 3.5 gig.

  4. #4
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    688
    And what the size of your database?
    Try to save your backup on D:\

    RUN {
    ALLOCATE CHANNEL CH1 TYPE DISK;
    BACKUP
    format='D:\temp\%t.%d.%s.%p'
    DATABASE;
    release channel CH1;
    }


    Originally posted by Diggers12
    I see that but on drive c: I have 1.4 gig of free space and on d: I have 3.5 gig.

  5. #5
    Join Date
    Apr 2001
    Posts
    142
    Thanks,

    that worked, I got a backup file called 96T.96D.96S.96P. Now how do I restore thsi file. I tried with a script from the pracle manual and got the following.

    RMAN> run {
    2> allocate channel ch1 type disk;
    3> restore database;
    4> }

    RMAN-03022: compiling command: allocate
    RMAN-03023: executing command: allocate
    RMAN-08030: allocated channel: ch1
    RMAN-08500: channel ch1: sid=10 devtype=DISK

    RMAN-03022: compiling command: restore

    RMAN-03022: compiling command: IRESTORE
    RMAN-03023: executing command: IRESTORE
    RMAN-08016: channel ch1: starting datafile backupset restore
    RMAN-08502: set_count=4 set_stamp=432750962 creation_time=18-JUN-01
    RMAN-08089: channel ch1: specifying datafile(s) to restore from backup set
    RMAN-08523: restoring datafile 00001 to C:\ORACLE\ORA817\DATABASE\SYSPICIS.ORA
    RMAN-08523: restoring datafile 00002 to C:\ORACLE\ORA817\DATABASE\PCS_TEMP01.DBF
    RMAN-08523: restoring datafile 00003 to C:\ORACLE\ORA817\DATABASE\PCS_RBS_01.DBF
    RMAN-08523: restoring datafile 00004 to C:\ORACLE\ORA817\DATABASE\PCS_RBS_02.DBF
    RMAN-08523: restoring datafile 00005 to C:\ORACLE\ORA817\DATABASE\PCS_RBS_03.DBF
    RMAN-08523: restoring datafile 00006 to C:\ORACLE\ORA817\DATABASE\PCS_RBS_04.DBF
    RMAN-08523: restoring datafile 00007 to D:\ORACLEDATA\PCS_RT_INDXS.DBF
    RMAN-08523: restoring datafile 00008 to D:\ORACLEDATA\PCS_RT_DATA.DBF
    RMAN-08523: restoring datafile 00009 to D:\ORACLEDATA\PCS_CARE_DATA.DBF
    RMAN-08523: restoring datafile 00010 to D:\ORACLEDATA\PCS_CARE_INDXS.DBF
    RMAN-08523: restoring datafile 00011 to D:\ORACLEDATA\PCS_COMMON_DATA.DBF
    RMAN-08523: restoring datafile 00012 to D:\ORACLEDATA\PCS_COMMON_INDXS.DBF
    RMAN-08523: restoring datafile 00013 to D:\ORACLEDATA\PCS_LABS_INDXS.DBF
    RMAN-08523: restoring datafile 00014 to D:\ORACLEDATA\PCS_LABS_DATA.DBF
    RMAN-08523: restoring datafile 00015 to D:\ORACLEDATA\PCS_PREOP_DATA.DBF
    RMAN-08523: restoring datafile 00016 to D:\ORACLEDATA\PCS_PREOP_INDXS.DBF
    RMAN-08523: restoring datafile 00017 to D:\ORACLEDATA\PCS_EXTERNAL_DATA.DBF
    RMAN-08523: restoring datafile 00018 to D:\ORACLEDATA\PCS_EXTERNAL_INDXS.DBF
    RMAN-08523: restoring datafile 00019 to D:\ORACLEDATA\RMANDATA01.DBF
    RMAN-03026: error recovery releasing channel resources
    RMAN-08031: released channel: ch1
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure during compilation of command
    RMAN-03013: command type: restore
    RMAN-03006: non-retryable error occurred during execution of command: IRESTORE
    RMAN-07004: unhandled exception during command execution on channel ch1
    RMAN-10035: exception raised in RPC: ORA-19573: cannot obtain exclusive enqueue for datafile 7
    RMAN-10031: ORA-19583 occurred during call to DBMS_BACKUP_RESTORE.RESTOREBACKUPPIECE

    Any ideas, thanks

  6. #6
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    688
    1) mount database;
    2) run {
    allocate channel ch1 type disk;
    restore database;
    recover database;
    sql 'ALTER DATABASE OPEN';
    release channel ch1;
    }
    Best wishes!

    Originally posted by Diggers12
    Thanks,
    that worked, I got a backup file called 96T.96D.96S.96P. Now how do I restore thsi file. I tried with a script from the pracle manual and got the following.
    RMAN> run {
    2> allocate channel ch1 type disk;
    3> restore database;
    4> }

  7. #7
    Join Date
    Apr 2001
    Posts
    142
    Hi,

    where do I mount the database from RMAN or svrmgr?

    thanks

  8. #8
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    in the RMAN, issue

    startup mount on your target database

    i.e

    startup mount pfile=$ORACLE_HOME/admin/SID/pfile/initSID.ora


    Refer the below mentioned link for more details on learning how to do backup and recovery using RMAN.

    http://technet.oracle.com/doc/oracle...a76990/toc.htm

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  9. #9
    Join Date
    Apr 2001
    Posts
    142
    I have tried to enter the command you gave me but I get the following.

    RMAN> startup mount PFILE=c:\oracle\ora817\database\init.PICIS.ora;

    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-06171: not connected to target database

  10. #10
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    688

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