User Managed ( cold Backup ) Scenarious :
1. Take cold backup with the above steps, make one of the datafile missing after that restore the cold backup taken.
2.Take the cold backup and the database is in archive log mode, make some of the datafiles misplaced. Restore and recover from cold back
3. The cold backup has to be restored on different mount point(use physically different server)
4. The cold backup has to be restored on different mount point(use physically different server) There are three log groups with tow members each. While restoring you found that from the first log group member log1b.log is missing and in the second log group log2a.log is missing
5. The cold backup when restoring on the different server, you have found that 1 redo log member is missing and 1 control file is missing – restore the database.
6. How you will identify that the database was clean shutdown last time?
7.Calculate the logical database size and and physical size of database?
8.Recover a lost datafile in Noarchive Mode - data is present in Redolog
a. Restore damaged datafile
b. Recover it
9.Recover a lost datafile in Noarchive Mode - data is not present in redologfile (Incomplete Recovery)
c. Restore cold backup
10.Recover System Datafile in Archive Mode (Database was Closed initially)
11.Recover Non-System Datafile in Archive Mode (Database was closed initially)
Recover Non-system datafile to new location (Database was closed initially)
12. Do time based recovery – a table is dropped which you need to recover
13. Take cold backup. Later start the database. Database is working fine for one entire day. Next day if all the control files are lost because of disk failure where the control files were stored. Now restore control file from cold backup.
14. A table is drop – use incomplete recovery to recover the table
15. A table is drop – client is not willing to lose data, use flashback option and take the table from recycle bin. Which will give you table as well as database will not get recover as incomplete recovery
16.Taken backup of database on 64 bit OS and restored on 32 bit OS – how will you do it?
17. Cold backup taken of db with version 10.2.0.1 and want to restore on database server with 10.2.0.4 version
18.Reverse the above scenario
2.Take the cold backup and the database is in archive log mode, make some of the datafiles misplaced. Restore and recover from cold back
3. The cold backup has to be restored on different mount point(use physically different server)
4. The cold backup has to be restored on different mount point(use physically different server) There are three log groups with tow members each. While restoring you found that from the first log group member log1b.log is missing and in the second log group log2a.log is missing
5. The cold backup when restoring on the different server, you have found that 1 redo log member is missing and 1 control file is missing – restore the database.
6. How you will identify that the database was clean shutdown last time?
7.Calculate the logical database size and and physical size of database?
8.Recover a lost datafile in Noarchive Mode - data is present in Redolog
a. Restore damaged datafile
b. Recover it
9.Recover a lost datafile in Noarchive Mode - data is not present in redologfile (Incomplete Recovery)
c. Restore cold backup
10.Recover System Datafile in Archive Mode (Database was Closed initially)
11.Recover Non-System Datafile in Archive Mode (Database was closed initially)
Recover Non-system datafile to new location (Database was closed initially)
12. Do time based recovery – a table is dropped which you need to recover
13. Take cold backup. Later start the database. Database is working fine for one entire day. Next day if all the control files are lost because of disk failure where the control files were stored. Now restore control file from cold backup.
14. A table is drop – use incomplete recovery to recover the table
15. A table is drop – client is not willing to lose data, use flashback option and take the table from recycle bin. Which will give you table as well as database will not get recover as incomplete recovery
16.Taken backup of database on 64 bit OS and restored on 32 bit OS – how will you do it?
17. Cold backup taken of db with version 10.2.0.1 and want to restore on database server with 10.2.0.4 version
18.Reverse the above scenario
No comments:
Post a Comment