Ask the Expert

Taking a full offline backup

One of my clients is using Oracle and operating system windows NT 4.0. I have taken logical export (exp80,f= y) of the database, and now I want to take full offline backup through Oracle.

I just want to know what RMAN command will work on Oracle We cannot use Oracle Enterprise Manager because we have lost the password for that.

Are there any other tools or ways to take a complete offline backup through Oracle ?

    Requires Free Membership to View

In Oracle 8.0, I would recommend shutting down the database with IMMEDIATE or NORMAL. Then use OS utilities to backup the database's datafiles, control files, online redo logs, and parameter files. I was not a fan of RMAN in 8.0 so I would still use user-managed backups for that version.

This was first published in January 2008

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
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
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: