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: For my understanding can we take backup the catalog database through RMAN
1. yes possible to take backup like
rman target / catalog catalogdbusername/password@catalogdbname
How ever it wont be good to have backup like this better to go with offline ...
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: Your database in archive log mode one of your archive file is missing there is no way to performed complete recovery you can able to do incomplete recovery, recover database till cancelled or there is another way if you have a export copy of that datafile ...
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. ...
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 ...
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. ...
Whats the Concept of Flashback Query in Oracle (10g in particular) and how is it beneficial?
Latest Answer: It lets you to view and repair historical data.They query the database by TIME or user specified SCN. It do not UNDO anything .It is only a query mechanism.You can take o/p from flashback query and perform an undo yourself. It ...
View page [1] 2 3 4 Next >>
Go Top
