Remi Visser Oracle DBA

Hi, I am an Oracle DBA with almost 15 years experience. Here is where I store some of my braindumps. You can contact me using LinkedIn or GMAIL.

Employers

remivisser@gmail.com LinkedIn

Transporting an Oracle database to another os platform the fastest way

You can use RMAN to transport tablespaces across platforms with different endian formats. You can also use RMAN to transport an entire database to a different platform so long as the two platforms have the same endian format. — From “27 Transporting Data Across Platforms” – http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmxplat.htm So, in my own words – datafiles (tablespaces) […]

Read More…

Fix ORA-00257: archiver error. Connect internal only, until freed – in Oracle 11G

When your database hangs with a ORA-00257 error while you notice there is plenty of space in the /recoveryarea mountpoint you’re likely to have reached the maximum size defined by the new ** initialization parameter ‘db_recovery_file_dest_size‘. Fast solution is to simply increase the value for db_recovery_file_dest_size (and after that of course start archiving…) ** 2012-04-02T12:10:; […]

Read More…

Why Oracle May Really Be Doomed This Time

http://pandodaily.com/2012/02/11/why-oracle-may-really-be-doomed-this-time/ I was laying awake early this morning thinking about Oracle. O my Typically I think big public companies are inept, but I would not count Oracle out. Ellison has long shown he viscerally gets where the stock market, the customer and the technology are going. He may be better at this than anyone leading […]

Read More…

PL/SQL quickie; generate RMAN set newname script to different mountpoints

Script below generates RMAN newname file where database A is copied to database B AND database B has ‘conflicting’ mountpoints set up. Mountpoints setup on database A is like /m001/, /m002/, /m003/, /m004/ but mountpoints on database B side is just /m001/ and /m002. /m001 has only 800 G free space so I place everything […]

Read More…


Feedback



Purnendu said:
good one

Gio said:
Fixed Thank you !


ClarkX said:
Excellent!


Senthil Murugan said:
good fix, thanks


sanjaya said:
Fixed Thank you !

Ramesh Velauthem said:
Timely helped...






Maulik said:
Thanks :)





Shailesh Govani said:
Very useful script

chandu said:
thank you very much.



remivisser said:
Thanks Laurent :)

Tag & Categories

awk convert installer oraInst.loc rman shutdown undo *nix 10g 11g 12c Administration DBA util Grid Joomla! Misc mssql mssql for the oracle minded New Features oracle Oracle Golden Gate os commands performance and tuning Progress scripts SQL Trace T-SQL Uncategorized vmware windows