Re: Problem with Recovery Manager?!

From: Yass Khogaly <ykhogaly_at_us.oracle.com>
Date: Sun, 21 Nov 1999 06:14:10 -0800
Message-ID: <818r3k$ip5$1@inet16.us.oracle.com>

Assumptions for the examples below:
TARG is the instance name for the Target database to be backed up. RCAT represents the home directory of the Recovery Catalog.

Do not include the Recovery Catalog in the database that is being backed up. Because, in the event of a Target database failure, the Recovery Catalog will not be available.

To Create and configure an RMAN user:

I. Create Tablespace, Create RMAN User, Grant RMAN Rights in Recovery Database

1. Start SVRMGR30
2. CONNECT INTERNAL/pwd_at_rcat_alias
3. CREATE TABLESPACE RCVCAT DATAFILE 'c:\orant\dataqbase\rcv1rcat.ora' SIZE 10M AUTOEXTEND ON NEXT 5M MAXSIZE 50M;
4. SPOOL create_rman.log
5. CREATE USER rman IDENTIFIED BY rman TEMPORARY TABLESPACE temporary DEFAULT TABLESPACE rcvcat QUOTA UNLIMITED ON rcvcat;
6. GRANT RECOVERY_CATALOG_OWNER TO rman;
   • IMPORTANT NOTE * It is very important that the quota on rcvcat be unlimited else you will receive "unable to create file" errors.
7. CONNECT rman/rman_pwd_at_rcat_alias
8. @%ORACLE_HOME\rdbms80\admin\catrman.sql

  This generates the tables, views and procedures needed for RMAN   and the recovery catalog.

II. Register Database

1. RMAN80 TARGET internal/targ_pwd_at_targ_alias RCVCAT rman/rman_pwd_at_rcat_alias
   • IMPORTANT NOTE * This command is to be typed all on one line.
2. REGISTER DATABASE

III. Add RMAN user to Target Database with DBA or SYSDBA role.

1. Start SVRMGR30
2. CONNECT INTERNAL/targ_passwd_at_targ_alias
3. GRANT SYSDBA TO rman;

"The Views expressed here are my own and not necessarily those of Oracle Corporation"

<ibm_97_at_yahoo.com> wrote in message news:814277$vmj$1_at_nnrp1.deja.com...
> Oracle 8i and OEM 2.0.4 for Solaris Sparc. ORACLE_HOME is
> /u01/app/oracle/product/8.1.5 And OEM is in /u01/app/oracle/product/oem
>
> Try to create revovery catalog. First create 'recover' tablespace with
> 100MB and a recovery user 'rman', then 'grant recovery_catalog_owner' to
> 'rman'. Finally according to the manual, I issue:
>
> rman recover rman/<pass_of_rman>@<service_name>
>
> The error message is:
>
>
> Argument Value Description
> ------------------------------------------------------------------------
> -----
> target quoted-string connect-string for target database
> rcvcat quoted-string connect-string for recovery catalog
> debug none if specified, activate debugging mode
> cmdfile quoted-string name of input command file
> msglog quoted-string name of output message log file
> trace quoted-string name of output debugging message log file
> append none if specified, msglog opened in append mode
> nocatalog none if specified, then no recovery catalog
> ------------------------------------------------------------------------
> -----
> Both single and double quotes (' or ") are accepted for a quoted-string.
> Quotes are not required unless the string contains embedded white-space.
>
> RMAN-00571: ===========================================================
> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
> RMAN-00571: ===========================================================
> RMAN-00552: syntax error in command line arguments
> RMAN-01005: syntax error: found "recover": expecting one of: "append,
> at, auxiliary, catalog, cmdfile, clone, debug, log, msglog, mask, msgno,
> nocatalog, pipe, rcvcat, slaxdebug, send, target, timeout, trace"
> RMAN-01007: at line 2 column 1 file: command line arguments
>
>
> What's wrong? I have no idea at all. Because there's so little help.
>
> Thanks!
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sun Nov 21 1999 - 08:14:10 CST