Database and Backup Size
Hi Friends,
1. To find the exact database size can I use select sum(bytes)/1024/1024/1024 from dba_segments; ?? This output need not be equal to the sum of sizes of all the datafiles in the database ..correct?
2. Suppose the above query returns 500G, I want to take a full backup of the database to disk.
Which backup I should use.. level 0 Incremental backup or full database backup? what is the difference between the both?
Could you please help
Thanks and Regards,
Su.
1. To find the exact database size can I use select sum(bytes)/1024/1024/1024 from dba_segments; ?? This output need not be equal to the sum of sizes of all the datafiles in the database ..correct?
2. Suppose the above query returns 500G, I want to take a full backup of the database to disk.
Which backup I should use.. level 0 Incremental backup or full database backup? what is the difference between the both?
Could you please help
Thanks and Regards,
Su.
0