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

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

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

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

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