Home » RDBMS Server » Backup & Recovery » cold backup with RMAN
cold backup with RMAN [message #132396] Fri, 12 August 2005 09:38 Go to next message
alanm
Messages: 284
Registered: March 2005
Senior Member

I have a database instance in noarchivelog mode. how do I backup this database using RMAN? Does anyone have an example script that I could use?

best regards


Alan
Re: cold backup with RMAN [message #132397 is a reply to message #132396] Fri, 12 August 2005 09:40 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmbackp.htm#435660
Re: cold backup with RMAN [message #132402 is a reply to message #132397] Fri, 12 August 2005 10:23 Go to previous messageGo to next message
alanm
Messages: 284
Registered: March 2005
Senior Member

hi,
thanks for that
i have done the following

replace script 'rman_daily_backup' {
shutdown immediate;
startup mount;
allocate channel dev1 type disk format '/images/rman_%s.bak';
backup database include current controlfile;
alter database open;
release channel dev1;
}

when I run this script however, I get the following error

RMAN-03022: compiling command: allocate
RMAN-03026: error recovery releasing channel resources
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03015: error occurred in stored script rman_daily_backup
RMAN-03002: failure during compilation of command
RMAN-03013: command type: allocate
RMAN-06004: ORACLE error from recovery catalog database: ORA-03113: end-of-file on communication channel
RMAN-06097: text of failing SQL statement: begin dbms_rcvman . resetAll ; :success := dbms_rcvman . SUCCESS ; :av
RMAN-06099: error occurred in source file: krmk.pc, line: 9397

any ideas what this could be caused by?

best regards


Alan.
Re: cold backup with RMAN [message #132409 is a reply to message #132402] Fri, 12 August 2005 10:39 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>RMAN-06004: ORACLE error from recovery catalog database:

Your RMAN session cannot talk to your recovery catalog.
are you having your Recovery catalog inside the target datatabase?
Hope no.
Make sure you have listner available and proper tnsentries enabled so RMAN can talk to the target database.
And first, did you do the necessary Configurations for RMAN?
post your show all output, oracle version, OS, target and recovery catalog versions.
Previous Topic: Full Method for both backup and Recovery
Next Topic: Recover a table from oracle 8i archive log mode urgent
Goto Forum:
  


Current Time: Thu Apr 18 03:26:26 CDT 2024