Useful shortcuts for vi editor

Showing posts with label rman. Show all posts
Showing posts with label rman. Show all posts

Sunday, 19 October 2014

How to connect into RMAN tool in Windows?

Press Windows button + R and press cmd then click "OK".
Write down "rman" and press enter

Lastly run that command to connect environment.

RMAN> connect target /

connected to target database: XE (DBID=2732638794)

Wednesday, 15 October 2014

How to set DB ID in RMAN?

RMAN> set dbid=111111;
-- 111111 -> desired dbid

Tuesday, 14 October 2014

How to delete archive log files until specific time in RMAN?

RMAN> delete archivelog until time ‘SYSDATE-10’;
i: it will delete them until 10 days ago

Also it has a no prompt option;
RMAN> delete noprompt archivelog until time ‘SYSDATE-10′;