Can Full Backup be performed when the database is open ?

Can Full Backup be performed when the database is
open ?
by

1 Answer

Answer :

No.
by

Related questions

How does one backup a database using the export utility? (for DBA

Description : How does one backup a database using the export utility? (for DBA

Last Answer : Oracle exports are "logical" database backups (not physical) as they extract data and logical definitions from the database into a file. Other backup strategies normally back-up the physical data ... exports include more information about the database in the export file than user level exports.

Why and when should I backup my database? (for DBA

Description : Why and when should I backup my database? (for DBA

Last Answer : Backup and recovery is one of the most important aspects of a DBAs job. If you lose your company's data, you could very well lose your job. Hardware and software can always be ... things that will get you. Most failed recoveries are a result of organizational errors and miscommunications.

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

Description : You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

Last Answer : I would create a text based backup control file, stipulating where on disk all the data files where and then issue the recover command with the using backup control file clause.

My database was terminated while in BACKUP MODE, do I need to recover? (for DBA

Description : My database was terminated while in BACKUP MODE, do I need to recover? (for DBA

Last Answer : If a database was terminated while one of its tablespaces was in BACKUP MODE (ALTER TABLESPACE xyz BEGIN BACKUP;), it will tell you that media recovery is required when you try to restart the ... : ALTER DATABASE END BACKUP; The above commands need to be issued when the database is mounted.

How does one backup a database using RMAN? (for DBA

Description : How does one backup a database using RMAN? (for DBA

Last Answer : The biggest advantage of RMAN is that it only backup used space in the database. Rman doesn't put tablespaces in backup mode, saving on redo generation overhead. RMAN will re-read database ... directly to tape. Alternatively one can backup to disk and then manually copy the backups to tape.

Is it possible to backup your database without the use of an RMAN database to store the catalog?

Description : Is it possible to backup your database without the use of an RMAN database to store the catalog?

Last Answer : Yes, but the catalog would be stored in the controlfile.

What is Full Backup ?

Description : What is Full Backup ?

Last 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

What command would you use to create a backup control file?

Description : What command would you use to create a backup control file?

Last Answer : Alter database backup control file to trace.

Explain the difference between a hot backup and a cold backup and the benefits associated with each.

Description : Explain the difference between a hot backup and a cold backup and the benefits associated with each.

Last Answer : A hot backup is basically taking a backup of the database while it is still up and running and it must be in archive log mode. A cold backup is taking a backup of the database while it is ... and thus there will be a slight performance gain as the database is not cutting archive logs to disk.

What utility is used to create a physical backup?

Description : What utility is used to create a physical backup?

Last Answer : Either rman or alter tablespace begin backup will do..

What is cold backup? What are the elements of it?

Description : What is cold backup? What are the elements of it?

Last Answer : Cold backup is taking backup of all physical files after normal shutdown of database. We need to take. - All Data files. - All Control files. - All on-line redo log files. - The init.ora file (Optional)

What is a logical backup?

Description : What is a logical backup?

Last Answer : Logical backup involves reading a set of database records and writing them into a file. Export utility is used for taking backup and Import utility is used to recover from backup.

What is hot backup and how it can be taken?

Description : What is hot backup and how it can be taken?

Last Answer : Taking backup of archive log files when database is open. For this the ARCHIVELOG mode should be enabled. The following files need to be backed up. All data files. All Archive log, redo log files. All control files.

Does Oracle write to data files in begin/hot backup mode? (for DBA

Description : Does Oracle write to data files in begin/hot backup mode? (for DBA

Last Answer : Oracle will stop updating file headers, but will continue to write data to the database files even if a tablespace is in backup mode.In backup mode, Oracle will write out complete changed blocks ... ). Because of this, one should notice increased log activity and archiving during on-line backups.

How does one backup archived log files? (for DBA

Description : How does one backup archived log files? (for DBA

Last Answer : One can backup archived log files using RMAN or any operating system backup utility. Remember to delete files after backing them up to prevent the archive log directory from filling up. If the ... oracle/arch_backup/log_t%t_s%s_p%p' 5> (archivelog all delete input); 6> release channel dev1; 7> }

What is Partial Backup ?

Description : What is Partial Backup ?

Last Answer : A Partial Backup is any operating system backup short of a full backup, taken while the database is open or shut down.

What is cold backup and hot backup (in case of Oracle)?

Description : What is cold backup and hot backup (in case of Oracle)?

Last Answer : ∙ Cold Backup: It is copying the three sets of files (database files, redo logs, and control file) when the instance is shut down. This is a straight file copy, usually from the disk ... was done. The database is restored to the most consistent state without any loss of committed transactions.

Name two utilities that Oracle provides, which are use for backup and recovery.

Description : Name two utilities that Oracle provides, which are use for backup and recovery.

Last Answer : Along with the RDBMS software, Oracle provides two utilities that you can use to back up and restore the database. These utilities are Export and Import. The Export utility dumps the definitions and data ... best you can do is recover the database to the time when the export was last performed.

How does one manage Oracle database users? (for DBA

Description : How does one manage Oracle database users? (for DBA

Last Answer : Oracle user accounts can be locked, unlocked, forced to choose new passwords, etc. For example, all accounts except SYS and SYSTEM will be locked after creating an Oracle9iDB database using the DB ... locked users account ALTER USER scott PASSWORD EXPIRE; -- Force user to choose a new password

How does one manage Oracle database users? (for DBA

Description : How does one manage Oracle database users? (for DBA

Last Answer : Oracle user accounts can be locked, unlocked, forced to choose new passwords, etc. For example, all accounts except SYS and SYSTEM will be locked after creating an Oracle9iDB database using the ... from SYS.V$BH log buffer spaces Increase LOG_BUFFER parameter or move log files to faster disks

What strategies are available for backing-up an Oracle database? (for DBA

Description : What strategies are available for backing-up an Oracle database? (for DBA

Last Answer : The following methods are valid for backing-up an Oracle database: Export/Import - Exports are "logical" database backups in that they extract logical definitions and data from the database to a file. ... , etc. If your database is in ARCGIVELOG mode, you also need to backup archived log files.

What are the roles and user accounts created automatically with the database?

Description : What are the roles and user accounts created automatically with the database?

Last Answer : DBA - role Contains all database system privileges. SYS user account - The DBA role will be assigned to this account. All of the base tables and views for the database's dictionary ... administrative information and internal tables and views used by oracle tools are created using this username.

What are the responsibilities of a Database Administrator ?

Description : What are the responsibilities of a Database Administrator ?

Last Answer : Installing and upgrading the Oracle Server and application tools. Allocating system storage and planning future storage requirements for the database system. Managing primary database structures ... tape Backing up and restoring the database. Contacting Oracle Corporation for technical support.

How does one create a standby database? (for DBA)

Description : How does one create a standby database? (for DBA)

Last Answer : While your production database is running, take an (image copy) backup and restore it on duplicate hardware. Note that an export will not work!!! On your standby database, issue ... the standby database, stop the recovery process and activate it: ALTER DATABASE ACTIVATE STANDBY DATABASE;

Name two files used for network connection to a database.

Description : Name two files used for network connection to a database.

Last Answer : TNSNAMES.ORA and SQLNET.ORA

When creating a user, what permissions must you grant to allow them to connect to the database?

Description : When creating a user, what permissions must you grant to allow them to connect to the database?

Last Answer : Grant the CONNECT to the user.

Name a tablespace automatically created when you create a database.

Description : Name a tablespace automatically created when you create a database.

Last Answer : The SYSTEM tablespace.

How would you determine the time zone under which a database was operating?

Description : How would you determine the time zone under which a database was operating?

Last Answer : select DBTIMEZONE from dual;

Where would you look for errors from the database engine?

Description : Where would you look for errors from the database engine?

Last Answer : In the alert log.

What is network database link?

Description : What is network database link?

Last Answer : Network database link is created and managed by a network domain service. A network database link can be used when any user of any database in the network specifies a global object name in a SQL statement or object definition.

What is public database link?

Description : What is public database link?

Last Answer : Public database link is created for the special user group PUBLIC. A public database link can be used when any user in the associated database specifies a global object name in a SQL statement or object definition.

What is private database link?

Description : What is private database link?

Last Answer : Private database link is created on behalf of a specific user. A private database link can be used only when the owner of the link specifies a global object name in a SQL statement or in the definition of the owner's views or procedures.

What are the types of database links?

Description : What are the types of database links?

Last Answer : Private database link, public database link & network database link.

What is Database Link ?

Description : What is Database Link ?

Last Answer : A database link is a named object that describes a "path" from one database to another.

What are the steps involved in Database Shutdown ?

Description : What are the steps involved in Database Shutdown ?

Last Answer : Close the Database, Dismount the Database and Shutdown the Instance.

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode ?

Description : What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode ?

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

What are the different modes of mounting a Database with the Parallel Server ?

Description : What are the different modes of mounting a Database with the Parallel Server ?

Last Answer : Exclusive Mode If the first instance that mounts a database does so in exclusive mode, only that Instance can mount the database. Parallel Mode If the first instance that mounts a database is started in parallel mode, other instances that are started in parallel mode can also mount the database.

What are the steps involved in Database Startup ?

Description : What are the steps involved in Database Startup ?

Last Answer : Start an instance, Mount the Database and Open the Database. Rolling forward to recover data that has not been recorded in data files, yet has been recorded in the on-line redo ... Resolving any pending distributed transactions undergoing a two- phase commit at the time of the instance failure.

Can you store pictures in database? How?

Description : Can you store pictures in database? How?

Last Answer : Yes , in long Raw datatype.

Can U disable database trigger? How?

Description : Can U disable database trigger? How?

Last Answer : Yes. With respect to table ALTER TABLE TABLE [[ DISABLE all_trigger ]]

Who created all these users in my database?/ Can I drop this user? (for DBA

Description : Who created all these users in my database?/ Can I drop this user? (for DBA

Last Answer : Oracle creates a number of default database users or schemas when a new database is created. Below are a few of them: SYS/CHANGE_ON_INSTALL or INTERNAL Oracle Data Dictionary/ Catalog Created ... there should be no problem altering these users to use a different default and temporary tablespace.

How does one create and drop database users?

Description : How does one create and drop database users?

Last Answer : Look at these examples: CREATE USER scott IDENTIFIED BY tiger -- Assign password DEFAULT TABLESACE tools -- Assign space for table and index segments TEMPORARY TABLESPACE temp; -- Assign sort space ... give the user some space quota on its tablespaces: ALTER USER scott QUOTA UNLIMITED ON tools;

What are Database Triggers and Stored Procedures

Description : What are Database Triggers and Stored Procedures

Last Answer : Database Triggers :: Database Triggers are Procedures that are automatically executed as a result of insert in, update to, or delete from table. Database triggers have the values old and new to ... procedures is that many users can use the same procedure in compiled and ready to use format.

What is a database link ?

Description : What is a database link ?

Last Answer : Database Link is a named path through which a remote database can be accessed.

Difference between database triggers and form triggers?

Description : Difference between database triggers and form triggers?

Last Answer : Data base trigger(DBT) fires when a DML operation is performed on a data base table. Form trigger(FT) Fires when user presses a key or navigates between fields on the screen -Can be row ... other database triggers to fire.Can cause other database triggers to fire, but not other form triggers.

Can you use a commit statement within a database trigger?

Description : Can you use a commit statement within a database trigger?

Last Answer : No

What are different Oracle database objects?

Description : What are different Oracle database objects?

Last Answer : TABLES -VIEWS INDEXES -SYNONYMS -SEQUENCES -TABLESPACES etc

What is Database Trigger ?

Description : What is Database Trigger ?

Last Answer : A Database Trigger is procedure (set of SQL and PL/SQL statements) that is automatically executed as a result of an insert in,update to, or delete from a table.

What are the uses of Database Trigger ?

Description : What are the uses of Database Trigger ?

Last Answer : Database triggers can be used to automatic data generation, audit data modifications, enforce complex Integrity constraints, and customize complex security authorizations.

What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

Description : What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

Last Answer : Procedures and Functions,Packages and Database Triggers.