Oracle database backup and recovery

Email Alerts

Register now to receive SearchOracle.com-related news, tips and more, delivered to your inbox.
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

  • Opening a database with a missing datafile

    Can you tell me the procedure to open a database that has a missing datafile because of deletion? The database is in noarchivelog mode, there's not any backup and the version is 10g Release 2.  Ask the Expert

  • Are records inserted during backup?

    The user_data tablespace is in backup. Some users are going to insert records. Is the data inserted and if it is inserted, then how?  Ask the Expert

  • Upgrading Sun OS with Oracle9i

    We have Oracle9i Enterprise Edition running on Sun OS 5.7. We are going to upgrade to Sun OS 10 with Oracle9i Standard Edition. Could you tell me the procedure?  Ask the Expert

  • SCN entries in controlfile during database crash

    While taking an RMAN backup, if the DB crashes, will the entry in the controlfile be removed? If yes, when will it be removed?  Ask the Expert

  • Cloning database with hot backup

    Can you please give me the steps to clone the database using a hot backup?  Ask the Expert

  • Restoring tablespace on another instance and another server

    We are trying to take a backup of a tablespace (nuiop.dbf) from an instance nedb1. I want to restore this tablespace onto another instance (nedb2) running on another server.  Ask the Expert

  • Moving temp tablespace and temp file in 10g

    I have done some relocation jobs of data files on Oracle 8i before. But in Oracle 10g, how could you deal with the TEMP tablespace and its temp file?  Ask the Expert

  • Tools to migrate/export data from 8i to 10g

    I have to migrate or export data from Oracle 8i to Oracle 10g. The size of the data is approximately 80GB. Are there any front-end tools or other technology that can help me do this?  Ask the Expert

  • Auditing or tracking changes in Oracle 10g

    Is there a way to audit or track changes to an Oracle 10g database? I need to find out who makes changes to users, tables or anything at all.  Ask the Expert

  • Two catalog databases for primary and standby?

    Is creating two catalog databases for primary and standby the proper option, or should I keep a backup of the primary and standby databases on one catalog database?  Ask the Expert

Back to top