-
What is Full Backup ?
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.
oracleofdelphi
- Sep 9th, 2009
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 on...
-
Can Full Backup be performed when the database is open ?
No.
Kamran Agayev A.
- Sep 8th, 2009
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 ...
sanjayoracle
- Apr 25th, 2008
NO, we can't. cuz Full Backup means consistent backup and we can take this backup only when our database is close.
-
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
-
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 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...
-
How do you verify and validate the Datafile which is backed up?
-
How can I Export 9i data in 8 ? I mean when I Export from 9i and Import in 8, I face errors. what sould I do and my pc is not in Network.
narendra05
- Apr 23rd, 2010
I would suggest create a db link in Oracle 8 to Oracle 9i and run the CREATE TABLE AS SELECT FROM another database.I would suggest you move to Oracle 10g /11g soon as Oracle support is already stopped to 9i and 8i release.Narendra
sanjayoracle
- Apr 25th, 2008
We can do it. but first we have to confirm that parameter NLS_LANG is same in both database. otherwise in IMP process oracle will give error
-
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.
-
Backup Mode Redo Generation
Why more redos are generated when the database is in begin backup mode?
ddj1966
- May 28th, 2010
When a user managed Hot backup is executed, the tablespace or database has to be placed in backup mode. This informs the Oracle kernel that SCNs should not be updated on the datafile. i.e. the header ...
dhandapanik
- Dec 30th, 2009
During begin backup mode, the data file headers get freezed and it doesn’t get updated until the end backup. So it causes a checkpoint to the datafile. This causes all dirty blocks to be w...
-
What is mean live dead lock? How to prevent it.?
prahlad_786
- Jun 23rd, 2010
Whenever you have competing DML running against the same data, you run the risk of a deadlock.Tune the application - Single-threading related updates and other application changes can often remove dea...
naveen5555
- Sep 22nd, 2007
A deadlock occurs when two or more users are waiting for data locked by each other(Not commited by user01).To fix this, recreate the segment with higher INITTRANS and/or PCTFREE values. This will allo...
-
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...
-
Background Processes
Which processes will run when we take online backup?
narendra05
- Aug 16th, 2010
The rman process runs in case of backup running in parallel multiple such processes would run. select sid,program,osuser,status from v$session where program like '%rman%' query will give the status of such sessions.
slavaostapenko
- Jul 13th, 2010
I suppose no other database background process is performed. RMAN appears as usual client for database. So, there are only several RMAN processes launched in OS, but no database background processes.
-
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
-
Corrupted OS
How will you recover database if OS is corrupted. Assume you have hot backup on same hard drive.
vasantksaxena
- Oct 10th, 2010
OS Corruption doen't mean hard disk crashed.?Connect this hard disk as secondary device in a working system, copy the back files/folder to other location, and proceed.
-
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...
-
How do you setup a Physical stanby for Oracle 9i in Linux ?
matabrez
- Jan 10th, 2011
Steps for Physical standby for Oracle 9i in LINUX.On Primary Side 1. Take rman fullbackup with controlfile and spfile.2. Take standby controlfile backup as SQL> ALTER DATABASE CREATE STANDBY CONTRO...
-
Authentication Methods for DBAs
What are the steps to creating a password authentication file?
ashokbabugaddipati
- Jun 2nd, 2011
1.set the remote_login_passwordfile='EXCLUSIVE'2.orapwd ?file=pwdsid.ora password=xxxxxx? force=ywe have to check the password file is?created or not using the following querySQL> select * from v$pwfile_users;
g.mrunalini
- Jul 22nd, 2008
There are two types of authenticationsOS levelDB levelFor OS level authentication:1. Shutdown the database2. Set OS_AUTHENT_PREFIX=' ' in init.ora file3.$ connect '...
-
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. -
-
RMAN - parameters when scheduling backup
What parameters do you specify/define while scheduling back-up using RMAN?
Oracle Backup and Recovery Interview Questions
Ans