(DF.TOTAL + LOG.TOTAL + CONTROL.TOTAL)/1048576 "Total Size Mb" from dual,(select sum(a.bytes) TOTAL from dba_data_files a) DF,
SQL> select name from v$database Ĭalculate total space for all datafiles within database SQL> select DF.TOTAL/1048576 "DataFile Size Mb",LOG.TOTAL/1048576 "Redo Log Size Mb",CONTROL.TOTAL/1048576 "Control File Size Mb", Right click on thir URL, Save Target as & then Download it.ĭetermine how much disk space will be required. For more information about Oracle (NYSE:ORCL), visit PDF Document from here Duplicate Database from ASM to Non pdf Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts. Step 2.4 - Catalog the backuppieces if required Step 2.2.1 This steps are specific to WINDOWS Step 2.2 - Transfer the backuppieces to the new host Step 2.1 - Backup the production database Solution 2 - Detailed Steps With Example Output Step 1.2 - Transfer Backuppieces to New Host Step 1.1 - Backup the Production Database Solution 1 - Concise Steps Without Example Output
To view full details, sign in with your My Oracle Support account.ĭon't have a My Oracle Support account? Click to get started! Restoring to a different platform and/or RDBMS patchset is quite complex and will not be addressed in this note.Ģ) all datafiles and tablespaces are onlined and accessible The production database's recovery catalog will get confused if there are multiple databases with the same DBID.ġ) the existing and new hosts are running on the same operating system and RDBMS patchsets. Important Note: During the restore and recovery process, do NOT connect to the production database's recovery catalog, even if you are using one to perform the backup.
0 kommentar(er)
