Rman

[vinay_p]

Hi All

I am using rman scripts to backup my database but everytime I run my script I get the following error. any ideas.

RMAN> run {
2> #backup the database to disk
3> allocate channel d1 type disk;
4> backup
5> full
6> tag full_db
7> format '/backups/db_%t_%s_p%p'
8> (database);
9> release channel d1;
10> }

RMAN-03022: compiling command: allocate
RMAN-03026: error recovery releasing channel resources
RMAN-00569: ================error message stack follows================
RMAN-06004: ORACLE error from recovery catalog database: ORA-01012: not logged o
n
RMAN-03002: failure during compilation of command
RMAN-03013: command type: allocate
RMAN-06004: ORACLE error from recovery catalog database: ORA-01012: not logged o
n

RMAN>


Thanks Vinay

[raghucharan]

I think there is # with the command backup , is it typo mistake or it is really in the script,another thing there wont be any command like 'backup the database' it should be 'backup database',if it is preceded by # I think it is commented.U already allocated the channel to disk why again specifying the disk type with backup command.
{
Allocate channel c1 type disk;
backup database
....
....
}

[DBAtrix]

How are you connecting to your target and catalog databases? Is this for 8.0 or 8i?

D.

[vinay_p]

I am connecting to the database via the command
rman80 sys/password

the version of oracle is 8.0.5

Vinay

[dragon99]

It seems that you did not connect to recovery catalog.
If you ever created recovery catalog, you need to connect to both target database and the database your recovery catalog resides. I am using Oracle 8.1.5, it works fine for me.

[DBAtrix]

Have you tried something like the following?

rman80 rcvcat rman/rman@rmandb target sys/password
-- or --
rman80 rcvcat rman/rman@rmandb
RMAN> connect target

The key to be sure to indicate your catalog database with "rcvcat"
For these examples, your target database is local. $ORACLE_SID (for UNIX) must be set as well for the target.

D.