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 ...
What are different types of backup? (Hot, Cold, logical, Physical) Explain in detail.
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 ...
Cold backup is taking backup of all physical files after normal shutdown of database. We need to take. - All Data files. - All Control files.
A backup of one or more database files taken while the database is closed. Typically, closed backups are also whole database backups. If you closed the database cleanly, then all the files in the backup are consistent. SQL>SHUTDOWN IMMEDIATE (or) NORMAL ...
Which two commands perform a full backup of all files in the root (/) file system to the default /dev/rmt/0 tape device? (Choose two) A. ufsdump 0 / B. ufsdump /dev/rmt/0 / C. ufsdump / /dev/rmt/0 D. ufsdump 0 /dev/rmt/0 / E. ufsdump Of /dev/rmt/0 /
Answer: C, D
Use Export and Import tools for backups and restore resp.you can use exp and imp as well ...
* What are constraints and derivation?* Explain the process of taking backup in DataStage?*What are the different types of lookups available in DataStage?
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; ...
How many days, we are going to retain the data after taking the backup. For example the data which backed up today that will get expire in 90 days. That means, it is 90 days retention policy for 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
Detail script of backup using RMAN in both mode catalog and nocatalog
Full Backup in the sense taking up the whole database backup into a specific folder or a path but we cant take any jobs as backup and SQL Server logins also we cant take. ...
View page << Previous 1 [2] 3 4 5 6 7 8 9 10 Next >>
Go Top
