What are different types of backup? (Hot, Cold, logical, Physical) Explain in detail.
Latest Answer: 1. Hot, inconsistance and online backup are same2. Cold, close consistance and offline backup are sameFor 1. db must be archive mode, inconsistance mean the SCN are not sameFor 2. db may be archive mode, consistance mean SCN are same (controlfile, datafile)Logical ...
Latest Answer: One difference between NT Backup and full-blown, third-party backup utilities is the lack of an internal backup job scheduler. While most backup utilities can be set to run automatically at a certain time of the day, NT Backup doesn’t have this option. ...
Whats the Concept of Flashback Query in Oracle (10g in particular) and how is it beneficial?
Latest Answer: It lets you to view and repair historical data.They query the database by TIME or user specified SCN. It do not UNDO anything .It is only a query mechanism.You can take o/p from flashback query and perform an undo yourself. It ...
You can take a coldbackup from solaris and use it on windows NT?A) YesB) Yes, if RMAN backup performed from NT serverC) Yes, after running RMAN convertD) No
My database is in archive mode. when log switch occur that log file is archiving . what happens when log switch occurs
Latest Answer: After logswitch checkpoint accour.It update the hedder of datafile and controlfile with new SCN no. and checkpoint position.it also give the signal to dbwr to writ dirty buffer to datafile. ...
Latest Answer: Whenever we take any backup through RMAN, in the repository information of the backup is recorded. The RMAN respository can be either controlfile or recovery catalog. However if I take a backup through OS command then RMAN does not aware of that and hence ...
If an oracle database has crashed. How would you recover the transactions that are not in the backups?
Latest Answer: Cold backup we can perform using OS commands after shutting down the database.In DB running position we can take hot backup using the following commans;alter database begin backup; ...
Latest Answer: If this is the situation, simple process is :1. Take a trace of control file from clone do the changes in that like database name and datafile name and location.2. Save it as < name >.ora3. Run the file in nomount stage. This will create your control ...
Latest Answer: Creating a physical standby using RMAN ...
View page << Previous 1 [2] 3 4 5 Next >>
Go Top
