|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions Export the user Perform import using the command imp system/manager file=export.dmp indexfile=newrite.sql. This will create all definitions into newfile.sql. Drop Latest Answer : If its the same database use:alter table the_table move tablespace other_tablespace; alter index the_index rebuild tablespace other_tablespace; ... Shadow set of disks save as a backup in the event of disk failure. In most Operating System if any disk failure occurs it automatically switchover to place of failed disk. Improved We should depend on export/import utility for backup/recovery (fully reliable) The tar command cannot be used for physical file backup, instead we can - Logical Backups - Cold Backups - Hot Backups (Archive log) Latest Answer : 1. Physical Backup---Hot Backup---Cold Backup2. Logical Backup---Export---Import ... Logical backup involves reading a set of database records and writing them into a file. Export utility is used for taking backup and Import utility is used to recover from backup. Latest Answer : The simple example for logical backup is export and import. The logical backup involves in taking the snapshot of the database at that particular instance in terms of series of SQL statements which is not a byte-by-byte copy of the database. This is obvious ... Tags : Backup Cold backup is taking backup of all physical files after normal shutdown of database. We need to take. - All Data files. - All Control files. Latest Answer : A backup of one or more database files taken while the database is closed. Typically, closed backups are also whole database backups. If you closed the database cleanly, then all the files in the backup are consistent. SQL>SHUTDOWN IMMEDIATE (or) NORMAL ... Tags : Backup Full back - Complete databaseIncremental - Only affected tables from last incremental date/full backup date.Cumulative backup Latest Answer : Different kinds of Exports are:1. Owner(Schema) level Backup2. Object(table) level backup3. Full Backup4. Tablespace Level Backup ... Taking backup of archive log files when database is open. For this the ARCHIVELOG mode should be enabled. The following files need to be backed up. All data Latest Answer : The database should be in Archive log mode to take hot backups.Step1: Shutdown the database gracefullyStep2: Take full backup of the databaseStep3: Edit the following intialization parameters likelog_archive_destlog_archive_formatlog_archive_startStep4: ... Tags : Backup
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
