Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

If we issue alter database begin backup. What happens to database?

Question Posted / kittu_chintu2005

Answers were Sorted based on User's Feedback



If we issue alter database begin backup. What happens to database?..

Answer / raj

it locks the header #SCN number of the datafiles and
datafiles will be updated continuously.
If the db is coming out from begin backup mode it updates
the header #SCN number.

Is This Answer Correct ?    16 Yes 1 No

If we issue alter database begin backup. What happens to database?..

Answer / kittu_chintu2005

It freezes the entire database and it won’t take any transaction to datafile then excessive redologs generates.

Is This Answer Correct ?    5 Yes 2 No

Post New Answer

More DB Administration Interview Questions

hi, how can i check all backups are exist to restore? I.e. i forget to take backup on one day. But now i want to check that all backups are there to restore now. I know the answer of through timestamps we know how to check. But i need any other way?

1 Answers  

Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog

4 Answers  

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

0 Answers  

Give two methods you could use to determine what DDL changes have been made.

2 Answers  

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

0 Answers  

what is the role of dip user in our database?

0 Answers  

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

0 Answers  

what is ora 24313?what is the procedure to exclude that error?

0 Answers  

how will you see when the database was started using sql prompt?

2 Answers   IBM,

one datafile is lost in standy side how can you recover that??

2 Answers  

What the different types of replication and why are they used? : sql server DBA

0 Answers  

what is meant by gateway

1 Answers   IBM,

For more DB Administration Interview Questions Click Here
Categories