-
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. -
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 Archived Redo Log ?
Archived Redo Log consists of Redo Log files that have archived before being reused.
-
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...
-
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?
-
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...
-
How to take cold and hot backup using UNIX
Sajeev123
- Jan 8th, 2009
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;
JOY
- Jun 12th, 2007
We can perform cold backup in unix by shutting down the database in proper mode so the control file will in consistent state and after that u can perform backing up all database files.I hot back we ca...
-
Oracle log switch question
My database is in archive mode. when log switch occur that log file is archiving . what happens when log switch occurs
rupiy2k
- Dec 20th, 2008
After logswitch checkpoint accour.It update the hedder of datafile and controlfile with new SCN no. and checkpoint position.it also give the signal to dbwr to writ dirty buffer to datafile.
naveen5555
- Sep 22nd, 2007
Log switch event will take place. But the status of the log file which is archiving will be ACTIVE till it finish archiving.
-
RMAN Backup
Detail script of backup using RMAN in both mode catalog and nocatalog
MUNNU2U
- Nov 26th, 2008
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.
-
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.
-
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.
-
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 '...
Oracle Backup and Recovery Interview Questions
Ans