• October 02, 2006 02 Oct'06

    Performing full backup without all archivelogs

    I support an Oracle 10g database on an AIX server and some of the older archivelogs were mistakenly deleted before they were backed up. I want to take a full backup that I can restore the database to this point if there's a failure of some sort. ...  Continue Reading

  • October 02, 2006 02 Oct'06

    Creating an RMAN catalog

    I have created the RMAN database and the rman/rman user. I created the tablespace. Not too clear about the catalog. Do I need to run a script or package to create a catalog? Once the catalog is created, what are the next steps?  Continue Reading

  • October 02, 2006 02 Oct'06

    Full export with sys and sys object errors

    I made a full export on an Oracle 9i database and created a database on a different machine with a different name. When I tried to make the full import I had lots of errors, especially at the sys and sys objects. What should I do?  Continue Reading

  • October 02, 2006 02 Oct'06

    Full import/export from database with different name

    How do I make full import into a database using full export from a database with a different name?  Continue Reading

  • October 02, 2006 02 Oct'06

    Taking full backup with Toad

    Can you please tell me how to take a backup of a database? I am using Toad, but Toad has options to take each component (like tablespace, table data) backup separately while I need the backup of the whole database. Can you send me the script, if we ...  Continue Reading