 Related Questions Latest Answer : Components of Physical database are:-1. Datafile - One or more2. Redo log file - Two or more3. Control File - Two or more ... Latest Answer : Oracle logical structure follows the order likeTablespaceSegments
ExtentsDatablocksOracle database consists of tablesapces (one or more tablespace forms database)
Segments is the area in which on oracle object sores in a tablespace.One Oracle object ... The primary functional difference between logical and physical standby database setups is that logical standby permits you to add additional objects (tables, indexes, etc) to the database, while physical Latest Answer : A physical or logical standby database is a database replica created from a backup of a primary database. A physical standby database is physically identical to the primary database on a block-for-block basis. It's maintained in managed ... Oracle DBA Questionswhat happen when we kill smon,what happen when we kill pmonwhat is fracture block and how to fix itwhat is corrupted block and how to fix itwhat are the oracle threads are going to start ,when we start the databasehow to check index is working properly ,what are the steps to be taken andon what basis we have to decide particular index has to rebuild not all indexeswhat steps to be taken if receive a call that performance has gone down as dba what steps has be takenWhat possible View Question | Asked by : Ibad Tags : Backup What kind of backup you take Physical / Logical? Which one is better and Why? Latest Answer : Logical backup means backing up the individual database objects such as tables, views , indexes.. using the utility called EXPORT, provided by Oracle. The objects exported in this way can be imported into either same database or into any other database. ... Tags : Backup What is standby databases? Difference between Physical and logical standby databases Latest Answer : A standby database is a transactionally consistent copy of the primary database. Using a backup copy of the primary database, you can create up to nine standby databases.A standby database can be either a physical standby database or a logical standby ... How to write script for export backup in shell. Can you take online backup of a Control File If yes, How? Latest Answer : Yes you could take a online backup of a control file. SQL> alter database backup controlfile to trace;This will create a text copy of your controlfile. You could use this text file to recreate your controlfile. ... Latest Answer : We need to put the tablespaces in backup mode during hot backup so that writing to datafiles related to this tablespace would stop and be written in the archive logs instead during the period of the backup. If you will not put the tablespaces in backup ... What are the common problems while taking backups? What are the necessary steps to take backup on to tapes and disks in real time?
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1 
1