Query to find RMAN Backup status

 

col STATUS format a10

col hrs format 999.99

select SESSION_KEY, INPUT_TYPE, STATUS,to_char(START_TIME,'mm/dd/yy hh24:mi') start_time,

to_char(END_TIME,'mm/dd/yy hh24:mi') end_time,elapsed_seconds/3600 hrs from V$RMAN_BACKUP_JOB_DETAILS

order by session_key;

How to Install Python in Windows System?

 Installing Python on your computer is straightforward. Here's a step-by-step guide for different operating systems:

For Windows:

1. Download Python:

   • Go to the official Python website.
   • Click on the Download Python button (it will recommend the latest version for Windows).

2. Run the Installer:

   • Once the installer is downloaded, run the .exe file to start the installation process.
   • Important: During installation, make sure to check the box that says "Add Python to PATH" before clicking "Install Now". This step makes Python accessible from the command line.

3. Verify the Installation:

   • Open Command Prompt (you can search for "cmd" in the Start menu).
   • Type python --version or python -V and press Enter. You should see the installed Python version displayed.

Steps to Create a VCN in Oracle Cloud Infrastructure

 

1. Log into Oracle Cloud Console.
2. Go to Networking → Virtual Cloud Networks.
3. Click on Create VCN and provide a name for the VCN.
4. Choose the CIDR block for the VCN (e.g., 10.0.0.0/16).
5. Choose whether to create subnets automatically or manually.
   • You can create multiple subnets, each with different IP ranges and attributes (public/private).
6. Optionally, create an Internet Gateway, NAT Gateway, and Route Tables for routing traffic to and from the internet.
7. Configure Security Lists or NSGs to manage access to the instances within the VCN.
8. Click Create to finalize the VCN.

Use Cases for VCN:

• Secure Multi-tier Architecture: You can separate different application layers (web servers, application servers, and databases) into different subnets and control traffic flow between them using route tables and security lists.
• Hybrid Cloud: VCN allows you to securely extend your on-premises network to the cloud via VPN or DRG, enabling hybrid cloud environments.
• Private Connectivity: For sensitive applications that require private communication, a VCN can ensure that traffic remains isolated from the public internet.
• Disaster Recovery: You can use VCN in conjunction with other OCI services to set up disaster recovery scenarios with secure, private communication between regions.

Example VCN Structure:

• VCN: 10.0.0.0/16
  • Public Subnet 1: 10.0.0.0/24 (For web servers)
  • Private Subnet 1: 10.0.1.0/24 (For database servers)
  • Private Subnet 2: 10.0.2.0/24 (For internal services)
  • Internet Gateway: Connects the VCN to the internet.
  • NAT Gateway: Provides internet access to private subnet instances without exposing them to the public.