Topic : Backup and Recovery

Without LIST FAILURE can we say ADVISE FAILURE in Data Recovery Advisor?


  • Yes
  • No

Answer :

Yes

Show Answer Discuss

What do you mean by database backup and which files must be backed up?


Answer :

- Database stores most crucial data of business ;so it?s important to keep the data safe and this can be achieved by backup.
The following files must be backed up
- Database files (Header of datafiles is freezed during backup)
- Control files<

Show Answer Discuss

What is a full backup and name some tools you use for full backup?


Answer :

- A full backup is a backup of all the control files; data files; and parameter file (SPFILE or PFILE).
- You must also backup your ORACLE_HOME binaries which are used for cloning.
- A full backup can be performed when our database runs in NON ARC

Show Answer Discuss

What are the different types of backup?s available and also explain the difference between them?


Answer :

There are 2 types of backup?s :
1. COLD backup(User managed & RMAN)
2. HOT backup(User managed & RMAN)
- Hot backup is taken when the database is still online and database should be in ARCHIVE LOG MODE.
- Cold backup is taken when the database is in offline mode.
- Hot backup is inconsistent backup where as cold backup is consistent backup.
- You can begin backup by using the following command
SQL> alter database begin backup;
- End backup by
SQL> alter database end backup;

Show Answer Discuss

How to recover database if we lost the control file and we do not have a backup and what is RMAN?


Answer :

- We can recover our database at any point of time; when we have backup of our control files in different mount points.
- Also check whether the control file is available in trace file located in USERDUMP or the alert log to recover the database.

Show Answer Discuss