| Backup & Recovery - RMAN [message #57290] |
Mon, 02 June 2003 20:21  |
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...!!
Thanks
Ramesh
|
|
|
|
| Re: Backup & Recovery - RMAN [message #57294 is a reply to message #57290] |
Tue, 03 June 2003 01:25  |
psmyth
Messages: 81
Registered: October 2002
|
Member |
|
|
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 |
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;
backup
incremental level 0
filesperset 5
database;
}
alter database open;
More information about setting up RMAN, backup scripts and procedures can be found Here
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
