![]() 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 ... How do you setup the RMAN tape backups? Latest Answer : RMAN Target / run{Allocate channel ch1 device type sbt_tape maxpiecesize 4gFormat'%D_%U_%T_%t';sql 'alter system switch logfile';Backup database;backup archivelog from time 'sysdate-7';Backup Format '%D_CTLFILE_P_%U_%T_%t' Current controlfile;release ... 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 ... What is Channel? How do you enable the parallel backups with RMAN? Latest Answer : Channel is a link that RMAN requires to link to target database. This link
is required when backup and recovery operations are performed and recorded.
This channel can be allocated manually or can be preconfigured by using
automatic channel ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||