-
How to recover control file without backup and without 'create control file' command?
chetan.ind
- Mar 18th, 2009
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 f...
sanjayoracle
- Apr 25th, 2008
If we don;t have any backup of Controlfile...then we have to use create controlfile command..
-
Types of Backup
What are different types of backup? (Hot, Cold, logical, Physical) Explain in detail.
-
Configure Command
What is configure command? When do you use this?
oraclemanconsulting
- Aug 20th, 2010
CONFIGURE allows you to set options and have the setting stick around (persistence)common things to set:SNAPSHOT CONTROLFILE NAMERETENTION POLICY CHANNEL DEVICE TYPE CONTROLFILE AUTOBACKUP See what is set (or standing default values now)SHOW ALL;assumes the use of a recovery catalog
imran44
- Jan 15th, 2009
Show all; command at RMAN will show all configure command in default or update configuration mode
-
Rman backup
Suppose I have taken Rman backup on Server A. Can I apply this backup on Server B? How?
-
Inconsistant Backup
Why is the header of datafile and information of control file different at the time of inconsistant backup?
hari shankar
- Aug 5th, 2016
This will happen only one situation when we are taking backup when database is in open mode and we are taking data file in offline. In this situation data files header are block but control files are still open mode and updated by oracle process.
Sekaran Narsimhan
- Jun 16th, 2011
Inconsistent backup means online backup . when v r doing the online backup the database will be running and query ill be hitting the server in that time scn no ill differ from header of the datafile and the control file . so the both the info will be differ from each other in inconsistent backup?
-
What is Restricted Mode of Instance Startup ?
An instance can be started in (or later altered to be in) restricted mode so that when the database is open connections are limited only to those whose user accounts have been granted the RESTRICTED SESSION system privilege.
satish_manukonda
- Jan 24th, 2010
Restricted mode comes into picture when your taking backup and maintance activites. In the restricted mode no user is allowed to access..Bring the database to mount , that it will makes Restricted mode active.
satyam_2007
- Oct 25th, 2007
RESTRICT is one of an important option used with an open database.It performs a database startup with the database in the restricted user mode. User must having the privileges of RESTRICT, u...
-
144. What is On-line Redo Log?
The On-line Redo Log is a set of tow or more on-line redo files that record all committed changes made to the database. Whenever a transaction is committed, the corresponding redo entries temporarily stores in redo log buffers of the SGA are written to an on-line redo log file by the background ...
oracleofdelphi
- Sep 9th, 2009
Online redologs name is used since archivelogs are called offline redologs. Online redologs can be in three states current to which lWr is currently writing transaction changes then this current beco...
samala
- Sep 15th, 2007
Redo logs records all the changes to the database? whether commited or uncommited. How does it know whether you are committing or rolling back till you commit it. Oracle always thinks positively that...
-
What is Log Switch ?
The point at which ORACLE ends writing to one online redo log file and begins writing to another is called a log switch.
nitanjandial
- Dec 8th, 2007
log switch occurs when current redo logfile gets full and lgwr writes redo to next redo logfile.Even we can perform log switch with the command alsobefore we execute the sql execute following statemen...
Mohammed Abdul Afroze
- Sep 28th, 2007
The point at which oracle ends writing from one redo log and begins writing to another is called as a log switch.
-
How much time will it take a hotbackup if the batabase size is 60Gb
Mohammed Abdul Afroze
- Sep 28th, 2007
It depends on the datafiles related to database at OS Level.
-
How do you verify and validate the Datafile which is backed up?
-
You have taken a manual backup of a datafile using o/s. How RMAN will know about it?
naveen_rc
- Aug 6th, 2009
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 throug...
subhash.terdale
- Oct 1st, 2008
Full backup is offline backup of datafiles, Parameter file, Controlfiles, Redologfiles
-
RMAN Calatalog Database
Is it possible to take backup of catalog database using RMAN? If Yes, How?
slavaostapenko
- Jul 13th, 2010
RMAN catalog is a usual database, so just backup is with RMAN as any other database, using it as target database:RMAN sys/password@<RMAN catalog tnsname>.It can be done with no catalog or any other catalog (surely not using itself as catalog)/
naveen_rc
- Aug 6th, 2009
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 Dat...
-
Diagnose the problem
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?
Merlin5by5
- Jul 20th, 2011
Sign on as Oracle, connect to the Target DB on third floor as DBA, and perform your commands.
This only requires a Good OracleNet client arrangement.Merlin5by5
- Jul 20th, 2011
Disconnect from your current target DB, and connect to the target DB on the next floor.
This assumes you have connected to the Target DB as DBA, on YOUR floor. -
What are the steps involved in Instance Recovery ?
Rolling forward to recover data that has not been recorded in data files, yet has been recorded in the on-line redo log, including the contents of rollback segments. Rolling back transactions that have been explicitly rolled back or have not been committed as indicated by the rollback segments regenerated in step a. Releasing any resources (locks) held by transactions in process...
oracleofdelphi
- Sep 9th, 2009
Crash recovery is performed by SMON when database started after an instance crash or after a shutdown abort. Since during crash current transactions are present in redolog files and not yet been wri...
krishna
- May 23rd, 2007
Steps involve in recovery1.Restore backup datafiles2.Recover using Archive log files 3.apply partial backup 4.recover using redo log files
-
What do you mean by MEDIA RECOVERY..?
narendra05
- Apr 23rd, 2010
Recovery is method of making the database consitent. The database keeps this by way of SCN in headrer of all the datafile and controlfile. In case the SCN on datafile and controlfile database th...
kannan7
- Apr 15th, 2010
Media recovery is used to recover from a damaged(or lost) datafile, controlfile, or spfile. The goal of media recovery is to restore database integrity.
-
What is the difference between media recovery & crash recovery..?
hemant
- Oct 23rd, 2007
The basic diff between the media and crash recovery is that , media recovery is performed by the user or dba with the helps of backups while the crash recovery is performed by the oracle itself by using his sman background process.
shabirwani
- Sep 17th, 2006
oracle never accepts the inconsistency of the database. so when oracle goes down due to power outage or aborted manually, next time once the database base is opened it goes mainly to the three states ...
-
What are the different tools available for hot backups. Is it preferable to take it manually all the time or it depends on the size of the database.
bhendega
- Feb 24th, 2009
In oracle there are different tools for hot backup RMAN OEMAs per my view, it's de...
Chiranjeevi Manne
- Mar 30th, 2007
1. Using OS level filesystem backup tools 2. RMAN utility 3. Using traditional hot backup methos like keeping the tablespace in backup mode and the using OS level copy command to copy the datafiles to the backup location
-
-
Corrupted Archieve Logs
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 the archive logs applied are from nos 1 to 100, but 50 gets corrupted. What do we do? Can we proceed further? If so how?
nvkchaitanya
- Dec 7th, 2010
In this critical situation I had a pritical example which follows this.SQL> recover database until cancel using backup controlfile;ORA-00279: change 9867098396261 generated at 03/21/2008 13:37:44 n...
Kamran Agayev A.
- Sep 8th, 2009
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 us...
-
Recovery Catalog
What is recovery catalog? Why do you need this?
mkguduru
- Aug 12th, 2008
When we specify Catalog - RMAN uses recovery catalog database to store RMAN metadata.
jkrish.sharma
- Jul 27th, 2008
Recovery catalog contains metadata of control file of target database, whenever we take backup by RMAN it contains information and location of backup.
Oracle Backup and Recovery Interview Questions
Ans