Notify of new replies to this comment Notify of new replies to this comment Search for: Search Recent CommentsDBA on ORA-12541: TNS:no listenerMaty on ORA-12541: TNS:no listenerRohit on ORA-12560: TNS:protocol adapter Posted by Thinus Meyer at 1:06 PM 1 comment: Links to this post Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest Labels: AWR Friday, December 5, 2008 Delete archive logs from Senior MemberAccount Moderator Quote:B25986-01 Oracle Database and Database Related Metric Reference Manual I will not scan the whole book. Posted by Thinus Meyer at 7:51 AM No comments: Links to this post Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest Labels: Administration, Performance Newer Posts Older Posts Home Subscribe to:
CIFS FS does not support datapump operations. 4. drop this diskgroup:SQL> drop diskgroup test;3. Share this:PrintEmailLinkedInFacebookTwitterGoogleLike this:Like Loading... It has a limitation that the backup piece cannot be greater than 2GB.
- Use non CIFS FS for expdp if you're using.
- Regards Michel [Updated on: Tue, 09 October 2007 01:26]Report message to a moderator Re: Archive log errors [message #273212 is a reply to message #272991] Tue, 09 October
- Quote:Deadlock :ORA-00060 How is this related to archive log errors?
- Posted by Thinus Meyer at 8:32 AM 1 comment: Links to this post Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest Labels: ASM Wednesday, December 10, 2008 SQL workload history with
- Learn more about SAP Q&A.
- Remove compression when expdp if you are using. 2.
- I logged a SR with Oracle Support and got the following feedback:Bug 7516653 - DROPPED ASM DISK STILL HELD BY ASM PROCESSESClosed as duplicate for bug:Bug 7225720 - ASM DOES NOT
- Please click on alert log error status if you want to look at this.....
- Friday, December 12, 2014 ORA-19510 and ORA-27045 on RMAN Backup Situation: Doing RMAN backup I got this error message: ORA-19510: failed to set size of 1193456 blocks for file "/backup" (block
Senior MemberAccount Moderator Quote:I was under the impression based on documentation Which one? The status of the disks are also updated.SQL> select MOUNT_STATUS, MODE_STATUS, STATE, NAME, PATH, header_statusfrom v$asm_diskwhere name is null/MOUNT_S MODE_ST STATE NAME PATH HEADER_STATU------- ------- -------- ------------------------------ ------------------------------ ------------CLOSED ONLINE NORMAL Send to Email Address Your Name Your Email Address Cancel Post was not sent - check your email addresses! Anyone had similar issues ?
blocks for file ORA-02236: invalid file name (ORACLE MANAGED FILES (OMF) LOCATION) COMMENTS IN TNSNAMES.ORA ORA-24244 INVALID HOST OR PORT FOR ACCESS CONTROL LIST (ACL) ASSIGNMENT Blogroll Arup Nanda's Blog Ergem For this we can use the MAXPIECESIZE option. For archive log error? Some components may not be visible.
The total size of the FRA came down to 8493396 MB, but the RMAN backup completed successfully.Lesson Learned:ASM spreads file extents evenly accross all the disks disks on a diskgroup. ACFS) [Cloud Control 12c] OMS installation fails with ORA-14400 [RDBMS] Enabling and Disabling Database Vault in RAC 11g R2 [RDBMS] How To Change Oracle Installation Owner [RDBMS] File /etc/oratab is not Please help: where is "tnsnames.ora" 12. Database : Oracle8i E.E.
My environment as below list: 1. In prior releases, RMAN did not prompt. Posted by Thinus Meyer at 8:47 AM No comments: Links to this post Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest Labels: Data Guard, Ora-19510 Ora-27037 skip to main | skip to sidebar Thinus Meyer's DBA adventures Tuesday, December 23, 2008 Problem setting up Archive Log file management on ASM I created a ASM diskgroup for FRA Ora-19510: Failed To Set Size Of 4294967295 Blocks For File Thank you Yog Report message to a moderator Re: Archive log errors [message #273087 is a reply to message #273020] Tue, 09 October 2007 01:26 Michel Cadot Messages:
Related Filed under ORACLE ← MMON PROCESS IS NOTRUNNING ORA-31603: object "SP1" of type PROCEDURE not found in schema "USER1" → Leave a Reply Cancel reply Enter your comment here... RMAN marks backups and copies as expired when you run a CROSSCHECK command and the files are absent or inaccessible. result from v$archive_dest DESTINATION ERROR BINDING SEQUENCE# ------------------------ --------------------- -------------- /dump/arch02/dbf ORA-19510: failed to set size of blocks for I have managed to add new logfile groups to QA copies of this database and other similarly installed Production ECC6 systems. Ora-27037 Rman
Categories ASM (9) EMGC (14) EXADATA (6) LINUX (115) MSSQL (1) ORACLE (530) OTHER (1) RAC (1) RMAN (27) Uncategorized (3) UNIX (122) VBS (1) WINDOWS (28) Top Posts & Pages SolutionsSupportTrainingCommunityDeveloperPartnerAbout Community / Archives / Discussions Archive / SAP on Oracle / ORA-19510 when adding raw devices as new logfile groups to Oracle database on AIX 7.1 ORA-19510 when adding raw The prompt returns immediatly, but the job (of migrating the data) is not yet done.
I had to remove 10 disks from a +ASM test system that had to be redeployed on another server.
Thank you Yog Report message to a moderator Re: Archive log errors [message #272992 is a reply to message #272991] Mon, 08 October 2007 09:11 Michel Cadot Messages: Ora-17505 using RMAN with ASM Remove ASM disk SQL workload history with DBA_HIST_SQLSTAT Delete archive logs from the standby server Fast Index Creation ► November (2) ► October (1) ► September Senior MemberAccount Moderator Quote:Please click on alert log error status if you want to look at this The title of your topic is: Quote:Archive log errors Regards Michel Report message to I wanted to test the same procedure to build Data Guard that I will use for Production, and that meant that I had to do a RMAN backup to ASM.
Help ".dbf file to .mdb file " 11. I removed all the disks of varying sizes and only kept the disks of 69052 MB Size. In order to monitor progress use the following SQL.SQL> select * from v$asm_operation/When the job is done the SQL will retun no rows. Designed for Best iPad Case Dcreators, Boat Insurance, Download Fashion Stock Pictures Skip navigationOracle Community DirectoryOracle Community FAQLog inRegisterMy Oracle Support Community (MOSC)SearchSearchCancelGo Directly To Oracle Technology Network CommunityMy Oracle Support