- 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 ...
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 ...
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: ...
To give the export file name.
Flag to indicate whether export should compress fragmented segments into single extents.
A flag to indicate whether grants on databse objects will be exported or not. Value is 'Y' or 'N'.
A flag to indicate whether indexes on tables will be exported.
Flag to indicate whether table rows should be exported. If 'N' only DDL statements for the database objects will be created.
View page << Previous 1 2 [3] 4 5 6 7 8 9 10 Next >>
Go Top
