Lệnh start database pdbs
alter pluggable database emr open; or alter pluggable database all open; or alter session set container=emr; >startup alter session set container=CDB$ROOT; Đóng alter pluggable database all close;
alter pluggable database emr open; or alter pluggable database all open; or alter session set container=emr; >startup alter session set container=CDB$ROOT; Đóng alter pluggable database all close;
💡 Alternate client restores of Oracle backups failing with “RMAN-06026: some targets not found – aborting restore” 🚚 Cause It shows FRA area ============================================== SQL> show parameter db_recovery_file; NAME TYPE…
💡 While shutting down my TEST database process was hanged. Then I had to use shutdown abort. But when I wanted to start database it did not open. Xử lý…
💡 Bài toán đặt ra là: Giả sử database server bị hỏng hoàn toàn, nhưng thật may mắn chúng ta đã có trong tay bản backup và database đã cấu…
💡 In case of worst situation with data guard primary database, or not available for production than we can activated standby database as a primary production database. Login in to…
💡 Bị connection time out db 1. Check the current FRA destination. SQL> show parameter db_recovery_file NAME TYPE VALUE ———————————— ———– —————————— db_recovery_file_dest string /dbaclassdb/oradata/FRA db_recovery_file_dest_size big integer 20G SQL>…
💡 After restoring an RAC database to a standalone database through RMAN, we tried to drop the redolog groups belongs to thread 2. We hit the below error. SQL> alter…
💡 I was cloning a database from rman backup . After completion of cloning, when I did RESETLOG it failed with ORA-00392 error. RMAN> alter database open resetlogs; RMAN-00571: ===========================================================…
💡 I was cloning a database from rman backup . After completion of cloning, when I did RESETLOG it failed with ORA-00344 error. RMAN> alter database open resetlogs; RMAN-00571: ===========================================================…
💡 I was cloning a database from rman backup . After completion of cloning, when I did RESETLOG it failed with ORA-00344 error. Errors in file /u01/app/oracle/admin/icai/bdump/icai_mrp0_20855.trc: ORA-10562: Error occurred…