-
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
-
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
....
....
}
-
How are you connecting to your target and catalog databases? Is this for 8.0 or 8i?
D.
-
I am connecting to the database via the command
rman80 sys/password
the version of oracle is 8.0.5
Vinay
-
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.
-
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.