Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Rman Restore Database

Beauty_and_dBestMar 13 2018 — edited Mar 16 2018

11gR2

OL6

Hi ALL,

I am restoring rman backup  to our DR server.

I encountered no space left error, but I still see 200Gb Free in the target data folder.

What could be the cause? Does this mean 200Gb is not enough.

If I can freeup some more space, How do I restart the aborted process?

Please help...

Kind regards,

jc

channel ORA_DISK_8: starting datafile backup set restore

channel ORA_DISK_8: specifying datafile(s) to restore from backup set

channel ORA_DISK_8: restoring datafile 00007 to /home/oraprod/PROD/data/owad01.dbf

channel ORA_DISK_8: restoring datafile 00017 to /home/oraprod/PROD/data/a_int02.dbf

channel ORA_DISK_8: restoring datafile 00040 to /home/oraprod/PROD/data/a_txn_data05.dbf

channel ORA_DISK_8: restoring datafile 00043 to /home/oraprod/PROD/data/a_txn_ind08.dbf

channel ORA_DISK_8: restoring datafile 00397 to /home/oraprod/PROD/data/a_nolog01.dbf

channel ORA_DISK_8: restoring datafile 00398 to /home/oraprod/PROD/data/a_archive01.dbf

channel ORA_DISK_8: restoring datafile 00401 to /home/oraprod/PROD/data/a_txn_data02.dbf

channel ORA_DISK_8: restoring datafile 00404 to /home/oraprod/PROD/data/a_txn_ind03.dbf

channel ORA_DISK_8: reading from backup piece /home/FRA/PROD/backupset/2018_03_11/o1_mf_nnndf_TAG20180311T010143_fb83wkcd_.bkp

channel ORA_DISK_1: piece handle=/home/FRA/PROD/backupset/2018_03_11/o1_mf_nnndf_TAG20180311T010143_fb83w48k_.bkp tag=TAG20180311T010143

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:27:08

channel ORA_DISK_2: piece handle=/home/FRA/PROD/backupset/2018_03_11/o1_mf_nnndf_TAG20180311T010143_fb83w4lw_.bkp tag=TAG20180311T010143

channel ORA_DISK_2: restored backup piece 1

channel ORA_DISK_2: restore complete, elapsed time: 00:58:29

channel ORA_DISK_3: piece handle=/home/FRA/PROD/backupset/2018_03_11/o1_mf_nnndf_TAG20180311T010143_fb83w4yx_.bkp tag=TAG20180311T010143

channel ORA_DISK_3: restored backup piece 1

channel ORA_DISK_3: restore complete, elapsed time: 01:14:40

channel ORA_DISK_4: ORA-19870: error while restoring backup piece /home/FRA/PROD/backupset/2018_03_11/o1_mf_nnndf_TAG20180311T010143_fb83wkq5_.bkp

ORA-19502: write error on file "/home/oraprod/PROD/data/a_queue01.dbf", block number 4025216 (block size=8192)

ORA-27072: File I/O error

Linux-x86_64 Error: 28: No space left on device

Additional information: 4

Additional information: 4025216

Additional information: -1

RMAN-06900: WARNING: unable to generate V$RMAN_STATUS or V$RMAN_OUTPUT row

RMAN-06901: WARNING: disabling update of the V$RMAN_STATUS and V$RMAN_OUTPUT rows

ORACLE error from target database:

ORA-09817: Write to audit file failed.

Linux-x86_64 Error: 28: No space left on device

Additional information: 12

channel ORA_DISK_5: ORA-19870: error while restoring backup piece /home/FRA/PROD/backupset/2018_03_11/o1_mf_nnndf_TAG20180311T010143_fb83wky1_.bkp

ORA-19502: write error on file "/home/oraprod/PROD/data/a_txn_data01.dbf", block number 3538048 (block size=8192)

ORA-27072: File I/O error

Additional information: 4

Additional information: 3538048

Additional information: 491520

channel ORA_DISK_6: ORA-19870: error while restoring backup piece /home/FRA/PROD/backupset/2018_03_11/o1_mf_nnndf_TAG20180311T010143_fb83wl6z_.bkp

ORA-19502: write error on file "/home/oraprod/PROD/data/a_queue02.dbf", block number 3437824 (block size=8192)

ORA-27072: File I/O error

Linux-x86_64 Error: 28: No space left on device

Additional information: 4

Additional information: 3437824

Additional information: -1

channel ORA_DISK_7: ORA-19870: error while restoring backup piece /home/FRA/PROD/backupset/2018_03_11/o1_mf_nnndf_TAG20180311T010143_fb83wk0l_.bkp

ORA-19502: write error on file "/home/oraprod/PROD/data/sysaux03.dbf", block number 3360896 (block size=8192)

ORA-27072: File I/O error

Linux-x86_64 Error: 28: No space left on device

Additional information: 4

Additional information: 3360896

Additional information: -1

c. dbms_backup_restore.restoreCancel() failed

channel ORA_DISK_8: ORA-19870: error while restoring backup piece /home/FRA/PROD/backupset/2018_03_11/o1_mf_nnndf_TAG20180311T010143_fb83wkcd_.bkp

ORA-19502: write error on file "/home/oraprod/PROD/data/a_txn_data02.dbf", block number 3166976 (block size=8192)

ORA-27072: File I/O error

Linux-x86_64 Error: 28: No space left on device

Additional information: 4

Additional information: 3166976

Additional information: -1

failover to previous backup

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of restore command at 03/14/2018 02:07:29

RMAN-06026: some targets not found - aborting restore

RMAN-06023: no backup or copy of datafile 401 found to restore

RMAN-06023: no backup or copy of datafile 399 found to restore

RMAN-06023: no backup or copy of datafile 392 found to restore

RMAN-06023: no backup or copy of datafile 36 found to restore

RMAN-06023: no backup or copy of datafile 14 found to restore

RMAN-06023: no backup or copy of datafile 11 found to restore

RMAN-06023: no backup or copy of datafile 8 found to restore

This post has been answered by Beauty_and_dBest on Mar 16 2018
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 13 2018
Added on Mar 13 2018
4 comments
749 views