Re: simulate rman backup

To run a backup without creating any backup files, " validate database " or "validate check logical database" .
This does exactly what a backup to /dev/null would do. Older versions required you to use the "backup validate database" instead, but the outcome is the same.
Be sure to include all the setup commands the same way as a real backup- types of channels, number of channels, backupset name syntax etc. Since this writes very little data, it simulates the read behavior of the backup, but not the full runtime of creating the backup files / backupsets.

On Fri, Jul 19, 2024 at 2:34 PM Jon Crisler <joncrisler_at_gmail.com> wrote:

> Another feature is that there is a rman directive that will parse / test
> your command without actually running it.
> For the validate database (aka backup validate) there is also the
> parameter for "logical", which does additional checks on table and index
> sanity.
> This will sometimes find errors that previously could only be found when
> doing a index validation. I will see if I can find my sample code that
> uses these features.
>
> On Fri, Jul 19, 2024 at 1:22 PM Jonathan Lewis <jlewisoracle_at_gmail.com>
> wrote:
>
>>
>> No idea if this could work, but how about creating a pipe (mknod) start
>> a process reading the pipe (e.g. wc to count bytes), then backup to the
>> pipe.
>>
>>
>> Regards
>> Jonathan Lewis
>> (From my iPad mini; please excuse typos and auto-correct)
>>
>>
>> On 19 Jul 2024, at 15:45, Laurentiu Oprea <laurentiu.oprea06_at_gmail.com>
>> wrote:
>>
>> 
>> Validate -> is there a way to run validate as compressed backupset? :)
>>
>> I tried to run with /dev/null - I tried with both disk channels format
>> /dev/null and with SBT BAKCUP_DIR=/dev/null in both situation is giving an
>> I/O error: ora-27037
>>
>> În vin., 19 iul. 2024 la 17:27, jacques kostic <jacques.kostic_at_gmail.com>
>> a scris:
>>
>>> Yes you can,
>>>
>>> Output the channel into/dev/null
>>>
>>> Jko
>>>
>>> Le 19 juillet 2024 16:13:42 Laurentiu Oprea <laurentiu.oprea06_at_gmail.com>
>>> a écrit :
>>>
>>>> Dear all,
>>>>
>>>> Out of curiosity, is there a way to simulate a rman backup run ? The
>>>> purpose will be to simulate a backup execution without actually writing any
>>>> files just to observe how big a compressed backup will be.
>>>>
>>>> Most probably officially this is not supported but anyone has any crazy
>>>> idea how to achieve this? :)
>>>>
>>>> Thank you.
>>>>
>>>
>>>

--
http://www.freelists.org/webpage/oracle-l