| RMAN hot backup with no archivelogs [message #125981] |
Thu, 30 June 2005 06:10  |
mlobel
Messages: 1
Registered: June 2005
|
Junior Member |
|
|
Hi all,
To hot back up a 9.2.0.1 database without any catalog we use the following rman script :
run {
allocate channel Channel1 type disk format '${DEST}/${ORACLE_SID}_%U_%T';
backup ( database tag 'DATA_${ORACLE_SID}_${TODAY}')
( archivelog all delete input tag 'ARCH_${ORACLE_SID}_${TODAY}');
}
and we systematically obtain the RMAN-20242 error "specification does not match any archivelog in the recovery catalog"
althought the oracle documentation says "RMAN does not signal an error if the command finds no logs to back up, because this situation probably exists because no new logs were generated after the previous BACKUP ARCHIVELOG ALL DELETE INPUT command." (http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96565/rcmsynta9.htm#1015657)
to correct this, whe have to add an "alter system switch logfile" to create at least one archivelog (note that we sometimes obtain the same error but very rarely)
Using this script :
run {
allocate channel Channel1 type disk format '${DEST}/${ORACLE_SID}_%U_%T';
backup ( database tag 'DATA_${ORACLE_SID}_${TODAY}');
backup ( archivelog all delete input tag 'ARCH_${ORACLE_SID}_${TODAY}');
}
everything's going right as specified in the oracle documentation, and adding an alter system switch logfile is not usefull anymore.
Could anyone explain this behaviour ?
Thanks for your ideas !
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
