Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Help: RMAN problem

Help: RMAN problem

From: charlie cs <cs3526_at_ureach.com>
Date: Thu, 19 Dec 2002 00:35:07 GMT
Message-ID: <%u8M9.47410$4W1.24734@nwrddc02.gnilink.net>


We are using RedHat Linux.
We are using 9i RAC, and I am trying to use RMAN to make a single instance standby database.
I am using RMAN without catalog.
When I run
RMAN> run {

2> backup database include current controlfile for standby;
3> sql "alter system archive log current";
4> backup archivelog all;
5> }

Starting backup at 10-DEC-02
using target database controlfile instead of recovery catalog allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=25 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including standby controlfile in backupset
input datafile fno=00001 name=/dev/raw/ora_system01
input datafile fno=00002 name=/dev/raw/ora_undotbs01
input datafile fno=00003 name=/dev/raw/ora_users01
channel ORA_DISK_1: starting piece 1 at 10-DEC-02 channel ORA_DISK_1: finished piece 1 at 10-DEC-02 piece handle=/backup/rman/1rea0c9n_1_1 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:01:17 Finished backup at 10-DEC-02
Starting Control File Autobackup at 10-DEC-02 piece handle=/backup/rman/cf_c-2934970990-20021210-04 comment=NONE Finished Control File Autobackup at 10-DEC-02 sql statement: alter system archive log current Starting backup at 10-DEC-02
current log archived
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 12/10/2002 13:41:35 RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /backup/rac1/archarch_1_s.arc ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory Additional information: 3
Text continued in next action...

the archive destination is "/backup/rac1/arch/", but somehow RMAN rufuse to add one more "/" at the end. it should read "/backup/rac1/arch/arch_1_s.arc"

So I edit the init.ora, and rebouce the database, this time I add "/" at the archivelog_dest_1, as show below
SQL> select name,value from v$parameter
2 where value like '%backup%';

NAME



VALUE


log_archive_dest_1
location=/backup/rac1/arch/

But I still get the exact the same problem. Could somebody tell me what is wrong?

Thanks Received on Wed Dec 18 2002 - 18:35:07 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US