 Related Questions A full backup is an operating system backup of all data files, on-line redo log files and control file that constitute ORACLE database and the parameter. Latest Answer : When using logical backup if we give full=y - that is a full backup.When using RMAN by default it takes full backup and image copy is also full backup since it contains all blocks used and not used ones. But in RMAN terms full backup is part of incremental ... Tags : Backup No. Latest Answer : Of course YESUsing RMAN you can take full backup of database while it's open. But don't forget to archive current redo log file and backup it also, because it keeps all changes made to database while it was backed up
For more information, please refer ... A Partial Backup is any operating system backup short of a full backup, taken while the database is open or shut down. Latest Answer : A partial backup is an operating system backup of part of a database. The backup of an individual tablespace's datafiles or the backup of a control file are examples of partial backups. Partial backups are useful only when the database is in ARCHIVELOG ... Tags : Backup What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode ? Complete database recovery from disk failure is possible only in ARCHIVELOG mode.Online database backup is possible only in ARCHIVELOG mode. Latest Answer : If this is the situation, simple process is :1. Take a trace of control file from clone do the changes in that like database name and datafile name and location.2. Save it as < name >.ora3. Run the file in nomount stage. This will create your control ... Read Answers (3) | Asked by : GAURAV Tags : Backup Latest Answer : Cold backup we can perform using OS commands after shutting down the database.In DB running position we can take hot backup using the following commans;alter database begin backup; ... Read Answers (2) | Asked by : Sameer Tags : Backup Latest Answer : Whenever we take any backup through RMAN, in the repository information of the backup is recorded. The RMAN respository can be either controlfile or recovery catalog. However if I take a backup through OS command then RMAN does not aware of that and hence ... Read Answers (4) | Asked by : manoj Tags : Backup You can take a coldbackup from solaris and use it on windows NT?A) YesB) Yes, if RMAN backup performed from NT serverC) Yes, after running RMAN convertD) No Tags : Backup Latest Answer : One difference between NT Backup and full-blown, third-party backup utilities is the lack of an internal backup job scheduler. While most backup utilities can be set to run automatically at a certain time of the day, NT Backup doesn’t have this option. ... Tags : Backup What are different types of backup? (Hot, Cold, logical, Physical) Explain in detail. Latest Answer : 1. Hot, inconsistance and online backup are same2. Cold, close consistance and offline backup are sameFor 1. db must be archive mode, inconsistance mean the SCN are not sameFor 2. db may be archive mode, consistance mean SCN are same (controlfile, datafile)Logical ... Tags : Backup
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
