Q
Problem solve Get help with specific problems with your technologies, process and projects.

RMAN commands for Oracle 8i

I have created an RMAN catalog database (8.1.7.0.0) and have registered a target db (8.1.7.4). I did this mostly with information from a 9i RMAN book and the web, which is mostly 9i and 10g info. I can connect to the catalog and the target from my catalog server but now am trying to find out how to configure the catalog and run a backup. The RMAN commands that I have found do not work.

I have created an RMAN catalog database (8.1.7.0.0) and have registered a target db (8.1.7.4). I did this mostly with information from a 9i RMAN book and the web, which is mostly 9i and 10g info. I can connect to the catalog and the target from my catalog server but now am trying to find out how to configure the catalog and run a backup. The RMAN commands that I have found do not work. Could you tell me how to do this?
There have been many changes in RMAN in the 9i and 10g versions. In 10g, you can simply say "backup database" and be done with it. Your Oracle 8i RMAN version simply needs the correct syntax to be able to backup your database. And you'll have to explicitly allocate a channel to denote your backup destination. A sample RMAN command to backup your entire database to tape looks like the following:

run { 
     allocate channel ch1 type 'sbt_tape';
     backup database
     format '/oracle/backup/%U';  # %U generates a unique filename }

I would recommend reading the Oracle 8i Recovery Manager User's Guide for more information. You can find a copy, complete with many backup and recovery examples with RMAN, here:

http://oraclesvca2.oracle.com/docs/cd/A87860_01/doc/server.817/a76990/toc.htm

Dig Deeper on Oracle database backup and recovery

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close