 Related Questions 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 ... 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 the steps for recovering the full database from cold backup? Explain the steps to perform the point in time recovery with a backup which is taken before the resetlogs of the db? Outline the steps involved in TIME based recovery from the full database from hot backup?
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
