| rman in nonarchivelog [message #73294] |
Wed, 17 March 2004 11:25  |
Susan
Messages: 102
Registered: October 2001
|
Senior Member |
|
|
hi experts
when i am trying to backup tablespace with rman
its giving error the database should be archivelog mode
whether its compulsory to be in archivelog mode.or any way to run in
nonarchive log mode
with regards
susan
|
|
|
|
|
|
| Re: rman in nonarchivelog [message #73302 is a reply to message #73294] |
Thu, 18 March 2004 10:11  |
DR
Messages: 12
Registered: July 2003
|
Junior Member |
|
|
The database does not have to be in archivelog mode to use RMAN.
However, without archivelog mode, the only backup available is a cold one - database shut down. RMAN with noarchivelog mode needs the database to be in mount mode so RMAN can get to the control file.
|
|
|
|
| Re: rman in nonarchivelog [message #73312 is a reply to message #73295] |
Mon, 22 March 2004 10:24 |
DR
Messages: 12
Registered: July 2003
|
Junior Member |
|
|
RMAN can be used to backup a database in noarchivelog mode. See article copied from Metalink:
From: Oracle, Gina Thunder 10-Jun-03 23:59
Subject: Re : RMAN and NOARCHIVELOG
Hello,
1) Online backups can only be performed in archivelog mode.
2) RMAN can be used in noarchivelog mode, however, the database must be shutdown cleanly for consistency.
3) You can perform incremental backups in NOARCHIVELOG mode, but once again the database must be shutdown for consistency.
If your database is in noarchivelog mode then you can only perform cold/offline backups, regardless of the backup method.
Gina
Oracle Support Services
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
