서버 내 이미지 백업을 통한 자동화된 Oracle VLDB 복제 수명 주기
Allen Cao, Niyaz Mohamed, NetApp
이 솔루션은 퍼블릭 클라우드 플랫폼에서 사용 가능한 NetApp 클라우드 볼륨에 있는 Oracle 데이터베이스 이미지 백업 사본에서 Oracle 복제된 매우 큰 데이터베이스(VLDB)를 설정, 복제 및 새로 고치기 위한 Ansible 기반 자동화 툴킷을 제공합니다. 이 툴킷은 처음에는 Google Cloud NetApp Volumes (GCNV)를 지원하지만 Azure NetApp Files (ANF)나 Amazon FSx for ONTAP (FSxN)과 같은 다른 클라우드 볼륨을 지원하도록 확장될 수 있습니다.
목적
퍼블릭 클라우드의 서버 내 데이터베이스 이미지 백업 사본에서 Oracle VLDB용 NetApp ONTAP 볼륨의 빠른 복제(분) 기능을 활용하면 여러 가지 목적을 달성할 수 있습니다. 보고, 개발 또는 UAT 사용 사례를 위한 거의 실시간의 전체 크기 프로덕션 데이터베이스를 제공합니다. 특히 기본 데이터베이스 백업 볼륨의 씬 복제가 옵션인 경우 저장 비용이 절감됩니다. Ansible 기반 자동화 툴킷을 사용하면 사용자가 원하는 일정에 따라 복제된 Oracle 데이터베이스를 설정, 복제하고 새로 고침하여 간소화된 수명 주기 관리를 수행할 수 있습니다. 이 툴킷은 Google 퍼블릭 클라우드에 배포된 Oracle VLDB의 사용 사례를 대상으로 하며, GCNV를 서버 내 데이터베이스 백업 저장소로 사용합니다.
이 솔루션은 다음과 같은 사용 사례를 해결합니다.
-
자동화된 Oracle 데이터베이스 복제를 위해 데이터베이스 복제 구성 파일을 설정합니다.
-
스케줄러에서 Ansible 플레이북을 사용하여 기본 데이터베이스 이미지 백업 사본에서 복제 Oracle 데이터베이스를 만들거나 새로 고칩니다.
대상
이 솔루션은 다음과 같은 사람들을 위해 만들어졌습니다.
-
Google Cloud에서 Oracle 데이터베이스를 관리하는 DBA입니다.
-
Google NetApp Volumes 스토리지를 관리하는 스토리지 관리자입니다.
-
다른 사용 사례를 위해 데이터베이스 이미지 백업 사본에서 Oracle 데이터베이스를 복제하려는 애플리케이션 소유자입니다.
특허
이 GitHub 저장소의 콘텐츠에 액세스하거나 다운로드, 설치 또는 사용함으로써 귀하는 본 라이선스에 명시된 조건에 동의하는 것입니다."라이센스 파일" .
|
이 GitHub 저장소의 콘텐츠를 사용하여 파생 작품을 제작 및/또는 공유하는 데에는 특정 제한이 있습니다. 콘텐츠를 사용하기 전에 라이선스 조건을 꼭 읽어보세요. 모든 약관에 동의하지 않을 경우, 이 저장소의 콘텐츠에 접근하거나 다운로드하거나 사용하지 마십시오. |
솔루션 구축
배포를 위한 전제 조건
Details
배포에는 다음과 같은 전제 조건이 필요합니다.
Ansible controller: Ansible v.2.10 and higher ONTAP collection 21.19.1 Python 3 Python libraries: netapp-lib xmltodict jmespath
Oracle servers: Primary Oracle VLDB server with an in-server image backup Clone target Oracle server
|
단순화를 위해 복제 대상 Oracle 서버는 Oracle 소프트웨어 스택 및 Oracle 홈의 디렉토리 레이아웃 등을 기본 Oracle 서버와 동일하게 구성해야 합니다. |
툴킷을 다운로드하세요
Details
https://bitbucket.ngage.netapp.com/projects/NS-BB/repos/na_oracle_bkup_clone/browse
|
현재 이 툴킷은 bitbucket 액세스 권한이 있는 NetApp 내부 사용자만 액세스할 수 있습니다. 관심 있는 외부 사용자는 계정 팀에 액세스를 요청하거나 NetApp 솔루션 엔지니어링 팀에 문의하세요. |
Ansible 소스 및 대상 호스트 파일 구성
Details
툴킷에는 Ansible 플레이북이 실행되는 소스 및 대상 Oracle 호스트를 정의하는 호스트 파일이 포함되어 있습니다. 일반적으로 여기에는 기본 데이터베이스 서버 호스트와 대상 복제본 데이터베이스 서버 호스트가 포함됩니다. 다음은 예시 파일입니다. 호스트 항목에는 대상 호스트 IP 주소는 물론 사용자가 호스트에 액세스하여 복제 또는 새로 고침 명령을 실행하는 데 필요한 ssh 키도 포함됩니다. Google Cloud NetApp Volumes 스토리지는 gcloud cli를 통해 액세스하고 관리합니다.
#Oracle hosts [ora_prod] orap ansible_host=35.212.10.122 ansible_ssh_private_key_file=oras.pem
[ora_clone] orac ansible_host=35.212.1.75 ansible_ssh_private_key_file=orac.pem
[gcp] localhost ansible_connection=local
전역 변수 구성
Details
다음은 글로벌 수준에서 적용 가능한 변수를 포함하는 일반적인 글로벌 변수 파일 vars.yml의 예입니다.
###################################################################### ###### Oracle DB clone on GCNV user configuration variables ###### ###### Consolidate all variables from GCNV, linux and oracle ###### ######################################################################
############################################ ### ONTAP/GCNV specific config variables ### ############################################
# GCNV credential key_file: /home/admin/google-cloud-sdk/service_key.json
# Cloned DB volumes from the primary DB project_id: cvs-pm-host-1p location: us-east4 protocol: nfsv3 bkup_mnt: /nfsgcnv ora_data: '{{ bkup_mnt }}/oracopy' ora_logs: '{{ bkup_mnt }}/archlog' data_vols: - "{{ groups.ora_prod[0] }}-bkup"
nfs_lifs: - 10.165.128.5
nfs_client: 0.0.0.0/0
########################################### ### Linux env specific config variables ### ###########################################
#################################################### ### DB env specific install and config variables ### ####################################################
# Primary DB configuration oracle_user: oracle oracle_base: /u01/app/oracle oracle_sid: NTAP oracle_home: '{{ oracle_base }}/product/19.0.0/{{ oracle_sid }}' adump: '{{ oracle_base }}/admin/{{ oracle_sid }}/adump' db_id: 1379265854
# Clond DB configuration clone_sid: NTAPDEV sys_pwd: "XXXXXXXX"
|
보다 안전한 자동화 배포를 위해 Ansible Vault를 사용하여 비밀번호, 액세스 토큰 또는 키 등의 중요한 정보를 암호화할 수 있습니다. 이 솔루션은 Ansible Vault 구현을 다루지는 않지만 Ansible 문서에 자세히 설명되어 있습니다. 참조해주세요"Ansible Vault를 사용하여 민감한 데이터 보호" 자세한 내용은. |
호스트 변수 구성
Details
호스트 변수는 {{host_name}}.yml이라는 이름의 host_vars 디렉토리에 정의되어 있으며 특정 호스트에만 적용됩니다. 이 솔루션의 경우 대상 복제본 DB 호스트 매개변수 파일만 구성됩니다. Oracle 기본 DB 매개변수는 글로벌 vars 파일에서 구성됩니다. 아래는 일반적인 구성을 보여주는 대상 Oracle 클론 DB 호스트 변수 파일 orac.yml의 예입니다.
# User configurable Oracle clone host specific parameters
# Database SID - clone DB SID oracle_base: /u01/app/oracle oracle_user: oracle clone_sid: NTAPDEV oracle_home: '{{ oracle_base }}/product/19.0.0/{{ oracle_sid }}' clone_adump: '{{ oracle_base }}/admin/{{ clone_sid }}/adump' sga_size: 4096M
추가 복제 대상 Oracle 서버 구성
Details
복제 대상 Oracle 서버에는 소스 Oracle 서버와 동일한 Oracle 소프트웨어 스택이 설치되고 패치되어야 합니다. $ORACLE_HOME 변수는 이상적으로 소스 Oracle 서버 설정과 일치해야 합니다. 대상 ORACLE_HOME 설정이 기본 Oracle 서버 구성과 다른 경우, 차이점을 해결하기 위해 심볼릭 링크를 만듭니다.
기본 데이터베이스가 ASM으로 구성된 경우, 데이터 파일 기본 그룹은 asm 그룹에 속할 수 있으며, 동일한 그룹 ID를 가진 동일한 asm 그룹을 복제 호스트에 추가하여 권한 문제를 방지해야 합니다.
플레이북 실행
Details
Oracle 데이터베이스 복제 수명 주기를 실행하기 위한 플레이북은 총 두 개가 있습니다. DB 복제 또는 새로 고침은 필요에 따라 실행하거나 crontab 작업으로 예약할 수 있습니다.
-
Ansible 컨트롤러 필수 구성 요소를 한 번만 설치하세요.
ansible-playbook -i hosts ansible_requirements.yml
-
쉘 스크립트를 사용하여 복제본이나 새로 고침 플레이북을 호출하여 crontab에서 필요에 따라 또는 정기적으로 복제본 데이터베이스를 만들고 새로 고칩니다.
ansible-playbook -i hosts oracle_bkup_clone_gcnv.yml -u admin -e @vars/vars.yml
30 */4 * * * /home/admin/na_oracle_bkup_clone/oracle_bkup_clone_gcnv.sh
추가 데이터베이스를 복제하려면 별도로 oracle_bkup_clone_n_gcnv.yml과 oracle_bkup_clone_n_gcnv.sh를 만듭니다. Ansible 대상 호스트, 글로벌 vars.yml 및 host_vars 디렉토리의 hostname.yml 파일을 이에 따라 구성합니다.
|
다양한 단계에서 툴킷 실행이 일시 중지되어 특정 작업이 완료됩니다. 예를 들어, DB 볼륨 복제가 완료될 때까지 2분간 일시 중지합니다. 일반적으로 기본값은 충분하지만, 특정 상황이나 구현에 따라 타이밍을 조정해야 할 수도 있습니다. |
플레이북 실행 세부 정보
Details
다음 로그 파일은 플레이북을 완전히 실행한 결과의 세부 정보를 참조용으로 캡처한 것입니다.
Begin Oracle DB clone or refresh at 2025-0627-083001 PLAY [Check to drop existing clone sid for refresh] **************************** TASK [Gathering Facts] ********************************************************* ok: [orac] TASK [Call clone check/drop tasks block] *************************************** TASK [oracle : Check if DB with clone_sid registered in /etc/oratab] *********** changed: [orac] TASK [oracle : Show the check result] ****************************************** ok: [orac] => { "msg": { "changed": true, "cmd": "if grep -q NTAPDEV /etc/oratab; then\n echo 'YES'\nelse\n echo 'NO'\nfi\n", "delta": "0:00:00.005924", "end": "2025-06-27 12:30:05.207068", "failed": false, "msg": "", "rc": 0, "start": "2025-06-27 12:30:05.201144", "stderr": "", "stderr_lines": [], "stdout": "YES", "stdout_lines": [ "YES" ] } } TASK [oracle : Copy db drop script to clone host] ****************************** ok: [orac] TASK [oracle : Drop existing clone if exist] *********************************** changed: [orac] TASK [oracle : Remove oratab entry for clone DB] ******************************* changed: [orac] TASK [oracle : Files to delete in dbs directory] ******************************* ok: [orac] TASK [oracle : Clean up Oracle files in dbs dir] ******************************* changed: [orac] => (item={'path': '/u01/app/oracle/product/19.0.0/NTAP/dbs/initNTAPDEV.ora', 'mode': '0644', 'isdir': False, 'ischr': False, 'isblk': False, 'isreg': True, 'isfifo': False, 'islnk': False, 'issock': False, 'uid': 54321, 'gid': 54321, 'size': 719, 'inode': 4098517569, 'dev': 46, 'nlink': 1, 'atime': 1751013685.3448362, 'mtime': 1751013685.3398356, 'ctime': 1751013685.34829, 'gr_name': 'oinstall', 'pw_name': 'oracle', 'wusr': True, 'rusr': True, 'xusr': False, 'wgrp': False, 'rgrp': True, 'xgrp': False, 'woth': False, 'roth': True, 'xoth': False, 'isuid': False, 'isgid': False}) changed: [orac] => (item={'path': '/u01/app/oracle/product/19.0.0/NTAP/dbs/hc_NTAP.dat', 'mode': '0660', 'isdir': False, 'ischr': False, 'isblk': False, 'isreg': True, 'isfifo': False, 'islnk': False, 'issock': False, 'uid': 54321, 'gid': 54321, 'size': 1544, 'inode': 4098517516, 'dev': 46, 'nlink': 1, 'atime': 1751013264.035136, 'mtime': 1751013672.821017, 'ctime': 1751013672.821017, 'gr_name': 'oinstall', 'pw_name': 'oracle', 'wusr': True, 'rusr': True, 'xusr': False, 'wgrp': True, 'rgrp': True, 'xgrp': False, 'woth': False, 'roth': False, 'xoth': False, 'isuid': False, 'isgid': False}) changed: [orac] => (item={'path': '/u01/app/oracle/product/19.0.0/NTAP/dbs/lkNTAP', 'mode': '0640', 'isdir': False, 'ischr': False, 'isblk': False, 'isreg': True, 'isfifo': False, 'islnk': False, 'issock': False, 'uid': 54321, 'gid': 54321, 'size': 24, 'inode': 4098517570, 'dev': 46, 'nlink': 1, 'atime': 1751013280.898314, 'mtime': 1751013280.901301, 'ctime': 1751013280.901301, 'gr_name': 'oinstall', 'pw_name': 'oracle', 'wusr': True, 'rusr': True, 'xusr': False, 'wgrp': False, 'rgrp': True, 'xgrp': False, 'woth': False, 'roth': False, 'xoth': False, 'isuid': False, 'isgid': False}) changed: [orac] => (item={'path': '/u01/app/oracle/product/19.0.0/NTAP/dbs/snapcf_NTAP.f', 'mode': '0640', 'isdir': False, 'ischr': False, 'isblk': False, 'isreg': True, 'isfifo': False, 'islnk': False, 'issock': False, 'uid': 54321, 'gid': 54321, 'size': 18726912, 'inode': 4098517640, 'dev': 46, 'nlink': 1, 'atime': 1751013606.020257, 'mtime': 1751013607.487233, 'ctime': 1751013607.487233, 'gr_name': 'oinstall', 'pw_name': 'oracle', 'wusr': True, 'rusr': True, 'xusr': False, 'wgrp': False, 'rgrp': True, 'xgrp': False, 'woth': False, 'roth': False, 'xoth': False, 'isuid': False, 'isgid': False}) changed: [orac] => (item={'path': '/u01/app/oracle/product/19.0.0/NTAP/dbs/lkNTAPDEV', 'mode': '0640', 'isdir': False, 'ischr': False, 'isblk': False, 'isreg': True, 'isfifo': False, 'islnk': False, 'issock': False, 'uid': 54321, 'gid': 54321, 'size': 24, 'inode': 4098517783, 'dev': 46, 'nlink': 1, 'atime': 1751013695.137098, 'mtime': 1751013695.1391, 'ctime': 1751013695.1391, 'gr_name': 'oinstall', 'pw_name': 'oracle', 'wusr': True, 'rusr': True, 'xusr': False, 'wgrp': False, 'rgrp': True, 'xgrp': False, 'woth': False, 'roth': False, 'xoth': False, 'isuid': False, 'isgid': False}) changed: [orac] => (item={'path': '/u01/app/oracle/product/19.0.0/NTAP/dbs/hc_NTAPDEV.dat', 'mode': '0660', 'isdir': False, 'ischr': False, 'isblk': False, 'isreg': True, 'isfifo': False, 'islnk': False, 'issock': False, 'uid': 54321, 'gid': 54321, 'size': 1544, 'inode': 4098517742, 'dev': 46, 'nlink': 1, 'atime': 1751013689.452215, 'mtime': 1751027428.293948, 'ctime': 1751027428.293948, 'gr_name': 'oinstall', 'pw_name': 'oracle', 'wusr': True, 'rusr': True, 'xusr': False, 'wgrp': True, 'rgrp': True, 'xgrp': False, 'woth': False, 'roth': False, 'xoth': False, 'isuid': False, 'isgid': False}) TASK [oracle : Umount NFS file systems on Oracle hosts] ************************ changed: [orac] => (item=/nfsgcnv) TASK [oracle : Clean up fstab entry for nfs mounts] **************************** ok: [orac] => (item=['orap-bkup', '10.165.128.5', '/nfsgcnv']) TASK [oracle : set_fact] ******************************************************* ok: [orac -> localhost] => (item=localhost) TASK [oracle : debug] ********************************************************** ok: [orac] => { "msg": "YES" } PLAY [Purge exising clone DB volumes for clone refresh] ************************ TASK [Call gcp volumes purge tasks block] ************************************** TASK [ontap : Login to GCP with service key from cli] ************************** changed: [localhost] TASK [ontap : Purge existing cloned GCP DB volumes] **************************** changed: [localhost] => (item=orap-bkup) TASK [ontap : Pause to allow volume purge to complete] ************************* Pausing for 25 seconds ok: [localhost] PLAY [Delete existing snapshot if exist and take a new volume snapshot] ******** TASK [Call gcp volumes snapshot tasks block] *********************************** TASK [ontap : Login to GCP with service key from cli] ************************** changed: [localhost] TASK [ontap : List an existing snapshot of all DB volumes in sequence if exist] *** changed: [localhost] => (item=orap-bkup) TASK [ontap : set_fact] ******************************************************** ok: [localhost] => (item={'changed': True, 'stdout': "---\ncreateTime: '2025-06-27T08:31:42.595Z'\nname: projects/cvs-pm-host-1p/locations/us-east4/volumes/orap-bkup/snapshots/snapclone-orap-bkup-ntapdev\nstate: READY\nstateDetails: Available for use\nusedBytes: 454656.0", 'stderr': '', 'rc': 0, 'cmd': ['gcloud', 'netapp', 'volumes', 'snapshots', 'list', '--project=cvs-pm-host-1p', '--location=us-east4', '--volume=orap-bkup', '--project=cvs-pm-host-1p', '--location=us-east4', '--volume=orap-bkup'], 'start': '2025-06-27 08:31:14.094576', 'end': '2025-06-27 08:31:16.505816', 'delta': '0:00:02.411240', 'msg': '', 'invocation': {'module_args': {'_raw_params': 'gcloud netapp volumes snapshots list --project=cvs-pm-host-1p --location=us-east4 --volume=orap-bkup --project=cvs-pm-host-1p --location=us-east4 --volume=orap-bkup\n', '_uses_shell': False, 'expand_argument_vars': True, 'stdin_add_newline': True, 'strip_empty_ends': True, 'argv': None, 'chdir': None, 'executable': None, 'creates': None, 'removes': None, 'stdin': None}}, 'stdout_lines': ['---', "createTime: '2025-06-27T08:31:42.595Z'", 'name: projects/cvs-pm-host-1p/locations/us-east4/volumes/orap-bkup/snapshots/snapclone-orap-bkup-ntapdev', 'state: READY', 'stateDetails: Available for use', 'usedBytes: 454656.0'], 'stderr_lines': [], 'failed': False, 'item': 'orap-bkup', 'ansible_loop_var': 'item'}) TASK [ontap : Delete an existing snapshot of all DB volumes in sequence if exist] *** changed: [localhost] => (item=['orap-bkup', '']) TASK [ontap : Pause to allow snapshots delete to complete] ********************* Pausing for 25 seconds ok: [localhost] TASK [ontap : Take a snapshot of all DB volumes in sequence] ******************* changed: [localhost] => (item=orap-bkup) TASK [ontap : Pause to allow snapshots to complete] **************************** Pausing for 25 seconds ok: [localhost] PLAY [Create clone DB volumes from snapshot] *********************************** TASK [ontap : Open a GCP connection via cli] *********************************** included: /home/admin/na_oracle_bkup_clone/roles/ontap/tasks/gcp_open_conn.yml for localhost TASK [ontap : Login to GCP with service key from cli] ************************** changed: [localhost] TASK [ontap : Set facts for DB volumes] **************************************** included: /home/admin/na_oracle_bkup_clone/roles/ontap/tasks/gcp_vol_setfact.yml for localhost TASK [ontap : Get DB volumes details to set facts] ***************************** changed: [localhost] => (item=orap-bkup) TASK [ontap : set_fact] ******************************************************** ok: [localhost] => (item={'changed': True, 'stdout': 'capacityGib: \'1024\'\ncreateTime: \'2025-05-23T15:45:26.897Z\'\nencryptionType: SERVICE_MANAGED\nexportPolicy:\n rules:\n - accessType: READ_WRITE\n allowedClients: 0.0.0.0/0\n hasRootAccess: \'true\'\n kerberos5ReadOnly: false\n kerberos5ReadWrite: false\n kerberos5iReadOnly: false\n kerberos5iReadWrite: false\n kerberos5pReadOnly: false\n kerberos5pReadWrite: false\n nfsv3: true\n nfsv4: false\nlabels:\n creator: acao\n database: oracle\n resource_id: \'12664458934480123852\'\nmountOptions:\n- export: /orap-bkup\n exportFull: 10.165.128.5:/orap-bkup\n instructions: |-\n Setting up your instance\n Open an SSH client and connect to your instance.\n Install the nfs client on your instance.\n On Red Hat Enterprise Linux or SuSE Linux instance:\n sudo yum install -y nfs-utils\n On an Ubuntu or Debian instance:\n sudo apt-get install nfs-common\n\n Mounting your volume\n Create a new directory on your instance, such as "/orap-bkup":\n sudo mkdir /orap-bkup\n Mount your volume using the example command below:\n sudo mount -t nfs -o rw,hard,rsize=65536,wsize=65536,vers=3,tcp 10.165.128.5:/orap-bkup /orap-bkup\n Note. Please use mount options appropriate for your specific workloads when known.\n ipAddress: 10.165.128.5\n protocol: NFSV3\nname: projects/cvs-pm-host-1p/locations/us-east4/volumes/orap-bkup\nnetwork: projects/565676753309/global/networks/shared-vpc-prod\nprotocols:\n- NFSV3\nsecurityStyle: UNIX\nserviceLevel: STANDARD\nshareName: orap-bkup\nstate: READY\nstateDetails: Available for use\nstoragePool: ora-bkup\nunixPermissions: \'0770\'\nusedGib: \'916\'', 'stderr': '', 'rc': 0, 'cmd': ['gcloud', 'netapp', 'volumes', 'describe', 'orap-bkup', '--project=cvs-pm-host-1p', '--location=us-east4'], 'start': '2025-06-27 08:32:12.741499', 'end': '2025-06-27 08:32:14.637893', 'delta': '0:00:01.896394', 'msg': '', 'invocation': {'module_args': {'_raw_params': 'gcloud netapp volumes describe orap-bkup --project=cvs-pm-host-1p --location=us-east4\n', '_uses_shell': False, 'expand_argument_vars': True, 'stdin_add_newline': True, 'strip_empty_ends': True, 'argv': None, 'chdir': None, 'executable': None, 'creates': None, 'removes': None, 'stdin': None}}, 'stdout_lines': ["capacityGib: '1024'", "createTime: '2025-05-23T15:45:26.897Z'", 'encryptionType: SERVICE_MANAGED', 'exportPolicy:', ' rules:', ' - accessType: READ_WRITE', ' allowedClients: 0.0.0.0/0', " hasRootAccess: 'true'", ' kerberos5ReadOnly: false', ' kerberos5ReadWrite: false', ' kerberos5iReadOnly: false', ' kerberos5iReadWrite: false', ' kerberos5pReadOnly: false', ' kerberos5pReadWrite: false', ' nfsv3: true', ' nfsv4: false', 'labels:', ' creator: acao', ' database: oracle', " resource_id: '12664458934480123852'", 'mountOptions:', '- export: /orap-bkup', ' exportFull: 10.165.128.5:/orap-bkup', ' instructions: |-', ' Setting up your instance', ' Open an SSH client and connect to your instance.', ' Install the nfs client on your instance.', ' On Red Hat Enterprise Linux or SuSE Linux instance:', ' sudo yum install -y nfs-utils', ' On an Ubuntu or Debian instance:', ' sudo apt-get install nfs-common', '', ' Mounting your volume', ' Create a new directory on your instance, such as "/orap-bkup":', ' sudo mkdir /orap-bkup', ' Mount your volume using the example command below:', ' sudo mount -t nfs -o rw,hard,rsize=65536,wsize=65536,vers=3,tcp 10.165.128.5:/orap-bkup /orap-bkup', ' Note. Please use mount options appropriate for your specific workloads when known.', ' ipAddress: 10.165.128.5', ' protocol: NFSV3', 'name: projects/cvs-pm-host-1p/locations/us-east4/volumes/orap-bkup', 'network: projects/565676753309/global/networks/shared-vpc-prod', 'protocols:', '- NFSV3', 'securityStyle: UNIX', 'serviceLevel: STANDARD', 'shareName: orap-bkup', 'state: READY', 'stateDetails: Available for use', 'storagePool: ora-bkup', "unixPermissions: '0770'", "usedGib: '916'"], 'stderr_lines': [], 'failed': False, 'item': 'orap-bkup', 'ansible_loop_var': 'item'}) TASK [ontap : debug] *********************************************************** ok: [localhost] => { "msg": [ "capacityGib: '1024'" ] } TASK [ontap : set_fact] ******************************************************** ok: [localhost] => (item=capacityGib: '1024') TASK [ontap : set_fact] ******************************************************** ok: [localhost] => (item={'changed': True, 'stdout': 'capacityGib: \'1024\'\ncreateTime: \'2025-05-23T15:45:26.897Z\'\nencryptionType: SERVICE_MANAGED\nexportPolicy:\n rules:\n - accessType: READ_WRITE\n allowedClients: 0.0.0.0/0\n hasRootAccess: \'true\'\n kerberos5ReadOnly: false\n kerberos5ReadWrite: false\n kerberos5iReadOnly: false\n kerberos5iReadWrite: false\n kerberos5pReadOnly: false\n kerberos5pReadWrite: false\n nfsv3: true\n nfsv4: false\nlabels:\n creator: acao\n database: oracle\n resource_id: \'12664458934480123852\'\nmountOptions:\n- export: /orap-bkup\n exportFull: 10.165.128.5:/orap-bkup\n instructions: |-\n Setting up your instance\n Open an SSH client and connect to your instance.\n Install the nfs client on your instance.\n On Red Hat Enterprise Linux or SuSE Linux instance:\n sudo yum install -y nfs-utils\n On an Ubuntu or Debian instance:\n sudo apt-get install nfs-common\n\n Mounting your volume\n Create a new directory on your instance, such as "/orap-bkup":\n sudo mkdir /orap-bkup\n Mount your volume using the example command below:\n sudo mount -t nfs -o rw,hard,rsize=65536,wsize=65536,vers=3,tcp 10.165.128.5:/orap-bkup /orap-bkup\n Note. Please use mount options appropriate for your specific workloads when known.\n ipAddress: 10.165.128.5\n protocol: NFSV3\nname: projects/cvs-pm-host-1p/locations/us-east4/volumes/orap-bkup\nnetwork: projects/565676753309/global/networks/shared-vpc-prod\nprotocols:\n- NFSV3\nsecurityStyle: UNIX\nserviceLevel: STANDARD\nshareName: orap-bkup\nstate: READY\nstateDetails: Available for use\nstoragePool: ora-bkup\nunixPermissions: \'0770\'\nusedGib: \'916\'', 'stderr': '', 'rc': 0, 'cmd': ['gcloud', 'netapp', 'volumes', 'describe', 'orap-bkup', '--project=cvs-pm-host-1p', '--location=us-east4'], 'start': '2025-06-27 08:32:12.741499', 'end': '2025-06-27 08:32:14.637893', 'delta': '0:00:01.896394', 'msg': '', 'invocation': {'module_args': {'_raw_params': 'gcloud netapp volumes describe orap-bkup --project=cvs-pm-host-1p --location=us-east4\n', '_uses_shell': False, 'expand_argument_vars': True, 'stdin_add_newline': True, 'strip_empty_ends': True, 'argv': None, 'chdir': None, 'executable': None, 'creates': None, 'removes': None, 'stdin': None}}, 'stdout_lines': ["capacityGib: '1024'", "createTime: '2025-05-23T15:45:26.897Z'", 'encryptionType: SERVICE_MANAGED', 'exportPolicy:', ' rules:', ' - accessType: READ_WRITE', ' allowedClients: 0.0.0.0/0', " hasRootAccess: 'true'", ' kerberos5ReadOnly: false', ' kerberos5ReadWrite: false', ' kerberos5iReadOnly: false', ' kerberos5iReadWrite: false', ' kerberos5pReadOnly: false', ' kerberos5pReadWrite: false', ' nfsv3: true', ' nfsv4: false', 'labels:', ' creator: acao', ' database: oracle', " resource_id: '12664458934480123852'", 'mountOptions:', '- export: /orap-bkup', ' exportFull: 10.165.128.5:/orap-bkup', ' instructions: |-', ' Setting up your instance', ' Open an SSH client and connect to your instance.', ' Install the nfs client on your instance.', ' On Red Hat Enterprise Linux or SuSE Linux instance:', ' sudo yum install -y nfs-utils', ' On an Ubuntu or Debian instance:', ' sudo apt-get install nfs-common', '', ' Mounting your volume', ' Create a new directory on your instance, such as "/orap-bkup":', ' sudo mkdir /orap-bkup', ' Mount your volume using the example command below:', ' sudo mount -t nfs -o rw,hard,rsize=65536,wsize=65536,vers=3,tcp 10.165.128.5:/orap-bkup /orap-bkup', ' Note. Please use mount options appropriate for your specific workloads when known.', ' ipAddress: 10.165.128.5', ' protocol: NFSV3', 'name: projects/cvs-pm-host-1p/locations/us-east4/volumes/orap-bkup', 'network: projects/565676753309/global/networks/shared-vpc-prod', 'protocols:', '- NFSV3', 'securityStyle: UNIX', 'serviceLevel: STANDARD', 'shareName: orap-bkup', 'state: READY', 'stateDetails: Available for use', 'storagePool: ora-bkup', "unixPermissions: '0770'", "usedGib: '916'"], 'stderr_lines': [], 'failed': False, 'item': 'orap-bkup', 'ansible_loop_var': 'item'}) TASK [ontap : set_fact] ******************************************************** ok: [localhost] => (item=storagePool: ora-bkup) TASK [ontap : set_fact] ******************************************************** ok: [localhost] => (item={'changed': True, 'stdout': 'capacityGib: \'1024\'\ncreateTime: \'2025-05-23T15:45:26.897Z\'\nencryptionType: SERVICE_MANAGED\nexportPolicy:\n rules:\n - accessType: READ_WRITE\n allowedClients: 0.0.0.0/0\n hasRootAccess: \'true\'\n kerberos5ReadOnly: false\n kerberos5ReadWrite: false\n kerberos5iReadOnly: false\n kerberos5iReadWrite: false\n kerberos5pReadOnly: false\n kerberos5pReadWrite: false\n nfsv3: true\n nfsv4: false\nlabels:\n creator: acao\n database: oracle\n resource_id: \'12664458934480123852\'\nmountOptions:\n- export: /orap-bkup\n exportFull: 10.165.128.5:/orap-bkup\n instructions: |-\n Setting up your instance\n Open an SSH client and connect to your instance.\n Install the nfs client on your instance.\n On Red Hat Enterprise Linux or SuSE Linux instance:\n sudo yum install -y nfs-utils\n On an Ubuntu or Debian instance:\n sudo apt-get install nfs-common\n\n Mounting your volume\n Create a new directory on your instance, such as "/orap-bkup":\n sudo mkdir /orap-bkup\n Mount your volume using the example command below:\n sudo mount -t nfs -o rw,hard,rsize=65536,wsize=65536,vers=3,tcp 10.165.128.5:/orap-bkup /orap-bkup\n Note. Please use mount options appropriate for your specific workloads when known.\n ipAddress: 10.165.128.5\n protocol: NFSV3\nname: projects/cvs-pm-host-1p/locations/us-east4/volumes/orap-bkup\nnetwork: projects/565676753309/global/networks/shared-vpc-prod\nprotocols:\n- NFSV3\nsecurityStyle: UNIX\nserviceLevel: STANDARD\nshareName: orap-bkup\nstate: READY\nstateDetails: Available for use\nstoragePool: ora-bkup\nunixPermissions: \'0770\'\nusedGib: \'916\'', 'stderr': '', 'rc': 0, 'cmd': ['gcloud', 'netapp', 'volumes', 'describe', 'orap-bkup', '--project=cvs-pm-host-1p', '--location=us-east4'], 'start': '2025-06-27 08:32:12.741499', 'end': '2025-06-27 08:32:14.637893', 'delta': '0:00:01.896394', 'msg': '', 'invocation': {'module_args': {'_raw_params': 'gcloud netapp volumes describe orap-bkup --project=cvs-pm-host-1p --location=us-east4\n', '_uses_shell': False, 'expand_argument_vars': True, 'stdin_add_newline': True, 'strip_empty_ends': True, 'argv': None, 'chdir': None, 'executable': None, 'creates': None, 'removes': None, 'stdin': None}}, 'stdout_lines': ["capacityGib: '1024'", "createTime: '2025-05-23T15:45:26.897Z'", 'encryptionType: SERVICE_MANAGED', 'exportPolicy:', ' rules:', ' - accessType: READ_WRITE', ' allowedClients: 0.0.0.0/0', " hasRootAccess: 'true'", ' kerberos5ReadOnly: false', ' kerberos5ReadWrite: false', ' kerberos5iReadOnly: false', ' kerberos5iReadWrite: false', ' kerberos5pReadOnly: false', ' kerberos5pReadWrite: false', ' nfsv3: true', ' nfsv4: false', 'labels:', ' creator: acao', ' database: oracle', " resource_id: '12664458934480123852'", 'mountOptions:', '- export: /orap-bkup', ' exportFull: 10.165.128.5:/orap-bkup', ' instructions: |-', ' Setting up your instance', ' Open an SSH client and connect to your instance.', ' Install the nfs client on your instance.', ' On Red Hat Enterprise Linux or SuSE Linux instance:', ' sudo yum install -y nfs-utils', ' On an Ubuntu or Debian instance:', ' sudo apt-get install nfs-common', '', ' Mounting your volume', ' Create a new directory on your instance, such as "/orap-bkup":', ' sudo mkdir /orap-bkup', ' Mount your volume using the example command below:', ' sudo mount -t nfs -o rw,hard,rsize=65536,wsize=65536,vers=3,tcp 10.165.128.5:/orap-bkup /orap-bkup', ' Note. Please use mount options appropriate for your specific workloads when known.', ' ipAddress: 10.165.128.5', ' protocol: NFSV3', 'name: projects/cvs-pm-host-1p/locations/us-east4/volumes/orap-bkup', 'network: projects/565676753309/global/networks/shared-vpc-prod', 'protocols:', '- NFSV3', 'securityStyle: UNIX', 'serviceLevel: STANDARD', 'shareName: orap-bkup', 'state: READY', 'stateDetails: Available for use', 'storagePool: ora-bkup', "unixPermissions: '0770'", "usedGib: '916'"], 'stderr_lines': [], 'failed': False, 'item': 'orap-bkup', 'ansible_loop_var': 'item'}) TASK [ontap : set_fact] ******************************************************** ok: [localhost] => (item=shareName: orap-bkup) TASK [ontap : Clone DB volumes from snapshots] ********************************* included: /home/admin/na_oracle_bkup_clone/roles/ontap/tasks/gcp_vol_snapclone.yml for localhost TASK [ontap : Clone DB volumes in sequence] ************************************ changed: [localhost] => (item=['orap-bkup', 'ora-bkup', "'1024'", 'orap-bkup']) TASK [ontap : Pause to allow snapshots volumes clone to complete] ************** Pausing for 120 seconds ok: [localhost] PLAY [Clone Oracle DB at clone host from backup copy on gcnv] ****************** TASK [Gathering Facts] ********************************************************* ok: [orac] TASK [oracle : Mount cloned DB volumes on clone host] ************************** included: /home/admin/na_oracle_bkup_clone/roles/oracle/tasks/ora_vol_mount.yml for orac TASK [oracle : Create mount points for NFS file systems] *********************** changed: [orac] TASK [oracle : Mount NFS file systems on Oracle hosts] ************************* changed: [orac] => (item=['orap-bkup', '10.165.128.5']) TASK [oracle : Convert clone DB vol and recover DB] **************************** included: /home/admin/na_oracle_bkup_clone/roles/oracle/tasks/ora_clone_convert.yml for orac TASK [oracle : Create primary DB adump dir on clone host] ********************** ok: [orac] TASK [oracle : Create a starter DB init file on clone host] ******************** ok: [orac] TASK [oracle : Copy conversion script to clone host] *************************** ok: [orac] TASK [oracle : Switch DB to backup copy] *************************************** changed: [orac] TASK [oracle : Print convert output] ******************************************* ok: [orac] => { "msg": { "changed": true, "cmd": "export ORACLE_SID=NTAP;export ORACLE_HOME=/u01/app/oracle/product/19.0.0/NTAP;export PATH=$ORACLE_HOME/bin:$PATH\nrman target / nocatalog @/tmp/ora_clone_convert.cmd\n", "delta": "0:00:33.967761", "end": "2025-06-27 12:34:58.298231", "failed": false, "msg": "", "rc": 0, "start": "2025-06-27 12:34:24.330470", "stderr": "", "stderr_lines": [], "stdout": "\nRecovery Manager: Release 19.0.0.0.0 - Production on Fri Jun 27 12:34:24 2025\nVersion 19.18.0.0.0\n\nCopyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.\n\nconnected to target database (not started)\n\nRMAN> startup nomount pfile='/home/oracle/initNTAP.ora';\n2> set dbid = 1379265854;\n3> restore controlfile from autobackup;\n4> restore spfile to pfile '$ORACLE_HOME/dbs/initNTAPDEV.ora' from autobackup;\n5> alter database mount;\n6> switch database to copy;\n7> exit;\nOracle instance started\n\nTotal System Global Area 4294963936 bytes\n\nFixed Size 9171680 bytes\nVariable Size 805306368 bytes\nDatabase Buffers 3472883712 bytes\nRedo Buffers 7602176 bytes\n\nexecuting command: SET DBID\n\nStarting restore at 27-JUN-25\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=9 device type=DISK\n\nrecovery area destination: /nfsgcnv/archlog/\ndatabase name (or database unique name) used for search: NTAP\nchannel ORA_DISK_1: AUTOBACKUP /nfsgcnv/archlog/NTAP/autobackup/2025_06_25/o1_mf_s_1204733866_n5r89f5f_.bkp found in the recovery area\nchannel ORA_DISK_1: looking for AUTOBACKUP on day: 20250627\nchannel ORA_DISK_1: looking for AUTOBACKUP on day: 20250626\nchannel ORA_DISK_1: looking for AUTOBACKUP on day: 20250625\nchannel ORA_DISK_1: restoring control file from AUTOBACKUP /nfsgcnv/archlog/NTAP/autobackup/2025_06_25/o1_mf_s_1204733866_n5r89f5f_.bkp\nchannel ORA_DISK_1: control file restore from AUTOBACKUP complete\noutput file name=/nfsgcnv/oracopy/NTAPDEV.ctl\nFinished restore at 27-JUN-25\n\nStarting restore at 27-JUN-25\nusing channel ORA_DISK_1\n\nrecovery area destination: /nfsgcnv/archlog/\ndatabase name (or database unique name) used for search: NTAP\nchannel ORA_DISK_1: AUTOBACKUP /nfsgcnv/archlog/NTAP/autobackup/2025_06_25/o1_mf_s_1204733866_n5r89f5f_.bkp found in the recovery area\nchannel ORA_DISK_1: looking for AUTOBACKUP on day: 20250627\nchannel ORA_DISK_1: looking for AUTOBACKUP on day: 20250626\nchannel ORA_DISK_1: looking for AUTOBACKUP on day: 20250625\nchannel ORA_DISK_1: restoring spfile from AUTOBACKUP /nfsgcnv/archlog/NTAP/autobackup/2025_06_25/o1_mf_s_1204733866_n5r89f5f_.bkp\nchannel ORA_DISK_1: SPFILE restore from AUTOBACKUP complete\nFinished restore at 27-JUN-25\n\nreleased channel: ORA_DISK_1\nStatement processed\n\nStarting implicit crosscheck backup at 27-JUN-25\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=9 device type=DISK\nCrosschecked 33 objects\nFinished implicit crosscheck backup at 27-JUN-25\n\nStarting implicit crosscheck copy at 27-JUN-25\nusing channel ORA_DISK_1\nCrosschecked 49 objects\nFinished implicit crosscheck copy at 27-JUN-25\n\nsearching for all files in the recovery area\ncataloging files...\ncataloging done\n\nList of Cataloged Files\n=======================\nFile Name: /nfsgcnv/archlog/NTAP/archivelog/2025_06_26/o1_mf_1_25_n5snz5ps_.arc\nFile Name: /nfsgcnv/archlog/NTAP/archivelog/2025_06_26/o1_mf_1_26_n5vkb3qh_.arc\nFile Name: /nfsgcnv/archlog/NTAP/autobackup/2025_06_25/o1_mf_s_1204733866_n5r89f5f_.bkp\n\ndatafile 1 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SYSTEM_FNO-1_dt3rn522\"\ndatafile 3 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SYSAUX_FNO-3_ds3rn4rh\"\ndatafile 4 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-UNDOTBS1_FNO-4_du3rn52l\"\ndatafile 5 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SYSTEM_FNO-5_e63rn5fh\"\ndatafile 6 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SYSAUX_FNO-6_e23rn5am\"\ndatafile 7 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-USERS_FNO-7_eb3rn5ju\"\ndatafile 8 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-UNDOTBS1_FNO-8_e83rn5id\"\ndatafile 9 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SYSTEM_FNO-9_e33rn5c4\"\ndatafile 10 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SYSAUX_FNO-10_dv3rn569\"\ndatafile 11 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-UNDOTBS1_FNO-11_e73rn5gu\"\ndatafile 12 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-USERS_FNO-12_ec3rn5k1\"\ndatafile 13 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SYSTEM_FNO-13_e43rn5d1\"\ndatafile 14 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SYSAUX_FNO-14_e03rn57p\"\ndatafile 15 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-UNDOTBS1_FNO-15_e93rn5if\"\ndatafile 16 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-USERS_FNO-16_ed3rn5k2\"\ndatafile 17 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SYSTEM_FNO-17_e53rn5e4\"\ndatafile 18 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SYSAUX_FNO-18_e13rn598\"\ndatafile 19 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-UNDOTBS1_FNO-19_ea3rn5js\"\ndatafile 20 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-USERS_FNO-20_ee3rn5k4\"\ndatafile 21 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE1_FNO-21_ct3rm3ae\"\ndatafile 22 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE1_FNO-22_cu3rm3ae\"\ndatafile 23 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE2_FNO-23_d83rmcpr\"\ndatafile 24 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE3_FNO-24_di3rmr29\"\ndatafile 25 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE1_FNO-25_cv3rm3ae\"\ndatafile 26 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE2_FNO-26_d93rmcrt\"\ndatafile 27 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE3_FNO-27_dj3rmr5k\"\ndatafile 28 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE1_FNO-28_d03rm3ae\"\ndatafile 29 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE2_FNO-29_da3rmhi5\"\ndatafile 30 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE2_FNO-30_db3rmhid\"\ndatafile 31 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE3_FNO-31_dk3rmr5l\"\ndatafile 32 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE1_FNO-32_d23rm81j\"\ndatafile 33 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE1_FNO-33_d33rm82n\"\ndatafile 34 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE2_FNO-34_dc3rmhlo\"\ndatafile 35 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE3_FNO-35_dl3rmrd2\"\ndatafile 36 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE1_FNO-36_d43rm838\"\ndatafile 37 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE2_FNO-37_dd3rmhtd\"\ndatafile 38 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE3_FNO-38_dm3rmvu9\"\ndatafile 39 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE2_FNO-39_de3rmmah\"\ndatafile 40 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE3_FNO-40_dn3rmvua\"\ndatafile 41 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE1_FNO-41_d53rm850\"\ndatafile 42 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE2_FNO-42_df3rmmdh\"\ndatafile 43 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE3_FNO-43_do3rn01j\"\ndatafile 44 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE1_FNO-44_d63rmco2\"\ndatafile 45 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE3_FNO-45_dp3rn09s\"\ndatafile 46 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE1_FNO-46_d73rmcpr\"\ndatafile 47 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE2_FNO-47_dg3rmmdo\"\ndatafile 48 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE2_FNO-48_dh3rmml5\"\ndatafile 49 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE3_FNO-49_dq3rn4mn\"\ndatafile 50 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE3_FNO-50_dr3rn4pe\"\n\nRecovery Manager complete.", "stdout_lines": [ "", "Recovery Manager: Release 19.0.0.0.0 - Production on Fri Jun 27 12:34:24 2025", "Version 19.18.0.0.0", "", "Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.", "", "connected to target database (not started)", "", "RMAN> startup nomount pfile='/home/oracle/initNTAP.ora';", "2> set dbid = 1379265854;", "3> restore controlfile from autobackup;", "4> restore spfile to pfile '$ORACLE_HOME/dbs/initNTAPDEV.ora' from autobackup;", "5> alter database mount;", "6> switch database to copy;", "7> exit;", "Oracle instance started", "", "Total System Global Area 4294963936 bytes", "", "Fixed Size 9171680 bytes", "Variable Size 805306368 bytes", "Database Buffers 3472883712 bytes", "Redo Buffers 7602176 bytes", "", "executing command: SET DBID", "", "Starting restore at 27-JUN-25", "allocated channel: ORA_DISK_1", "channel ORA_DISK_1: SID=9 device type=DISK", "", "recovery area destination: /nfsgcnv/archlog/", "database name (or database unique name) used for search: NTAP", "channel ORA_DISK_1: AUTOBACKUP /nfsgcnv/archlog/NTAP/autobackup/2025_06_25/o1_mf_s_1204733866_n5r89f5f_.bkp found in the recovery area", "channel ORA_DISK_1: looking for AUTOBACKUP on day: 20250627", "channel ORA_DISK_1: looking for AUTOBACKUP on day: 20250626", "channel ORA_DISK_1: looking for AUTOBACKUP on day: 20250625", "channel ORA_DISK_1: restoring control file from AUTOBACKUP /nfsgcnv/archlog/NTAP/autobackup/2025_06_25/o1_mf_s_1204733866_n5r89f5f_.bkp", "channel ORA_DISK_1: control file restore from AUTOBACKUP complete", "output file name=/nfsgcnv/oracopy/NTAPDEV.ctl", "Finished restore at 27-JUN-25", "", "Starting restore at 27-JUN-25", "using channel ORA_DISK_1", "", "recovery area destination: /nfsgcnv/archlog/", "database name (or database unique name) used for search: NTAP", "channel ORA_DISK_1: AUTOBACKUP /nfsgcnv/archlog/NTAP/autobackup/2025_06_25/o1_mf_s_1204733866_n5r89f5f_.bkp found in the recovery area", "channel ORA_DISK_1: looking for AUTOBACKUP on day: 20250627", "channel ORA_DISK_1: looking for AUTOBACKUP on day: 20250626", "channel ORA_DISK_1: looking for AUTOBACKUP on day: 20250625", "channel ORA_DISK_1: restoring spfile from AUTOBACKUP /nfsgcnv/archlog/NTAP/autobackup/2025_06_25/o1_mf_s_1204733866_n5r89f5f_.bkp", "channel ORA_DISK_1: SPFILE restore from AUTOBACKUP complete", "Finished restore at 27-JUN-25", "", "released channel: ORA_DISK_1", "Statement processed", "", "Starting implicit crosscheck backup at 27-JUN-25", "allocated channel: ORA_DISK_1", "channel ORA_DISK_1: SID=9 device type=DISK", "Crosschecked 33 objects", "Finished implicit crosscheck backup at 27-JUN-25", "", "Starting implicit crosscheck copy at 27-JUN-25", "using channel ORA_DISK_1", "Crosschecked 49 objects", "Finished implicit crosscheck copy at 27-JUN-25", "", "searching for all files in the recovery area", "cataloging files...", "cataloging done", "", "List of Cataloged Files", "=======================", "File Name: /nfsgcnv/archlog/NTAP/archivelog/2025_06_26/o1_mf_1_25_n5snz5ps_.arc", "File Name: /nfsgcnv/archlog/NTAP/archivelog/2025_06_26/o1_mf_1_26_n5vkb3qh_.arc", "File Name: /nfsgcnv/archlog/NTAP/autobackup/2025_06_25/o1_mf_s_1204733866_n5r89f5f_.bkp", "", "datafile 1 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SYSTEM_FNO-1_dt3rn522\"", "datafile 3 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SYSAUX_FNO-3_ds3rn4rh\"", "datafile 4 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-UNDOTBS1_FNO-4_du3rn52l\"", "datafile 5 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SYSTEM_FNO-5_e63rn5fh\"", "datafile 6 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SYSAUX_FNO-6_e23rn5am\"", "datafile 7 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-USERS_FNO-7_eb3rn5ju\"", "datafile 8 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-UNDOTBS1_FNO-8_e83rn5id\"", "datafile 9 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SYSTEM_FNO-9_e33rn5c4\"", "datafile 10 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SYSAUX_FNO-10_dv3rn569\"", "datafile 11 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-UNDOTBS1_FNO-11_e73rn5gu\"", "datafile 12 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-USERS_FNO-12_ec3rn5k1\"", "datafile 13 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SYSTEM_FNO-13_e43rn5d1\"", "datafile 14 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SYSAUX_FNO-14_e03rn57p\"", "datafile 15 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-UNDOTBS1_FNO-15_e93rn5if\"", "datafile 16 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-USERS_FNO-16_ed3rn5k2\"", "datafile 17 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SYSTEM_FNO-17_e53rn5e4\"", "datafile 18 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SYSAUX_FNO-18_e13rn598\"", "datafile 19 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-UNDOTBS1_FNO-19_ea3rn5js\"", "datafile 20 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-USERS_FNO-20_ee3rn5k4\"", "datafile 21 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE1_FNO-21_ct3rm3ae\"", "datafile 22 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE1_FNO-22_cu3rm3ae\"", "datafile 23 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE2_FNO-23_d83rmcpr\"", "datafile 24 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE3_FNO-24_di3rmr29\"", "datafile 25 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE1_FNO-25_cv3rm3ae\"", "datafile 26 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE2_FNO-26_d93rmcrt\"", "datafile 27 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE3_FNO-27_dj3rmr5k\"", "datafile 28 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE1_FNO-28_d03rm3ae\"", "datafile 29 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE2_FNO-29_da3rmhi5\"", "datafile 30 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE2_FNO-30_db3rmhid\"", "datafile 31 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE3_FNO-31_dk3rmr5l\"", "datafile 32 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE1_FNO-32_d23rm81j\"", "datafile 33 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE1_FNO-33_d33rm82n\"", "datafile 34 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE2_FNO-34_dc3rmhlo\"", "datafile 35 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE3_FNO-35_dl3rmrd2\"", "datafile 36 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE1_FNO-36_d43rm838\"", "datafile 37 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE2_FNO-37_dd3rmhtd\"", "datafile 38 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE3_FNO-38_dm3rmvu9\"", "datafile 39 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE2_FNO-39_de3rmmah\"", "datafile 40 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE3_FNO-40_dn3rmvua\"", "datafile 41 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE1_FNO-41_d53rm850\"", "datafile 42 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE2_FNO-42_df3rmmdh\"", "datafile 43 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE3_FNO-43_do3rn01j\"", "datafile 44 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE1_FNO-44_d63rmco2\"", "datafile 45 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE3_FNO-45_dp3rn09s\"", "datafile 46 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE1_FNO-46_d73rmcpr\"", "datafile 47 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE2_FNO-47_dg3rmmdo\"", "datafile 48 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE2_FNO-48_dh3rmml5\"", "datafile 49 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE3_FNO-49_dq3rn4mn\"", "datafile 50 switched to datafile copy \"/nfsgcnv/oracopy/data_D-NTAP_I-1379265854_TS-SOE3_FNO-50_dr3rn4pe\"", "", "Recovery Manager complete." ] } } TASK [oracle : Copy recovery script to clone host] ***************************** ok: [orac] TASK [oracle : Recover database to last scn in archived log from bkup] ********* changed: [orac] TASK [oracle : Rename recovered DB to clone SID] ******************************* changed: [orac] TASK [oracle : Post clone tasks] *********************************************** included: /home/admin/na_oracle_bkup_clone/roles/oracle/tasks/ora_post_clone.yml for orac TASK [oracle : Create clone DB adump dir on clone host] ************************ ok: [orac] TASK [oracle : Remove source DB init file] ************************************* ok: [orac] TASK [oracle : Remove dynamic parameters in clone DB init file] **************** changed: [orac] TASK [oracle : Update clone DB name] ******************************************* changed: [orac] TASK [oracle : Update clone DB controlfile] ************************************ changed: [orac] TASK [oracle : Update clone DB adump] ****************************************** changed: [orac] TASK [oracle : Copy post clone script to clone host] *************************** ok: [orac] TASK [oracle : Reset log, turn off archive mode, open clone DB] **************** changed: [orac] TASK [oracle : Add oratab entry for clone DB] ********************************** changed: [orac] PLAY RECAP ********************************************************************* localhost : ok=24 changed=9 unreachable=0 failed=0 skipped=0 rescued=0 ignored=0 orac : ok=35 changed=16 unreachable=0 failed=0 skipped=0 rescued=0 ignored=0 End Oracle DB clone or refresh at 2025-0627-084452
추가 정보를 찾을 수 있는 곳
NetApp 솔루션 자동화에 대해 자세히 알아보려면 다음 웹사이트를 검토하세요."NetApp 솔루션 자동화"