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

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

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

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

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

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

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

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

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

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