What is FRA ? When do you use this ?
Latest Answer: A flash recovery area, a disk location in which the database can store and
manage files related to backup and recovery.
Flash recovery area where you can store not only the traditional components
found in a backup strategy such as control ...
How do you generate the begin backup script?
Latest Answer: SQL>set head off
SQL>spool beginbackup.sql
SQL>select 'alter tablespace ' tablespace_name ' begin backup;' from dba_tablespaces;
SQL>spool off
This will create file beginbackup.sql with entry for all tablespaces, remove any unnecessary ...
When do you recommend hot backup? What are the pre-reqs?
Latest Answer: Database must be Archivelog ModeArchive Destination must be set and LOG_ARCHIVE_START=TRUE (EARLIER VERSION BEFORE 10G)If you go through RMAN then CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # defaultCONFIGURE BACKUP OPTIMIZATION OFF; # defaultCONFIGURE ...
What is hot backup and what is cold backup?
Latest Answer: Hot backup when the database is online, cold backup is taken during shut down period ...
What is the difference between physical and logical backups?
Latest Answer: In Oracle Logical Backup is "which is taken using either Traditional Export/Import or Latest Data Pump". Where as Physical backup is known "when you take Physical O/s Database related Files as Backup". ...
What is RAID? What is RAID0? What is RAID1? What is RAID 10?
Latest Answer: RAID: It is a redundant array of independent diskRAID0: Concatenation and strippingRAID1: Mirroring ...
What are the various tape backup solutions available in the market?
What are RTO, MTBF, and MTTR?
What are things which play major role in designing the backup strategy?
Latest Answer: Cold backup: shutdown the database and copy the datafiles with the help of
O.S. command. this is simply copying of datafiles just like any other text file
copy.
Holt backup: backup process starts even though database in running. The
process to ...
View page << Previous 1 2 3 4 [5]
Go Top
