Why more redos are generated when the database is in begin backup mode?
Latest Answer: As soon as you issue SQL> Alter database begin backup;This command freezes the datafile headers as well as controlfile headers, but the headers of redolog files are free. Hence if any of the transaction is performed after the online backup command. ...
Why is the header of datafile and information of control file different at the time of inconsistant backup?
Latest Answer: When we start datafile backup with begin backup command which will freeze the datafile headers and SCN cannot be updated only in controlfile SCN will update. This process is till end backup. ...
Suppose you have two servers, one at 2nd floor and another on 3rd floor,If you have to configure the server on 3rd floor while sitting on 2nd floor how Will you do it?
Latest Answer: If both are same domain, connect to ftp and ssh or scp / remote desktop connection/netmeetigs/vncserver. ...
How we you identify if a table was exported in its life time?
Latest Answer: Refer cumulative or an incremental backup (export )we have a parameter (RECORD) & the default parameter is yes & is to track the incremental backup of a table so those backup (export) information will get update in the following sys ...
Is it possible to take backup of catalog database using RMAN? If Yes, How?
Latest Answer: Yes, Schedule a Schema level Export backup of the RMAN Catalog Database in Task Scheduler or CRON
Exporting the Recovery Catalog
This example uses the Original Export utility described in Oracle Database Utilities to create a logical export of the recovery ...
What are the steps to creating a password authentication file?
Latest Answer: There are two types of authenticationsOS levelDB levelFor OS level authentication:1. Shutdown the database2. Set OS_AUTHENT_PREFIX=' ' in init.ora file3.$ connect '/ as sysdba'4. > startup5.> create user ...
There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery
Latest Answer: In this situation you're not able to recover the database. Of course, it can be done by using nonsupported and nondocumented parameter "_ALLOW_RESETLOGS_CORRUPTED" but you HAVE NOT to use it without Oracle Support's suggestion If your ...
What is configure command? When do you use this?
Latest Answer: show all; command at RMAN will show all configure command in default or update configuration mode ...
What is recovery catalog? Why do you need this?
Latest Answer: When we specify Catalog - RMAN uses recovery catalog database to store RMAN metadata. ...
Detail script of backup using RMAN in both mode catalog and nocatalog
Latest Answer: 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 [1] 2 3 4 5 Next >>
Go Top
