I have archived logs that come out in the following format
-bash-3.2$ ls /archlog1/BB60
1_253772_786457154.arc 1_253823_786457154.arc 1_253874_786457154.arc 1_253925_786457154.arc 1_253976_786457154.arc
1_253773_786457154.arc 1_253824_786457154.arc 1_253875_786457154.arc 1_253926_786457154.arc 1_253977_786457154.arc
I want to use RMAN to back these up and retain the same filenames for the backed up files.
I'm thinking something like:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/archlog2/BB60/archlogbackup/%...%...
How do I find out how to do that?
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime? I'm talking things like:
* Dropping columns
* Shrinking allocated space
* Removing chained blocks and restoring the PCTFREE
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.