Friday, December 28, 2012

RMAN Configuration for 2 nodes RAC Database

question is:

Is it the same procedure to create catalog and register database for RAC DB with 2 nodes as of Single Production DB.


If the archived redologs are on the clustered filesystems (and i strongly advise you to use a clustered file system) and both the nodes can see the filesystem and it is properly configured then yes

BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;

This will work perfectly


Refercenes:

RMAN Configuration for 2 nodes RAC Database

RMAN delete commands

rosscheck backup of database
completed between 'SYSDATE' and 'SYSDATE-30';

When you are deleting backups ensure that you don't use OS commands to do so.

For deleting expired backups of previous week type the following

RMAN>DELETE EXPIRED BACKUP COMPLETED BEFORE SYSDATE-7

and for deleting backups completed before 7 days type

RMAN>DELETE BACKUP COMPLETED BEFORE SYSDATE-7

Don't use the OS utilites to maintain the backups.

Thursday, December 27, 2012

set linux root password

具体方法:
1 重启。系统默认加载之前倒数5秒之前按方向键,当出现grub选择界面时,按“E”键
2 此时会进入grub编辑模式,选中kernel 那一行,再次按“e”
3 出现kernel引导命令的编辑界面,在末尾追加 "single"。注意,加single之前要加个空格。然后回车
4 按“b”,此时会引导你进入单用户模式,
5 当出现“sh-2.05#”时,就意味着已经进入单用户模式。现在,输入“passwd root”,就可以重新设置root密码了。
6 修改完成后,重启。正常进入系统即可


Ref:
http://www.itpub.net/thread-1752019-1-1.html