أرجو المساعدة بهذا السؤال ومشكورين سلفا

عندي مشكلة بهدول الأسئلة  وماعرفت حللون بصراحة لو حدا بيساعدني بكون كتير ممنونكن

بس بدي السيكريبت يللي بخلوني أعمل restore and recover

وشكرا كتيير عالمساعدة

1-

you have a current control file and SPFILE but all datafiles are damaged or lost. You must restore and recover the whole database.

The database has one read-only tablespace (ITEM_TS), which must be restored from backup but which does not need media recovery.

Write the commands and scripts needed to restore and recover the database when the current control file is available.

Note: make sure that the database is in the right mode before starting recovery steps, channels are allocated and configured, and the output of the recovery is successful.

2-

In this scenario, the database is open, and some but not all of the datafiles are damaged. You want to restore and recover the damaged tablespace, while leaving the database open so that the rest of the database remains available.

Note: Determine Which Database Files to Restore or Recover (you can suppose the damaged files are DF01, Df02 as an example), let RMAN choose the backups to use in restoring the tablespace and any needed incremental backups and logs from disk or tape, make sure that the database is in the right mode before starting recovery steps, channels are allocated and configured, and the output of the recovery is successful.

تم تعديل 23 يونيو 201312 سنة بواسطة Shadi N. Ar