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 ...
What are the various tape backup solutions available in the market?
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 ...
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 ...
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 ...
How do you install the RMAN recovery catalog?
Latest Answer : Steps to be followed: 1) Create connection string at catalog database. 2) At catalog database, create one new user or use existing user and give that user a recovery_catalog_owner privilege.3)
Login into RMAN with connection string ...
What is backup set?
Latest Answer : RMAN can also store its backups in an RMAN-exclusive format which is called backup set. A backup set is a collection of backup pieces, each of which may contain one or more datafile backups. ...
How do you enable the encryption for RMAN backups?
Latest Answer : If you wish to modify your existing backup environment so that all RMAN
backups are encrypted, perform the following steps:
· Set up the Oracle Encryption Wallet
· Issue the following RMAN command:
RMAN> CONFIGURE ENCRYPTION ALGORITHM ...
Outline steps for recovery with missing archived redo logs?
Latest Answer : If the database is operating in ARCHIVELOG mode, and if the only copy of an archived redo log file is damaged, then the damaged file does not affect the present operation of the database. The following situations can arise, however, depending on when ...
What is db_recovery_file_dest ? When do you need to set this value?
Latest Answer : db_recovery_file_dest and db_recovery_file_dest_size are used to specify the location and size of the Flash Recovery Area. These database intilization parameters help RMAN to manage the backup storage and delete the obsolete backups and the ...
