Pravin Kumar

• Feb 22nd, 2018

Restoring the database means copy the required datafiles from backup. Recovery means applying redolog or archived log to make the database up to given time, scn, lsn.

hari shankar

• Oct 12th, 2015

Restore is the process in which RMAN is copying the backup file from backup location to proper database location.

Recover is the process in which applying the archive logs to and updating the data files.

Answer Question  Select Best Answer

Complete database recovery from disk failure is possible only in ARCHIVELOG mode.Online database backup is possible only in ARCHIVELOG     mode.

Vikas

• Jan 9th, 2018

Too many !! High Availability (DATAGUARD,RAC), Point in time recovery, Flashback , Audits and many more.....

hari shankar

• Aug 5th, 2016

We can do a lot of things in archivelog mode. 1. Can take Hot backup 2. Complete or incomplete recovery 3. Can manage several policy 4. Take incremental back 5. No need to shutdown or offline or unav...

Answer Question  Select Best Answer

subhash.terdale

 Profile Answers by subhash.terdale Questions by subhash.terdale

• Oct 1st, 2008

Steps involved in database startup are as follows Startup nomount - Instance starts, SGA allocated, Background processes started Used during database creation Startup mount - Control file read, d...

satyam_2007

 Profile Answers by satyam_2007 Questions by satyam_2007

• Oct 21st, 2007

There are the three steps need to follow to start database:1) Start an Instance.2) Mount the database.3) Open the database.Connect with operating system authentication:conncet / as sysdba1) Start an I...

Answer Question  Select Best Answer

No.

Kamran Agayev A.

 Profile Answers by Kamran Agayev A. Questions by 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

 Profile Answers by sanjayoracle Questions by 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.

Answer Question  Select Best Answer

narendra05

 Profile Answers by narendra05 Questions by 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

 Profile Answers by sanjayoracle Questions by 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

Answer Question  Select Best Answer

Close the Database, Dismount the Database and Shutdown the Instance

karteek

• Feb 6th, 2015

1.does not allow New user
2.conditions(shutdown immediate or transnational or abort)
3.logswitch activity
4.close the data file header and control file header for read and write
5.when the instance and database will be disconnect

Mukunda

• Jul 19th, 2011

Before shut down better to take up the back up of the database and then disconnect the database and then shutdown the database

Answer Question  Select Best Answer

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

 Profile Answers by oracleofdelphi Questions by 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...

oracle56

 Profile Answers by oracle56 Questions by oracle56

• Aug 23rd, 2008

Full backup means it having datafiles, controlfile and parameter file.

Answer Question  Select Best Answer

Vikas

• Jan 9th, 2018

Assuming it was in archive log mode, With recent controlfile backup and archives, uncommitted transactions could be recovered.

surya

• Jun 7th, 2016

Is it the only command for complete recovery? Do we have to mention SCN or not?

Answer Question  Select Best Answer

What is recovery catalog? Why do you need this?

mkguduru

 Profile Answers by mkguduru Questions by mkguduru

• Aug 12th, 2008

When we specify Catalog - RMAN uses recovery catalog database to store RMAN metadata.

jkrish.sharma

 Profile Answers by jkrish.sharma Questions by 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.

Answer Question  Select Best Answer

Why more redos are generated when the database is in begin backup mode?

ddj1966

 Profile Answers by ddj1966 Questions by 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

 Profile Answers by dhandapanik Questions by 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...

Answer Question  Select Best Answer

when to use logical backup(Datapump-expdp,impdp) and when to use physical backup(hot&cold backup) in oracle?

Vikas

• Jan 9th, 2018

Generally, datapump is being used to remap schemas or tables as routine activities which is logical backup. For cases like database restore, creating replicated databases physical backup is mostly considered.

Nishanth

• Mar 15th, 2016

A database dump using expdp is a 1-time export of one or more database schemas. It backs up DDL (table structures, views, synonyms, stored procedures, packages, etc), plus data. An RMAN backup is a...

Answer Question  Select Best Answer

Where does oracle stores the tables created by user? How to take backup of these tables?

koteswar

• Mar 30th, 2018

The Tables are physically stored into datafiles and logically stored into tablespaces

Neha Tiwari

• Dec 20th, 2017

Oracle stores the tables in default tablespace or you can say datafiles. You can table EXPDP of the table or RMAN backup as well.

Answer Question  Select Best Answer

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

 Profile Answers by shabirwani Questions by 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 ...

Answer Question  Select Best Answer

bhendega

 Profile Answers by bhendega Questions by 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

Answer Question  Select Best Answer

Vikas

• Jan 9th, 2018

NO, cross platform restore is only possible thru DATAPUMP or with transporatable tablepaces.

Amin

• Oct 14th, 2016

Yes, we can do it. Take logical backup of export datapump and import it into window NT system.

Answer Question  Select Best Answer

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

 Profile Answers by nvkchaitanya Questions by 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.

 Profile Answers by Kamran Agayev A. Questions by 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...

Answer Question  Select Best Answer

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

 Profile Answers by oracleofdelphi Questions by 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

Answer Question  Select Best Answer

narendra05

 Profile Answers by narendra05 Questions by 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

 Profile Answers by kannan7 Questions by 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.

Answer Question  Select Best Answer

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

 Profile Answers by satish_manukonda Questions by 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

 Profile Answers by satyam_2007 Questions by 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...

Answer Question  Select Best Answer

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

 Profile Answers by oracleofdelphi Questions by 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...

Answer Question  Select Best Answer