 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 ... 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 ... List some of the RMAN catalog view names which contains the catalog information ? Latest Answer : RC_DATABASE_INCARNATION,RC_BACKUP_COPY_DETAILS,RC_BACKUP_CORRUPTION,RC_BACKUP-DATAFILE_SUMMARY to name a few ... Outline the steps for recovering the full database from cold backup?
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
