OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » Rman Backup (Rman Backup without archive log list)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Rman Backup [message #275690]

Mon, 22 October 2007 06:36

subash_dev
Messages: 1
Registered: October 2007
Location: New Delhi

Junior Member

Can we take the RMAN backup if the database is in no archive log mode? If it is possible how. If not why.

Thanks & Regards,
Subash.

Report message to a moderator

Re: Rman Backup [message #275693 is a reply to message #275690]

Mon, 22 October 2007 06:57

Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Yes it is possible.
Follow the documentation.

Regards
Michel

Report message to a moderator

Re: Rman Backup [message #275750 is a reply to message #275693]

Mon, 22 October 2007 10:26

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Quote:

? If it is possible how. If not why.

Yes normal shutdown then start up mount ...and put your backup command.

Report message to a moderator

Re: Rman Backup [message #275780 is a reply to message #275690]

Mon, 22 October 2007 11:47

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

C:\> set ORACLE_SID=sidname
C:\> rman TARGET=SYS

RMAN> run
{
#shutdown database and startup with mount mode for backup.
shutdown immediate;
startup mount;
#perform full database backup
backup database;
#open database for normal use
sql 'alter database open';
#backup current controlfile
backup current controlfile;
sql 'alter database backup controlfile to TRACE';
}

Report message to a moderator