Tag Info

New answers tagged

2

No need to de-install Oracle rdbms software. Just install and configure ASM. If you have enough storage available you can copy your database to ASM using rman.


2

The Oracle docs for 11.2 ASM migration are here: http://docs.oracle.com/cd/E11882_01/server.112/e18951/asm_rman.htm#OSTMG12000 These explain the process that you need to go through to migrate to ASM from filesystem storage.


0

First you need ensure that that the backup is in your library (surely you know better ways for find it, I put my query): select D.DB_NAME, B.DB_ID, BASET.BCK_TYPE, decode(BASET.CONTROLFILE_INCLUDED,'BACKUP','YES','NO') as CONTROLFILE_INCLUDED, BASET.INCR_LEVEL, bapiece.tag, bapiece.handle, bapiece.start_time, bapiece.completion_time, ...


0

You can set a retention policy to redundancy or recovery window and just make another backup of your database so that your existing backups completed before your current incarnation began become obsolete according to the defined retention policy. Surely, you can also configure automatic backup of your database according to your backup strategy. If you set ...


1

I couldn't find any clause to the REPORT or LIST commands which would allow you to specify the incarnation of interest. You could however correlate your latest incarnation reset time with backup completion time to identify the backups completed before your current incarnation began. First, let's set the environment variables so that RMAN output also ...



Top 50 recent answers are included