* Create directory login as Root user
mkdir /nas_dbbkp_vol07
*mount storage volume
mount 10.1.1.182 : /vol07 /nas_dbbkp_vol07
Same like df -k command output show below
Dream it | Work it | Make it : - Real-world Cloud DBA troubleshooting guides covering RAC, Data Guard, RMAN, performance tuning, AWR analysis, cloud migration, PostgreSQL , AI Database, Linux | Enterprise database architecture secrets revealed.
I am Anurag Pandey, working as Cloud Database Architect | Cloud Migration and Modernization Expert .Database Administration and Implementation. Provide technical guidance and work with global team. Extensive Experience in Database Installation and Configuration, Real Application Cluster (RAC), ASM, Dataguard , Patching, Upgrade, RMAN, Performance Tuning, Backup and Recovery, Azure, Google, AWS Cloud, AWS RDS, MySQL, Database Migration Service(DMS),CloudEndure - MGN, Azure Site Recovery, Azure Migrate, Datapump, terraform automation, Ansible, Audit, Email - anuragkumarjoy@gmail.com
Anurag Pandey is a Database Architect with expertise in Oracle, PostgreSQL, SQL Server, Linux, and enterprise database platforms and specializes in database architecture, performance tuning, high availability, disaster recovery, cloud modernization, and operational excellence. With extensive experience in enterprise-scale environments, Anurag is passionate about leveraging AI, automation, and modern data platforms to improve reliability, scalability, and business outcomes. He actively contributes to technical communities through knowledge sharing, architecture guidance, and thought leadership in database and data engineering domains.
Follow more articles at
Visit Blog
hastatus -summary – Outputs the status of clusterhasys -display – Displays the cluster operation statushastart [-force|-stale] – ‘force’ is used to load local configurationhasys -force 'system' – start the cluster using config file from the mentioned “system”hastop -local [-force|-evacuate] – ‘local’ option will stop the service only on the system you type the commandhastop -sys 'system' [-force|-evacuate] – ‘sys’ stops had on the system you specifyhastop -all [-force] – ‘all’ stops had on all systems in the clusterhaconf -makerw – makes VCS configuration in read/write modehaconf -dump -makero – Dumps the configuration changeshaagent -start agent_name -sys system – Starts an agenthaagent -stop agent_name -sys system – Stops an agenthaclus -display – Displays cluster information and statushaclus -enable LinkMonitoring – Enables heartbeat link monitoring in the GUIhaclus -disable LinkMonitoring – Disables heartbeat link monitoring in the GUIhauser -add user_name – Adds a user with read/write accesshauser -add VCSGuest – Adds a user with read-only accesshauser -modify user_name – Modifies a users passwordhauser -delete user_name – Deletes a userhauser -display [user_name] – Displays all users if username is not specifiedhasys -list – List systems in the clusterhasys -display – Get detailed information about each systemhasys -add system – Add a system to clusterhasys -delete system – Delete a system from clusterhatype -list – List resource typeshatype -display [type_name] – Get detailed information about a resource typehatype -resources type_name – List all resources of a particular typehatype -add resource_type – Add a resource typehatype -modify .... – Set the value of static attributeshatype -delete resource_type – Delete a resource typehares -list – List all resourceshares -dep [resource] – List a resource’s dependencieshares -display [resource] – Get detailed information about a resourcehares -add resource_type service_group – Add a resourcehares -modify resource attribute_name value – Modify the attributes of the new resourcehares -delete resource – Delete a resource typehares -online resource -sys systemname – Online a resource, typehares -offline resource -sys systemname – Offline a resource, typehares -probe resource -sys system – Cause a resource’s agent to immediately monitor the resource on a particular systemhares -clear resource [-sys system] – Clear a faulted resourcehares -local resource attribute_name value – Make a resource’s attribute value localhares -global resource attribute_name value – Make a resource’s attribute value globalhares -link parent_res child_res – Specify a dependency between two resourceshares -unlink parent_res child_res – Remove the dependency relationship between two resourceshagrp -list – List all service groupshagrp -resources [service_group] – List a service group’s resourceshagrp -dep [service_group] – List a service group’s dependencieshagrp -display [service_group] – Get detailed information about a service grouphagrp -online groupname -sys systemname – Start a service group and bring it resourceshagrp -offline groupname -sys systemname – Stop a service group and take it resources offlinehagrp -switch groupname -to systemname – Switch a service group from one system to anotherhagrp -freeze -sys -persistent – Gets into Maintenance Mode. Freeze a service group. This will disable online and offline operationshagrp -unfreeze -sys -persistent] – Take the servicegroup out of maintenance modehagrp -enable service_group [-sys system] – Enable a service grouphagrp -disable service_group [-sys system] – Disable a service grouphagrp -enableresources service_group – Enable all the resources in a service grouphagrp -disableresources service_group – Disable all the resources in a service grouphagrp -link parent_group child_group relationship – Specify the dependency relationship between two service groupshagrp -unlink parent_group child_group – Remove the dependency between two service groups
I am Anurag Pandey, working as Cloud Database Architect | Cloud Migration and Modernization Expert .Database Administration and Implementation. Provide technical guidance and work with global team. Extensive Experience in Database Installation and Configuration, Real Application Cluster (RAC), ASM, Dataguard , Patching, Upgrade, RMAN, Performance Tuning, Backup and Recovery, Azure, Google, AWS Cloud, AWS RDS, MySQL, Database Migration Service(DMS),CloudEndure - MGN, Azure Site Recovery, Azure Migrate, Datapump, terraform automation, Ansible, Audit, Email - anuragkumarjoy@gmail.com
Anurag Pandey is a Database Architect with expertise in Oracle, PostgreSQL, SQL Server, Linux, and enterprise database platforms and specializes in database architecture, performance tuning, high availability, disaster recovery, cloud modernization, and operational excellence. With extensive experience in enterprise-scale environments, Anurag is passionate about leveraging AI, automation, and modern data platforms to improve reliability, scalability, and business outcomes. He actively contributes to technical communities through knowledge sharing, architecture guidance, and thought leadership in database and data engineering domains.
Follow more articles at
Visit Blog
APPLY ONLY NON-SYSTEM TABLESPACE OR TEMP TABLESPACE
SQL> alter tablespace test offline; Tablespace altered. SQL>
first u copy datafile to another location
SQL> ! cp /u02/app/oracle/oradata/test/test.dbf /u02/app/oracle/oradata/orcl/test.dbfSQL>alter database rename file '/u02/app/oracle/oradata/test/test.dbf' to '/u02/app/oracle/oradata/orcl/test.dbf';SQL> alter tablespace test online; Tablespace altered.if working properly then delete old file from/u02/app/oracle/oradata/test/test.dbf location........
I am Anurag Pandey, working as Cloud Database Architect | Cloud Migration and Modernization Expert .Database Administration and Implementation. Provide technical guidance and work with global team. Extensive Experience in Database Installation and Configuration, Real Application Cluster (RAC), ASM, Dataguard , Patching, Upgrade, RMAN, Performance Tuning, Backup and Recovery, Azure, Google, AWS Cloud, AWS RDS, MySQL, Database Migration Service(DMS),CloudEndure - MGN, Azure Site Recovery, Azure Migrate, Datapump, terraform automation, Ansible, Audit, Email - anuragkumarjoy@gmail.com
Anurag Pandey is a Database Architect with expertise in Oracle, PostgreSQL, SQL Server, Linux, and enterprise database platforms and specializes in database architecture, performance tuning, high availability, disaster recovery, cloud modernization, and operational excellence. With extensive experience in enterprise-scale environments, Anurag is passionate about leveraging AI, automation, and modern data platforms to improve reliability, scalability, and business outcomes. He actively contributes to technical communities through knowledge sharing, architecture guidance, and thought leadership in database and data engineering domains.
Follow more articles at
Visit Blog
Oracle Database Deep Health Check Checklist Recommended assessment levels Level Purpose Typical scope L1 Operational health Availability, sp...