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

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

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

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

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

Suppose I have taken Rman backup on Server A. Can I apply this backup on Server B? How?

Vikas

• Jan 9th, 2018

It depends actually. OS should be same and if it is, RMAN duplicate or rman restore either would help.

mahesh

• Aug 5th, 2016

That whole procedure is database cloning by using RMAN

Answer Question  Select Best Answer

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

 Profile Answers by Sekaran Narsimhan Questions by 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?

Answer Question  Select Best Answer

Gajendra mourya

• Jun 27th, 2015

Hello friends, Data guard is very important concept for disaster recovery, in data guard we have one primary database or one or more up to nine standby database for our database safety, now first w...

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

What parameters do you specify/define while scheduling back-up using RMAN?

SIMON AYOMPE

• Aug 13th, 2014

RMAN attaches a character string called a tag to every backup it creates, as a way of identifying the backup. You can either accept the default tag or specify your own with the TAG parameter of the BA...

Answer Question  Select Best Answer

Omi

• Mar 12th, 2014

To protect from fractured block corruption during begin backup mode oracle copies the whole block into redo record , So the size if redo increases . In this context more redo is generated .

Answer Question  Select Best Answer

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

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

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

Answer Question  Select Best Answer

What are the steps to creating a password authentication file?

ashokbabugaddipati

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

 Profile Answers by g.mrunalini Questions by 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  '...

Answer Question  Select Best Answer

matabrez

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

naveen5555

 Profile Answers by naveen5555 Questions by naveen5555

• Sep 22nd, 2007

Creating a physical standby using RMAN

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

How will you recover database if OS is corrupted. Assume you have hot backup on same hard drive.

vasantksaxena

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

ramshon

 Profile Answers by ramshon Questions by ramshon

• Sep 9th, 2010

Cannot be recovered.

Answer Question  Select Best Answer

What is configure command? When do you use this?

oraclemanconsulting

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

 Profile Answers by imran44 Questions by imran44

• Jan 15th, 2009

Show all; command at RMAN will show all configure command in default or update configuration mode

Answer Question  Select Best Answer

Which processes will run when we take online backup?

narendra05

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

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

Answer Question  Select Best Answer

Is it possible to take backup of catalog database using RMAN? If Yes, How?

slavaostapenko

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

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

Answer Question  Select Best Answer