بتاريخ: 22 فبراير 200917 سنة comment_149751 please help me, to do this exercise :This case study is meant to serve as a basis for developing your own backup, maintenance, and recovery scripts. Assumptions:1- The target database is running on windows 2000 platform.2- The target database will be Oracle 9i, named DESTDB.3- A user is created in the target database named BKuser with a password BKpass, and this user is granted SYSDBA privileges.4- The database is running in NOARCHIVE mode.This case study is divided into the following sections:1- create an RMAN script for configuring RMAN parameters.2- Backup the target database.3- Validate the database:a. Verify that database is restorable.b. Verify that tablespaces are restorable.4- Run Recovery catalog maintenance against the target database's control file.5- Remove the target database to simulate and setup a disaster recovery situation.6- Restore and recover the target database.Q1:Write the commands that will login to the target database, with no recovery catalog.Q2:Write the script that will set the default values for the following parameters:Retention policy Redundancy 2Device type DiskControl file backup AutomaticControl file backup destination D:\Oracle9i\OraBackups\Degree of parallelism 2Q3:Keep in mind that the only backups that are allowed are: 1- Whole database backups when the database is cleanly closed and the instance is mounted. 2- Tablespace backups of tablespaces that are offline clean or read only. Write the script that will backup the whole database, after taking the two previous points in consideration.Q4:Write a script to verify that a the entire database can be restored using the existing backups, and check on the ability to restore an individual tablespace named redo_tbs.Q5:Write a script to do the following:1- Display a list of files that need to be backed up based on the retention policy.2- Delete any un-necessary backups.3- Get a complete summary list of existing backups.Q6:We removed the target database to simulate and setup a disaster recovery situation, the instance is shutdown, and all the configuration files are in their appropriate places, write a script to restore and recover the target database. تقديم بلاغ
انضم إلى المناقشة
يمكنك المشاركة الآن والتسجيل لاحقاً. إذا كان لديك حساب, سجل دخولك الآن لتقوم بالمشاركة من خلال حسابك.