Home » RDBMS Server » Backup & Recovery » Backup & Recovery - RMAN
Backup & Recovery - RMAN [message #57290] Mon, 02 June 2003 20:21 Go to next message
Ramesh Viswanathan
Messages: 9
Registered: May 2003
Junior Member
In my company we have Oracle Parallel Server 8.1.7 running under ibm aix. The database in a raw partition (RAID area) in aix and the database is running in NOARCHIVELOG mode.

Can we use RMAN for online backup and restoration when there is noarchivelog mode? if so what is the steps to be followed? any useful links to know in detail about RMAN...!!


Re: Backup & Recovery - RMAN [message #57294 is a reply to message #57290] Tue, 03 June 2003 01:25 Go to previous messageGo to next message
Messages: 81
Registered: October 2002
no hope of doing online backups without archivelogs.

Your only options without archivelogs are exports or cold backups.

Might be worth enabling archive logging ;-)
Re: Backup & Recovery - RMAN [message #57344 is a reply to message #57290] Fri, 06 June 2003 17:03 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
You cannot backup online db in noarchivelog mode, because you will not get consistent backup set. You have to shutdown the db and then use RMAN to backup the db. Example:

shutdown immediate;

startup force dba;
shutdown immediate;

startup mount;
run {
# duplex the backup
set duplex = 2;

# allocate channel t1 type 'SBT_TAPE';
# allocate channel t2 type 'SBT_TAPE';
allocate channel t1 type disk;
allocate channel t2 type disk;

set limit channel t1 kbytes 2097150;
set limit channel t2 kbytes 2097150;

incremental level 0
filesperset 5

alter database open;

More information about setting up RMAN, backup scripts and procedures can be found Here

Hope that helps,


Visit our Web site

Previous Topic: what are EBU and RMAN
Next Topic: Closed Backup Error
Goto Forum:

Current Time: Fri Jun 02 06:43:41 CDT 2023