Search results for query: *

We recently changed the Oracle backup location to an external disk share instead of the same machine that the database is located on. I made the change within EM specifying the backup location under disk backup location. The backup runs fine, but my problem is when using RMAN. Whenever I try...

I found some information about it: 32000 x 1024 gives 32K blocks, obviously, Oracle imposes a 32 Gb upper limit for each datafile What happens when the tablespace limit is reached? Will Oracle automatically reuse space or will the database blow up? Do I need to allocate more space or create an...

When I created this particular database the vendor specifications were to set the datafile to auto increment by 100 MB and to set maximum file size to unlimited. I was doing some general maintenance the other day and noticed an 85% warning on the tablespace size. When I viewed it, it was no...

Okay, I think I understand what needs to happen in 1-4. Please correct if I am wrong: 1. create pfile from spfile because pfile does not exist if database is using spfile and pfile can be edited in notepad whereas spfile cannot. CREATE PFILE FROM SPFILE; 2. remove spfile - Can I just delete it...

Thanks LDBrwnDBA, I have actually done a lot of research and do have the correct sequence of tasks. I know to do the following: 1. Backup the database 2. Mount the database after a clean shutdown 3. Invoke DBNEWID and use the SETNAME parameter since I only want to change the database name and...

LKBrwnDBA Not sure if I mentioned I was going to use DBNEWID but only change the database name not the ID. Do I need to do all that you mentioned in #1 in this case? If so, can you please elaborate?

Hi, I need to rename an oracle 10g database but not change the database id. I have identified the steps from different articles but I had a couple questions regarding a couple of steps. I understand all the steps but need clarification with the following. My main concern is the modifications to...